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 374 by tony, Wed Jan 5 15:21:22 2022 UTC vs.
Revision 375 by tony, Sun Jan 9 23:42:58 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 = 6014
537   Transaction is Read/Write
538 < Transaction ID = 5972
538 > Transaction ID = 6014
539   Oldest Interesting = 5461
540 < Oldest Action = 5971
541 < Oldest Snapshot = 5971
540 > Oldest Action = 6013
541 > Oldest Snapshot = 6013
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
573 > Current memory = 937,656
574 > Delta memory = 1,296
575 > Max memory = 965,720
576   Elapsed time= 0.003 sec
577 < Cpu = 0.000 sec
577 > Cpu = 0.001 sec
578   Buffers = 75
579   Reads = 0
580   Writes = 0
# 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 3563 | Line 3559 | MYARRAY = NULL
3559  
3560   Journal Table
3561   IBX$SESSIONID = 1
3562 < IBX$TRANSACTIONID = 8
3562 > IBX$TRANSACTIONID = 7
3563   IBX$OLDTRANSACTIONID = NULL
3564   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3565 < IBX$CREATED = 2022/01/02 13:50:08.4510
3565 > IBX$CREATED = 2022/01/09 15:33:11.5220
3566   IBX$SESSIONID = 1
3567 < IBX$TRANSACTIONID = 10
3568 < IBX$OLDTRANSACTIONID = 9
3567 > IBX$TRANSACTIONID = 9
3568 > IBX$OLDTRANSACTIONID = 8
3569   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3570 < IBX$CREATED = 2022/01/02 13:50:08.7550
3570 > IBX$CREATED = 2022/01/09 15:33:11.8430
3571  
3572   Journal Entries
3573   Journal Entry = jeTransStart(Transaction Start)
3574   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3575   Attachment ID = 2
3576   Session ID = 1
3577 < Transaction ID = 8
3577 > Transaction ID = 7
3578   Transaction Name = "Transaction_29_1"
3579   TPB: Item Count = 3
3580    isc_tpb_write
# Line 3591 | Line 3587 | Journal Entry = jeQuery(Query)
3587   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3588   Attachment ID = 2
3589   Session ID = 1
3590 < Transaction ID = 8
3590 > Transaction ID = 7
3591   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3592  
3593   Journal Entry = jeQuery(Query)
3594   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3595   Attachment ID = 2
3596   Session ID = 1
3597 < Transaction ID = 8
3597 > Transaction ID = 7
3598   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3599  
3600   Journal Entry = jeTransCommitRet(Commit Retaining)
3601   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3602   Attachment ID = 2
3603   Session ID = 1
3604 < Transaction ID = 9
3605 < Old TransactionID = 8
3604 > Transaction ID = 8
3605 > Old TransactionID = 7
3606  
3607   Journal Entry = jeQuery(Query)
3608   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3609   Attachment ID = 2
3610   Session ID = 1
3611 < Transaction ID = 9
3611 > Transaction ID = 8
3612   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3613  
3614   Journal Entry = jeTransRollbackRet(Rollback Retaining)
3615   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3616   Attachment ID = 2
3617   Session ID = 1
3618 < Transaction ID = 10
3619 < Old TransactionID = 9
3618 > Transaction ID = 9
3619 > Old TransactionID = 8
3620  
3621   Journal Entry = jeQuery(Query)
3622   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3623   Attachment ID = 2
3624   Session ID = 1
3625 < Transaction ID = 10
3625 > Transaction ID = 9
3626   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3627  
3628   Journal Entry = jeTransStart(Transaction Start)
3629   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3630   Attachment ID = 2
3631   Session ID = 1
3632 < Transaction ID = 11
3632 > Transaction ID = 10
3633   Transaction Name = "Transaction_29_2"
3634   TPB: Item Count = 3
3635    isc_tpb_write
# Line 3646 | Line 3642 | Journal Entry = jeTransCommit(Commit)
3642   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3643   Attachment ID = 2
3644   Session ID = 1
3645 < Transaction ID = 10
3645 > Transaction ID = 9
3646  
3647   Journal Entry = jeQuery(Query)
3648   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3649   Attachment ID = 2
3650   Session ID = 1
3651 < Transaction ID = 11
3651 > Transaction ID = 10
3652   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:
3653   Whether ''tis nobler in the mind to suffer
3654   The slings and arrows of outrageous fortune,
# Line 3694 | Line 3690 | Journal Entry = jeQuery(Query)
3690   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3691   Attachment ID = 2
3692   Session ID = 1
3693 < Transaction ID = 11
3693 > Transaction ID = 10
3694   Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3695   FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3696   0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
# Line 3706 | Line 3702 | Journal Entry = jeQuery(Query)
3702   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3703   Attachment ID = 2
3704   Session ID = 1
3705 < Transaction ID = 11
3705 > Transaction ID = 10
3706   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">
3707   <elt ix="0">100</elt>
3708   <elt ix="1">99</elt>
# Line 3732 | Line 3728 | Journal Entry = jeTransRollback(Rollback
3728   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3729   Attachment ID = 2
3730   Session ID = 1
3731 < Transaction ID = 11
3731 > Transaction ID = 10
3732  
3733  
3734  

Diff Legend

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