| 3 |
|
|
| 4 |
|
Starting Tests |
| 5 |
|
Client API Version = 2.5 |
| 6 |
< |
Firebird Environment Variable = /opt/firebird2.5.9 |
| 7 |
< |
Firebird Client Library Path = /opt/firebird2.5.9/lib/libfbembed.so |
| 6 |
> |
Firebird Environment Variable = /opt/firebird/2.5.9 |
| 7 |
> |
Firebird Client Library Path = /opt/firebird/2.5.9/lib/libfbembed.so |
| 8 |
|
Running Test 1: Create and Drop a Database |
| 9 |
|
Creating a Database with empty parameters |
| 10 |
< |
Create Database fails (as expected): I/O error during "open O_CREAT" operation for file "" |
| 11 |
< |
-Error while trying to create file |
| 12 |
< |
-No such file or directory |
| 10 |
> |
Create Database fails (as expected): Engine Code: 335544344 |
| 11 |
> |
I/O error during "open O_CREAT" operation for file "" |
| 12 |
|
Creating a Database using an SQL Statement |
| 13 |
|
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
| 14 |
|
SQL Dialect = 3 |
| 19 |
|
DB ODS Major Version = 11 |
| 20 |
|
DB ODS Minor Version = 2 |
| 21 |
|
User Authentication Method = Legacy_Auth |
| 22 |
< |
Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so |
| 22 |
> |
Firebird Library Path = /opt/firebird/2.5.9/lib/libfbembed.so |
| 23 |
|
DB Client Implementation Version = 2.5 |
| 24 |
|
DPB: Item Count = 3 |
| 25 |
|
isc_dpb_user_name = SYSDBA |
| 41 |
|
DB ODS Major Version = 11 |
| 42 |
|
DB ODS Minor Version = 2 |
| 43 |
|
User Authentication Method = Legacy_Auth |
| 44 |
< |
Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so |
| 44 |
> |
Firebird Library Path = /opt/firebird/2.5.9/lib/libfbembed.so |
| 45 |
|
DB Client Implementation Version = 2.5 |
| 46 |
|
Dropping Database |
| 47 |
|
DPB: Item Count = 4 |
| 54 |
|
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
| 55 |
|
ODS major = 11 |
| 56 |
|
ODS minor = 2 |
| 57 |
+ |
Attachment ID = 2 |
| 58 |
|
DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb |
| 59 |
|
DB Charset ID = 4 |
| 60 |
|
DB SQL Dialect = 3 |
| 62 |
|
DB ODS Major Version = 11 |
| 63 |
|
DB ODS Minor Version = 2 |
| 64 |
|
User Authentication Method = Legacy_Auth |
| 65 |
< |
Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so |
| 65 |
> |
Firebird Library Path = /opt/firebird/2.5.9/lib/libfbembed.so |
| 66 |
|
DB Client Implementation Version = 2.5 |
| 67 |
|
RDB$DESCRIPTION = |
| 68 |
|
RDB$RELATION_ID = 128 |
| 73 |
|
|
| 74 |
|
------------------------------------------------------ |
| 75 |
|
Running Test 2: Open the employee database and run a query |
| 76 |
< |
Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 76 |
> |
Open Database fails Engine Code: 335544472 |
| 77 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 78 |
|
Opening localhost:employee |
| 79 |
|
Database Open, SQL Dialect = 3 |
| 80 |
|
TPB: Item Count = 3 |
| 535 |
|
Opening localhost:employee |
| 536 |
|
Database Open |
| 537 |
|
Employee Count = 42 |
| 538 |
+ |
Transaction ID = 6470 |
| 539 |
+ |
Transaction is Read/Write |
| 540 |
+ |
Transaction ID = 6470 |
| 541 |
+ |
Oldest Interesting = 6318 |
| 542 |
+ |
Oldest Action = 6469 |
| 543 |
+ |
Oldest Snapshot = 6469 |
| 544 |
+ |
Oldest Interesting = 0 |
| 545 |
|
Employee Count = 41 |
| 546 |
|
Employee Count = 42 |
| 547 |
|
Employee Count = 41 |
| 572 |
|
SALARY = 64,635.00 |
| 573 |
|
FULL_NAME = Johnson, Leslie |
| 574 |
|
|
| 575 |
< |
Current memory = 948,496 |
| 575 |
> |
Current memory = 937,552 |
| 576 |
|
Delta memory = 1,288 |
| 577 |
< |
Max memory = 992,448 |
| 577 |
> |
Max memory = 965,624 |
| 578 |
|
Elapsed time= 0.001 sec |
| 579 |
|
Cpu = 0.000 sec |
| 580 |
|
Buffers = 75 |
| 2613 |
|
|
| 2614 |
|
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) |
| 2615 |
|
|
| 2616 |
< |
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) |
| 2616 |
> |
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) |
| 2617 |
|
|
| 2618 |
|
|
| 2619 |
|
Shrink to 2:10 |
| 2629 |
|
|
| 2630 |
|
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) |
| 2631 |
|
|
| 2632 |
< |
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) |
| 2632 |
> |
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) |
| 2633 |
|
|
| 2634 |
|
|
| 2635 |
|
|
| 2713 |
|
|
| 2714 |
|
------------------------------------------------------ |
| 2715 |
|
Running Test 9: Database Information tests |
| 2716 |
< |
Database ID = 4 FB = /opt/firebird2.5.9/examples/empbuild/employee.fdb SN = zeus |
| 2716 |
> |
Database ID = 4 FB = /opt/firebird/2.5.9/examples/empbuild/employee.fdb SN = zeus |
| 2717 |
|
Pages =272 |
| 2718 |
|
Base Level = 13,4,0,3, |
| 2719 |
|
Implementation = 11,7,0,3,66,1,66, |
| 2726 |
|
Database Created: 17/6/2019 19:37:08 |
| 2727 |
|
Unknown Response 3 |
| 2728 |
|
Unknown Response 3 |
| 2729 |
< |
Server Memory = 841392 |
| 2729 |
> |
Server Memory = 721912 |
| 2730 |
|
Forced Writes = 1 |
| 2731 |
< |
Max Memory = 879288 |
| 2731 |
> |
Max Memory = 737792 |
| 2732 |
|
Num Buffers = 75 |
| 2733 |
|
Sweep Interval = 20000 |
| 2734 |
|
Logged in Users: SYSDBA, |
| 2735 |
|
Active Transaction Count = 0 |
| 2736 |
< |
Fetches = 1040 |
| 2737 |
< |
Writes = 6 |
| 2738 |
< |
Reads = 84 |
| 2739 |
< |
Page Writes = 6 |
| 2736 |
> |
Fetches = 519 |
| 2737 |
> |
Writes = 3 |
| 2738 |
> |
Reads = 57 |
| 2739 |
> |
Page Writes = 3 |
| 2740 |
|
Record Version Removals Operation Counts |
| 2741 |
|
|
| 2742 |
|
Deletes Operation Counts |
| 2748 |
|
Purge Count Countites Operation Counts |
| 2749 |
|
|
| 2750 |
|
Indexed Reads Count Operation Counts |
| 2743 |
– |
Table ID = 2 |
| 2744 |
– |
Count = 14 |
| 2745 |
– |
Table ID = 5 |
| 2746 |
– |
Count = 28 |
| 2751 |
|
Table ID = 6 |
| 2752 |
< |
Count = 58 |
| 2752 |
> |
Count = 11 |
| 2753 |
|
Table ID = 11 |
| 2754 |
< |
Count = 3 |
| 2754 |
> |
Count = 1 |
| 2755 |
|
Table ID = 12 |
| 2756 |
< |
Count = 36 |
| 2756 |
> |
Count = 24 |
| 2757 |
|
Table ID = 28 |
| 2758 |
< |
Count = 9 |
| 2758 |
> |
Count = 4 |
| 2759 |
|
Table ID = 29 |
| 2760 |
< |
Count = 7 |
| 2760 |
> |
Count = 4 |
| 2761 |
|
|
| 2762 |
|
Sequential Table Scans Operation Counts |
| 2763 |
|
Table ID = 0 |
| 2777 |
|
Event Signalled |
| 2778 |
|
First Event - usually ignored |
| 2779 |
|
Signal Event |
| 2780 |
+ |
Event Signalled |
| 2781 |
|
Event Counts: TESTEVENT, Count = 1 |
| 2782 |
|
Two more events |
| 2783 |
|
Call Async Wait |
| 2784 |
|
Async Wait Called |
| 2785 |
|
Event Signalled |
| 2786 |
< |
Signal Event |
| 2786 |
> |
Deferred Events Caught |
| 2787 |
|
Event Counts: TESTEVENT, Count = 2 |
| 2788 |
+ |
Signal Event |
| 2789 |
+ |
Event Counts: TESTEVENT, Count = 1 |
| 2790 |
|
Async Wait: Test Cancel |
| 2791 |
|
Event Signalled |
| 2792 |
|
Async Wait Called |
| 2794 |
|
Time Out - Cancel Worked! |
| 2795 |
|
Sync wait |
| 2796 |
|
Event Signalled |
| 2797 |
< |
Event Counts: TESTEVENT, Count = 2 |
| 2797 |
> |
Event Counts: TESTEVENT, Count = 1 |
| 2798 |
|
|
| 2799 |
|
|
| 2800 |
|
------------------------------------------------------ |
| 2808 |
|
Implementation = Firebird/linux AMD64 |
| 2809 |
|
|
| 2810 |
|
Lock Directory = /tmp/firebird/ |
| 2811 |
< |
Message File = /opt/firebird2.5.9/ |
| 2812 |
< |
Security File = /opt/firebird2.5.9/security2.fdb |
| 2811 |
> |
Message File = /opt/firebird/2.5.9/ |
| 2812 |
> |
Security File = /opt/firebird/2.5.9/security2.fdb |
| 2813 |
|
|
| 2814 |
|
DB Attachments |
| 2815 |
|
No. of Attachments = 0 |
| 2824 |
|
Group ID = 0 |
| 2825 |
|
|
| 2826 |
|
|
| 2827 |
< |
Licence Info: feature is not supported |
| 2828 |
< |
-feature is not supported |
| 2827 |
> |
Licence Info: Engine Code: 335544378 |
| 2828 |
> |
feature is not supported |
| 2829 |
|
|
| 2830 |
< |
Licence Mask Info: feature is not supported |
| 2830 |
> |
Licence Mask Info: Engine Code: 335544378 |
| 2831 |
> |
feature is not supported |
| 2832 |
|
|
| 2833 |
|
Capabilities = 260 |
| 2834 |
|
|
| 3115 |
|
------------------------------------------------------ |
| 3116 |
|
Running Test 16: Error handling |
| 3117 |
|
Invalid Database Name Test |
| 3118 |
< |
Error Handled: I/O error during "open" operation for file "Malformed Name" |
| 3119 |
< |
-Error while trying to open file |
| 3120 |
< |
-No such file or directory |
| 3118 |
> |
Error Handled: SQLCODE: -902 |
| 3119 |
> |
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3120 |
> |
Engine Code: 335544344 |
| 3121 |
> |
I/O error during "open" operation for file "Malformed Name" |
| 3122 |
|
Invalid User Name Test |
| 3123 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3123 |
> |
Error Handled: SQLCODE: -902 |
| 3124 |
> |
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3125 |
> |
Engine Code: 335544472 |
| 3126 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3127 |
|
Invalid password Test |
| 3128 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3128 |
> |
Error Handled: SQLCODE: -902 |
| 3129 |
> |
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3130 |
> |
Engine Code: 335544472 |
| 3131 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3132 |
|
Invalid Prepare SQL Test |
| 3133 |
< |
Error Handled: Dynamic SQL Error |
| 3134 |
< |
-SQL error code = -206 |
| 3135 |
< |
-Column unknown |
| 3136 |
< |
-UNKNOWN_DATE |
| 3122 |
< |
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
| 3133 |
> |
Error Handled: SQLCODE: -206 |
| 3134 |
> |
Column does not belong to referenced table |
| 3135 |
> |
Engine Code: 335544569 |
| 3136 |
> |
Dynamic SQL Error When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
| 3137 |
|
Invalid Open Cursor SQL Test |
| 3138 |
< |
Error Handled: Dynamic SQL Error |
| 3139 |
< |
-SQL error code = -206 |
| 3140 |
< |
-Column unknown |
| 3141 |
< |
-X |
| 3128 |
< |
-At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE |
| 3138 |
> |
Error Handled: SQLCODE: -206 |
| 3139 |
> |
Column does not belong to referenced table |
| 3140 |
> |
Engine Code: 335544569 |
| 3141 |
> |
Dynamic SQL Error When Executing: Select X,count(*) As Counter from EMPLOYEE |
| 3142 |
|
Transaction not started Test |
| 3143 |
|
Error Handled: Transaction is not active |
| 3144 |
|
Invalid Param SQL Type Test |
| 3161 |
|
COUNTER = 42 |
| 3162 |
|
|
| 3163 |
|
Invalid Server Name Test |
| 3164 |
< |
Error Handled: Unable to complete network request to host "unknown". |
| 3165 |
< |
-Failed to locate host machine |
| 3164 |
> |
Error Handled: SQLCODE: -902 |
| 3165 |
> |
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3166 |
> |
Engine Code: 335544721 |
| 3167 |
> |
Unable to complete network request to host "unknown" |
| 3168 |
|
Invalid User Name Test |
| 3169 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3169 |
> |
Error Handled: SQLCODE: -902 |
| 3170 |
> |
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3171 |
> |
Engine Code: 335544472 |
| 3172 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3173 |
|
Invalid password Test |
| 3174 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3174 |
> |
Error Handled: SQLCODE: -902 |
| 3175 |
> |
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3176 |
> |
Engine Code: 335544472 |
| 3177 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3178 |
|
|
| 3179 |
|
|
| 3180 |
|
------------------------------------------------------ |
| 3305 |
|
Parsing of 1,000 failed |
| 3306 |
|
Parsing of 1e1e1 failed |
| 3307 |
|
Parsing of 1.2+3 failed |
| 3308 |
+ |
Validating Numeric Interface - IFBNumeric |
| 3309 |
+ |
Value from Currency = 9999.1235 |
| 3310 |
+ |
Raw Value = 99991235 Scale = -4 |
| 3311 |
+ |
Value from Currency(rescaled) = 9999.12 |
| 3312 |
+ |
Raw Value = 999912 Scale = -2 |
| 3313 |
+ |
Value from Double = 9999.12345678 |
| 3314 |
+ |
Raw Value = 999912345678 Scale = -8 |
| 3315 |
+ |
Value from Integer = 9223372036854775807 |
| 3316 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
| 3317 |
+ |
Value from string = 9223372036854775807 |
| 3318 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
| 3319 |
+ |
Value from string = 9999.12345678 |
| 3320 |
+ |
Raw Value = 999912345678 Scale = -8 |
| 3321 |
+ |
Value from string = -0.12 |
| 3322 |
+ |
Raw Value = -12 Scale = -3 |
| 3323 |
+ |
Value from BCD = 9999.12345678 |
| 3324 |
+ |
Raw Value = 999912345678 Scale = -8 |
| 3325 |
+ |
Value from Raw Data = 9999123.456780 |
| 3326 |
+ |
Raw Value = 9999123456780 Scale = -6 |
| 3327 |
+ |
Numeric Operations |
| 3328 |
+ |
Add 2.23 + 24.12345 = 26.35345 |
| 3329 |
+ |
Add Double 2.23 + 24.12645 = 26.35645 |
| 3330 |
+ |
Add integer 2.23 + 2412345 = 2412347.23 |
| 3331 |
+ |
Subtract 2.23 - 24.12345 = -21.89345 |
| 3332 |
+ |
Subtract Double 24.12645 - 2.23 = -21.89645 |
| 3333 |
+ |
Subtract integer 24123.45 - 223 = -23900.45 |
| 3334 |
+ |
Multiply 2.23 * 24.12345 = 53.7952935 |
| 3335 |
+ |
Multiply Double 24.12645 * 2.23 = 53.8019835 |
| 3336 |
+ |
Multiply integer 241.2345 * 223 = 53795.2935 |
| 3337 |
+ |
Divide 24.12345 / 2.23 = 10.81769 |
| 3338 |
+ |
Divide Double 2.23 / 24.12645 = 0.09 |
| 3339 |
+ |
Divide integer 241.2345 / 223 = 1.0818 |
| 3340 |
+ |
Compare 2.23, -24.12345 = 1 |
| 3341 |
+ |
Compare integer 2.23, 3 = -1 |
| 3342 |
+ |
Compare Double 2.23, 2.23 = 0 |
| 3343 |
+ |
Negate 24.12345 = -24.12345 |
| 3344 |
|
SQL Params |
| 3345 |
|
SQLType =SQL_LONG |
| 3346 |
|
sub type = 0 |
| 3391 |
|
Nullable |
| 3392 |
|
Size = 8 |
| 3393 |
|
|
| 3394 |
< |
Expected Error - Dynamic SQL Error |
| 3395 |
< |
-SQL error code = -303 |
| 3396 |
< |
-conversion error from string "1,000" |
| 3397 |
< |
Expected Error - Dynamic SQL Error |
| 3398 |
< |
-SQL error code = -303 |
| 3399 |
< |
-conversion error from string "10.0.0" |
| 3394 |
> |
Expected Error - SQLCODE: -303 |
| 3395 |
> |
Incompatible column/host variable data type |
| 3396 |
> |
Engine Code: 335544569 |
| 3397 |
> |
Dynamic SQL Error |
| 3398 |
> |
Expected Error - SQLCODE: -303 |
| 3399 |
> |
Incompatible column/host variable data type |
| 3400 |
> |
Engine Code: 335544569 |
| 3401 |
> |
Dynamic SQL Error |
| 3402 |
> |
Test Numeric Type |
| 3403 |
|
ROWID = 1 |
| 3404 |
|
ITYPE = 101 |
| 3405 |
|
I64TYPE = 9223372036854775807 |
| 3424 |
|
CURRTYPE = .02300000 |
| 3425 |
|
DTYPE = .00110000 |
| 3426 |
|
FIXEDPOINT = 233.45600000 |
| 3427 |
+ |
ROWID = 7 |
| 3428 |
+ |
ITYPE = 1 |
| 3429 |
+ |
I64TYPE = 1234567 |
| 3430 |
+ |
CURRTYPE = .02300000 |
| 3431 |
+ |
DTYPE = .00110000 |
| 3432 |
+ |
FIXEDPOINT = 1,234.25000000 |
| 3433 |
+ |
|
| 3434 |
+ |
|
| 3435 |
+ |
|
| 3436 |
+ |
------------------------------------------------------ |
| 3437 |
+ |
Running Test 22: Journalling |
| 3438 |
+ |
Start Journaling. Session ID = 0 |
| 3439 |
+ |
1234.567 parsed to 1234567 scale = -3 |
| 3440 |
+ |
As Float = 1.2345670000000000E+003 |
| 3441 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
| 3442 |
+ |
As Float = -7.6543209999999999E+002 |
| 3443 |
+ |
0.1 parsed to 1 scale = -1 |
| 3444 |
+ |
As Float = 1.0000000000000001E-001 |
| 3445 |
+ |
0.01 parsed to 1 scale = -2 |
| 3446 |
+ |
As Float = 1.0000000000000000E-002 |
| 3447 |
+ |
+123 parsed to 123 scale = 0 |
| 3448 |
+ |
As Float = 1.2300000000000000E+002 |
| 3449 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
| 3450 |
+ |
As Float = 1.2345600000000001E+308 |
| 3451 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
| 3452 |
+ |
As Float = -1.2000000000000000E-002 |
| 3453 |
+ |
10. parsed to 10 scale = 0 |
| 3454 |
+ |
As Float = 1.0000000000000000E+001 |
| 3455 |
+ |
.12 parsed to 12 scale = -2 |
| 3456 |
+ |
As Float = 1.2000000000000000E-001 |
| 3457 |
+ |
0.12 parsed to 12 scale = -2 |
| 3458 |
+ |
As Float = 1.2000000000000000E-001 |
| 3459 |
+ |
Parsing of 1.2E1.2 failed |
| 3460 |
+ |
Parsing of 1,000 failed |
| 3461 |
+ |
Parsing of 1e1e1 failed |
| 3462 |
+ |
Parsing of 1.2+3 failed |
| 3463 |
+ |
SQL Params |
| 3464 |
+ |
SQLType =SQL_LONG |
| 3465 |
+ |
sub type = 0 |
| 3466 |
+ |
Field Name = |
| 3467 |
+ |
Scale = 0 |
| 3468 |
+ |
Charset id = 0 |
| 3469 |
+ |
Not Null |
| 3470 |
+ |
Size = 4 |
| 3471 |
+ |
Value = 0 |
| 3472 |
+ |
|
| 3473 |
+ |
SQLType =SQL_LONG |
| 3474 |
+ |
sub type = 0 |
| 3475 |
+ |
Field Name = |
| 3476 |
+ |
Scale = 0 |
| 3477 |
+ |
Charset id = 0 |
| 3478 |
+ |
Nullable |
| 3479 |
+ |
Size = 4 |
| 3480 |
+ |
|
| 3481 |
+ |
SQLType =SQL_INT64 |
| 3482 |
+ |
sub type = 0 |
| 3483 |
+ |
Field Name = |
| 3484 |
+ |
Scale = 0 |
| 3485 |
+ |
Charset id = 0 |
| 3486 |
+ |
Nullable |
| 3487 |
+ |
Size = 8 |
| 3488 |
+ |
|
| 3489 |
+ |
SQLType =SQL_INT64 |
| 3490 |
+ |
sub type = 0 |
| 3491 |
+ |
Field Name = |
| 3492 |
+ |
Scale = -4 |
| 3493 |
+ |
Charset id = 0 |
| 3494 |
+ |
Nullable |
| 3495 |
+ |
Size = 8 |
| 3496 |
+ |
|
| 3497 |
+ |
SQLType =SQL_DOUBLE |
| 3498 |
+ |
sub type = 0 |
| 3499 |
+ |
Field Name = |
| 3500 |
+ |
Scale = 0 |
| 3501 |
+ |
Charset id = 0 |
| 3502 |
+ |
Nullable |
| 3503 |
+ |
Size = 8 |
| 3504 |
+ |
|
| 3505 |
+ |
SQLType =SQL_INT64 |
| 3506 |
+ |
sub type = 0 |
| 3507 |
+ |
Field Name = |
| 3508 |
+ |
Scale = -6 |
| 3509 |
+ |
Charset id = 0 |
| 3510 |
+ |
Nullable |
| 3511 |
+ |
Size = 8 |
| 3512 |
+ |
|
| 3513 |
+ |
|
| 3514 |
+ |
Text Tests |
| 3515 |
+ |
SQL Params |
| 3516 |
+ |
SQLType =SQL_LONG |
| 3517 |
+ |
sub type = 0 |
| 3518 |
+ |
Field Name = |
| 3519 |
+ |
Scale = 0 |
| 3520 |
+ |
Charset id = 0 |
| 3521 |
+ |
Not Null |
| 3522 |
+ |
Size = 4 |
| 3523 |
+ |
Value = 0 |
| 3524 |
+ |
|
| 3525 |
+ |
SQLType =SQL_VARYING |
| 3526 |
+ |
sub type = 0 |
| 3527 |
+ |
Field Name = |
| 3528 |
+ |
Scale = 0 |
| 3529 |
+ |
Charset id = 4 |
| 3530 |
+ |
Nullable |
| 3531 |
+ |
Size = 1024 |
| 3532 |
+ |
|
| 3533 |
+ |
SQLType =SQL_BLOB |
| 3534 |
+ |
sub type = 1 |
| 3535 |
+ |
Field Name = |
| 3536 |
+ |
Scale = 0 |
| 3537 |
+ |
Charset id = 4 |
| 3538 |
+ |
Nullable |
| 3539 |
+ |
Size = 8 |
| 3540 |
+ |
|
| 3541 |
+ |
|
| 3542 |
+ |
Binary Blob Tests |
| 3543 |
+ |
|
| 3544 |
+ |
Array Test |
| 3545 |
+ |
SQL Params |
| 3546 |
+ |
SQLType =SQL_LONG |
| 3547 |
+ |
sub type = 0 |
| 3548 |
+ |
Field Name = |
| 3549 |
+ |
Scale = 0 |
| 3550 |
+ |
Charset id = 0 |
| 3551 |
+ |
Not Null |
| 3552 |
+ |
Size = 4 |
| 3553 |
+ |
Value = 0 |
| 3554 |
+ |
|
| 3555 |
+ |
SQLType =SQL_ARRAY |
| 3556 |
+ |
sub type = 0 |
| 3557 |
+ |
Field Name = |
| 3558 |
+ |
Scale = 0 |
| 3559 |
+ |
Charset id = 0 |
| 3560 |
+ |
Nullable |
| 3561 |
+ |
Size = 8 |
| 3562 |
+ |
|
| 3563 |
+ |
ROWID = 1 |
| 3564 |
+ |
ITYPE = 101 |
| 3565 |
+ |
I64TYPE = 9223372036854775807 |
| 3566 |
+ |
CURRTYPE = 10,000.12340000 |
| 3567 |
+ |
DTYPE = 9,999.12345678 |
| 3568 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
| 3569 |
+ |
STR = NULL |
| 3570 |
+ |
TEXTBLOB = NULL |
| 3571 |
+ |
OTHERBLOB = NULL |
| 3572 |
+ |
MYARRAY = NULL |
| 3573 |
+ |
ROWID = 2 |
| 3574 |
+ |
ITYPE = -32457 |
| 3575 |
+ |
I64TYPE = -9223372036854775808 |
| 3576 |
+ |
CURRTYPE = 1,000,001.12000000 |
| 3577 |
+ |
DTYPE = 1.7E308 |
| 3578 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
| 3579 |
+ |
STR = NULL |
| 3580 |
+ |
TEXTBLOB = NULL |
| 3581 |
+ |
OTHERBLOB = NULL |
| 3582 |
+ |
MYARRAY = NULL |
| 3583 |
+ |
ROWID = 4 |
| 3584 |
+ |
ITYPE = 1 |
| 3585 |
+ |
I64TYPE = 10 |
| 3586 |
+ |
CURRTYPE = .02300000 |
| 3587 |
+ |
DTYPE = .00110000 |
| 3588 |
+ |
FIXEDPOINT = 233.45600000 |
| 3589 |
+ |
STR = NULL |
| 3590 |
+ |
TEXTBLOB = NULL |
| 3591 |
+ |
OTHERBLOB = NULL |
| 3592 |
+ |
MYARRAY = NULL |
| 3593 |
+ |
|
| 3594 |
+ |
Journal Table |
| 3595 |
+ |
IBX$SESSIONID = 1 |
| 3596 |
+ |
IBX$TRANSACTIONID = 8 |
| 3597 |
+ |
IBX$OLDTRANSACTIONID = NULL |
| 3598 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
| 3599 |
+ |
IBX$CREATED = 2022/07/18 14:42:19.7840 |
| 3600 |
+ |
IBX$SESSIONID = 1 |
| 3601 |
+ |
IBX$TRANSACTIONID = 10 |
| 3602 |
+ |
IBX$OLDTRANSACTIONID = 9 |
| 3603 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
| 3604 |
+ |
IBX$CREATED = 2022/07/18 14:42:19.8630 |
| 3605 |
+ |
|
| 3606 |
+ |
Journal Entries |
| 3607 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
| 3608 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3609 |
+ |
Attachment ID = 2 |
| 3610 |
+ |
Session ID = 1 |
| 3611 |
+ |
Transaction ID = 8 |
| 3612 |
+ |
Transaction Name = "Transaction_29_1" |
| 3613 |
+ |
TPB: Item Count = 3 |
| 3614 |
+ |
isc_tpb_write |
| 3615 |
+ |
isc_tpb_nowait |
| 3616 |
+ |
isc_tpb_concurrency |
| 3617 |
+ |
|
| 3618 |
+ |
Default Completion = TACommit |
| 3619 |
+ |
|
| 3620 |
+ |
Journal Entry = jeQuery(Query) |
| 3621 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3622 |
+ |
Attachment ID = 2 |
| 3623 |
+ |
Session ID = 1 |
| 3624 |
+ |
Transaction ID = 8 |
| 3625 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
| 3626 |
+ |
|
| 3627 |
+ |
Journal Entry = jeQuery(Query) |
| 3628 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3629 |
+ |
Attachment ID = 2 |
| 3630 |
+ |
Session ID = 1 |
| 3631 |
+ |
Transaction ID = 8 |
| 3632 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
| 3633 |
+ |
|
| 3634 |
+ |
Journal Entry = jeTransCommitRet(Commit Retaining) |
| 3635 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3636 |
+ |
Attachment ID = 2 |
| 3637 |
+ |
Session ID = 1 |
| 3638 |
+ |
Transaction ID = 9 |
| 3639 |
+ |
Old TransactionID = 8 |
| 3640 |
+ |
|
| 3641 |
+ |
Journal Entry = jeQuery(Query) |
| 3642 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3643 |
+ |
Attachment ID = 2 |
| 3644 |
+ |
Session ID = 1 |
| 3645 |
+ |
Transaction ID = 9 |
| 3646 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
| 3647 |
+ |
|
| 3648 |
+ |
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
| 3649 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3650 |
+ |
Attachment ID = 2 |
| 3651 |
+ |
Session ID = 1 |
| 3652 |
+ |
Transaction ID = 10 |
| 3653 |
+ |
Old TransactionID = 9 |
| 3654 |
+ |
|
| 3655 |
+ |
Journal Entry = jeQuery(Query) |
| 3656 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3657 |
+ |
Attachment ID = 2 |
| 3658 |
+ |
Session ID = 1 |
| 3659 |
+ |
Transaction ID = 10 |
| 3660 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
| 3661 |
+ |
|
| 3662 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
| 3663 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3664 |
+ |
Attachment ID = 2 |
| 3665 |
+ |
Session ID = 1 |
| 3666 |
+ |
Transaction ID = 11 |
| 3667 |
+ |
Transaction Name = "Transaction_29_2" |
| 3668 |
+ |
TPB: Item Count = 3 |
| 3669 |
+ |
isc_tpb_write |
| 3670 |
+ |
isc_tpb_nowait |
| 3671 |
+ |
isc_tpb_concurrency |
| 3672 |
+ |
|
| 3673 |
+ |
Default Completion = TARollback |
| 3674 |
+ |
|
| 3675 |
+ |
Journal Entry = jeTransCommit(Commit) |
| 3676 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3677 |
+ |
Attachment ID = 2 |
| 3678 |
+ |
Session ID = 1 |
| 3679 |
+ |
Transaction ID = 10 |
| 3680 |
+ |
|
| 3681 |
+ |
Journal Entry = jeQuery(Query) |
| 3682 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3683 |
+ |
Attachment ID = 2 |
| 3684 |
+ |
Session ID = 1 |
| 3685 |
+ |
Transaction ID = 11 |
| 3686 |
+ |
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: |
| 3687 |
+ |
Whether ''tis nobler in the mind to suffer |
| 3688 |
+ |
The slings and arrows of outrageous fortune, |
| 3689 |
+ |
Or to take arms against a sea of troubles, |
| 3690 |
+ |
And, by opposing, end them. To die, to sleep- |
| 3691 |
+ |
No more-and by a sleep to say we end |
| 3692 |
+ |
The heartache and the thousand natural shocks |
| 3693 |
+ |
That flesh is heir to-''tis a consummation |
| 3694 |
+ |
Devoutly to be wished. To die, to sleep- |
| 3695 |
+ |
To sleep, perchance to dream. Aye, there''s the rub, |
| 3696 |
+ |
For in that sleep of death what dreams may come, |
| 3697 |
+ |
When we have shuffled off this mortal coil, |
| 3698 |
+ |
Must give us pause. There''s the respect |
| 3699 |
+ |
That makes calamity of so long life. |
| 3700 |
+ |
For who would bear the whips and scorns of time, |
| 3701 |
+ |
Th'' oppressor''s wrong, the proud man''s contumely, |
| 3702 |
+ |
The pangs of despised love, the law’s delay, |
| 3703 |
+ |
The insolence of office, and the spurns |
| 3704 |
+ |
That patient merit of the unworthy takes, |
| 3705 |
+ |
When he himself might his quietus make |
| 3706 |
+ |
With a bare bodkin? Who would fardels bear, |
| 3707 |
+ |
To grunt and sweat under a weary life, |
| 3708 |
+ |
But that the dread of something after death, |
| 3709 |
+ |
The undiscovered country from whose bourn |
| 3710 |
+ |
No traveler returns, puzzles the will |
| 3711 |
+ |
And makes us rather bear those ills we have |
| 3712 |
+ |
Than fly to others that we know not of? |
| 3713 |
+ |
Thus conscience does make cowards of us all, |
| 3714 |
+ |
And thus the native hue of resolution |
| 3715 |
+ |
Is sicklied o''er with the pale cast of thought, |
| 3716 |
+ |
And enterprises of great pitch and moment, |
| 3717 |
+ |
With this regard their currents turn awry, |
| 3718 |
+ |
And lose the name of action.-Soft you now, |
| 3719 |
+ |
The fair Ophelia.-Nymph, in thy orisons |
| 3720 |
+ |
Be all my sins remembered |
| 3721 |
+ |
') |
| 3722 |
+ |
|
| 3723 |
+ |
Journal Entry = jeQuery(Query) |
| 3724 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3725 |
+ |
Attachment ID = 2 |
| 3726 |
+ |
Session ID = 1 |
| 3727 |
+ |
Transaction ID = 11 |
| 3728 |
+ |
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
| 3729 |
+ |
FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00 |
| 3730 |
+ |
0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300 |
| 3731 |
+ |
01000000010000001A01050001000000DA000000 |
| 3732 |
+ |
</blob> |
| 3733 |
+ |
) |
| 3734 |
+ |
|
| 3735 |
+ |
Journal Entry = jeQuery(Query) |
| 3736 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3737 |
+ |
Attachment ID = 2 |
| 3738 |
+ |
Session ID = 1 |
| 3739 |
+ |
Transaction ID = 11 |
| 3740 |
+ |
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"> |
| 3741 |
+ |
<elt ix="0">100</elt> |
| 3742 |
+ |
<elt ix="1">99</elt> |
| 3743 |
+ |
<elt ix="2">98</elt> |
| 3744 |
+ |
<elt ix="3">97</elt> |
| 3745 |
+ |
<elt ix="4">96</elt> |
| 3746 |
+ |
<elt ix="5">95</elt> |
| 3747 |
+ |
<elt ix="6">94</elt> |
| 3748 |
+ |
<elt ix="7">93</elt> |
| 3749 |
+ |
<elt ix="8">92</elt> |
| 3750 |
+ |
<elt ix="9">91</elt> |
| 3751 |
+ |
<elt ix="10">90</elt> |
| 3752 |
+ |
<elt ix="11">89</elt> |
| 3753 |
+ |
<elt ix="12">88</elt> |
| 3754 |
+ |
<elt ix="13">87</elt> |
| 3755 |
+ |
<elt ix="14">86</elt> |
| 3756 |
+ |
<elt ix="15">85</elt> |
| 3757 |
+ |
<elt ix="16">84</elt> |
| 3758 |
+ |
</array> |
| 3759 |
+ |
) |
| 3760 |
+ |
|
| 3761 |
+ |
Journal Entry = jeTransRollback(Rollback) |
| 3762 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 3763 |
+ |
Attachment ID = 2 |
| 3764 |
+ |
Session ID = 1 |
| 3765 |
+ |
Transaction ID = 11 |
| 3766 |
|
|
| 3767 |
|
|
| 3768 |
|
|
