--- ibx/branches/udr/testsuite/FB2reference.log 2022/01/10 10:13:17 380 +++ ibx/branches/udr/testsuite/FB2reference.log 2022/01/15 00:06:22 381 @@ -533,12 +533,12 @@ Running Test 3: ad hoc queries Opening localhost:employee Database Open Employee Count = 42 -Transaction ID = 6014 +Transaction ID = 6359 Transaction is Read/Write -Transaction ID = 6014 -Oldest Interesting = 5461 -Oldest Action = 6013 -Oldest Snapshot = 6013 +Transaction ID = 6359 +Oldest Interesting = 6318 +Oldest Action = 6358 +Oldest Snapshot = 6358 Oldest Interesting = 0 Employee Count = 41 Employee Count = 42 @@ -570,11 +570,11 @@ JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie -Current memory = 937,656 -Delta memory = 1,296 -Max memory = 965,720 -Elapsed time= 0.003 sec -Cpu = 0.001 sec +Current memory = 937,536 +Delta memory = 1,288 +Max memory = 965,600 +Elapsed time= 0.000 sec +Cpu = 0.000 sec Buffers = 75 Reads = 0 Writes = 0 @@ -2611,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.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 @@ -2627,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.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) @@ -3309,6 +3309,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 @@ -3562,12 +3579,12 @@ IBX$SESSIONID = 1 IBX$TRANSACTIONID = 7 IBX$OLDTRANSACTIONID = NULL IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) -IBX$CREATED = 2022/01/09 15:33:11.5220 +IBX$CREATED = 2022/01/14 23:03:42.7720 IBX$SESSIONID = 1 IBX$TRANSACTIONID = 9 IBX$OLDTRANSACTIONID = 8 IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) -IBX$CREATED = 2022/01/09 15:33:11.8430 +IBX$CREATED = 2022/01/14 23:03:43.1080 Journal Entries Journal Entry = jeTransStart(Transaction Start)