ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/udr/testsuite/FB2reference.log
(Generate patch)

Comparing ibx/branches/udr/testsuite/FB2reference.log (file contents):
Revision 371 by tony, Wed Jan 5 15:21:22 2022 UTC vs.
Revision 381 by tony, Sat Jan 15 00:06:22 2022 UTC

# Line 533 | Line 533 | Running Test 3: ad hoc queries
533   Opening localhost:employee
534   Database Open
535   Employee Count = 42
536 < Transaction ID = 5972
536 > Transaction ID = 6359
537   Transaction is Read/Write
538 < Transaction ID = 5972
539 < Oldest Interesting = 5461
540 < Oldest Action = 5971
541 < Oldest Snapshot = 5971
538 > Transaction ID = 6359
539 > Oldest Interesting = 6318
540 > Oldest Action = 6358
541 > Oldest Snapshot = 6358
542   Oldest Interesting = 0
543   Employee Count = 41
544   Employee Count = 42
# Line 570 | Line 570 | JOB_COUNTRY = USA
570   SALARY = 64,635.00
571   FULL_NAME = Johnson, Leslie
572  
573 < Current memory = 948,640
574 < Delta memory = 1,304
575 < Max memory = 992,560
576 < Elapsed time= 0.003 sec
573 > Current memory = 937,536
574 > Delta memory = 1,288
575 > Max memory = 965,600
576 > Elapsed time= 0.000 sec
577   Cpu = 0.000 sec
578   Buffers = 75
579   Reads = 0
# Line 2611 | Line 2611 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
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.46) (16: 4269)
2614 > 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)
2615  
2616  
2617   Shrink to 2:10
# Line 2627 | Line 2627 | MYARRAY = Array: (0: 100) (1: 99) (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.46) (16: 4269)
2630 > 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)
2631  
2632  
2633  
# Line 2724 | Line 2724 | Database is Read/Write
2724   Database Created: 17/6/2019 19:37:08
2725   Unknown Response 3
2726   Unknown Response 3
2727 < Server Memory = 841392
2727 > Server Memory = 721912
2728   Forced Writes  = 1
2729 < Max Memory  = 879440
2729 > Max Memory  = 737792
2730   Num Buffers  = 75
2731   Sweep Interval  = 20000
2732   Logged in Users: SYSDBA,
2733   Active Transaction Count = 0
2734 < Fetches  = 1040
2735 < Writes  = 6
2736 < Reads  = 84
2737 < Page Writes  = 6
2734 > Fetches  = 520
2735 > Writes  = 4
2736 > Reads  = 58
2737 > Page Writes  = 4
2738   Record Version Removals Operation Counts
2739  
2740   Deletes Operation Counts
# Line 2746 | Line 2746 | Insert Count Operation Counts
2746   Purge Count Countites Operation Counts
2747  
2748   Indexed Reads Count Operation Counts
2749 – Table ID = 2
2750 – Count = 14
2751 – Table ID = 5
2752 – Count = 28
2749   Table ID = 6
2750 < Count = 58
2750 > Count = 11
2751   Table ID = 11
2752 < Count = 3
2752 > Count = 1
2753   Table ID = 12
2754 < Count = 36
2754 > Count = 24
2755   Table ID = 28
2756 < Count = 9
2756 > Count = 4
2757   Table ID = 29
2758 < Count = 7
2758 > Count = 4
2759  
2760   Sequential Table Scans Operation Counts
2761   Table ID = 0
# Line 3313 | Line 3309 | Value from BCD = 9999.12345678
3309   Raw Value = 999912345678 Scale = -8
3310   Value from Raw Data = 9999123.456780
3311   Raw Value = 9999123456780 Scale = -6
3312 + Numeric Operations
3313 + Add 2.23 + 24.12345 = 26.35345
3314 + Add Double 2.23 + 24.12645 = 26.35645
3315 + Add integer 2.23 + 2412345 = 2412347.23
3316 + Subtract 2.23 - 24.12345 = -21.89345
3317 + Subtract Double 24.12645 - 2.23 = -21.89645
3318 + Subtract integer 24123.45 - 223 = -23900.45
3319 + Multiply 2.23 * 24.12345 = 53.7952935
3320 + Multiply Double 24.12645 * 2.23 = 53.8019835
3321 + Multiply integer 241.2345 * 223 = 53795.2935
3322 + Divide 24.12345 / 2.23 = 10.81769
3323 + Divide Double 2.23 / 24.12645 = 0.09
3324 + Divide integer 241.2345 / 223 = 1.0818
3325 + Compare 2.23, -24.12345 = 1
3326 + Compare integer 2.23, 3 = -1
3327 + Compare Double 2.23, 2.23 = 0
3328 + Negate 24.12345 = -24.12345
3329   SQL Params
3330   SQLType =SQL_LONG
3331   sub type = 0
# Line 3563 | Line 3576 | MYARRAY = NULL
3576  
3577   Journal Table
3578   IBX$SESSIONID = 1
3579 < IBX$TRANSACTIONID = 8
3579 > IBX$TRANSACTIONID = 7
3580   IBX$OLDTRANSACTIONID = NULL
3581   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3582 < IBX$CREATED = 2022/01/02 13:50:08.4510
3582 > IBX$CREATED = 2022/01/14 23:03:42.7720
3583   IBX$SESSIONID = 1
3584 < IBX$TRANSACTIONID = 10
3585 < IBX$OLDTRANSACTIONID = 9
3584 > IBX$TRANSACTIONID = 9
3585 > IBX$OLDTRANSACTIONID = 8
3586   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3587 < IBX$CREATED = 2022/01/02 13:50:08.7550
3587 > IBX$CREATED = 2022/01/14 23:03:43.1080
3588  
3589   Journal Entries
3590   Journal Entry = jeTransStart(Transaction Start)
3591   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3592   Attachment ID = 2
3593   Session ID = 1
3594 < Transaction ID = 8
3594 > Transaction ID = 7
3595   Transaction Name = "Transaction_29_1"
3596   TPB: Item Count = 3
3597    isc_tpb_write
# Line 3591 | Line 3604 | Journal Entry = jeQuery(Query)
3604   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3605   Attachment ID = 2
3606   Session ID = 1
3607 < Transaction ID = 8
3607 > Transaction ID = 7
3608   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3609  
3610   Journal Entry = jeQuery(Query)
3611   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3612   Attachment ID = 2
3613   Session ID = 1
3614 < Transaction ID = 8
3614 > Transaction ID = 7
3615   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3616  
3617   Journal Entry = jeTransCommitRet(Commit Retaining)
3618   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3619   Attachment ID = 2
3620   Session ID = 1
3621 < Transaction ID = 9
3622 < Old TransactionID = 8
3621 > Transaction ID = 8
3622 > Old TransactionID = 7
3623  
3624   Journal Entry = jeQuery(Query)
3625   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3626   Attachment ID = 2
3627   Session ID = 1
3628 < Transaction ID = 9
3628 > Transaction ID = 8
3629   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3630  
3631   Journal Entry = jeTransRollbackRet(Rollback Retaining)
3632   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3633   Attachment ID = 2
3634   Session ID = 1
3635 < Transaction ID = 10
3636 < Old TransactionID = 9
3635 > Transaction ID = 9
3636 > Old TransactionID = 8
3637  
3638   Journal Entry = jeQuery(Query)
3639   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3640   Attachment ID = 2
3641   Session ID = 1
3642 < Transaction ID = 10
3642 > Transaction ID = 9
3643   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3644  
3645   Journal Entry = jeTransStart(Transaction Start)
3646   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3647   Attachment ID = 2
3648   Session ID = 1
3649 < Transaction ID = 11
3649 > Transaction ID = 10
3650   Transaction Name = "Transaction_29_2"
3651   TPB: Item Count = 3
3652    isc_tpb_write
# Line 3646 | Line 3659 | Journal Entry = jeTransCommit(Commit)
3659   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3660   Attachment ID = 2
3661   Session ID = 1
3662 < Transaction ID = 10
3662 > Transaction ID = 9
3663  
3664   Journal Entry = jeQuery(Query)
3665   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3666   Attachment ID = 2
3667   Session ID = 1
3668 < Transaction ID = 11
3668 > Transaction ID = 10
3669   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:
3670   Whether ''tis nobler in the mind to suffer
3671   The slings and arrows of outrageous fortune,
# Line 3694 | Line 3707 | Journal Entry = jeQuery(Query)
3707   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3708   Attachment ID = 2
3709   Session ID = 1
3710 < Transaction ID = 11
3710 > Transaction ID = 10
3711   Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3712   FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3713   0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
# Line 3706 | Line 3719 | Journal Entry = jeQuery(Query)
3719   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3720   Attachment ID = 2
3721   Session ID = 1
3722 < Transaction ID = 11
3722 > Transaction ID = 10
3723   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">
3724   <elt ix="0">100</elt>
3725   <elt ix="1">99</elt>
# Line 3732 | Line 3745 | Journal Entry = jeTransRollback(Rollback
3745   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3746   Attachment ID = 2
3747   Session ID = 1
3748 < Transaction ID = 11
3748 > Transaction ID = 10
3749  
3750  
3751  

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines