--- ibx/branches/journaling/fbintf/testsuite/FB4reference.log 2021/12/07 13:27:39 362
+++ ibx/branches/journaling/fbintf/testsuite/FB4reference.log 2021/12/07 13:30:05 363
@@ -57,6 +57,7 @@ Creating a Database with a DPD
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
@@ -307,6 +308,30 @@ JOB_COUNTRY = USA
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
@@ -626,6 +651,17 @@ Running Test 3: ad hoc queries
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
@@ -656,10 +692,10 @@ JOB_COUNTRY = USA
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
@@ -2808,16 +2844,16 @@ Page Size = 8192
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
@@ -2843,7 +2879,7 @@ Count = 2
Table ID = 12
Count = 24
Table ID = 18
-Count = 811
+Count = 821
Table ID = 20
Count = 5
Table ID = 28
@@ -2855,7 +2891,7 @@ Count = 1
Sequential Table Scans Operation Counts
Table ID = 0
-Count = 98
+Count = 100
Table ID = 1
Count = 24
@@ -4682,5 +4718,325 @@ FIXEDPOINT = 233.45600000
+------------------------------------------------------
+Running Test 22: Journalling
+Start Journaling. Session ID = 1
+1234.567 parsed to 1234567 scale = -3
+As Float = 1.2345670000000000E+003
+-765.4321 parsed to -7654321 scale = -4
+As Float = -7.6543209999999999E+002
+0.1 parsed to 1 scale = -1
+As Float = 1.0000000000000001E-001
+0.01 parsed to 1 scale = -2
+As Float = 1.0000000000000000E-002
++123 parsed to 123 scale = 0
+As Float = 1.2300000000000000E+002
+1.23456E308 parsed to 123456 scale = 303
+As Float = 1.2345600000000001E+308
+-1.2e-02 parsed to -12 scale = -3
+As Float = -1.2000000000000000E-002
+10. parsed to 10 scale = 0
+As Float = 1.0000000000000000E+001
+.12 parsed to 12 scale = -2
+As Float = 1.2000000000000000E-001
+0.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,
+FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
+0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
+01000000010000001A01050001000000DA000000
+
+)
+
+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,
+ 100
+ 99
+ 98
+ 97
+ 96
+ 95
+ 94
+ 93
+ 92
+ 91
+ 90
+ 89
+ 88
+ 87
+ 86
+ 85
+ 84
+
+)
+
+Journal Entry = jeTransRollback(Rollback)
+Timestamp = 2021/12/07 09:50:09.1560
+Session ID = 1
+Transaction ID = 12
+
+
+
------------------------------------------------------
Test Suite Ends