3 |
|
|
4 |
|
Starting Tests |
5 |
|
Client API Version = 4.0 |
6 |
< |
Firebird Environment Variable = /opt/firebird4.0.0 |
7 |
< |
Firebird Bin Directory = /opt/firebird4.0.0/bin |
8 |
< |
Firebird Conf Directory = /opt/firebird4.0.0/ |
9 |
< |
Firebird Client Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
6 |
> |
Firebird Environment Variable = /opt/firebird4.0.1 |
7 |
> |
Firebird Bin Directory = /opt/firebird4.0.1/bin |
8 |
> |
Firebird Conf Directory = /opt/firebird4.0.1/ |
9 |
> |
Firebird Client Library Path = /opt/firebird4.0.1/lib/libfbclient.so |
10 |
|
Running Test 1: Create and Drop a Database |
11 |
|
Creating a Database with empty parameters |
12 |
< |
Create Database fails (as expected): I/O error during "open O_CREAT" operation for file "" |
12 |
> |
Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file "" |
13 |
|
-Error while trying to create file |
14 |
|
-No such file or directory |
15 |
|
Creating a Database using an SQL Statement |
22 |
|
DB ODS Major Version = 13 |
23 |
|
DB ODS Minor Version = 0 |
24 |
|
User Authentication Method = Srp256 |
25 |
< |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
25 |
> |
Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so |
26 |
|
DB Client Implementation Version = 4.0 |
27 |
|
DPB: Item Count = 3 |
28 |
|
isc_dpb_user_name = SYSDBA |
30 |
|
isc_dpb_set_db_sql_dialect = 3 |
31 |
|
|
32 |
|
Firebird Server Version Info |
33 |
< |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
34 |
< |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C" |
35 |
< |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C" |
33 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
34 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:C" |
35 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:C" |
36 |
|
on disk structure version 13.0 |
37 |
|
|
38 |
|
Dropping Database |
44 |
|
DB ODS Major Version = 13 |
45 |
|
DB ODS Minor Version = 0 |
46 |
|
User Authentication Method = Srp256 |
47 |
< |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
47 |
> |
Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so |
48 |
|
DB Client Implementation Version = 4.0 |
49 |
|
Dropping Database |
50 |
|
DPB: Item Count = 4 |
65 |
|
DB ODS Major Version = 13 |
66 |
|
DB ODS Minor Version = 0 |
67 |
|
User Authentication Method = Srp256 |
68 |
< |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
68 |
> |
Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so |
69 |
|
DB Client Implementation Version = 4.0 |
70 |
|
RDB$DESCRIPTION = |
71 |
|
RDB$RELATION_ID = 128 |
78 |
|
|
79 |
|
------------------------------------------------------ |
80 |
|
Running Test 2: Open the employee database and run a query |
81 |
< |
Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
81 |
> |
Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
82 |
|
Opening inet://localhost/employee |
83 |
|
Database Open, SQL Dialect = 3 |
84 |
|
TPB: Item Count = 3 |
316 |
|
DB ODS Major Version = 13 |
317 |
|
DB ODS Minor Version = 0 |
318 |
|
User Authentication Method = Srp256 |
319 |
< |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
319 |
> |
Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so |
320 |
|
DB Client Implementation Version = 4.0 |
321 |
|
Do Fetch Next: |
322 |
|
EMP_NO = 2 |
331 |
|
SALARY = 105,900.00 |
332 |
|
FULL_NAME = Nelson, Robert |
333 |
|
Do Fetch Last: |
334 |
< |
Remote Scrollable cursors test fails feature is not supported |
334 |
> |
Remote Scrollable cursors test fails Engine Code: 335544378 feature is not supported |
335 |
|
Now open the employee database as a local database |
336 |
|
TPB: Item Count = 3 |
337 |
|
isc_tpb_read |
568 |
|
DB ODS Major Version = 13 |
569 |
|
DB ODS Minor Version = 0 |
570 |
|
User Authentication Method = User name in DPB |
571 |
< |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
571 |
> |
Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so |
572 |
|
DB Client Implementation Version = 4.0 |
573 |
|
Do Fetch Next: |
574 |
|
EMP_NO = 2 |
651 |
|
Opening inet://localhost/employee |
652 |
|
Database Open |
653 |
|
Employee Count = 42 |
654 |
< |
Transaction ID = 6547 |
654 |
> |
Transaction ID = 8337 |
655 |
|
Transaction is Read/Write |
656 |
|
Transaction Database Path = inet://localhost/employee |
657 |
< |
Transaction ID = 6547 |
658 |
< |
Oldest Interesting = 6545 |
659 |
< |
Oldest Action = 6546 |
660 |
< |
Oldest Snapshot = 6546 |
661 |
< |
Oldest Snapshot Number = 2 |
657 |
> |
Transaction ID = 8337 |
658 |
> |
Oldest Interesting = 8335 |
659 |
> |
Oldest Action = 8336 |
660 |
> |
Oldest Snapshot = 8336 |
661 |
> |
Oldest Snapshot Number = 1 |
662 |
|
Lock Timeout = 0 |
663 |
|
Transaction Access = isc_info_tra_readwrite |
664 |
|
Isolation Type = isc_info_tra_concurrency |
675 |
|
Running Test 4: Update, Insert and Delete Queries |
676 |
|
Opening inet://localhost/employee |
677 |
|
Database Open |
678 |
< |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
679 |
< |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
680 |
< |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
678 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
679 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
680 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
681 |
|
on disk structure version 13.0 |
682 |
|
Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0 |
683 |
|
EMP_NO = 8 |
692 |
|
SALARY = 64,635.00 |
693 |
|
FULL_NAME = Johnson, Leslie |
694 |
|
|
695 |
< |
Current memory = 19,767,952 |
695 |
> |
Current memory = 19,762,400 |
696 |
|
Delta memory = 4,464 |
697 |
< |
Max memory = 19,813,568 |
698 |
< |
Elapsed time= 0.001 sec |
697 |
> |
Max memory = 19,807,728 |
698 |
> |
Elapsed time= 0.003 sec |
699 |
|
Cpu = 0.000 sec |
700 |
|
Buffers = 2048 |
701 |
|
Reads = 0 |
702 |
< |
Writes = 0 |
702 |
> |
Writes = 1 |
703 |
|
Fetches = 3 |
704 |
|
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 |
705 |
|
Relation Name = EMPLOYEE |
2733 |
|
|
2734 |
|
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2735 |
|
|
2736 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (16: 4269) |
2736 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) |
2737 |
|
|
2738 |
|
|
2739 |
|
Shrink to 2:10 |
2749 |
|
|
2750 |
|
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2751 |
|
|
2752 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (16: 4269) |
2752 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) |
2753 |
|
|
2754 |
|
|
2755 |
|
|
2833 |
|
|
2834 |
|
------------------------------------------------------ |
2835 |
|
Running Test 9: Database Information tests |
2836 |
< |
Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus |
2837 |
< |
Pages =1075 |
2836 |
> |
Database ID = 4 FB = /opt/firebird4.0.1/examples/empbuild/employee.fdb SN = zeus |
2837 |
> |
Pages =413 |
2838 |
|
Base Level = 13,4,0,3, |
2839 |
|
Implementation = 11,7,0,3,66,1,66, |
2840 |
|
Reserved = 0 |
2841 |
|
ODS minor = 0 |
2842 |
|
ODS major = 13 |
2843 |
|
Page Size = 8192 |
2844 |
< |
Version = 1: LI-V6.3.0.2496 Firebird 4.0 |
2844 |
> |
Version = 1: LI-V6.3.1.2692 Firebird 4.0 |
2845 |
|
Database is Read/Write |
2846 |
< |
Database Created: 29/5/2021 16:47:30 |
2847 |
< |
Pages Used = 313 |
2848 |
< |
Pages Free = 762 |
2849 |
< |
Server Memory = 19484112 |
2846 |
> |
Database Created: 21/12/2021 10:52:59 |
2847 |
> |
Pages Used = 352 |
2848 |
> |
Pages Free = 61 |
2849 |
> |
Server Memory = 19476112 |
2850 |
|
Forced Writes = 1 |
2851 |
< |
Max Memory = 19630384 |
2851 |
> |
Max Memory = 19506944 |
2852 |
|
Num Buffers = 2048 |
2853 |
|
Sweep Interval = 20000 |
2854 |
|
Logged in Users: SYSDBA, |
2855 |
|
Active Transaction Count = 0 |
2856 |
< |
Fetches = 1653 |
2857 |
< |
Writes = 8 |
2858 |
< |
Reads = 92 |
2859 |
< |
Page Writes = 4 |
2856 |
> |
Fetches = 1698 |
2857 |
> |
Writes = 6 |
2858 |
> |
Reads = 97 |
2859 |
> |
Page Writes = 3 |
2860 |
|
Record Version Removals Operation Counts |
2861 |
|
|
2862 |
|
Deletes Operation Counts |
2871 |
|
Table ID = 4 |
2872 |
|
Count = 63 |
2873 |
|
Table ID = 6 |
2874 |
< |
Count = 23 |
2874 |
> |
Count = 13 |
2875 |
|
Table ID = 9 |
2876 |
< |
Count = 3 |
2876 |
> |
Count = 1 |
2877 |
|
Table ID = 11 |
2878 |
|
Count = 2 |
2879 |
|
Table ID = 12 |
2880 |
|
Count = 24 |
2881 |
|
Table ID = 18 |
2882 |
< |
Count = 821 |
2882 |
> |
Count = 952 |
2883 |
|
Table ID = 20 |
2884 |
|
Count = 5 |
2885 |
|
Table ID = 28 |
2891 |
|
|
2892 |
|
Sequential Table Scans Operation Counts |
2893 |
|
Table ID = 0 |
2894 |
< |
Count = 100 |
2894 |
> |
Count = 98 |
2895 |
|
Table ID = 1 |
2896 |
< |
Count = 24 |
2896 |
> |
Count = 14 |
2897 |
|
|
2898 |
|
Update Count Operation Counts |
2899 |
|
|
2907 |
|
Event Signalled |
2908 |
|
First Event - usually ignored |
2909 |
|
Signal Event |
2910 |
+ |
Event Signalled |
2911 |
|
Event Counts: TESTEVENT, Count = 1 |
2912 |
|
Two more events |
2913 |
|
Call Async Wait |
2914 |
|
Async Wait Called |
2915 |
|
Event Signalled |
2915 |
– |
Event Signalled |
2916 |
|
Deferred Events Caught |
2917 |
|
Event Counts: TESTEVENT, Count = 2 |
2918 |
|
Signal Event |
2934 |
|
password = masterkey |
2935 |
|
|
2936 |
|
Service Manager Version = 2 |
2937 |
< |
Server Version = LI-V4.0.0.2496 Firebird 4.0 |
2937 |
> |
Server Version = LI-V4.0.1.2692 Firebird 4.0 |
2938 |
|
Implementation = Firebird/Linux/AMD/Intel/x64 |
2939 |
|
|
2940 |
|
Lock Directory = /tmp/firebird/ |
2941 |
< |
Message File = /opt/firebird4.0.0/ |
2942 |
< |
Security File = /opt/firebird4.0.0/security4.fdb |
2941 |
> |
Message File = /opt/firebird4.0.1/ |
2942 |
> |
Security File = /opt/firebird4.0.1/security4.fdb |
2943 |
|
|
2944 |
|
DB Attachments |
2945 |
|
No. of Attachments = 0 |
2954 |
|
Group ID = 0 |
2955 |
|
|
2956 |
|
|
2957 |
< |
Licence Info: feature is not supported |
2957 |
> |
Licence Info: Engine Code: 335544378 feature is not supported |
2958 |
|
-feature is not supported |
2959 |
|
|
2960 |
< |
Licence Mask Info: feature is not supported |
2960 |
> |
Licence Mask Info: Engine Code: 335544378 feature is not supported |
2961 |
|
|
2962 |
|
Capabilities = 6 |
2963 |
|
|
3244 |
|
------------------------------------------------------ |
3245 |
|
Running Test 16: Error handling |
3246 |
|
Invalid Database Name Test |
3247 |
< |
Error Handled: I/O error during "open" operation for file "Malformed Name" |
3247 |
> |
Error Handled: SQLCODE: -902 |
3248 |
> |
Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3249 |
> |
I/O error during "open" operation for file "Malformed Name" |
3250 |
|
-Error while trying to open file |
3251 |
|
-No such file or directory |
3252 |
|
Invalid User Name Test |
3253 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3253 |
> |
Error Handled: SQLCODE: -902 |
3254 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3255 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3256 |
|
Invalid password Test |
3257 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3257 |
> |
Error Handled: SQLCODE: -902 |
3258 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3259 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3260 |
|
Invalid Prepare SQL Test |
3261 |
< |
Error Handled: Dynamic SQL Error |
3261 |
> |
Error Handled: SQLCODE: -206 |
3262 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3263 |
> |
Dynamic SQL Error |
3264 |
|
-SQL error code = -206 |
3265 |
|
-Column unknown |
3266 |
|
-UNKNOWN_DATE |
3267 |
|
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3268 |
|
Invalid Open Cursor SQL Test |
3269 |
< |
Error Handled: Dynamic SQL Error |
3269 |
> |
Error Handled: SQLCODE: -206 |
3270 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3271 |
> |
Dynamic SQL Error |
3272 |
|
-SQL error code = -206 |
3273 |
|
-Column unknown |
3274 |
|
-X |
3295 |
|
COUNTER = 42 |
3296 |
|
|
3297 |
|
Invalid Server Name Test |
3298 |
< |
Error Handled: Unable to complete network request to host "unknown". |
3298 |
> |
Error Handled: SQLCODE: -902 |
3299 |
> |
Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3300 |
> |
Unable to complete network request to host "unknown". |
3301 |
|
-Failed to locate host machine. |
3302 |
|
-The specified name was not found in the hosts file or Domain Name Services |
3303 |
|
Invalid User Name Test |
3304 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3304 |
> |
Error Handled: SQLCODE: -902 |
3305 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3306 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3307 |
|
Invalid password Test |
3308 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3308 |
> |
Error Handled: SQLCODE: -902 |
3309 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3310 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3311 |
|
|
3312 |
|
|
3313 |
|
------------------------------------------------------ |
3314 |
|
Running Test 17: Date/Time tests and Firebird 4 extensions |
3315 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
3315 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
3316 |
|
Has Local TZ DB = TRUE |
3317 |
|
|
3318 |
|
Testdata |
4074 |
|
|
4075 |
|
------------------------------------------------------ |
4076 |
|
Running Test 18: Firebird 4 Decfloat extensions |
4077 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
4077 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
4078 |
|
|
4079 |
|
FB4 Testdata_DECFloat |
4080 |
|
|
4343 |
|
Running Test 19: Batch Update and Insert Queries |
4344 |
|
Opening inet://localhost/employee |
4345 |
|
Database Open |
4346 |
< |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
4347 |
< |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
4348 |
< |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
4346 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
4347 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
4348 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
4349 |
|
on disk structure version 13.0 |
4350 |
|
Rows before update |
4351 |
|
EMP_NO = 2 |
4576 |
|
|
4577 |
|
|
4578 |
|
Test Error Handling |
4579 |
< |
Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING |
4579 |
> |
Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type |
4580 |
|
Test Error Handling - Update returning should fail |
4581 |
|
Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched |
4582 |
|
Error handling when Insert rows - duplicate key |
4583 |
< |
Error reported when inserting: Error Processing update/insert batch on row number 2 - violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE" |
4583 |
> |
Error reported when inserting: Error Processing update/insert batch on row number 2 - SQLCODE: -803 |
4584 |
> |
Engine Code: 335544665 Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values |
4585 |
> |
violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE" |
4586 |
|
-Problematic key value is ("EMP_NO" = 150) |
4587 |
|
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 |
4588 |
|
Batch Completion Info |
4595 |
|
|
4596 |
|
------------------------------------------------------ |
4597 |
|
Running Test 20: Stress Test IBatch interface |
4598 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
4598 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
4599 |
|
10000 rows added |
4600 |
|
20000 rows added |
4601 |
|
30000 rows added |
4649 |
|
Parsing of 1,000 failed |
4650 |
|
Parsing of 1e1e1 failed |
4651 |
|
Parsing of 1.2+3 failed |
4652 |
+ |
Validating Numeric Interface - IFBNumeric |
4653 |
+ |
Value from Currency = 9999.1235 |
4654 |
+ |
Raw Value = 99991235 Scale = -4 |
4655 |
+ |
Value from Currency(rescaled) = 9999.12 |
4656 |
+ |
Raw Value = 999912 Scale = -2 |
4657 |
+ |
Value from Double = 9999.12345678 |
4658 |
+ |
Raw Value = 999912345678 Scale = -8 |
4659 |
+ |
Value from Integer = 9223372036854775807 |
4660 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
4661 |
+ |
Value from string = 9223372036854775807 |
4662 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
4663 |
+ |
Value from string = 9999.12345678 |
4664 |
+ |
Raw Value = 999912345678 Scale = -8 |
4665 |
+ |
Value from string = -0.12 |
4666 |
+ |
Raw Value = -12 Scale = -3 |
4667 |
+ |
Value from BCD = 9999.12345678 |
4668 |
+ |
Raw Value = 999912345678 Scale = -8 |
4669 |
+ |
Value from Raw Data = 9999123.456780 |
4670 |
+ |
Raw Value = 9999123456780 Scale = -6 |
4671 |
+ |
Numeric Operations |
4672 |
+ |
Add 2.23 + 24.12345 = 26.35345 |
4673 |
+ |
Add Double 2.23 + 24.12645 = 26.35645 |
4674 |
+ |
Add integer 2.23 + 2412345 = 2412347.23 |
4675 |
+ |
Subtract 2.23 - 24.12345 = -21.89345 |
4676 |
+ |
Subtract Double 24.12645 - 2.23 = -21.89645 |
4677 |
+ |
Subtract integer 24123.45 - 223 = -23900.45 |
4678 |
+ |
Multiply 2.23 * 24.12345 = 53.7952935 |
4679 |
+ |
Multiply Double 24.12645 * 2.23 = 53.8019835 |
4680 |
+ |
Multiply integer 241.2345 * 223 = 53795.2935 |
4681 |
+ |
Divide 24.12345 / 2.23 = 10.81769 |
4682 |
+ |
Divide Double 2.23 / 24.12645 = 0.09 |
4683 |
+ |
Divide integer 241.2345 / 223 = 1.0818 |
4684 |
+ |
Compare 2.23, -24.12345 = 1 |
4685 |
+ |
Compare integer 2.23, 3 = -1 |
4686 |
+ |
Compare Double 2.23, 2.23 = 0 |
4687 |
+ |
Negate 24.12345 = -24.12345 |
4688 |
|
SQL Params |
4689 |
|
SQLType =SQL_LONG |
4690 |
|
sub type = 0 |
4745 |
|
Dynamic SQL Error |
4746 |
|
-SQL error code = -303 |
4747 |
|
-conversion error from string "10.0.0" |
4748 |
+ |
Test Numeric Type |
4749 |
|
ROWID = 1 |
4750 |
|
ITYPE = 101 |
4751 |
|
I64TYPE = 9223372036854775807 |
4770 |
|
CURRTYPE = .02300000 |
4771 |
|
DTYPE = .00110000 |
4772 |
|
FIXEDPOINT = 233.45600000 |
4773 |
+ |
ROWID = 7 |
4774 |
+ |
ITYPE = 1 |
4775 |
+ |
I64TYPE = 1234567 |
4776 |
+ |
CURRTYPE = .02300000 |
4777 |
+ |
DTYPE = .00110000 |
4778 |
+ |
FIXEDPOINT = 1,234.25000000 |
4779 |
|
|
4780 |
|
|
4781 |
|
|
4782 |
|
------------------------------------------------------ |
4783 |
|
Running Test 22: Journalling |
4784 |
< |
Start Journaling. Session ID = 1 |
4784 |
> |
Start Journaling. Session ID = 0 |
4785 |
|
1234.567 parsed to 1234567 scale = -3 |
4786 |
|
As Float = 1.2345670000000000E+003 |
4787 |
|
-765.4321 parsed to -7654321 scale = -4 |
4939 |
|
|
4940 |
|
Journal Table |
4941 |
|
IBX$SESSIONID = 1 |
4942 |
< |
IBX$TRANSACTIONID = 9 |
4942 |
> |
IBX$TRANSACTIONID = 8 |
4943 |
|
IBX$OLDTRANSACTIONID = NULL |
4944 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
4945 |
< |
IBX$CREATED = 2021/12/07 09:50:08.4430 |
4945 |
> |
IBX$CREATED = 2022/01/14 22:58:12.7560 |
4946 |
|
IBX$SESSIONID = 1 |
4947 |
< |
IBX$TRANSACTIONID = 11 |
4948 |
< |
IBX$OLDTRANSACTIONID = 10 |
4947 |
> |
IBX$TRANSACTIONID = 10 |
4948 |
> |
IBX$OLDTRANSACTIONID = 9 |
4949 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
4950 |
< |
IBX$CREATED = 2021/12/07 09:50:08.7940 |
4950 |
> |
IBX$CREATED = 2022/01/14 22:58:13.0520 |
4951 |
|
|
4952 |
|
Journal Entries |
4953 |
|
Journal Entry = jeTransStart(Transaction Start) |
4954 |
< |
Timestamp = 2021/12/07 09:50:08.4700 |
4954 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4955 |
> |
Attachment ID = 4 |
4956 |
|
Session ID = 1 |
4957 |
< |
Transaction ID = 9 |
4957 |
> |
Transaction ID = 8 |
4958 |
|
Transaction Name = "Transaction_29_1" |
4959 |
|
TPB: Item Count = 3 |
4960 |
|
isc_tpb_write |
4964 |
|
Default Completion = TACommit |
4965 |
|
|
4966 |
|
Journal Entry = jeQuery(Query) |
4967 |
< |
Timestamp = 2021/12/07 09:50:08.5300 |
4967 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4968 |
> |
Attachment ID = 4 |
4969 |
|
Session ID = 1 |
4970 |
< |
Transaction ID = 9 |
4970 |
> |
Transaction ID = 8 |
4971 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
4972 |
|
|
4973 |
|
Journal Entry = jeQuery(Query) |
4974 |
< |
Timestamp = 2021/12/07 09:50:08.5510 |
4974 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4975 |
> |
Attachment ID = 4 |
4976 |
|
Session ID = 1 |
4977 |
< |
Transaction ID = 9 |
4977 |
> |
Transaction ID = 8 |
4978 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
4979 |
|
|
4980 |
|
Journal Entry = jeTransCommitRet(Commit Retaining) |
4981 |
< |
Timestamp = 2021/12/07 09:50:08.6650 |
4981 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4982 |
> |
Attachment ID = 4 |
4983 |
|
Session ID = 1 |
4984 |
< |
Transaction ID = 10 |
4985 |
< |
Old TransactionID = 9 |
4984 |
> |
Transaction ID = 9 |
4985 |
> |
Old TransactionID = 8 |
4986 |
|
|
4987 |
|
Journal Entry = jeQuery(Query) |
4988 |
< |
Timestamp = 2021/12/07 09:50:08.6870 |
4988 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4989 |
> |
Attachment ID = 4 |
4990 |
|
Session ID = 1 |
4991 |
< |
Transaction ID = 10 |
4991 |
> |
Transaction ID = 9 |
4992 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
4993 |
|
|
4994 |
|
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
4995 |
< |
Timestamp = 2021/12/07 09:50:08.7900 |
4995 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4996 |
> |
Attachment ID = 4 |
4997 |
|
Session ID = 1 |
4998 |
< |
Transaction ID = 11 |
4999 |
< |
Old TransactionID = 10 |
4998 |
> |
Transaction ID = 10 |
4999 |
> |
Old TransactionID = 9 |
5000 |
|
|
5001 |
|
Journal Entry = jeQuery(Query) |
5002 |
< |
Timestamp = 2021/12/07 09:50:08.8140 |
5002 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5003 |
> |
Attachment ID = 4 |
5004 |
|
Session ID = 1 |
5005 |
< |
Transaction ID = 11 |
5005 |
> |
Transaction ID = 10 |
5006 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
5007 |
|
|
5008 |
|
Journal Entry = jeTransStart(Transaction Start) |
5009 |
< |
Timestamp = 2021/12/07 09:50:08.8260 |
5009 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5010 |
> |
Attachment ID = 4 |
5011 |
|
Session ID = 1 |
5012 |
< |
Transaction ID = 12 |
5012 |
> |
Transaction ID = 11 |
5013 |
|
Transaction Name = "Transaction_29_2" |
5014 |
|
TPB: Item Count = 3 |
5015 |
|
isc_tpb_write |
5019 |
|
Default Completion = TARollback |
5020 |
|
|
5021 |
|
Journal Entry = jeTransCommit(Commit) |
5022 |
< |
Timestamp = 2021/12/07 09:50:08.8860 |
5022 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5023 |
> |
Attachment ID = 4 |
5024 |
|
Session ID = 1 |
5025 |
< |
Transaction ID = 11 |
5025 |
> |
Transaction ID = 10 |
5026 |
|
|
5027 |
|
Journal Entry = jeQuery(Query) |
5028 |
< |
Timestamp = 2021/12/07 09:50:08.9660 |
5028 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5029 |
> |
Attachment ID = 4 |
5030 |
|
Session ID = 1 |
5031 |
< |
Transaction ID = 12 |
5031 |
> |
Transaction ID = 11 |
5032 |
|
Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question: |
5033 |
|
Whether ''tis nobler in the mind to suffer |
5034 |
|
The slings and arrows of outrageous fortune, |
5067 |
|
') |
5068 |
|
|
5069 |
|
Journal Entry = jeQuery(Query) |
5070 |
< |
Timestamp = 2021/12/07 09:50:09.0130 |
5070 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5071 |
> |
Attachment ID = 4 |
5072 |
|
Session ID = 1 |
5073 |
< |
Transaction ID = 12 |
5073 |
> |
Transaction ID = 11 |
5074 |
|
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
5075 |
|
FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00 |
5076 |
|
0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300 |
5079 |
|
) |
5080 |
|
|
5081 |
|
Journal Entry = jeQuery(Query) |
5082 |
< |
Timestamp = 2021/12/07 09:50:09.0380 |
5082 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5083 |
> |
Attachment ID = 4 |
5084 |
|
Session ID = 1 |
5085 |
< |
Transaction ID = 12 |
5085 |
> |
Transaction ID = 11 |
5086 |
|
Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16"> |
5087 |
|
<elt ix="0">100</elt> |
5088 |
|
<elt ix="1">99</elt> |
5105 |
|
) |
5106 |
|
|
5107 |
|
Journal Entry = jeTransRollback(Rollback) |
5108 |
< |
Timestamp = 2021/12/07 09:50:09.1560 |
5108 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5109 |
> |
Attachment ID = 4 |
5110 |
|
Session ID = 1 |
5111 |
< |
Transaction ID = 12 |
5111 |
> |
Transaction ID = 11 |
5112 |
|
|
5113 |
|
|
5114 |
|
|