--- ibx/branches/udr/testsuite/FB3reference.log 2022/01/10 10:13:17 380 +++ ibx/branches/udr/testsuite/FB3reference.log 2022/01/15 00:06:22 381 @@ -650,13 +650,13 @@ Running Test 3: ad hoc queries Opening inet://localhost/employee Database Open Employee Count = 42 -Transaction ID = 5734 +Transaction ID = 6142 Transaction is Read/Write Transaction Database Path = inet://localhost/employee -Transaction ID = 5734 -Oldest Interesting = 5732 -Oldest Action = 5733 -Oldest Snapshot = 5733 +Transaction ID = 6142 +Oldest Interesting = 6140 +Oldest Action = 6141 +Oldest Snapshot = 6141 Oldest Interesting = 0 Employee Count = 41 Employee Count = 42 @@ -691,11 +691,11 @@ FULL_NAME = Johnson, Leslie Current memory = 19,689,792 Delta memory = 4,480 Max memory = 19,751,184 -Elapsed time= 0.003 sec -Cpu = 0.010 sec +Elapsed time= 0.001 sec +Cpu = 0.000 sec Buffers = 2048 Reads = 0 -Writes = 1 +Writes = 0 Fetches = 3 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 Relation Name = EMPLOYEE @@ -2729,7 +2729,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.46) (16: 4269) +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) Shrink to 2:10 @@ -2745,7 +2745,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.46) (16: 4269) +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) @@ -2897,12 +2897,12 @@ Async Wait Called Event Signalled First Event - usually ignored Signal Event +Event Signalled Event Counts: TESTEVENT, Count = 1 Two more events Call Async Wait Async Wait Called Event Signalled -Event Signalled Deferred Events Caught Event Counts: TESTEVENT, Count = 2 Signal Event @@ -2914,7 +2914,7 @@ Event Cancelled Time Out - Cancel Worked! Sync wait Event Signalled -Event Counts: TESTEVENT, Count = 1 +Event Counts: TESTEVENT, Count = 0 ------------------------------------------------------ @@ -2961,7 +2961,6 @@ Local Backup - Local Backup Complete Local Restore @@ -3448,6 +3447,23 @@ Value from BCD = 9999.12345678 Raw Value = 999912345678 Scale = -8 Value from Raw Data = 9999123.456780 Raw Value = 9999123456780 Scale = -6 +Numeric Operations +Add 2.23 + 24.12345 = 26.35345 +Add Double 2.23 + 24.12645 = 26.35645 +Add integer 2.23 + 2412345 = 2412347.23 +Subtract 2.23 - 24.12345 = -21.89345 +Subtract Double 24.12645 - 2.23 = -21.89645 +Subtract integer 24123.45 - 223 = -23900.45 +Multiply 2.23 * 24.12345 = 53.7952935 +Multiply Double 24.12645 * 2.23 = 53.8019835 +Multiply integer 241.2345 * 223 = 53795.2935 +Divide 24.12345 / 2.23 = 10.81769 +Divide Double 2.23 / 24.12645 = 0.09 +Divide integer 241.2345 / 223 = 1.0818 +Compare 2.23, -24.12345 = 1 +Compare integer 2.23, 3 = -1 +Compare Double 2.23, 2.23 = 0 +Negate 24.12345 = -24.12345 SQL Params SQLType =SQL_LONG sub type = 0 @@ -3705,12 +3721,12 @@ IBX$SESSIONID = 1 IBX$TRANSACTIONID = 8 IBX$OLDTRANSACTIONID = NULL IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) -IBX$CREATED = 2022/01/09 15:31:44.1510 +IBX$CREATED = 2022/01/14 23:02:04.2320 IBX$SESSIONID = 1 IBX$TRANSACTIONID = 10 IBX$OLDTRANSACTIONID = 9 IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) -IBX$CREATED = 2022/01/09 15:31:44.8740 +IBX$CREATED = 2022/01/14 23:02:04.6690 Journal Entries Journal Entry = jeTransStart(Transaction Start)