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 375 by tony, Sun Jan 9 23:42:58 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 = 5734
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 = 5734
657 > Oldest Interesting = 5732
658 > Oldest Action = 5733
659 > Oldest Snapshot = 5733
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
695 < Cpu = 0.000 sec
693 > Max memory = 19,751,184
694 > Elapsed time= 0.003 sec
695 > Cpu = 0.010 sec
696   Buffers = 2048
697   Reads = 0
698 < Writes = 0
698 > Writes = 1
699   Fetches = 3
700   Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
701   Relation Name = EMPLOYEE
# 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 2961 | Line 2961 | Local Backup
2961  
2962  
2963  
2964 +
2965   Local Backup Complete
2966  
2967   Local Restore
# Line 3701 | Line 3702 | MYARRAY = NULL
3702  
3703   Journal Table
3704   IBX$SESSIONID = 1
3705 < IBX$TRANSACTIONID = 9
3705 > IBX$TRANSACTIONID = 8
3706   IBX$OLDTRANSACTIONID = NULL
3707   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3708 < IBX$CREATED = 2022/01/02 13:51:28.9780
3708 > IBX$CREATED = 2022/01/09 15:31:44.1510
3709   IBX$SESSIONID = 1
3710 < IBX$TRANSACTIONID = 11
3711 < IBX$OLDTRANSACTIONID = 10
3710 > IBX$TRANSACTIONID = 10
3711 > IBX$OLDTRANSACTIONID = 9
3712   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3713 < IBX$CREATED = 2022/01/02 13:51:29.3510
3713 > IBX$CREATED = 2022/01/09 15:31:44.8740
3714  
3715   Journal Entries
3716   Journal Entry = jeTransStart(Transaction Start)
3717   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3718   Attachment ID = 6
3719   Session ID = 1
3720 < Transaction ID = 9
3720 > Transaction ID = 8
3721   Transaction Name = "Transaction_29_1"
3722   TPB: Item Count = 3
3723    isc_tpb_write
# Line 3729 | Line 3730 | Journal Entry = jeQuery(Query)
3730   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3731   Attachment ID = 6
3732   Session ID = 1
3733 < Transaction ID = 9
3733 > Transaction ID = 8
3734   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3735  
3736   Journal Entry = jeQuery(Query)
3737   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3738   Attachment ID = 6
3739   Session ID = 1
3740 < Transaction ID = 9
3740 > Transaction ID = 8
3741   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3742  
3743   Journal Entry = jeTransCommitRet(Commit Retaining)
3744   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3745   Attachment ID = 6
3746   Session ID = 1
3747 < Transaction ID = 10
3748 < Old TransactionID = 9
3747 > Transaction ID = 9
3748 > Old TransactionID = 8
3749  
3750   Journal Entry = jeQuery(Query)
3751   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3752   Attachment ID = 6
3753   Session ID = 1
3754 < Transaction ID = 10
3754 > Transaction ID = 9
3755   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3756  
3757   Journal Entry = jeTransRollbackRet(Rollback Retaining)
3758   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3759   Attachment ID = 6
3760   Session ID = 1
3761 < Transaction ID = 11
3762 < Old TransactionID = 10
3761 > Transaction ID = 10
3762 > Old TransactionID = 9
3763  
3764   Journal Entry = jeQuery(Query)
3765   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3766   Attachment ID = 6
3767   Session ID = 1
3768 < Transaction ID = 11
3768 > Transaction ID = 10
3769   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3770  
3771   Journal Entry = jeTransStart(Transaction Start)
3772   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3773   Attachment ID = 6
3774   Session ID = 1
3775 < Transaction ID = 12
3775 > Transaction ID = 11
3776   Transaction Name = "Transaction_29_2"
3777   TPB: Item Count = 3
3778    isc_tpb_write
# Line 3784 | Line 3785 | Journal Entry = jeTransCommit(Commit)
3785   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3786   Attachment ID = 6
3787   Session ID = 1
3788 < Transaction ID = 11
3788 > Transaction ID = 10
3789  
3790   Journal Entry = jeQuery(Query)
3791   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3792   Attachment ID = 6
3793   Session ID = 1
3794 < Transaction ID = 12
3794 > Transaction ID = 11
3795   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:
3796   Whether ''tis nobler in the mind to suffer
3797   The slings and arrows of outrageous fortune,
# Line 3832 | Line 3833 | Journal Entry = jeQuery(Query)
3833   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3834   Attachment ID = 6
3835   Session ID = 1
3836 < Transaction ID = 12
3836 > Transaction ID = 11
3837   Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3838   FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3839   0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
# Line 3844 | Line 3845 | Journal Entry = jeQuery(Query)
3845   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3846   Attachment ID = 6
3847   Session ID = 1
3848 < Transaction ID = 12
3848 > Transaction ID = 11
3849   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">
3850   <elt ix="0">100</elt>
3851   <elt ix="1">99</elt>
# Line 3870 | Line 3871 | Journal Entry = jeTransRollback(Rollback
3871   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3872   Attachment ID = 6
3873   Session ID = 1
3874 < Transaction ID = 12
3874 > Transaction ID = 11
3875  
3876  
3877  

Diff Legend

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