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

Comparing ibx/branches/udr/testsuite/FB3reference.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 650 | Line 650 | Running Test 3: ad hoc queries
650   Opening inet://localhost/employee
651   Database Open
652   Employee Count = 42
653 < Transaction ID = 5588
653 > Transaction ID = 6142
654   Transaction is Read/Write
655   Transaction Database Path = inet://localhost/employee
656 < Transaction ID = 5588
657 < Oldest Interesting = 5586
658 < Oldest Action = 5587
659 < Oldest Snapshot = 5587
656 > Transaction ID = 6142
657 > Oldest Interesting = 6140
658 > Oldest Action = 6141
659 > Oldest Snapshot = 6141
660   Oldest Interesting = 0
661   Employee Count = 41
662   Employee Count = 42
# Line 688 | Line 688 | JOB_COUNTRY = USA
688   SALARY = 64,635.00
689   FULL_NAME = Johnson, Leslie
690  
691 < Current memory = 19,694,032
691 > Current memory = 19,689,792
692   Delta memory = 4,480
693 < Max memory = 19,755,888
694 < Elapsed time= 0.002 sec
693 > Max memory = 19,751,184
694 > Elapsed time= 0.001 sec
695   Cpu = 0.000 sec
696   Buffers = 2048
697   Reads = 0
# Line 2729 | Line 2729 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2729  
2730   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)
2731  
2732 < 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)
2732 > 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)
2733  
2734  
2735   Shrink to 2:10
# Line 2745 | Line 2745 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2745  
2746   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)
2747  
2748 < 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)
2748 > 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)
2749  
2750  
2751  
# Line 2842 | Line 2842 | Database is Read/Write
2842   Database Created: 09/1/2020 13:13:45
2843   Pages Used = 297
2844   Pages Free = 10
2845 < Server Memory = 19196128
2845 > Server Memory = 18985136
2846   Forced Writes  = 1
2847 < Max Memory  = 19316896
2847 > Max Memory  = 19022320
2848   Num Buffers  = 2048
2849   Sweep Interval  = 20000
2850   Logged in Users: SYSDBA,
2851   Active Transaction Count = 0
2852 < Fetches  = 452
2853 < Writes  = 8
2854 < Reads  = 57
2855 < Page Writes  = 4
2852 > Fetches  = 407
2853 > Writes  = 6
2854 > Reads  = 55
2855 > Page Writes  = 3
2856   Record Version Removals Operation Counts
2857  
2858   Deletes Operation Counts
# Line 2867 | Line 2867 | Indexed Reads Count Operation Counts
2867   Table ID = 4
2868   Count = 28
2869   Table ID = 6
2870 < Count = 15
2870 > Count = 5
2871   Table ID = 9
2872 < Count = 3
2872 > Count = 1
2873   Table ID = 11
2874   Count = 1
2875   Table ID = 12
# Line 2897 | Line 2897 | Async Wait Called
2897   Event Signalled
2898   First Event - usually ignored
2899   Signal Event
2900 + Event Signalled
2901   Event Counts: TESTEVENT, Count = 1
2902   Two more events
2903   Call Async Wait
2904   Async Wait Called
2905   Event Signalled
2905 – Event Signalled
2906   Deferred Events Caught
2907   Event Counts: TESTEVENT, Count = 2
2908   Signal Event
# Line 2914 | Line 2914 | Event Cancelled
2914   Time Out - Cancel Worked!
2915   Sync wait
2916   Event Signalled
2917 < Event Counts: TESTEVENT, Count = 1
2917 > Event Counts: TESTEVENT, Count = 0
2918  
2919  
2920   ------------------------------------------------------
# Line 3447 | Line 3447 | Value from BCD = 9999.12345678
3447   Raw Value = 999912345678 Scale = -8
3448   Value from Raw Data = 9999123.456780
3449   Raw Value = 9999123456780 Scale = -6
3450 + Numeric Operations
3451 + Add 2.23 + 24.12345 = 26.35345
3452 + Add Double 2.23 + 24.12645 = 26.35645
3453 + Add integer 2.23 + 2412345 = 2412347.23
3454 + Subtract 2.23 - 24.12345 = -21.89345
3455 + Subtract Double 24.12645 - 2.23 = -21.89645
3456 + Subtract integer 24123.45 - 223 = -23900.45
3457 + Multiply 2.23 * 24.12345 = 53.7952935
3458 + Multiply Double 24.12645 * 2.23 = 53.8019835
3459 + Multiply integer 241.2345 * 223 = 53795.2935
3460 + Divide 24.12345 / 2.23 = 10.81769
3461 + Divide Double 2.23 / 24.12645 = 0.09
3462 + Divide integer 241.2345 / 223 = 1.0818
3463 + Compare 2.23, -24.12345 = 1
3464 + Compare integer 2.23, 3 = -1
3465 + Compare Double 2.23, 2.23 = 0
3466 + Negate 24.12345 = -24.12345
3467   SQL Params
3468   SQLType =SQL_LONG
3469   sub type = 0
# Line 3701 | Line 3718 | MYARRAY = NULL
3718  
3719   Journal Table
3720   IBX$SESSIONID = 1
3721 < IBX$TRANSACTIONID = 9
3721 > IBX$TRANSACTIONID = 8
3722   IBX$OLDTRANSACTIONID = NULL
3723   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3724 < IBX$CREATED = 2022/01/02 13:51:28.9780
3724 > IBX$CREATED = 2022/01/14 23:02:04.2320
3725   IBX$SESSIONID = 1
3726 < IBX$TRANSACTIONID = 11
3727 < IBX$OLDTRANSACTIONID = 10
3726 > IBX$TRANSACTIONID = 10
3727 > IBX$OLDTRANSACTIONID = 9
3728   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3729 < IBX$CREATED = 2022/01/02 13:51:29.3510
3729 > IBX$CREATED = 2022/01/14 23:02:04.6690
3730  
3731   Journal Entries
3732   Journal Entry = jeTransStart(Transaction Start)
3733   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3734   Attachment ID = 6
3735   Session ID = 1
3736 < Transaction ID = 9
3736 > Transaction ID = 8
3737   Transaction Name = "Transaction_29_1"
3738   TPB: Item Count = 3
3739    isc_tpb_write
# Line 3729 | Line 3746 | Journal Entry = jeQuery(Query)
3746   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3747   Attachment ID = 6
3748   Session ID = 1
3749 < Transaction ID = 9
3749 > Transaction ID = 8
3750   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3751  
3752   Journal Entry = jeQuery(Query)
3753   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3754   Attachment ID = 6
3755   Session ID = 1
3756 < Transaction ID = 9
3756 > Transaction ID = 8
3757   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3758  
3759   Journal Entry = jeTransCommitRet(Commit Retaining)
3760   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3761   Attachment ID = 6
3762   Session ID = 1
3763 < Transaction ID = 10
3764 < Old TransactionID = 9
3763 > Transaction ID = 9
3764 > Old TransactionID = 8
3765  
3766   Journal Entry = jeQuery(Query)
3767   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3768   Attachment ID = 6
3769   Session ID = 1
3770 < Transaction ID = 10
3770 > Transaction ID = 9
3771   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3772  
3773   Journal Entry = jeTransRollbackRet(Rollback Retaining)
3774   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3775   Attachment ID = 6
3776   Session ID = 1
3777 < Transaction ID = 11
3778 < Old TransactionID = 10
3777 > Transaction ID = 10
3778 > Old TransactionID = 9
3779  
3780   Journal Entry = jeQuery(Query)
3781   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3782   Attachment ID = 6
3783   Session ID = 1
3784 < Transaction ID = 11
3784 > Transaction ID = 10
3785   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3786  
3787   Journal Entry = jeTransStart(Transaction Start)
3788   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3789   Attachment ID = 6
3790   Session ID = 1
3791 < Transaction ID = 12
3791 > Transaction ID = 11
3792   Transaction Name = "Transaction_29_2"
3793   TPB: Item Count = 3
3794    isc_tpb_write
# Line 3784 | Line 3801 | Journal Entry = jeTransCommit(Commit)
3801   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3802   Attachment ID = 6
3803   Session ID = 1
3804 < Transaction ID = 11
3804 > Transaction ID = 10
3805  
3806   Journal Entry = jeQuery(Query)
3807   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3808   Attachment ID = 6
3809   Session ID = 1
3810 < Transaction ID = 12
3810 > Transaction ID = 11
3811   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:
3812   Whether ''tis nobler in the mind to suffer
3813   The slings and arrows of outrageous fortune,
# Line 3832 | Line 3849 | Journal Entry = jeQuery(Query)
3849   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3850   Attachment ID = 6
3851   Session ID = 1
3852 < Transaction ID = 12
3852 > Transaction ID = 11
3853   Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3854   FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3855   0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
# Line 3844 | Line 3861 | Journal Entry = jeQuery(Query)
3861   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3862   Attachment ID = 6
3863   Session ID = 1
3864 < Transaction ID = 12
3864 > Transaction ID = 11
3865   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">
3866   <elt ix="0">100</elt>
3867   <elt ix="1">99</elt>
# Line 3870 | Line 3887 | Journal Entry = jeTransRollback(Rollback
3887   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3888   Attachment ID = 6
3889   Session ID = 1
3890 < Transaction ID = 12
3890 > Transaction ID = 11
3891  
3892  
3893  

Diff Legend

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