7 |
|
Firebird Client Library Path = /opt/firebird2.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 I/O error during "open O_CREAT" operation for file "" |
11 |
|
Creating a Database using an SQL Statement |
12 |
|
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
13 |
|
SQL Dialect = 3 |
53 |
|
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
54 |
|
ODS major = 11 |
55 |
|
ODS minor = 2 |
56 |
+ |
Attachment ID = 2 |
57 |
|
DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb |
58 |
|
DB Charset ID = 4 |
59 |
|
DB SQL Dialect = 3 |
72 |
|
|
73 |
|
------------------------------------------------------ |
74 |
|
Running Test 2: Open the employee database and run a query |
75 |
+ |
Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
76 |
|
Opening localhost:employee |
77 |
|
Database Open, SQL Dialect = 3 |
78 |
|
TPB: Item Count = 3 |
287 |
|
Size = 2 |
288 |
|
Value = 0 |
289 |
|
|
290 |
+ |
Results for Cursor: Test Cursor |
291 |
|
EMP_NO = 8 |
292 |
|
FIRST_NAME = Leslie |
293 |
|
LAST_NAME = Johnson |
513 |
|
Size = 2 |
514 |
|
Value = 0 |
515 |
|
|
516 |
+ |
Results for Cursor: Test Cursor |
517 |
|
EMP_NO = 8 |
518 |
|
FIRST_NAME = Leslie |
519 |
|
LAST_NAME = Johnson |
533 |
|
Opening localhost:employee |
534 |
|
Database Open |
535 |
|
Employee Count = 42 |
536 |
+ |
Transaction ID = 6014 |
537 |
+ |
Transaction is Read/Write |
538 |
+ |
Transaction ID = 6014 |
539 |
+ |
Oldest Interesting = 5461 |
540 |
+ |
Oldest Action = 6013 |
541 |
+ |
Oldest Snapshot = 6013 |
542 |
+ |
Oldest Interesting = 0 |
543 |
|
Employee Count = 41 |
544 |
|
Employee Count = 42 |
545 |
|
Employee Count = 41 |
570 |
|
SALARY = 64,635.00 |
571 |
|
FULL_NAME = Johnson, Leslie |
572 |
|
|
573 |
< |
Current memory = 948,520 |
574 |
< |
Delta memory = 1,400 |
575 |
< |
Max memory = 992,448 |
576 |
< |
Elapsed time= 0.002 sec |
577 |
< |
Cpu = 0.000 sec |
573 |
> |
Current memory = 937,656 |
574 |
> |
Delta memory = 1,296 |
575 |
> |
Max memory = 965,720 |
576 |
> |
Elapsed time= 0.003 sec |
577 |
> |
Cpu = 0.001 sec |
578 |
|
Buffers = 75 |
579 |
|
Reads = 0 |
580 |
|
Writes = 0 |
736 |
|
JOB_CODE = Eng |
737 |
|
JOB_GRADE = 4 |
738 |
|
JOB_COUNTRY = England |
739 |
< |
SALARY = 40,000.58 |
739 |
> |
SALARY = 40,000.59 |
740 |
|
FULL_NAME = Major, Major |
741 |
|
|
742 |
|
Now Delete the rows |
2611 |
|
|
2612 |
|
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) |
2613 |
|
|
2614 |
< |
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: 14.69) (15: 15.75) (16: 16.79) |
2614 |
> |
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) |
2615 |
|
|
2616 |
|
|
2617 |
|
Shrink to 2:10 |
2627 |
|
|
2628 |
|
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) |
2629 |
|
|
2630 |
< |
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: 14.69) (15: 15.75) (16: 16.79) |
2630 |
> |
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) |
2631 |
|
|
2632 |
|
|
2633 |
|
|
2724 |
|
Database Created: 17/6/2019 19:37:08 |
2725 |
|
Unknown Response 3 |
2726 |
|
Unknown Response 3 |
2727 |
< |
Server Memory = 841392 |
2727 |
> |
Server Memory = 721912 |
2728 |
|
Forced Writes = 1 |
2729 |
< |
Max Memory = 879176 |
2729 |
> |
Max Memory = 737792 |
2730 |
|
Num Buffers = 75 |
2731 |
|
Sweep Interval = 20000 |
2732 |
|
Logged in Users: SYSDBA, |
2733 |
|
Active Transaction Count = 0 |
2734 |
< |
Fetches = 1040 |
2735 |
< |
Writes = 6 |
2736 |
< |
Reads = 84 |
2737 |
< |
Page Writes = 6 |
2734 |
> |
Fetches = 520 |
2735 |
> |
Writes = 4 |
2736 |
> |
Reads = 58 |
2737 |
> |
Page Writes = 4 |
2738 |
|
Record Version Removals Operation Counts |
2739 |
|
|
2740 |
|
Deletes Operation Counts |
2746 |
|
Purge Count Countites Operation Counts |
2747 |
|
|
2748 |
|
Indexed Reads Count Operation Counts |
2740 |
– |
Table ID = 2 |
2741 |
– |
Count = 14 |
2742 |
– |
Table ID = 5 |
2743 |
– |
Count = 28 |
2749 |
|
Table ID = 6 |
2750 |
< |
Count = 58 |
2750 |
> |
Count = 11 |
2751 |
|
Table ID = 11 |
2752 |
< |
Count = 3 |
2752 |
> |
Count = 1 |
2753 |
|
Table ID = 12 |
2754 |
< |
Count = 36 |
2754 |
> |
Count = 24 |
2755 |
|
Table ID = 28 |
2756 |
< |
Count = 9 |
2756 |
> |
Count = 4 |
2757 |
|
Table ID = 29 |
2758 |
< |
Count = 7 |
2758 |
> |
Count = 4 |
2759 |
|
|
2760 |
|
Sequential Table Scans Operation Counts |
2761 |
|
Table ID = 0 |
2819 |
|
Group ID = 0 |
2820 |
|
|
2821 |
|
|
2822 |
< |
Licence Info: feature is not supported |
2818 |
< |
-feature is not supported |
2822 |
> |
Licence Info: Engine Code: 335544378 feature is not supported |
2823 |
|
|
2824 |
< |
Licence Mask Info: feature is not supported |
2824 |
> |
Licence Mask Info: Engine Code: 335544378 feature is not supported |
2825 |
|
|
2826 |
|
Capabilities = 260 |
2827 |
|
|
3108 |
|
------------------------------------------------------ |
3109 |
|
Running Test 16: Error handling |
3110 |
|
Invalid Database Name Test |
3111 |
< |
Error Handled: I/O error during "open" operation for file "Malformed Name" |
3112 |
< |
-Error while trying to open file |
3113 |
< |
-No such file or directory |
3111 |
> |
Error Handled: SQLCODE: -902 |
3112 |
> |
Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3113 |
> |
I/O error during "open" operation for file "Malformed Name" |
3114 |
|
Invalid User Name Test |
3115 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3115 |
> |
Error Handled: SQLCODE: -902 |
3116 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3117 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3118 |
|
Invalid password Test |
3119 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3119 |
> |
Error Handled: SQLCODE: -902 |
3120 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3121 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3122 |
|
Invalid Prepare SQL Test |
3123 |
< |
Error Handled: Dynamic SQL Error |
3124 |
< |
-SQL error code = -206 |
3125 |
< |
-Column unknown |
3118 |
< |
-UNKNOWN_DATE |
3119 |
< |
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3123 |
> |
Error Handled: SQLCODE: -206 |
3124 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3125 |
> |
Dynamic SQL Error When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3126 |
|
Invalid Open Cursor SQL Test |
3127 |
< |
Error Handled: Dynamic SQL Error |
3128 |
< |
-SQL error code = -206 |
3129 |
< |
-Column unknown |
3124 |
< |
-X |
3125 |
< |
-At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE |
3127 |
> |
Error Handled: SQLCODE: -206 |
3128 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3129 |
> |
Dynamic SQL Error When Executing: Select X,count(*) As Counter from EMPLOYEE |
3130 |
|
Transaction not started Test |
3131 |
|
Error Handled: Transaction is not active |
3132 |
|
Invalid Param SQL Type Test |
3149 |
|
COUNTER = 42 |
3150 |
|
|
3151 |
|
Invalid Server Name Test |
3152 |
< |
Error Handled: Unable to complete network request to host "unknown". |
3153 |
< |
-Failed to locate host machine |
3152 |
> |
Error Handled: SQLCODE: -902 |
3153 |
> |
Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3154 |
> |
Unable to complete network request to host "unknown" |
3155 |
|
Invalid User Name Test |
3156 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3156 |
> |
Error Handled: SQLCODE: -902 |
3157 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3158 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3159 |
|
Invalid password Test |
3160 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3160 |
> |
Error Handled: SQLCODE: -902 |
3161 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3162 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3163 |
|
|
3164 |
|
|
3165 |
|
------------------------------------------------------ |
3266 |
|
|
3267 |
|
------------------------------------------------------ |
3268 |
|
Running Test 21: Exercise setting and getting of numeric data types |
3269 |
+ |
1234.567 parsed to 1234567 scale = -3 |
3270 |
+ |
As Float = 1.2345670000000000E+003 |
3271 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
3272 |
+ |
As Float = -7.6543209999999999E+002 |
3273 |
+ |
0.1 parsed to 1 scale = -1 |
3274 |
+ |
As Float = 1.0000000000000001E-001 |
3275 |
+ |
0.01 parsed to 1 scale = -2 |
3276 |
+ |
As Float = 1.0000000000000000E-002 |
3277 |
+ |
+123 parsed to 123 scale = 0 |
3278 |
+ |
As Float = 1.2300000000000000E+002 |
3279 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
3280 |
+ |
As Float = 1.2345600000000001E+308 |
3281 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
3282 |
+ |
As Float = -1.2000000000000000E-002 |
3283 |
+ |
10. parsed to 10 scale = 0 |
3284 |
+ |
As Float = 1.0000000000000000E+001 |
3285 |
+ |
.12 parsed to 12 scale = -2 |
3286 |
+ |
As Float = 1.2000000000000000E-001 |
3287 |
+ |
0.12 parsed to 12 scale = -2 |
3288 |
+ |
As Float = 1.2000000000000000E-001 |
3289 |
+ |
Parsing of 1.2E1.2 failed |
3290 |
+ |
Parsing of 1,000 failed |
3291 |
+ |
Parsing of 1e1e1 failed |
3292 |
+ |
Parsing of 1.2+3 failed |
3293 |
+ |
Validating Numeric Interface - IFBNumeric |
3294 |
+ |
Value from Currency = 9999.1235 |
3295 |
+ |
Raw Value = 99991235 Scale = -4 |
3296 |
+ |
Value from Currency(rescaled) = 9999.12 |
3297 |
+ |
Raw Value = 999912 Scale = -2 |
3298 |
+ |
Value from Double = 9999.12345678 |
3299 |
+ |
Raw Value = 999912345678 Scale = -8 |
3300 |
+ |
Value from Integer = 9223372036854775807 |
3301 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
3302 |
+ |
Value from string = 9223372036854775807 |
3303 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
3304 |
+ |
Value from string = 9999.12345678 |
3305 |
+ |
Raw Value = 999912345678 Scale = -8 |
3306 |
+ |
Value from string = -0.12 |
3307 |
+ |
Raw Value = -12 Scale = -3 |
3308 |
+ |
Value from BCD = 9999.12345678 |
3309 |
+ |
Raw Value = 999912345678 Scale = -8 |
3310 |
+ |
Value from Raw Data = 9999123.456780 |
3311 |
+ |
Raw Value = 9999123456780 Scale = -6 |
3312 |
|
SQL Params |
3313 |
|
SQLType =SQL_LONG |
3314 |
|
sub type = 0 |
3359 |
|
Nullable |
3360 |
|
Size = 8 |
3361 |
|
|
3362 |
+ |
Expected Error - SQLCODE: -303 |
3363 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
3364 |
+ |
Dynamic SQL Error |
3365 |
+ |
Expected Error - SQLCODE: -303 |
3366 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
3367 |
+ |
Dynamic SQL Error |
3368 |
+ |
Test Numeric Type |
3369 |
|
ROWID = 1 |
3370 |
|
ITYPE = 101 |
3371 |
|
I64TYPE = 9223372036854775807 |
3372 |
|
CURRTYPE = 10,000.12340000 |
3373 |
|
DTYPE = 9,999.12345678 |
3374 |
< |
FIXEDPOINT = 1,234,567,890.12345600 |
3374 |
> |
FIXEDPOINT = 1,234,567,890.12345700 |
3375 |
|
ROWID = 2 |
3376 |
|
ITYPE = -32457 |
3377 |
|
I64TYPE = -9223372036854775808 |
3378 |
|
CURRTYPE = 1,000,001.12000000 |
3379 |
|
DTYPE = 1.7E308 |
3380 |
< |
FIXEDPOINT = -1,234,567,890.12345600 |
3380 |
> |
FIXEDPOINT = -1,234,567,890.12345700 |
3381 |
|
ROWID = 3 |
3382 |
|
ITYPE = 0 |
3383 |
|
I64TYPE = 0 |
3384 |
|
CURRTYPE = .00000000 |
3385 |
|
DTYPE = .00000000 |
3386 |
|
FIXEDPOINT = .00000000 |
3387 |
+ |
ROWID = 4 |
3388 |
+ |
ITYPE = 1 |
3389 |
+ |
I64TYPE = 10 |
3390 |
+ |
CURRTYPE = .02300000 |
3391 |
+ |
DTYPE = .00110000 |
3392 |
+ |
FIXEDPOINT = 233.45600000 |
3393 |
+ |
ROWID = 7 |
3394 |
+ |
ITYPE = 1 |
3395 |
+ |
I64TYPE = 1234567 |
3396 |
+ |
CURRTYPE = .02300000 |
3397 |
+ |
DTYPE = .00110000 |
3398 |
+ |
FIXEDPOINT = 1,234.25000000 |
3399 |
+ |
|
3400 |
+ |
|
3401 |
+ |
|
3402 |
+ |
------------------------------------------------------ |
3403 |
+ |
Running Test 22: Journalling |
3404 |
+ |
Start Journaling. Session ID = 0 |
3405 |
+ |
1234.567 parsed to 1234567 scale = -3 |
3406 |
+ |
As Float = 1.2345670000000000E+003 |
3407 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
3408 |
+ |
As Float = -7.6543209999999999E+002 |
3409 |
+ |
0.1 parsed to 1 scale = -1 |
3410 |
+ |
As Float = 1.0000000000000001E-001 |
3411 |
+ |
0.01 parsed to 1 scale = -2 |
3412 |
+ |
As Float = 1.0000000000000000E-002 |
3413 |
+ |
+123 parsed to 123 scale = 0 |
3414 |
+ |
As Float = 1.2300000000000000E+002 |
3415 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
3416 |
+ |
As Float = 1.2345600000000001E+308 |
3417 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
3418 |
+ |
As Float = -1.2000000000000000E-002 |
3419 |
+ |
10. parsed to 10 scale = 0 |
3420 |
+ |
As Float = 1.0000000000000000E+001 |
3421 |
+ |
.12 parsed to 12 scale = -2 |
3422 |
+ |
As Float = 1.2000000000000000E-001 |
3423 |
+ |
0.12 parsed to 12 scale = -2 |
3424 |
+ |
As Float = 1.2000000000000000E-001 |
3425 |
+ |
Parsing of 1.2E1.2 failed |
3426 |
+ |
Parsing of 1,000 failed |
3427 |
+ |
Parsing of 1e1e1 failed |
3428 |
+ |
Parsing of 1.2+3 failed |
3429 |
+ |
SQL Params |
3430 |
+ |
SQLType =SQL_LONG |
3431 |
+ |
sub type = 0 |
3432 |
+ |
Field Name = |
3433 |
+ |
Scale = 0 |
3434 |
+ |
Charset id = 0 |
3435 |
+ |
Not Null |
3436 |
+ |
Size = 4 |
3437 |
+ |
Value = 0 |
3438 |
+ |
|
3439 |
+ |
SQLType =SQL_LONG |
3440 |
+ |
sub type = 0 |
3441 |
+ |
Field Name = |
3442 |
+ |
Scale = 0 |
3443 |
+ |
Charset id = 0 |
3444 |
+ |
Nullable |
3445 |
+ |
Size = 4 |
3446 |
+ |
|
3447 |
+ |
SQLType =SQL_INT64 |
3448 |
+ |
sub type = 0 |
3449 |
+ |
Field Name = |
3450 |
+ |
Scale = 0 |
3451 |
+ |
Charset id = 0 |
3452 |
+ |
Nullable |
3453 |
+ |
Size = 8 |
3454 |
+ |
|
3455 |
+ |
SQLType =SQL_INT64 |
3456 |
+ |
sub type = 0 |
3457 |
+ |
Field Name = |
3458 |
+ |
Scale = -4 |
3459 |
+ |
Charset id = 0 |
3460 |
+ |
Nullable |
3461 |
+ |
Size = 8 |
3462 |
+ |
|
3463 |
+ |
SQLType =SQL_DOUBLE |
3464 |
+ |
sub type = 0 |
3465 |
+ |
Field Name = |
3466 |
+ |
Scale = 0 |
3467 |
+ |
Charset id = 0 |
3468 |
+ |
Nullable |
3469 |
+ |
Size = 8 |
3470 |
+ |
|
3471 |
+ |
SQLType =SQL_INT64 |
3472 |
+ |
sub type = 0 |
3473 |
+ |
Field Name = |
3474 |
+ |
Scale = -6 |
3475 |
+ |
Charset id = 0 |
3476 |
+ |
Nullable |
3477 |
+ |
Size = 8 |
3478 |
+ |
|
3479 |
+ |
|
3480 |
+ |
Text Tests |
3481 |
+ |
SQL Params |
3482 |
+ |
SQLType =SQL_LONG |
3483 |
+ |
sub type = 0 |
3484 |
+ |
Field Name = |
3485 |
+ |
Scale = 0 |
3486 |
+ |
Charset id = 0 |
3487 |
+ |
Not Null |
3488 |
+ |
Size = 4 |
3489 |
+ |
Value = 0 |
3490 |
+ |
|
3491 |
+ |
SQLType =SQL_VARYING |
3492 |
+ |
sub type = 0 |
3493 |
+ |
Field Name = |
3494 |
+ |
Scale = 0 |
3495 |
+ |
Charset id = 4 |
3496 |
+ |
Nullable |
3497 |
+ |
Size = 1024 |
3498 |
+ |
|
3499 |
+ |
SQLType =SQL_BLOB |
3500 |
+ |
sub type = 1 |
3501 |
+ |
Field Name = |
3502 |
+ |
Scale = 0 |
3503 |
+ |
Charset id = 4 |
3504 |
+ |
Nullable |
3505 |
+ |
Size = 8 |
3506 |
+ |
|
3507 |
+ |
|
3508 |
+ |
Binary Blob Tests |
3509 |
+ |
|
3510 |
+ |
Array Test |
3511 |
+ |
SQL Params |
3512 |
+ |
SQLType =SQL_LONG |
3513 |
+ |
sub type = 0 |
3514 |
+ |
Field Name = |
3515 |
+ |
Scale = 0 |
3516 |
+ |
Charset id = 0 |
3517 |
+ |
Not Null |
3518 |
+ |
Size = 4 |
3519 |
+ |
Value = 0 |
3520 |
+ |
|
3521 |
+ |
SQLType =SQL_ARRAY |
3522 |
+ |
sub type = 0 |
3523 |
+ |
Field Name = |
3524 |
+ |
Scale = 0 |
3525 |
+ |
Charset id = 0 |
3526 |
+ |
Nullable |
3527 |
+ |
Size = 8 |
3528 |
+ |
|
3529 |
+ |
ROWID = 1 |
3530 |
+ |
ITYPE = 101 |
3531 |
+ |
I64TYPE = 9223372036854775807 |
3532 |
+ |
CURRTYPE = 10,000.12340000 |
3533 |
+ |
DTYPE = 9,999.12345678 |
3534 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
3535 |
+ |
STR = NULL |
3536 |
+ |
TEXTBLOB = NULL |
3537 |
+ |
OTHERBLOB = NULL |
3538 |
+ |
MYARRAY = NULL |
3539 |
+ |
ROWID = 2 |
3540 |
+ |
ITYPE = -32457 |
3541 |
+ |
I64TYPE = -9223372036854775808 |
3542 |
+ |
CURRTYPE = 1,000,001.12000000 |
3543 |
+ |
DTYPE = 1.7E308 |
3544 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
3545 |
+ |
STR = NULL |
3546 |
+ |
TEXTBLOB = NULL |
3547 |
+ |
OTHERBLOB = NULL |
3548 |
+ |
MYARRAY = NULL |
3549 |
+ |
ROWID = 4 |
3550 |
+ |
ITYPE = 1 |
3551 |
+ |
I64TYPE = 10 |
3552 |
+ |
CURRTYPE = .02300000 |
3553 |
+ |
DTYPE = .00110000 |
3554 |
+ |
FIXEDPOINT = 233.45600000 |
3555 |
+ |
STR = NULL |
3556 |
+ |
TEXTBLOB = NULL |
3557 |
+ |
OTHERBLOB = NULL |
3558 |
+ |
MYARRAY = NULL |
3559 |
+ |
|
3560 |
+ |
Journal Table |
3561 |
+ |
IBX$SESSIONID = 1 |
3562 |
+ |
IBX$TRANSACTIONID = 7 |
3563 |
+ |
IBX$OLDTRANSACTIONID = NULL |
3564 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3565 |
+ |
IBX$CREATED = 2022/01/09 15:33:11.5220 |
3566 |
+ |
IBX$SESSIONID = 1 |
3567 |
+ |
IBX$TRANSACTIONID = 9 |
3568 |
+ |
IBX$OLDTRANSACTIONID = 8 |
3569 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3570 |
+ |
IBX$CREATED = 2022/01/09 15:33:11.8430 |
3571 |
+ |
|
3572 |
+ |
Journal Entries |
3573 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
3574 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3575 |
+ |
Attachment ID = 2 |
3576 |
+ |
Session ID = 1 |
3577 |
+ |
Transaction ID = 7 |
3578 |
+ |
Transaction Name = "Transaction_29_1" |
3579 |
+ |
TPB: Item Count = 3 |
3580 |
+ |
isc_tpb_write |
3581 |
+ |
isc_tpb_nowait |
3582 |
+ |
isc_tpb_concurrency |
3583 |
+ |
|
3584 |
+ |
Default Completion = TACommit |
3585 |
+ |
|
3586 |
+ |
Journal Entry = jeQuery(Query) |
3587 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3588 |
+ |
Attachment ID = 2 |
3589 |
+ |
Session ID = 1 |
3590 |
+ |
Transaction ID = 7 |
3591 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
3592 |
+ |
|
3593 |
+ |
Journal Entry = jeQuery(Query) |
3594 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3595 |
+ |
Attachment ID = 2 |
3596 |
+ |
Session ID = 1 |
3597 |
+ |
Transaction ID = 7 |
3598 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
3599 |
+ |
|
3600 |
+ |
Journal Entry = jeTransCommitRet(Commit Retaining) |
3601 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3602 |
+ |
Attachment ID = 2 |
3603 |
+ |
Session ID = 1 |
3604 |
+ |
Transaction ID = 8 |
3605 |
+ |
Old TransactionID = 7 |
3606 |
+ |
|
3607 |
+ |
Journal Entry = jeQuery(Query) |
3608 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3609 |
+ |
Attachment ID = 2 |
3610 |
+ |
Session ID = 1 |
3611 |
+ |
Transaction ID = 8 |
3612 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
3613 |
+ |
|
3614 |
+ |
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
3615 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3616 |
+ |
Attachment ID = 2 |
3617 |
+ |
Session ID = 1 |
3618 |
+ |
Transaction ID = 9 |
3619 |
+ |
Old TransactionID = 8 |
3620 |
+ |
|
3621 |
+ |
Journal Entry = jeQuery(Query) |
3622 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3623 |
+ |
Attachment ID = 2 |
3624 |
+ |
Session ID = 1 |
3625 |
+ |
Transaction ID = 9 |
3626 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
3627 |
+ |
|
3628 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
3629 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3630 |
+ |
Attachment ID = 2 |
3631 |
+ |
Session ID = 1 |
3632 |
+ |
Transaction ID = 10 |
3633 |
+ |
Transaction Name = "Transaction_29_2" |
3634 |
+ |
TPB: Item Count = 3 |
3635 |
+ |
isc_tpb_write |
3636 |
+ |
isc_tpb_nowait |
3637 |
+ |
isc_tpb_concurrency |
3638 |
+ |
|
3639 |
+ |
Default Completion = TARollback |
3640 |
+ |
|
3641 |
+ |
Journal Entry = jeTransCommit(Commit) |
3642 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3643 |
+ |
Attachment ID = 2 |
3644 |
+ |
Session ID = 1 |
3645 |
+ |
Transaction ID = 9 |
3646 |
+ |
|
3647 |
+ |
Journal Entry = jeQuery(Query) |
3648 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3649 |
+ |
Attachment ID = 2 |
3650 |
+ |
Session ID = 1 |
3651 |
+ |
Transaction ID = 10 |
3652 |
+ |
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: |
3653 |
+ |
Whether ''tis nobler in the mind to suffer |
3654 |
+ |
The slings and arrows of outrageous fortune, |
3655 |
+ |
Or to take arms against a sea of troubles, |
3656 |
+ |
And, by opposing, end them. To die, to sleep- |
3657 |
+ |
No more-and by a sleep to say we end |
3658 |
+ |
The heartache and the thousand natural shocks |
3659 |
+ |
That flesh is heir to-''tis a consummation |
3660 |
+ |
Devoutly to be wished. To die, to sleep- |
3661 |
+ |
To sleep, perchance to dream. Aye, there''s the rub, |
3662 |
+ |
For in that sleep of death what dreams may come, |
3663 |
+ |
When we have shuffled off this mortal coil, |
3664 |
+ |
Must give us pause. There''s the respect |
3665 |
+ |
That makes calamity of so long life. |
3666 |
+ |
For who would bear the whips and scorns of time, |
3667 |
+ |
Th'' oppressor''s wrong, the proud man''s contumely, |
3668 |
+ |
The pangs of despised love, the law’s delay, |
3669 |
+ |
The insolence of office, and the spurns |
3670 |
+ |
That patient merit of the unworthy takes, |
3671 |
+ |
When he himself might his quietus make |
3672 |
+ |
With a bare bodkin? Who would fardels bear, |
3673 |
+ |
To grunt and sweat under a weary life, |
3674 |
+ |
But that the dread of something after death, |
3675 |
+ |
The undiscovered country from whose bourn |
3676 |
+ |
No traveler returns, puzzles the will |
3677 |
+ |
And makes us rather bear those ills we have |
3678 |
+ |
Than fly to others that we know not of? |
3679 |
+ |
Thus conscience does make cowards of us all, |
3680 |
+ |
And thus the native hue of resolution |
3681 |
+ |
Is sicklied o''er with the pale cast of thought, |
3682 |
+ |
And enterprises of great pitch and moment, |
3683 |
+ |
With this regard their currents turn awry, |
3684 |
+ |
And lose the name of action.-Soft you now, |
3685 |
+ |
The fair Ophelia.-Nymph, in thy orisons |
3686 |
+ |
Be all my sins remembered |
3687 |
+ |
') |
3688 |
+ |
|
3689 |
+ |
Journal Entry = jeQuery(Query) |
3690 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3691 |
+ |
Attachment ID = 2 |
3692 |
+ |
Session ID = 1 |
3693 |
+ |
Transaction ID = 10 |
3694 |
+ |
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
3695 |
+ |
FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00 |
3696 |
+ |
0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300 |
3697 |
+ |
01000000010000001A01050001000000DA000000 |
3698 |
+ |
</blob> |
3699 |
+ |
) |
3700 |
+ |
|
3701 |
+ |
Journal Entry = jeQuery(Query) |
3702 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3703 |
+ |
Attachment ID = 2 |
3704 |
+ |
Session ID = 1 |
3705 |
+ |
Transaction ID = 10 |
3706 |
+ |
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"> |
3707 |
+ |
<elt ix="0">100</elt> |
3708 |
+ |
<elt ix="1">99</elt> |
3709 |
+ |
<elt ix="2">98</elt> |
3710 |
+ |
<elt ix="3">97</elt> |
3711 |
+ |
<elt ix="4">96</elt> |
3712 |
+ |
<elt ix="5">95</elt> |
3713 |
+ |
<elt ix="6">94</elt> |
3714 |
+ |
<elt ix="7">93</elt> |
3715 |
+ |
<elt ix="8">92</elt> |
3716 |
+ |
<elt ix="9">91</elt> |
3717 |
+ |
<elt ix="10">90</elt> |
3718 |
+ |
<elt ix="11">89</elt> |
3719 |
+ |
<elt ix="12">88</elt> |
3720 |
+ |
<elt ix="13">87</elt> |
3721 |
+ |
<elt ix="14">86</elt> |
3722 |
+ |
<elt ix="15">85</elt> |
3723 |
+ |
<elt ix="16">84</elt> |
3724 |
+ |
</array> |
3725 |
+ |
) |
3726 |
+ |
|
3727 |
+ |
Journal Entry = jeTransRollback(Rollback) |
3728 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3729 |
+ |
Attachment ID = 2 |
3730 |
+ |
Session ID = 1 |
3731 |
+ |
Transaction ID = 10 |
3732 |
|
|
3733 |
|
|
3734 |
|
|