--- 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