--- ibx/branches/udr/testsuite/FB2reference.log 2022/01/05 14:59:15 370 +++ ibx/branches/udr/testsuite/FB2reference.log 2022/01/05 15:21:22 371 @@ -7,9 +7,7 @@ Firebird Environment Variable = /opt/fir Firebird Client Library Path = /opt/firebird2.5.9/lib/libfbembed.so Running Test 1: Create and Drop a Database Creating a Database with empty parameters -Create Database fails (as expected): I/O error during "open O_CREAT" operation for file "" --Error while trying to create file --No such file or directory +Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file "" Creating a Database using an SQL Statement Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus SQL Dialect = 3 @@ -74,7 +72,7 @@ Dropping Database ------------------------------------------------------ Running Test 2: Open the employee database and run a query -Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login +Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login Opening localhost:employee Database Open, SQL Dialect = 3 TPB: Item Count = 3 @@ -535,12 +533,12 @@ Running Test 3: ad hoc queries Opening localhost:employee Database Open Employee Count = 42 -Transaction ID = 5277 +Transaction ID = 5972 Transaction is Read/Write -Transaction ID = 5277 -Oldest Interesting = 5275 -Oldest Action = 5276 -Oldest Snapshot = 5276 +Transaction ID = 5972 +Oldest Interesting = 5461 +Oldest Action = 5971 +Oldest Snapshot = 5971 Oldest Interesting = 0 Employee Count = 41 Employee Count = 42 @@ -572,10 +570,10 @@ JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie -Current memory = 948,496 -Delta memory = 1,288 -Max memory = 992,448 -Elapsed time= 0.002 sec +Current memory = 948,640 +Delta memory = 1,304 +Max memory = 992,560 +Elapsed time= 0.003 sec Cpu = 0.000 sec Buffers = 75 Reads = 0 @@ -2613,7 +2611,7 @@ MYARRAY = Array: (0: 100) (1: 99) (2: 98 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) -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) +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) Shrink to 2:10 @@ -2629,7 +2627,7 @@ MYARRAY = Array: (0: 100) (1: 99) (2: 10 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) -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) +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) @@ -2728,7 +2726,7 @@ Unknown Response 3 Unknown Response 3 Server Memory = 841392 Forced Writes = 1 -Max Memory = 879288 +Max Memory = 879440 Num Buffers = 75 Sweep Interval = 20000 Logged in Users: SYSDBA, @@ -2825,10 +2823,9 @@ User ID = 0 Group ID = 0 -Licence Info: feature is not supported --feature is not supported +Licence Info: Engine Code: 335544378 feature is not supported -Licence Mask Info: feature is not supported +Licence Mask Info: Engine Code: 335544378 feature is not supported Capabilities = 260 @@ -3115,25 +3112,25 @@ Écoute moi ------------------------------------------------------ Running Test 16: Error handling Invalid Database Name Test -Error Handled: I/O error during "open" operation for file "Malformed Name" --Error while trying to open file --No such file or directory +Error Handled: SQLCODE: -902 +Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements +I/O error during "open" operation for file "Malformed Name" Invalid User Name Test -Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login +Error Handled: SQLCODE: -902 +Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements +Your user name and password are not defined. Ask your database administrator to set up a Firebird login Invalid password Test -Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login +Error Handled: SQLCODE: -902 +Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements +Your user name and password are not defined. Ask your database administrator to set up a Firebird login Invalid Prepare SQL Test -Error Handled: Dynamic SQL Error --SQL error code = -206 --Column unknown --UNKNOWN_DATE --At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? +Error Handled: SQLCODE: -206 +Engine Code: 335544569 Column does not belong to referenced table +Dynamic SQL Error When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? Invalid Open Cursor SQL Test -Error Handled: Dynamic SQL Error --SQL error code = -206 --Column unknown --X --At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE +Error Handled: SQLCODE: -206 +Engine Code: 335544569 Column does not belong to referenced table +Dynamic SQL Error When Executing: Select X,count(*) As Counter from EMPLOYEE Transaction not started Test Error Handled: Transaction is not active Invalid Param SQL Type Test @@ -3156,12 +3153,17 @@ New Transaction before Open Cursor COUNTER = 42 Invalid Server Name Test -Error Handled: Unable to complete network request to host "unknown". --Failed to locate host machine +Error Handled: SQLCODE: -902 +Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements +Unable to complete network request to host "unknown" Invalid User Name Test -Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login +Error Handled: SQLCODE: -902 +Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements +Your user name and password are not defined. Ask your database administrator to set up a Firebird login Invalid password Test -Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login +Error Handled: SQLCODE: -902 +Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements +Your user name and password are not defined. Ask your database administrator to set up a Firebird login ------------------------------------------------------ @@ -3292,6 +3294,25 @@ Parsing of 1.2E1.2 failed Parsing of 1,000 failed Parsing of 1e1e1 failed Parsing of 1.2+3 failed +Validating Numeric Interface - IFBNumeric +Value from Currency = 9999.1235 +Raw Value = 99991235 Scale = -4 +Value from Currency(rescaled) = 9999.12 +Raw Value = 999912 Scale = -2 +Value from Double = 9999.12345678 +Raw Value = 999912345678 Scale = -8 +Value from Integer = 9223372036854775807 +Raw Value = 9223372036854775807 Scale = 0 +Value from string = 9223372036854775807 +Raw Value = 9223372036854775807 Scale = 0 +Value from string = 9999.12345678 +Raw Value = 999912345678 Scale = -8 +Value from string = -0.12 +Raw Value = -12 Scale = -3 +Value from BCD = 9999.12345678 +Raw Value = 999912345678 Scale = -8 +Value from Raw Data = 9999123.456780 +Raw Value = 9999123456780 Scale = -6 SQL Params SQLType =SQL_LONG sub type = 0 @@ -3342,12 +3363,13 @@ Charset id = 0 Nullable Size = 8 -Expected Error - Dynamic SQL Error --SQL error code = -303 --conversion error from string "1,000" -Expected Error - Dynamic SQL Error --SQL error code = -303 --conversion error from string "10.0.0" +Expected Error - SQLCODE: -303 +Engine Code: 335544569 Incompatible column/host variable data type +Dynamic SQL Error +Expected Error - SQLCODE: -303 +Engine Code: 335544569 Incompatible column/host variable data type +Dynamic SQL Error +Test Numeric Type ROWID = 1 ITYPE = 101 I64TYPE = 9223372036854775807 @@ -3372,12 +3394,18 @@ I64TYPE = 10 CURRTYPE = .02300000 DTYPE = .00110000 FIXEDPOINT = 233.45600000 +ROWID = 7 +ITYPE = 1 +I64TYPE = 1234567 +CURRTYPE = .02300000 +DTYPE = .00110000 +FIXEDPOINT = 1,234.25000000 ------------------------------------------------------ Running Test 22: Journalling -Start Journaling. Session ID = 1 +Start Journaling. Session ID = 0 1234.567 parsed to 1234567 scale = -3 As Float = 1.2345670000000000E+003 -765.4321 parsed to -7654321 scale = -4 @@ -3538,16 +3566,17 @@ IBX$SESSIONID = 1 IBX$TRANSACTIONID = 8 IBX$OLDTRANSACTIONID = NULL IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) -IBX$CREATED = 2021/12/07 09:57:12.8450 +IBX$CREATED = 2022/01/02 13:50:08.4510 IBX$SESSIONID = 1 IBX$TRANSACTIONID = 10 IBX$OLDTRANSACTIONID = 9 IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) -IBX$CREATED = 2021/12/07 09:57:13.1650 +IBX$CREATED = 2022/01/02 13:50:08.7550 Journal Entries Journal Entry = jeTransStart(Transaction Start) -Timestamp = 2021/12/07 09:57:12.8740 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 8 Transaction Name = "Transaction_29_1" @@ -3559,43 +3588,50 @@ TPB: Item Count = 3 Default Completion = TACommit Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:57:12.9610 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 8 Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:57:12.9820 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 8 Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) Journal Entry = jeTransCommitRet(Commit Retaining) -Timestamp = 2021/12/07 09:57:13.0450 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 9 Old TransactionID = 8 Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:57:13.0670 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 9 Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) Journal Entry = jeTransRollbackRet(Rollback Retaining) -Timestamp = 2021/12/07 09:57:13.1620 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 10 Old TransactionID = 9 Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:57:13.1830 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 10 Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) Journal Entry = jeTransStart(Transaction Start) -Timestamp = 2021/12/07 09:57:13.1940 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 11 Transaction Name = "Transaction_29_2" @@ -3607,12 +3643,14 @@ TPB: Item Count = 3 Default Completion = TARollback Journal Entry = jeTransCommit(Commit) -Timestamp = 2021/12/07 09:57:13.2360 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 10 Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:57:13.2590 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 11 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,7 +3691,8 @@ Be all my sins remembered ') Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:57:13.2780 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 11 Query = Insert into TestData(RowID,OtherBlob) Values (6, @@ -3664,7 +3703,8 @@ FFD8FFE000104A46494600010101004800480000 ) Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:57:13.3010 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 11 Query = Insert into TestData(RowID,MyArray) Values (7, @@ -3689,7 +3729,8 @@ Query = Insert into TestData(RowID,MyArr ) Journal Entry = jeTransRollback(Rollback) -Timestamp = 2021/12/07 09:57:13.3610 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 2 Session ID = 1 Transaction ID = 11