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

Comparing ibx/branches/udr/testsuite/FB4reference.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 651 | Line 651 | Running Test 3: ad hoc queries
651   Opening inet://localhost/employee
652   Database Open
653   Employee Count = 42
654 < Transaction ID = 173
654 > Transaction ID = 5281
655   Transaction is Read/Write
656   Transaction Database Path = inet://localhost/employee
657 < Transaction ID = 173
658 < Oldest Interesting = 171
659 < Oldest Action = 172
660 < Oldest Snapshot = 172
661 < Oldest Snapshot Number = 2
657 > Transaction ID = 5281
658 > Oldest Interesting = 1895
659 > Oldest Action = 5280
660 > Oldest Snapshot = 5280
661 > Oldest Snapshot Number = 1
662   Lock Timeout = 0
663   Transaction Access = isc_info_tra_readwrite
664   Isolation Type = isc_info_tra_concurrency
# Line 692 | Line 692 | JOB_COUNTRY = USA
692   SALARY = 64,635.00
693   FULL_NAME = Johnson, Leslie
694  
695 < Current memory = 19,767,936
695 > Current memory = 19,762,192
696   Delta memory = 4,464
697 < Max memory = 19,813,552
697 > Max memory = 19,807,520
698   Elapsed time= 0.002 sec
699   Cpu = 0.000 sec
700   Buffers = 2048
# Line 2834 | Line 2834 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2834   ------------------------------------------------------
2835   Running Test 9: Database Information tests
2836   Database ID = 4 FB = /opt/firebird4.0.1/examples/empbuild/employee.fdb SN = zeus
2837 < Pages =346
2837 > Pages =413
2838   Base Level = 13,4,0,3,
2839   Implementation = 11,7,0,3,66,1,66,
2840   Reserved = 0
# Line 2844 | Line 2844 | Page Size = 8192
2844   Version = 1: LI-V6.3.1.2692 Firebird 4.0
2845   Database is Read/Write
2846   Database Created: 21/12/2021 10:52:59
2847 < Pages Used = 310
2848 < Pages Free = 36
2849 < Server Memory = 19482432
2847 > Pages Used = 351
2848 > Pages Free = 62
2849 > Server Memory = 19476112
2850   Forced Writes  = 1
2851 < Max Memory  = 19629552
2851 > Max Memory  = 19506944
2852   Num Buffers  = 2048
2853   Sweep Interval  = 20000
2854   Logged in Users: SYSDBA,
2855   Active Transaction Count = 0
2856 < Fetches  = 1634
2857 < Writes  = 8
2858 < Reads  = 91
2859 < Page Writes  = 4
2856 > Fetches  = 1683
2857 > Writes  = 6
2858 > Reads  = 97
2859 > Page Writes  = 3
2860   Record Version Removals Operation Counts
2861  
2862   Deletes Operation Counts
# Line 2871 | Line 2871 | Indexed Reads Count Operation Counts
2871   Table ID = 4
2872   Count = 63
2873   Table ID = 6
2874 < Count = 23
2874 > Count = 13
2875   Table ID = 9
2876 < Count = 3
2876 > Count = 1
2877   Table ID = 11
2878   Count = 2
2879   Table ID = 12
2880   Count = 24
2881   Table ID = 18
2882 < Count = 805
2882 > Count = 940
2883   Table ID = 20
2884   Count = 5
2885   Table ID = 28
# Line 2893 | Line 2893 | Sequential Table Scans Operation Counts
2893   Table ID = 0
2894   Count = 98
2895   Table ID = 1
2896 < Count = 24
2896 > Count = 14
2897  
2898   Update Count Operation Counts
2899  
# Line 2971 | Line 2971 | Local Backup
2971  
2972  
2973  
2974 +
2975   Local Backup Complete
2976  
2977   Local Restore
# Line 4922 | Line 4923 | MYARRAY = NULL
4923  
4924   Journal Table
4925   IBX$SESSIONID = 1
4926 < IBX$TRANSACTIONID = 9
4926 > IBX$TRANSACTIONID = 8
4927   IBX$OLDTRANSACTIONID = NULL
4928   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4929 < IBX$CREATED = 2022/01/02 14:16:56.6410
4929 > IBX$CREATED = 2022/01/09 15:24:09.1790
4930   IBX$SESSIONID = 1
4931 < IBX$TRANSACTIONID = 11
4932 < IBX$OLDTRANSACTIONID = 10
4931 > IBX$TRANSACTIONID = 10
4932 > IBX$OLDTRANSACTIONID = 9
4933   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4934 < IBX$CREATED = 2022/01/02 14:16:56.9850
4934 > IBX$CREATED = 2022/01/09 15:24:09.5040
4935  
4936   Journal Entries
4937   Journal Entry = jeTransStart(Transaction Start)
4938   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4939   Attachment ID = 4
4940   Session ID = 1
4941 < Transaction ID = 9
4941 > Transaction ID = 8
4942   Transaction Name = "Transaction_29_1"
4943   TPB: Item Count = 3
4944    isc_tpb_write
# Line 4950 | Line 4951 | Journal Entry = jeQuery(Query)
4951   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4952   Attachment ID = 4
4953   Session ID = 1
4954 < Transaction ID = 9
4954 > Transaction ID = 8
4955   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
4956  
4957   Journal Entry = jeQuery(Query)
4958   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4959   Attachment ID = 4
4960   Session ID = 1
4961 < Transaction ID = 9
4961 > Transaction ID = 8
4962   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4963  
4964   Journal Entry = jeTransCommitRet(Commit Retaining)
4965   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4966   Attachment ID = 4
4967   Session ID = 1
4968 < Transaction ID = 10
4969 < Old TransactionID = 9
4968 > Transaction ID = 9
4969 > Old TransactionID = 8
4970  
4971   Journal Entry = jeQuery(Query)
4972   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4973   Attachment ID = 4
4974   Session ID = 1
4975 < Transaction ID = 10
4975 > Transaction ID = 9
4976   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
4977  
4978   Journal Entry = jeTransRollbackRet(Rollback Retaining)
4979   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4980   Attachment ID = 4
4981   Session ID = 1
4982 < Transaction ID = 11
4983 < Old TransactionID = 10
4982 > Transaction ID = 10
4983 > Old TransactionID = 9
4984  
4985   Journal Entry = jeQuery(Query)
4986   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4987   Attachment ID = 4
4988   Session ID = 1
4989 < Transaction ID = 11
4989 > Transaction ID = 10
4990   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
4991  
4992   Journal Entry = jeTransStart(Transaction Start)
4993   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4994   Attachment ID = 4
4995   Session ID = 1
4996 < Transaction ID = 12
4996 > Transaction ID = 11
4997   Transaction Name = "Transaction_29_2"
4998   TPB: Item Count = 3
4999    isc_tpb_write
# Line 5005 | Line 5006 | Journal Entry = jeTransCommit(Commit)
5006   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5007   Attachment ID = 4
5008   Session ID = 1
5009 < Transaction ID = 11
5009 > Transaction ID = 10
5010  
5011   Journal Entry = jeQuery(Query)
5012   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5013   Attachment ID = 4
5014   Session ID = 1
5015 < Transaction ID = 12
5015 > Transaction ID = 11
5016   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:
5017   Whether ''tis nobler in the mind to suffer
5018   The slings and arrows of outrageous fortune,
# Line 5053 | Line 5054 | Journal Entry = jeQuery(Query)
5054   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5055   Attachment ID = 4
5056   Session ID = 1
5057 < Transaction ID = 12
5057 > Transaction ID = 11
5058   Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
5059   FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5060   0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
# Line 5065 | Line 5066 | Journal Entry = jeQuery(Query)
5066   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5067   Attachment ID = 4
5068   Session ID = 1
5069 < Transaction ID = 12
5069 > Transaction ID = 11
5070   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">
5071   <elt ix="0">100</elt>
5072   <elt ix="1">99</elt>
# Line 5091 | Line 5092 | Journal Entry = jeTransRollback(Rollback
5092   Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5093   Attachment ID = 4
5094   Session ID = 1
5095 < Transaction ID = 12
5095 > Transaction ID = 11
5096  
5097  
5098  

Diff Legend

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