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 |
72 |
|
|
73 |
|
------------------------------------------------------ |
74 |
|
Running Test 2: Open the employee database and run a query |
75 |
< |
Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
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 |
533 |
|
Opening localhost:employee |
534 |
|
Database Open |
535 |
|
Employee Count = 42 |
536 |
< |
Transaction ID = 5277 |
536 |
> |
Transaction ID = 5972 |
537 |
|
Transaction is Read/Write |
538 |
< |
Transaction ID = 5277 |
539 |
< |
Oldest Interesting = 5275 |
540 |
< |
Oldest Action = 5276 |
541 |
< |
Oldest Snapshot = 5276 |
538 |
> |
Transaction ID = 5972 |
539 |
> |
Oldest Interesting = 5461 |
540 |
> |
Oldest Action = 5971 |
541 |
> |
Oldest Snapshot = 5971 |
542 |
|
Oldest Interesting = 0 |
543 |
|
Employee Count = 41 |
544 |
|
Employee Count = 42 |
570 |
|
SALARY = 64,635.00 |
571 |
|
FULL_NAME = Johnson, Leslie |
572 |
|
|
573 |
< |
Current memory = 948,496 |
574 |
< |
Delta memory = 1,288 |
575 |
< |
Max memory = 992,448 |
576 |
< |
Elapsed time= 0.002 sec |
573 |
> |
Current memory = 948,640 |
574 |
> |
Delta memory = 1,304 |
575 |
> |
Max memory = 992,560 |
576 |
> |
Elapsed time= 0.003 sec |
577 |
|
Cpu = 0.000 sec |
578 |
|
Buffers = 75 |
579 |
|
Reads = 0 |
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: 0.42) (15: 42.45) (16: 4269) |
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: 0.42) (15: 42.45) (16: 4269) |
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 |
|
|
2726 |
|
Unknown Response 3 |
2727 |
|
Server Memory = 841392 |
2728 |
|
Forced Writes = 1 |
2729 |
< |
Max Memory = 879288 |
2729 |
> |
Max Memory = 879440 |
2730 |
|
Num Buffers = 75 |
2731 |
|
Sweep Interval = 20000 |
2732 |
|
Logged in Users: SYSDBA, |
2823 |
|
Group ID = 0 |
2824 |
|
|
2825 |
|
|
2826 |
< |
Licence Info: feature is not supported |
2829 |
< |
-feature is not supported |
2826 |
> |
Licence Info: Engine Code: 335544378 feature is not supported |
2827 |
|
|
2828 |
< |
Licence Mask Info: feature is not supported |
2828 |
> |
Licence Mask Info: Engine Code: 335544378 feature is not supported |
2829 |
|
|
2830 |
|
Capabilities = 260 |
2831 |
|
|
3112 |
|
------------------------------------------------------ |
3113 |
|
Running Test 16: Error handling |
3114 |
|
Invalid Database Name Test |
3115 |
< |
Error Handled: I/O error during "open" operation for file "Malformed Name" |
3116 |
< |
-Error while trying to open file |
3117 |
< |
-No such file or directory |
3115 |
> |
Error Handled: SQLCODE: -902 |
3116 |
> |
Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3117 |
> |
I/O error during "open" operation for file "Malformed Name" |
3118 |
|
Invalid User Name 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 password 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 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3125 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3126 |
|
Invalid Prepare SQL Test |
3127 |
< |
Error Handled: Dynamic SQL Error |
3128 |
< |
-SQL error code = -206 |
3129 |
< |
-Column unknown |
3129 |
< |
-UNKNOWN_DATE |
3130 |
< |
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3127 |
> |
Error Handled: SQLCODE: -206 |
3128 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3129 |
> |
Dynamic SQL Error When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3130 |
|
Invalid Open Cursor SQL Test |
3131 |
< |
Error Handled: Dynamic SQL Error |
3132 |
< |
-SQL error code = -206 |
3133 |
< |
-Column unknown |
3135 |
< |
-X |
3136 |
< |
-At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE |
3131 |
> |
Error Handled: SQLCODE: -206 |
3132 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3133 |
> |
Dynamic SQL Error When Executing: Select X,count(*) As Counter from EMPLOYEE |
3134 |
|
Transaction not started Test |
3135 |
|
Error Handled: Transaction is not active |
3136 |
|
Invalid Param SQL Type Test |
3153 |
|
COUNTER = 42 |
3154 |
|
|
3155 |
|
Invalid Server Name Test |
3156 |
< |
Error Handled: Unable to complete network request to host "unknown". |
3157 |
< |
-Failed to locate host machine |
3156 |
> |
Error Handled: SQLCODE: -902 |
3157 |
> |
Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3158 |
> |
Unable to complete network request to host "unknown" |
3159 |
|
Invalid User Name 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 |
|
Invalid password Test |
3164 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3164 |
> |
Error Handled: SQLCODE: -902 |
3165 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3166 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3167 |
|
|
3168 |
|
|
3169 |
|
------------------------------------------------------ |
3294 |
|
Parsing of 1,000 failed |
3295 |
|
Parsing of 1e1e1 failed |
3296 |
|
Parsing of 1.2+3 failed |
3297 |
+ |
Validating Numeric Interface - IFBNumeric |
3298 |
+ |
Value from Currency = 9999.1235 |
3299 |
+ |
Raw Value = 99991235 Scale = -4 |
3300 |
+ |
Value from Currency(rescaled) = 9999.12 |
3301 |
+ |
Raw Value = 999912 Scale = -2 |
3302 |
+ |
Value from Double = 9999.12345678 |
3303 |
+ |
Raw Value = 999912345678 Scale = -8 |
3304 |
+ |
Value from Integer = 9223372036854775807 |
3305 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
3306 |
+ |
Value from string = 9223372036854775807 |
3307 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
3308 |
+ |
Value from string = 9999.12345678 |
3309 |
+ |
Raw Value = 999912345678 Scale = -8 |
3310 |
+ |
Value from string = -0.12 |
3311 |
+ |
Raw Value = -12 Scale = -3 |
3312 |
+ |
Value from BCD = 9999.12345678 |
3313 |
+ |
Raw Value = 999912345678 Scale = -8 |
3314 |
+ |
Value from Raw Data = 9999123.456780 |
3315 |
+ |
Raw Value = 9999123456780 Scale = -6 |
3316 |
|
SQL Params |
3317 |
|
SQLType =SQL_LONG |
3318 |
|
sub type = 0 |
3363 |
|
Nullable |
3364 |
|
Size = 8 |
3365 |
|
|
3366 |
< |
Expected Error - Dynamic SQL Error |
3367 |
< |
-SQL error code = -303 |
3368 |
< |
-conversion error from string "1,000" |
3369 |
< |
Expected Error - Dynamic SQL Error |
3370 |
< |
-SQL error code = -303 |
3371 |
< |
-conversion error from string "10.0.0" |
3366 |
> |
Expected Error - SQLCODE: -303 |
3367 |
> |
Engine Code: 335544569 Incompatible column/host variable data type |
3368 |
> |
Dynamic SQL Error |
3369 |
> |
Expected Error - SQLCODE: -303 |
3370 |
> |
Engine Code: 335544569 Incompatible column/host variable data type |
3371 |
> |
Dynamic SQL Error |
3372 |
> |
Test Numeric Type |
3373 |
|
ROWID = 1 |
3374 |
|
ITYPE = 101 |
3375 |
|
I64TYPE = 9223372036854775807 |
3394 |
|
CURRTYPE = .02300000 |
3395 |
|
DTYPE = .00110000 |
3396 |
|
FIXEDPOINT = 233.45600000 |
3397 |
+ |
ROWID = 7 |
3398 |
+ |
ITYPE = 1 |
3399 |
+ |
I64TYPE = 1234567 |
3400 |
+ |
CURRTYPE = .02300000 |
3401 |
+ |
DTYPE = .00110000 |
3402 |
+ |
FIXEDPOINT = 1,234.25000000 |
3403 |
|
|
3404 |
|
|
3405 |
|
|
3406 |
|
------------------------------------------------------ |
3407 |
|
Running Test 22: Journalling |
3408 |
< |
Start Journaling. Session ID = 1 |
3408 |
> |
Start Journaling. Session ID = 0 |
3409 |
|
1234.567 parsed to 1234567 scale = -3 |
3410 |
|
As Float = 1.2345670000000000E+003 |
3411 |
|
-765.4321 parsed to -7654321 scale = -4 |
3566 |
|
IBX$TRANSACTIONID = 8 |
3567 |
|
IBX$OLDTRANSACTIONID = NULL |
3568 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3569 |
< |
IBX$CREATED = 2021/12/07 09:57:12.8450 |
3569 |
> |
IBX$CREATED = 2022/01/02 13:50:08.4510 |
3570 |
|
IBX$SESSIONID = 1 |
3571 |
|
IBX$TRANSACTIONID = 10 |
3572 |
|
IBX$OLDTRANSACTIONID = 9 |
3573 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3574 |
< |
IBX$CREATED = 2021/12/07 09:57:13.1650 |
3574 |
> |
IBX$CREATED = 2022/01/02 13:50:08.7550 |
3575 |
|
|
3576 |
|
Journal Entries |
3577 |
|
Journal Entry = jeTransStart(Transaction Start) |
3578 |
< |
Timestamp = 2021/12/07 09:57:12.8740 |
3578 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3579 |
> |
Attachment ID = 2 |
3580 |
|
Session ID = 1 |
3581 |
|
Transaction ID = 8 |
3582 |
|
Transaction Name = "Transaction_29_1" |
3588 |
|
Default Completion = TACommit |
3589 |
|
|
3590 |
|
Journal Entry = jeQuery(Query) |
3591 |
< |
Timestamp = 2021/12/07 09:57:12.9610 |
3591 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3592 |
> |
Attachment ID = 2 |
3593 |
|
Session ID = 1 |
3594 |
|
Transaction ID = 8 |
3595 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
3596 |
|
|
3597 |
|
Journal Entry = jeQuery(Query) |
3598 |
< |
Timestamp = 2021/12/07 09:57:12.9820 |
3598 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3599 |
> |
Attachment ID = 2 |
3600 |
|
Session ID = 1 |
3601 |
|
Transaction ID = 8 |
3602 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
3603 |
|
|
3604 |
|
Journal Entry = jeTransCommitRet(Commit Retaining) |
3605 |
< |
Timestamp = 2021/12/07 09:57:13.0450 |
3605 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3606 |
> |
Attachment ID = 2 |
3607 |
|
Session ID = 1 |
3608 |
|
Transaction ID = 9 |
3609 |
|
Old TransactionID = 8 |
3610 |
|
|
3611 |
|
Journal Entry = jeQuery(Query) |
3612 |
< |
Timestamp = 2021/12/07 09:57:13.0670 |
3612 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3613 |
> |
Attachment ID = 2 |
3614 |
|
Session ID = 1 |
3615 |
|
Transaction ID = 9 |
3616 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
3617 |
|
|
3618 |
|
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
3619 |
< |
Timestamp = 2021/12/07 09:57:13.1620 |
3619 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3620 |
> |
Attachment ID = 2 |
3621 |
|
Session ID = 1 |
3622 |
|
Transaction ID = 10 |
3623 |
|
Old TransactionID = 9 |
3624 |
|
|
3625 |
|
Journal Entry = jeQuery(Query) |
3626 |
< |
Timestamp = 2021/12/07 09:57:13.1830 |
3626 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3627 |
> |
Attachment ID = 2 |
3628 |
|
Session ID = 1 |
3629 |
|
Transaction ID = 10 |
3630 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
3631 |
|
|
3632 |
|
Journal Entry = jeTransStart(Transaction Start) |
3633 |
< |
Timestamp = 2021/12/07 09:57:13.1940 |
3633 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3634 |
> |
Attachment ID = 2 |
3635 |
|
Session ID = 1 |
3636 |
|
Transaction ID = 11 |
3637 |
|
Transaction Name = "Transaction_29_2" |
3643 |
|
Default Completion = TARollback |
3644 |
|
|
3645 |
|
Journal Entry = jeTransCommit(Commit) |
3646 |
< |
Timestamp = 2021/12/07 09:57:13.2360 |
3646 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3647 |
> |
Attachment ID = 2 |
3648 |
|
Session ID = 1 |
3649 |
|
Transaction ID = 10 |
3650 |
|
|
3651 |
|
Journal Entry = jeQuery(Query) |
3652 |
< |
Timestamp = 2021/12/07 09:57:13.2590 |
3652 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3653 |
> |
Attachment ID = 2 |
3654 |
|
Session ID = 1 |
3655 |
|
Transaction ID = 11 |
3656 |
|
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: |
3691 |
|
') |
3692 |
|
|
3693 |
|
Journal Entry = jeQuery(Query) |
3694 |
< |
Timestamp = 2021/12/07 09:57:13.2780 |
3694 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3695 |
> |
Attachment ID = 2 |
3696 |
|
Session ID = 1 |
3697 |
|
Transaction ID = 11 |
3698 |
|
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
3703 |
|
) |
3704 |
|
|
3705 |
|
Journal Entry = jeQuery(Query) |
3706 |
< |
Timestamp = 2021/12/07 09:57:13.3010 |
3706 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3707 |
> |
Attachment ID = 2 |
3708 |
|
Session ID = 1 |
3709 |
|
Transaction ID = 11 |
3710 |
|
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"> |
3729 |
|
) |
3730 |
|
|
3731 |
|
Journal Entry = jeTransRollback(Rollback) |
3732 |
< |
Timestamp = 2021/12/07 09:57:13.3610 |
3732 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3733 |
> |
Attachment ID = 2 |
3734 |
|
Session ID = 1 |
3735 |
|
Transaction ID = 11 |
3736 |
|
|