--- ibx/branches/udr/testsuite/FB4reference.log 2022/01/05 14:59:15 370 +++ ibx/branches/udr/testsuite/FB4reference.log 2022/01/05 15:21:22 371 @@ -3,13 +3,13 @@ Copyright MWA Software 2016-2021 Starting Tests Client API Version = 4.0 -Firebird Environment Variable = /opt/firebird4.0.0 -Firebird Bin Directory = /opt/firebird4.0.0/bin -Firebird Conf Directory = /opt/firebird4.0.0/ -Firebird Client Library Path = /opt/firebird4.0.0/lib/libfbclient.so +Firebird Environment Variable = /opt/firebird4.0.1 +Firebird Bin Directory = /opt/firebird4.0.1/bin +Firebird Conf Directory = /opt/firebird4.0.1/ +Firebird Client Library Path = /opt/firebird4.0.1/lib/libfbclient.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 "" +Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file "" -Error while trying to create file -No such file or directory Creating a Database using an SQL Statement @@ -22,7 +22,7 @@ DB Remote Protocol = TCPv4 DB ODS Major Version = 13 DB ODS Minor Version = 0 User Authentication Method = Srp256 -Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so +Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so DB Client Implementation Version = 4.0 DPB: Item Count = 3 isc_dpb_user_name = SYSDBA @@ -30,9 +30,9 @@ DPB: Item Count = 3 isc_dpb_set_db_sql_dialect = 3 Firebird Server Version Info -Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" -Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C" -Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C" +Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" +Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:C" +Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:C" on disk structure version 13.0 Dropping Database @@ -44,7 +44,7 @@ DB Remote Protocol = TCPv4 DB ODS Major Version = 13 DB ODS Minor Version = 0 User Authentication Method = Srp256 -Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so +Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so DB Client Implementation Version = 4.0 Dropping Database DPB: Item Count = 4 @@ -65,7 +65,7 @@ DB Remote Protocol = TCPv4 DB ODS Major Version = 13 DB ODS Minor Version = 0 User Authentication Method = Srp256 -Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so +Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so DB Client Implementation Version = 4.0 RDB$DESCRIPTION = RDB$RELATION_ID = 128 @@ -78,7 +78,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 inet://localhost/employee Database Open, SQL Dialect = 3 TPB: Item Count = 3 @@ -316,7 +316,7 @@ DB Remote Protocol = TCPv4 DB ODS Major Version = 13 DB ODS Minor Version = 0 User Authentication Method = Srp256 -Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so +Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so DB Client Implementation Version = 4.0 Do Fetch Next: EMP_NO = 2 @@ -331,7 +331,7 @@ JOB_COUNTRY = USA SALARY = 105,900.00 FULL_NAME = Nelson, Robert Do Fetch Last: -Remote Scrollable cursors test fails feature is not supported +Remote Scrollable cursors test fails Engine Code: 335544378 feature is not supported Now open the employee database as a local database TPB: Item Count = 3 isc_tpb_read @@ -568,7 +568,7 @@ DB Remote Protocol = DB ODS Major Version = 13 DB ODS Minor Version = 0 User Authentication Method = User name in DPB -Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so +Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so DB Client Implementation Version = 4.0 Do Fetch Next: EMP_NO = 2 @@ -651,13 +651,13 @@ Running Test 3: ad hoc queries Opening inet://localhost/employee Database Open Employee Count = 42 -Transaction ID = 6547 +Transaction ID = 173 Transaction is Read/Write Transaction Database Path = inet://localhost/employee -Transaction ID = 6547 -Oldest Interesting = 6545 -Oldest Action = 6546 -Oldest Snapshot = 6546 +Transaction ID = 173 +Oldest Interesting = 171 +Oldest Action = 172 +Oldest Snapshot = 172 Oldest Snapshot Number = 2 Lock Timeout = 0 Transaction Access = isc_info_tra_readwrite @@ -675,9 +675,9 @@ Constrained Employee Count = 3 Running Test 4: Update, Insert and Delete Queries Opening inet://localhost/employee Database Open -Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" -Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" -Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" +Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" +Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" +Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" on disk structure version 13.0 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0 EMP_NO = 8 @@ -692,10 +692,10 @@ JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie -Current memory = 19,767,952 +Current memory = 19,767,936 Delta memory = 4,464 -Max memory = 19,813,568 -Elapsed time= 0.001 sec +Max memory = 19,813,552 +Elapsed time= 0.002 sec Cpu = 0.000 sec Buffers = 2048 Reads = 0 @@ -2733,7 +2733,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 @@ -2749,7 +2749,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) @@ -2833,29 +2833,29 @@ MYARRAY = Array: (0,-1: A50) (0,0: A51) ------------------------------------------------------ Running Test 9: Database Information tests -Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus -Pages =1075 +Database ID = 4 FB = /opt/firebird4.0.1/examples/empbuild/employee.fdb SN = zeus +Pages =346 Base Level = 13,4,0,3, Implementation = 11,7,0,3,66,1,66, Reserved = 0 ODS minor = 0 ODS major = 13 Page Size = 8192 -Version = 1: LI-V6.3.0.2496 Firebird 4.0 +Version = 1: LI-V6.3.1.2692 Firebird 4.0 Database is Read/Write -Database Created: 29/5/2021 16:47:30 -Pages Used = 313 -Pages Free = 762 -Server Memory = 19484112 +Database Created: 21/12/2021 10:52:59 +Pages Used = 310 +Pages Free = 36 +Server Memory = 19482432 Forced Writes = 1 -Max Memory = 19630384 +Max Memory = 19629552 Num Buffers = 2048 Sweep Interval = 20000 Logged in Users: SYSDBA, Active Transaction Count = 0 -Fetches = 1653 +Fetches = 1634 Writes = 8 -Reads = 92 +Reads = 91 Page Writes = 4 Record Version Removals Operation Counts @@ -2879,7 +2879,7 @@ Count = 2 Table ID = 12 Count = 24 Table ID = 18 -Count = 821 +Count = 805 Table ID = 20 Count = 5 Table ID = 28 @@ -2891,7 +2891,7 @@ Count = 1 Sequential Table Scans Operation Counts Table ID = 0 -Count = 100 +Count = 98 Table ID = 1 Count = 24 @@ -2934,12 +2934,12 @@ SPB: Item Count = 2 password = masterkey Service Manager Version = 2 -Server Version = LI-V4.0.0.2496 Firebird 4.0 +Server Version = LI-V4.0.1.2692 Firebird 4.0 Implementation = Firebird/Linux/AMD/Intel/x64 Lock Directory = /tmp/firebird/ -Message File = /opt/firebird4.0.0/ -Security File = /opt/firebird4.0.0/security4.fdb +Message File = /opt/firebird4.0.1/ +Security File = /opt/firebird4.0.1/security4.fdb DB Attachments No. of Attachments = 0 @@ -2954,10 +2954,10 @@ User ID = 0 Group ID = 0 -Licence Info: feature is not supported +Licence Info: Engine Code: 335544378 feature is not supported -feature is not supported -Licence Mask Info: feature is not supported +Licence Mask Info: Engine Code: 335544378 feature is not supported Capabilities = 6 @@ -3244,21 +3244,31 @@ Écoute moi ------------------------------------------------------ Running Test 16: Error handling Invalid Database Name Test -Error Handled: I/O error during "open" operation for file "Malformed Name" +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" -Error while trying to open file -No such file or directory 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 +Error Handled: SQLCODE: -206 +Engine Code: 335544569 Column does not belong to referenced table +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 = ? Invalid Open Cursor SQL Test -Error Handled: Dynamic SQL Error +Error Handled: SQLCODE: -206 +Engine Code: 335544569 Column does not belong to referenced table +Dynamic SQL Error -SQL error code = -206 -Column unknown -X @@ -3285,18 +3295,24 @@ New Transaction before Open Cursor COUNTER = 42 Invalid Server Name Test -Error Handled: Unable to complete network request to host "unknown". +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". -Failed to locate host machine. -The specified name was not found in the hosts file or Domain Name Services 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 ------------------------------------------------------ Running Test 17: Date/Time tests and Firebird 4 extensions - FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" + FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" Has Local TZ DB = TRUE Testdata @@ -4058,7 +4074,7 @@ TZ_MINUTE = 0 ------------------------------------------------------ Running Test 18: Firebird 4 Decfloat extensions - FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" + FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" FB4 Testdata_DECFloat @@ -4327,9 +4343,9 @@ BigNumber Array: (0: 123456123400.123456 Running Test 19: Batch Update and Insert Queries Opening inet://localhost/employee Database Open -Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" -Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" -Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" +Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" +Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" +Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" on disk structure version 13.0 Rows before update EMP_NO = 2 @@ -4560,11 +4576,13 @@ LANGUAGE_REQ = Array: (1: Eng) (2: Fra) Test Error Handling -Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING +Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type Test Error Handling - Update returning should fail Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched Error handling when Insert rows - duplicate key -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" +Error reported when inserting: Error Processing update/insert batch on row number 2 - SQLCODE: -803 +Engine Code: 335544665 Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values +violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE" -Problematic key value is ("EMP_NO" = 150) Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 Batch Completion Info @@ -4577,7 +4595,7 @@ Row 2 State = bcExecuteFailed Msg = viol ------------------------------------------------------ Running Test 20: Stress Test IBatch interface - FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" + FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" 10000 rows added 20000 rows added 30000 rows added @@ -4631,6 +4649,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 @@ -4691,6 +4728,7 @@ Engine Code: 335544569 Incompatible colu Dynamic SQL Error -SQL error code = -303 -conversion error from string "10.0.0" +Test Numeric Type ROWID = 1 ITYPE = 101 I64TYPE = 9223372036854775807 @@ -4715,12 +4753,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 @@ -4881,16 +4925,17 @@ IBX$SESSIONID = 1 IBX$TRANSACTIONID = 9 IBX$OLDTRANSACTIONID = NULL IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) -IBX$CREATED = 2021/12/07 09:50:08.4430 +IBX$CREATED = 2022/01/02 14:16:56.6410 IBX$SESSIONID = 1 IBX$TRANSACTIONID = 11 IBX$OLDTRANSACTIONID = 10 IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) -IBX$CREATED = 2021/12/07 09:50:08.7940 +IBX$CREATED = 2022/01/02 14:16:56.9850 Journal Entries Journal Entry = jeTransStart(Transaction Start) -Timestamp = 2021/12/07 09:50:08.4700 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 9 Transaction Name = "Transaction_29_1" @@ -4902,43 +4947,50 @@ TPB: Item Count = 3 Default Completion = TACommit Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:50:08.5300 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 9 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:50:08.5510 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 9 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:50:08.6650 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 10 Old TransactionID = 9 Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:50:08.6870 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 10 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:50:08.7900 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 11 Old TransactionID = 10 Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:50:08.8140 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 11 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:50:08.8260 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 12 Transaction Name = "Transaction_29_2" @@ -4950,12 +5002,14 @@ TPB: Item Count = 3 Default Completion = TARollback Journal Entry = jeTransCommit(Commit) -Timestamp = 2021/12/07 09:50:08.8860 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 11 Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:50:08.9660 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 12 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: @@ -4996,7 +5050,8 @@ Be all my sins remembered ') Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:50:09.0130 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 12 Query = Insert into TestData(RowID,OtherBlob) Values (6, @@ -5007,7 +5062,8 @@ FFD8FFE000104A46494600010101004800480000 ) Journal Entry = jeQuery(Query) -Timestamp = 2021/12/07 09:50:09.0380 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 12 Query = Insert into TestData(RowID,MyArray) Values (7, @@ -5032,7 +5088,8 @@ Query = Insert into TestData(RowID,MyArr ) Journal Entry = jeTransRollback(Rollback) -Timestamp = 2021/12/07 09:50:09.1560 +Timestamp = yyyy/mm/dd hh:mm:ss.zzzz +Attachment ID = 4 Session ID = 1 Transaction ID = 12