[ViewVC] Diff of: public/ibx/branches/journaling/fbintf/testsuite/FB4reference.log

Comparing ibx/branches/journaling/fbintf/testsuite/FB4reference.log (file contents):
Revision 362 by tony, Tue Dec 7 13:27:39 2021 UTC vs.
Revision 363 by tony, Tue Dec 7 13:30:05 2021 UTC

+Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
+ODS major = 13
+ODS minor = 0
-+
+Attachment ID = 4
+DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
+DB Charset ID = 4
+DB SQL Dialect = 3
+SALARY = 64,635.00
+FULL_NAME = Johnson, Leslie
-+
+Scollable Cursors
-+
+DB Connect String = inet://localhost/employee
-+
+DB Charset ID = 4
-+
+DB SQL Dialect = 3
-+
+DB Remote Protocol = TCPv4
-+
+DB ODS Major Version = 13
-+
+DB ODS Minor Version = 0
-+
+User Authentication Method = Srp256
-+
+Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
-+
+DB Client Implementation Version = 4.0
-+
+Do Fetch Next:
-+
+EMP_NO = 2
-+
+FIRST_NAME = Robert
-+
+LAST_NAME = Nelson
-+
+PHONE_EXT = 250
-+
+HIRE_DATE = 1988/12/28 00:00:00.0000
-+
+DEPT_NO = 600
-+
+JOB_CODE = VP
-+
+JOB_GRADE = 2
-+
+JOB_COUNTRY = USA
-+
+SALARY = 105,900.00
-+
+FULL_NAME = Nelson, Robert
-+
+Do Fetch Last:
-+
+Remote Scrollable cursors test fails feature is not supported
+Now open the employee database as a local database
+TPB: Item Count = 3
+  isc_tpb_read
+Opening inet://localhost/employee
+Database Open
+Employee Count = 42
-+
+Transaction ID = 6547
-+
+Transaction is Read/Write
-+
+Transaction Database Path = inet://localhost/employee
-+
+Transaction ID = 6547
-+
+Oldest Interesting = 6545
-+
+Oldest Action = 6546
-+
+Oldest Snapshot = 6546
-+
+Oldest Snapshot Number = 2
-+
+Lock Timeout = 0
-+
+Transaction Access = isc_info_tra_readwrite
-+
+Isolation Type = isc_info_tra_concurrency
+Employee Count = 41
+Employee Count = 42
+Employee Count = 41
+SALARY = 64,635.00
+FULL_NAME = Johnson, Leslie
-<
+Current memory = 19,764,272
->
+Current memory = 19,767,952
+Delta memory = 4,464
-<
+Max memory = 19,809,888
-<
+Elapsed time= 0.002 sec
->
+Max memory = 19,813,568
->
+Elapsed time= 0.001 sec
+Cpu = 0.000 sec
+Buffers = 2048
+Reads = 0
+Version = 1: LI-V6.3.0.2496 Firebird 4.0
+Database is Read/Write
+Database Created: 29/5/2021 16:47:30
-<
+Pages Used = 310
-<
+Pages Free = 765
-<
+Server Memory = 19482272
->
+Pages Used = 313
->
+Pages Free = 762
->
+Server Memory = 19484112
+Forced Writes  = 1
-<
+Max Memory  = 19628544
->
+Max Memory  = 19630384
+Num Buffers  = 2048
+Sweep Interval  = 20000
+Logged in Users: SYSDBA,
+Active Transaction Count = 0
-<
+Fetches  = 1641
->
+Fetches  = 1653
+Writes  = 8
+Reads  = 92
+Page Writes  = 4
+Table ID = 12
+Count = 24
+Table ID = 18
-<
+Count = 811
->
+Count = 821
+Table ID = 20
+Count = 5
+Table ID = 28
+Sequential Table Scans Operation Counts
+Table ID = 0
-<
+Count = 98
->
+Count = 100
+Table ID = 1
+Count = 24
-+
+------------------------------------------------------
-+
+Running Test 22: Journalling
-+
+Start Journaling. Session ID = 1
-+
+.567 parsed to 1234567 scale = -3
-+
+As Float =  1.2345670000000000E+003
-+
+-765.4321 parsed to -7654321 scale = -4
-+
+As Float = -7.6543209999999999E+002
-+
+.1 parsed to 1 scale = -1
-+
+As Float =  1.0000000000000001E-001
-+
+.01 parsed to 1 scale = -2
-+
+As Float =  1.0000000000000000E-002
-+
++123 parsed to 123 scale = 0
-+
+As Float =  1.2300000000000000E+002
-+
+.23456E308 parsed to 123456 scale = 303
-+
+As Float =  1.2345600000000001E+308
-+
+-1.2e-02 parsed to -12 scale = -3
-+
+As Float = -1.2000000000000000E-002
-+
+. parsed to 10 scale = 0
-+
+As Float =  1.0000000000000000E+001
-+
+.12 parsed to 12 scale = -2
-+
+As Float =  1.2000000000000000E-001
-+
+.12 parsed to 12 scale = -2
-+
+As Float =  1.2000000000000000E-001
-+
+Parsing of 1.2E1.2 failed
-+
+Parsing of 1,000 failed
-+
+Parsing of 1e1e1 failed
-+
+Parsing of 1.2+3 failed
-+
+SQL Params
-+
+SQLType =SQL_LONG
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = 0
-+
+Charset id = 0
-+
+Not Null
-+
+Size = 4
-+
+Value = 0
-+
-+
+SQLType =SQL_LONG
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = 0
-+
+Charset id = 0
-+
+Nullable
-+
+Size = 4
-+
-+
+SQLType =SQL_INT64
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = 0
-+
+Charset id = 0
-+
+Nullable
-+
+Size = 8
-+
-+
+SQLType =SQL_INT64
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = -4
-+
+Charset id = 0
-+
+Nullable
-+
+Size = 8
-+
-+
+SQLType =SQL_DOUBLE
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = 0
-+
+Charset id = 0
-+
+Nullable
-+
+Size = 8
-+
-+
+SQLType =SQL_INT64
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = -6
-+
+Charset id = 0
-+
+Nullable
-+
+Size = 8
-+
-+
-+
+Text Tests
-+
+SQL Params
-+
+SQLType =SQL_LONG
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = 0
-+
+Charset id = 0
-+
+Not Null
-+
+Size = 4
-+
+Value = 0
-+
-+
+SQLType =SQL_VARYING
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = 0
-+
+Charset id = 4
-+
+Nullable
-+
+Size = 1024
-+
-+
+SQLType =SQL_BLOB
-+
+sub type = 1
-+
+Field Name =
-+
+Scale = 0
-+
+Charset id = 4
-+
+Nullable
-+
+Size = 8
-+
-+
-+
+Binary Blob Tests
-+
-+
+Array Test
-+
+SQL Params
-+
+SQLType =SQL_LONG
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = 0
-+
+Charset id = 0
-+
+Not Null
-+
+Size = 4
-+
+Value = 0
-+
-+
+SQLType =SQL_ARRAY
-+
+sub type = 0
-+
+Field Name =
-+
+Scale = 0
-+
+Charset id = 0
-+
+Nullable
-+
+Size = 8
-+
-+
+ROWID = 1
-+
+ITYPE = 101
-+
+I64TYPE = 9223372036854775807
-+
+CURRTYPE = 10,000.12340000
-+
+DTYPE = 9,999.12345678
-+
+FIXEDPOINT = 1,234,567,890.12345700
-+
+STR = NULL
-+
+TEXTBLOB = NULL
-+
+OTHERBLOB = NULL
-+
+MYARRAY = NULL
-+
+ROWID = 2
-+
+ITYPE = -32457
-+
+I64TYPE = -9223372036854775808
-+
+CURRTYPE = 1,000,001.12000000
-+
+DTYPE = 1.7E308
-+
+FIXEDPOINT = -1,234,567,890.12345700
-+
+STR = NULL
-+
+TEXTBLOB = NULL
-+
+OTHERBLOB = NULL
-+
+MYARRAY = NULL
-+
+ROWID = 4
-+
+ITYPE = 1
-+
+I64TYPE = 10
-+
+CURRTYPE = .02300000
-+
+DTYPE = .00110000
-+
+FIXEDPOINT = 233.45600000
-+
+STR = NULL
-+
+TEXTBLOB = NULL
-+
+OTHERBLOB = NULL
-+
+MYARRAY = NULL
-+
-+
+Journal Table
-+
+IBX$SESSIONID = 1
-+
+IBX$TRANSACTIONID = 9
-+
+IBX$OLDTRANSACTIONID = NULL
-+
+IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
-+
+IBX$CREATED = 2021/12/07 09:50:08.4430
-+
+IBX$SESSIONID = 1
-+
+IBX$TRANSACTIONID = 11
-+
+IBX$OLDTRANSACTIONID = 10
-+
+IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
-+
+IBX$CREATED = 2021/12/07 09:50:08.7940
-+
-+
+Journal Entries
-+
+Journal Entry = jeTransStart(Transaction Start)
-+
+Timestamp = 2021/12/07 09:50:08.4700
-+
+Session ID = 1
-+
+Transaction ID = 9
-+
+Transaction Name = "Transaction_29_1"
-+
+TPB: Item Count = 3
-+
+  isc_tpb_write
-+
+  isc_tpb_nowait
-+
+  isc_tpb_concurrency
-+
-+
+Default Completion = TACommit
-+
-+
+Journal Entry = jeQuery(Query)
-+
+Timestamp = 2021/12/07 09:50:08.5300
-+
+Session ID = 1
-+
+Transaction ID = 9
-+
+Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
-+
-+
+Journal Entry = jeQuery(Query)
-+
+Timestamp = 2021/12/07 09:50:08.5510
-+
+Session ID = 1
-+
+Transaction ID = 9
-+
+Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
-+
-+
+Journal Entry = jeTransCommitRet(Commit Retaining)
-+
+Timestamp = 2021/12/07 09:50:08.6650
-+
+Session ID = 1
-+
+Transaction ID = 10
-+
+Old TransactionID = 9
-+
-+
+Journal Entry = jeQuery(Query)
-+
+Timestamp = 2021/12/07 09:50:08.6870
-+
+Session ID = 1
-+
+Transaction ID = 10
-+
+Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
-+
-+
+Journal Entry = jeTransRollbackRet(Rollback Retaining)
-+
+Timestamp = 2021/12/07 09:50:08.7900
-+
+Session ID = 1
-+
+Transaction ID = 11
-+
+Old TransactionID = 10
-+
-+
+Journal Entry = jeQuery(Query)
-+
+Timestamp = 2021/12/07 09:50:08.8140
-+
+Session ID = 1
-+
+Transaction ID = 11
-+
+Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
-+
-+
+Journal Entry = jeTransStart(Transaction Start)
-+
+Timestamp = 2021/12/07 09:50:08.8260
-+
+Session ID = 1
-+
+Transaction ID = 12
-+
+Transaction Name = "Transaction_29_2"
-+
+TPB: Item Count = 3
-+
+  isc_tpb_write
-+
+  isc_tpb_nowait
-+
+  isc_tpb_concurrency
-+
-+
+Default Completion = TARollback
-+
-+
+Journal Entry = jeTransCommit(Commit)
-+
+Timestamp = 2021/12/07 09:50:08.8860
-+
+Session ID = 1
-+
+Transaction ID = 11
-+
-+
+Journal Entry = jeQuery(Query)
-+
+Timestamp = 2021/12/07 09:50:08.9660
-+
+Session ID = 1
-+
+Transaction ID = 12
-+
+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:
-+
+Whether ''tis nobler in the mind to suffer
-+
+The slings and arrows of outrageous fortune,
-+
+Or to take arms against a sea of troubles,
-+
+And, by opposing, end them. To die, to sleep-
-+
+No more-and by a sleep to say we end
-+
+The heartache and the thousand natural shocks
-+
+That flesh is heir to-''tis a consummation
-+
+Devoutly to be wished. To die, to sleep-
-+
+To sleep, perchance to dream. Aye, there''s the rub,
-+
+For in that sleep of death what dreams may come,
-+
+When we have shuffled off this mortal coil,
-+
+Must give us pause. There''s the respect
-+
+That makes calamity of so long life.
-+
+For who would bear the whips and scorns of time,
-+
+Th'' oppressor''s wrong, the proud man''s contumely,
-+
+The pangs of despised love, the law’s delay,
-+
+The insolence of office, and the spurns
-+
+That patient merit of the unworthy takes,
-+
+When he himself might his quietus make
-+
+With a bare bodkin? Who would fardels bear,
-+
+To grunt and sweat under a weary life,
-+
+But that the dread of something after death,
-+
+The undiscovered country from whose bourn
-+
+No traveler returns, puzzles the will
-+
+And makes us rather bear those ills we have
-+
+Than fly to others that we know not of?
-+
+Thus conscience does make cowards of us all,
-+
+And thus the native hue of resolution
-+
+Is sicklied o''er with the pale cast of thought,
-+
+And enterprises of great pitch and moment,
-+
+With this regard their currents turn awry,
-+
+And lose the name of action.-Soft you now,
-+
+The fair Ophelia.-Nymph, in thy orisons
-+
+Be all my sins remembered
-+
+')
-+
-+
+Journal Entry = jeQuery(Query)
-+
+Timestamp = 2021/12/07 09:50:09.0130
-+
+Session ID = 1
-+
+Transaction ID = 12
-+
+Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
-+
+FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
-+
+E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
-+
+01000000010000001A01050001000000DA000000
-+
+</blob>
-+
+)
-+
-+
+Journal Entry = jeQuery(Query)
-+
+Timestamp = 2021/12/07 09:50:09.0380
-+
+Session ID = 1
-+
+Transaction ID = 12
-+
+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">
-+
+ <elt ix="0">100</elt>
-+
+ <elt ix="1">99</elt>
-+
+ <elt ix="2">98</elt>
-+
+ <elt ix="3">97</elt>
-+
+ <elt ix="4">96</elt>
-+
+ <elt ix="5">95</elt>
-+
+ <elt ix="6">94</elt>
-+
+ <elt ix="7">93</elt>
-+
+ <elt ix="8">92</elt>
-+
+ <elt ix="9">91</elt>
-+
+ <elt ix="10">90</elt>
-+
+ <elt ix="11">89</elt>
-+
+ <elt ix="12">88</elt>
-+
+ <elt ix="13">87</elt>
-+
+ <elt ix="14">86</elt>
-+
+ <elt ix="15">85</elt>
-+
+ <elt ix="16">84</elt>
-+
+</array>
-+
+)
-+
-+
+Journal Entry = jeTransRollback(Rollback)
-+
+Timestamp = 2021/12/07 09:50:09.1560
-+
+Session ID = 1
-+
+Transaction ID = 12
-+
-+
-+
+------------------------------------------------------
+Test Suite Ends

Diff Legend

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

Comparing ibx/branches/journaling/fbintf/testsuite/FB4reference.log (file contents): Revision 362 by tony, Tue Dec 7 13:27:39 2021 UTC vs. Revision 363 by tony, Tue Dec 7 13:30:05 2021 UTC

Diff Legend

Comparing ibx/branches/journaling/fbintf/testsuite/FB4reference.log (file contents):
Revision 362 by tony, Tue Dec 7 13:27:39 2021 UTC vs.
Revision 363 by tony, Tue Dec 7 13:30:05 2021 UTC