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 = 173 |
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 |
657 |
> |
Transaction ID = 173 |
658 |
> |
Oldest Interesting = 171 |
659 |
> |
Oldest Action = 172 |
660 |
> |
Oldest Snapshot = 172 |
661 |
|
Oldest Snapshot Number = 2 |
662 |
|
Lock Timeout = 0 |
663 |
|
Transaction Access = isc_info_tra_readwrite |
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,767,936 |
696 |
|
Delta memory = 4,464 |
697 |
< |
Max memory = 19,813,568 |
698 |
< |
Elapsed time= 0.001 sec |
697 |
> |
Max memory = 19,813,552 |
698 |
> |
Elapsed time= 0.002 sec |
699 |
|
Cpu = 0.000 sec |
700 |
|
Buffers = 2048 |
701 |
|
Reads = 0 |
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.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.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.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.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 =346 |
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 = 310 |
2848 |
> |
Pages Free = 36 |
2849 |
> |
Server Memory = 19482432 |
2850 |
|
Forced Writes = 1 |
2851 |
< |
Max Memory = 19630384 |
2851 |
> |
Max Memory = 19629552 |
2852 |
|
Num Buffers = 2048 |
2853 |
|
Sweep Interval = 20000 |
2854 |
|
Logged in Users: SYSDBA, |
2855 |
|
Active Transaction Count = 0 |
2856 |
< |
Fetches = 1653 |
2856 |
> |
Fetches = 1634 |
2857 |
|
Writes = 8 |
2858 |
< |
Reads = 92 |
2858 |
> |
Reads = 91 |
2859 |
|
Page Writes = 4 |
2860 |
|
Record Version Removals Operation Counts |
2861 |
|
|
2879 |
|
Table ID = 12 |
2880 |
|
Count = 24 |
2881 |
|
Table ID = 18 |
2882 |
< |
Count = 821 |
2882 |
> |
Count = 805 |
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 |
2897 |
|
|
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 |
|
SQL Params |
4672 |
|
SQLType =SQL_LONG |
4673 |
|
sub type = 0 |
4728 |
|
Dynamic SQL Error |
4729 |
|
-SQL error code = -303 |
4730 |
|
-conversion error from string "10.0.0" |
4731 |
+ |
Test Numeric Type |
4732 |
|
ROWID = 1 |
4733 |
|
ITYPE = 101 |
4734 |
|
I64TYPE = 9223372036854775807 |
4753 |
|
CURRTYPE = .02300000 |
4754 |
|
DTYPE = .00110000 |
4755 |
|
FIXEDPOINT = 233.45600000 |
4756 |
+ |
ROWID = 7 |
4757 |
+ |
ITYPE = 1 |
4758 |
+ |
I64TYPE = 1234567 |
4759 |
+ |
CURRTYPE = .02300000 |
4760 |
+ |
DTYPE = .00110000 |
4761 |
+ |
FIXEDPOINT = 1,234.25000000 |
4762 |
|
|
4763 |
|
|
4764 |
|
|
4765 |
|
------------------------------------------------------ |
4766 |
|
Running Test 22: Journalling |
4767 |
< |
Start Journaling. Session ID = 1 |
4767 |
> |
Start Journaling. Session ID = 0 |
4768 |
|
1234.567 parsed to 1234567 scale = -3 |
4769 |
|
As Float = 1.2345670000000000E+003 |
4770 |
|
-765.4321 parsed to -7654321 scale = -4 |
4925 |
|
IBX$TRANSACTIONID = 9 |
4926 |
|
IBX$OLDTRANSACTIONID = NULL |
4927 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
4928 |
< |
IBX$CREATED = 2021/12/07 09:50:08.4430 |
4928 |
> |
IBX$CREATED = 2022/01/02 14:16:56.6410 |
4929 |
|
IBX$SESSIONID = 1 |
4930 |
|
IBX$TRANSACTIONID = 11 |
4931 |
|
IBX$OLDTRANSACTIONID = 10 |
4932 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
4933 |
< |
IBX$CREATED = 2021/12/07 09:50:08.7940 |
4933 |
> |
IBX$CREATED = 2022/01/02 14:16:56.9850 |
4934 |
|
|
4935 |
|
Journal Entries |
4936 |
|
Journal Entry = jeTransStart(Transaction Start) |
4937 |
< |
Timestamp = 2021/12/07 09:50:08.4700 |
4937 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4938 |
> |
Attachment ID = 4 |
4939 |
|
Session ID = 1 |
4940 |
|
Transaction ID = 9 |
4941 |
|
Transaction Name = "Transaction_29_1" |
4947 |
|
Default Completion = TACommit |
4948 |
|
|
4949 |
|
Journal Entry = jeQuery(Query) |
4950 |
< |
Timestamp = 2021/12/07 09:50:08.5300 |
4950 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4951 |
> |
Attachment ID = 4 |
4952 |
|
Session ID = 1 |
4953 |
|
Transaction ID = 9 |
4954 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
4955 |
|
|
4956 |
|
Journal Entry = jeQuery(Query) |
4957 |
< |
Timestamp = 2021/12/07 09:50:08.5510 |
4957 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4958 |
> |
Attachment ID = 4 |
4959 |
|
Session ID = 1 |
4960 |
|
Transaction ID = 9 |
4961 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
4962 |
|
|
4963 |
|
Journal Entry = jeTransCommitRet(Commit Retaining) |
4964 |
< |
Timestamp = 2021/12/07 09:50:08.6650 |
4964 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4965 |
> |
Attachment ID = 4 |
4966 |
|
Session ID = 1 |
4967 |
|
Transaction ID = 10 |
4968 |
|
Old TransactionID = 9 |
4969 |
|
|
4970 |
|
Journal Entry = jeQuery(Query) |
4971 |
< |
Timestamp = 2021/12/07 09:50:08.6870 |
4971 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4972 |
> |
Attachment ID = 4 |
4973 |
|
Session ID = 1 |
4974 |
|
Transaction ID = 10 |
4975 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
4976 |
|
|
4977 |
|
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
4978 |
< |
Timestamp = 2021/12/07 09:50:08.7900 |
4978 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4979 |
> |
Attachment ID = 4 |
4980 |
|
Session ID = 1 |
4981 |
|
Transaction ID = 11 |
4982 |
|
Old TransactionID = 10 |
4983 |
|
|
4984 |
|
Journal Entry = jeQuery(Query) |
4985 |
< |
Timestamp = 2021/12/07 09:50:08.8140 |
4985 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4986 |
> |
Attachment ID = 4 |
4987 |
|
Session ID = 1 |
4988 |
|
Transaction ID = 11 |
4989 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
4990 |
|
|
4991 |
|
Journal Entry = jeTransStart(Transaction Start) |
4992 |
< |
Timestamp = 2021/12/07 09:50:08.8260 |
4992 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4993 |
> |
Attachment ID = 4 |
4994 |
|
Session ID = 1 |
4995 |
|
Transaction ID = 12 |
4996 |
|
Transaction Name = "Transaction_29_2" |
5002 |
|
Default Completion = TARollback |
5003 |
|
|
5004 |
|
Journal Entry = jeTransCommit(Commit) |
5005 |
< |
Timestamp = 2021/12/07 09:50:08.8860 |
5005 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5006 |
> |
Attachment ID = 4 |
5007 |
|
Session ID = 1 |
5008 |
|
Transaction ID = 11 |
5009 |
|
|
5010 |
|
Journal Entry = jeQuery(Query) |
5011 |
< |
Timestamp = 2021/12/07 09:50:08.9660 |
5011 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5012 |
> |
Attachment ID = 4 |
5013 |
|
Session ID = 1 |
5014 |
|
Transaction ID = 12 |
5015 |
|
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: |
5050 |
|
') |
5051 |
|
|
5052 |
|
Journal Entry = jeQuery(Query) |
5053 |
< |
Timestamp = 2021/12/07 09:50:09.0130 |
5053 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5054 |
> |
Attachment ID = 4 |
5055 |
|
Session ID = 1 |
5056 |
|
Transaction ID = 12 |
5057 |
|
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
5062 |
|
) |
5063 |
|
|
5064 |
|
Journal Entry = jeQuery(Query) |
5065 |
< |
Timestamp = 2021/12/07 09:50:09.0380 |
5065 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5066 |
> |
Attachment ID = 4 |
5067 |
|
Session ID = 1 |
5068 |
|
Transaction ID = 12 |
5069 |
|
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"> |
5088 |
|
) |
5089 |
|
|
5090 |
|
Journal Entry = jeTransRollback(Rollback) |
5091 |
< |
Timestamp = 2021/12/07 09:50:09.1560 |
5091 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5092 |
> |
Attachment ID = 4 |
5093 |
|
Session ID = 1 |
5094 |
|
Transaction ID = 12 |
5095 |
|
|