--- ibx/trunk/testsuite/FB4reference.log 2021/02/25 12:14:35 323 +++ ibx/trunk/testsuite/FB4reference.log 2021/07/07 11:53:54 340 @@ -3,10 +3,10 @@ Copyright MWA Software 2016-2021 Starting Tests Client API Version = 4.0 -Firebird Environment Variable = /opt/firebird4rc1 -Firebird Bin Directory = /opt/firebird4rc1/bin -Firebird Conf Directory = /opt/firebird4rc1/ -Firebird Client Library Path = /opt/firebird4rc1/lib/libfbclient.so +Firebird Environment Variable = /opt/firebird4.0.0 +Firebird Bin Directory = /opt/firebird4.0.0/bin +Firebird Conf Directory = /opt/firebird4.0.0/ +Firebird Client Library Path = /opt/firebird4.0.0/lib/libfbclient.so Running Test 01: Open and read from Employee Database Read dataset unidirectional buffering Row No = 1 @@ -641,10 +641,10 @@ DEPT_KEY_PATH = 000;900 (Charset = UTF8 Rows printed = 42 -Current memory = 19,670,464 +Current memory = 19,686,512 Delta memory = 16,384 -Max memory = 19,765,360 -Elapsed time= 0.027 sec +Max memory = 19,781,408 +Elapsed time= 0.015 sec Cpu = 0.010 sec Buffers = 2048 Reads = 2 @@ -1445,7 +1445,7 @@ DPB: Item Count = 3 isc_dpb_lc_ctype = UTF8 Before Disconnect -inet://localhost/employee Disconnected after 17 ms +inet://localhost/employee Disconnected after 20 ms Before Connect Connected to inet://localhost/employee DPB: Item Count = 3 @@ -1454,7 +1454,7 @@ DPB: Item Count = 3 isc_dpb_lc_ctype = UTF8 Before Disconnect -inet://localhost/employee Disconnected after 4027 ms +inet://localhost/employee Disconnected after 4019 ms Idle Timer Expired for Test_Database_02 Database Closed Transaction Events @@ -1477,7 +1477,7 @@ TPB: Item Count = 3 isc_tpb_read Transaction Ending -Transaction Ended after 0 ms +Transaction Ended after 1 ms Transaction idle timer test Requested TPB: Item Count = 3 isc_tpb_concurrency @@ -1491,10 +1491,10 @@ TPB: Item Count = 3 isc_tpb_read Transaction Ending -Transaction Ended after 2000 ms +Transaction Ended after 1999 ms Idle Timer Expired for Test_Transaction_02 Before Disconnect -inet://localhost/employee Disconnected after 2035 ms +inet://localhost/employee Disconnected after 2038 ms SQL Dialect Downgrade test Before Connect Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb @@ -1506,7 +1506,7 @@ DPB: Item Count = 4 inet://localhost//tmp/ibx-testsuite/testsuite1.fdb created Before Disconnect -inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 26 ms +inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 29 ms Before Connect Warning: SQL Dialect Downgrade of inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb @@ -1516,7 +1516,7 @@ DPB: Item Count = 3 isc_dpb_lc_ctype = UTF8 Before Disconnect -inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms +inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 76 ms ------------------------------------------------------ @@ -1524,28 +1524,28 @@ Running Test 03: Database Information Authentication Method = Srp256 Remote Protocol = TCPv4 Attachment SQLDialect = 3 -Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1" -Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ" -Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ" +Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" +Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" +Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" on disk structure version 13.0 -FB Version: Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1", Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ", Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ", on disk structure version 13.0 -Firebird Library Pathname = /opt/firebird4rc1/lib/libfbclient.so +FB Version: Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0", Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ", Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ", on disk structure version 13.0 +Firebird Library Pathname = /opt/firebird4.0.0/lib/libfbclient.so DB SQLDialect = 3 Allocation = 346 Base Level = 4 -DB File Name = /opt/firebird4rc1/examples/empbuild/employee.fdb +DB File Name = /opt/firebird4.0.0/examples/empbuild/employee.fdb DB Site Name = zeus DB Implementation No = 7 -Database Created: 01/2/2021 14:57:08 +Database Created: 29/5/2021 16:47:30 DB Implementation Class = 0 Space is Reserved ODS Minor Version = 0 ODS Major Version = 13 Page Size = 8192 -Version = LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1 -Current Memory = 19485440 +Version = LI-V6.3.0.2496 Firebird 4.0 +Current Memory = 19501200 Forced Writes Enabled -Max Memory = 19612048 +Max Memory = 19627808 Number of Buffers = 2048 Sweep Interval = 20000 User Names: SYSDBA @@ -3297,11 +3297,11 @@ SALARY = 32,000.00 FULL_NAME = Guckenheimer, Mark DEPT_PATH = Corporate Headquarters / Engineering / Software Products Div. / Quality Assurance (Charset Id = 4 Codepage = 65001) DEPT_KEY_PATH = 000;600;620;622 (Charset Id = 4 Codepage = 65001) -Current memory = 19,651,184 +Current memory = 19,667,232 Delta memory = 16,416 -Max memory = 19,746,848 -Elapsed time= 0.009 sec -Cpu = 0.000 sec +Max memory = 19,762,896 +Elapsed time= 0.026 sec +Cpu = 0.020 sec Buffers = 2048 Reads = 2 Writes = 0 @@ -11764,50 +11764,50 @@ Event Handled: EVENT2, Count = 0 ------------------------------------------------------ Running Test 12: Test use of Services Connection -Firebird Library PathName = /opt/firebird4rc1/lib/libfbclient.so +Firebird Library PathName = /opt/firebird4.0.0/lib/libfbclient.so Connect String = localhost:service_mgr -Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1 +Server Version = LI-V4.0.0.2496 Firebird 4.0 Server Implementation = Firebird/Linux/AMD/Intel/x64 Service Version = 2 -Firebird Release = 4.0.0 (Build no. 2353) +Firebird Release = 4.0.0 (Build no. 2496) No. of attachments = 0 No. of databases = 0 -Base Location = /opt/firebird4rc1/ +Base Location = /opt/firebird4.0.0/ Lock File Location = /tmp/firebird/ -Security Database Location = /opt/firebird4rc1/security4.fdb -Message File Location = /opt/firebird4rc1/ +Security Database Location = /opt/firebird4.0.0/security4.fdb +Message File Location = /opt/firebird4.0.0/ Database Statistics for employee -Database "/opt/firebird4rc1/examples/empbuild/employee.fdb" -Gstat execution time Mon Feb 22 10:41:04 2021 +Database "/opt/firebird4.0.0/examples/empbuild/employee.fdb" +Gstat execution time Wed Jul 7 11:45:32 2021 Database header page information: Flags 0 -Generation 1138 +Generation 438 System Change Number 0 Page size 8192 ODS version 13.0 -Oldest transaction 1346 -Oldest active 1347 -Oldest snapshot 1347 -Next transaction 1347 +Oldest transaction 456 +Oldest active 457 +Oldest snapshot 457 +Next transaction 457 Sequence number 0 -Next attachment ID 1067 +Next attachment ID 274 Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc Shadow count 0 Page buffers 0 Next header page 0 Database dialect 3 -Creation date Feb 1, 2021 14:57:08 +Creation date May 29, 2021 15:47:30 Attributes force write Variable header data: -Database GUID: {22038096-B66F-4FBA-B3DF-A02ECCE5380E} +Database GUID: {7D20C88E-C496-4598-99F9-E33293AFA7E3} *END* Database file sequence: -File /opt/firebird4rc1/examples/empbuild/employee.fdb is the only file +File /opt/firebird4.0.0/examples/empbuild/employee.fdb is the only file Analyzing database pages ... COUNTRY (128) @@ -11866,7 +11866,7 @@ EMPLOYEE_PROJECT (134) Primary pointer page: 258, Index root page: 259 Pointer pages: 1, data page slots: 1 Data pages: 1, average fill: 10% -Primary pages: 1, secondary pages: 0, swept pages: 1 +Primary pages: 1, secondary pages: 0, swept pages: 0 Empty pages: 0, full pages: 0 Fill distribution: 0 - 19% = 1 @@ -11918,7 +11918,7 @@ SALARY_HISTORY (136) Primary pointer page: 270, Index root page: 271 Pointer pages: 1, data page slots: 1 Data pages: 1, average fill: 30% -Primary pages: 1, secondary pages: 0, swept pages: 1 +Primary pages: 1, secondary pages: 0, swept pages: 0 Empty pages: 0, full pages: 0 Fill distribution: 0 - 19% = 0 @@ -11940,97 +11940,97 @@ Fill distribution: 60 - 79% = 0 80 - 99% = 0 -Gstat completion time Mon Feb 22 10:41:04 2021 +Gstat completion time Wed Jul 7 11:45:32 2021 Server Log -zeus Thu Feb 11 14:23:45 2021 -firebird4rc1/bin/fbguard: guardian starting /opt/firebird4rc1/bin/firebird +zeus Wed Jun 9 10:07:18 2021 +firebird4/bin/fbguard: guardian starting /opt/firebird4/bin/firebird Online Validation -10:41:08.75 Validation started +11:45:32.71 Validation started -10:41:08.75 Relation 128 (COUNTRY) -10:41:08.75 process pointer page 0 of 1 -10:41:08.75 Index 1 (RDB$PRIMARY1) -10:41:08.75 Relation 128 (COUNTRY) is ok - -10:41:08.75 Relation 129 (JOB) -10:41:08.75 process pointer page 0 of 1 -10:41:08.75 Index 1 (RDB$PRIMARY2) -10:41:08.75 Index 2 (RDB$FOREIGN3) -10:41:08.75 Index 3 (MAXSALX) -10:41:08.75 Index 4 (MINSALX) -10:41:08.75 Relation 129 (JOB) is ok - -10:41:08.75 Relation 130 (DEPARTMENT) -10:41:08.75 process pointer page 0 of 1 -10:41:08.75 Index 1 (RDB$4) -10:41:08.75 Index 2 (RDB$PRIMARY5) -10:41:08.75 Index 3 (RDB$FOREIGN6) -10:41:08.75 Index 4 (BUDGETX) -10:41:08.75 Index 5 (RDB$FOREIGN10) -10:41:08.75 Relation 130 (DEPARTMENT) is ok - -10:41:08.75 Relation 131 (EMPLOYEE) -10:41:08.75 process pointer page 0 of 1 -10:41:08.75 Index 1 (RDB$PRIMARY7) -10:41:08.75 Index 2 (RDB$FOREIGN8) -10:41:08.75 Index 3 (RDB$FOREIGN9) -10:41:08.75 Index 4 (NAMEX) -10:41:08.75 Relation 131 (EMPLOYEE) is ok - -10:41:08.75 Relation 133 (PROJECT) -10:41:08.75 process pointer page 0 of 1 -10:41:08.75 Index 1 (RDB$11) -10:41:08.75 Index 2 (RDB$PRIMARY12) -10:41:08.75 Index 3 (RDB$FOREIGN13) -10:41:08.76 Index 4 (PRODTYPEX) -10:41:08.76 Relation 133 (PROJECT) is ok - -10:41:08.76 Relation 134 (EMPLOYEE_PROJECT) -10:41:08.76 process pointer page 0 of 1 -10:41:08.76 Index 1 (RDB$PRIMARY14) -10:41:08.76 Index 2 (RDB$FOREIGN15) -10:41:08.76 Index 3 (RDB$FOREIGN16) -10:41:08.76 Relation 134 (EMPLOYEE_PROJECT) is ok - -10:41:08.76 Relation 135 (PROJ_DEPT_BUDGET) -10:41:08.76 process pointer page 0 of 1 -10:41:08.76 Index 1 (RDB$PRIMARY17) -10:41:08.76 Index 2 (RDB$FOREIGN18) -10:41:08.76 Index 3 (RDB$FOREIGN19) -10:41:08.76 Relation 135 (PROJ_DEPT_BUDGET) is ok - -10:41:08.76 Relation 136 (SALARY_HISTORY) -10:41:08.76 process pointer page 0 of 1 -10:41:08.76 Index 1 (RDB$PRIMARY20) -10:41:08.76 Index 2 (RDB$FOREIGN21) -10:41:08.76 Index 3 (CHANGEX) -10:41:08.76 Index 4 (UPDATERX) -10:41:08.76 Relation 136 (SALARY_HISTORY) is ok - -10:41:08.76 Relation 137 (CUSTOMER) -10:41:08.76 process pointer page 0 of 1 -10:41:08.76 Index 1 (RDB$PRIMARY22) -10:41:08.76 Index 2 (RDB$FOREIGN23) -10:41:08.76 Index 3 (CUSTNAMEX) -10:41:08.76 Index 4 (CUSTREGION) -10:41:08.76 Relation 137 (CUSTOMER) is ok - -10:41:08.76 Relation 138 (SALES) -10:41:08.76 process pointer page 0 of 1 -10:41:08.76 Index 1 (RDB$PRIMARY24) -10:41:08.76 Index 2 (RDB$FOREIGN25) -10:41:08.76 Index 3 (RDB$FOREIGN26) -10:41:08.76 Index 4 (NEEDX) -10:41:08.76 Index 5 (QTYX) -10:41:08.76 Index 6 (SALESTATX) -10:41:08.76 Relation 138 (SALES) is ok +11:45:32.71 Relation 128 (COUNTRY) +11:45:32.71 process pointer page 0 of 1 +11:45:32.71 Index 1 (RDB$PRIMARY1) +11:45:32.71 Relation 128 (COUNTRY) is ok + +11:45:32.71 Relation 129 (JOB) +11:45:32.71 process pointer page 0 of 1 +11:45:32.71 Index 1 (RDB$PRIMARY2) +11:45:32.71 Index 2 (RDB$FOREIGN3) +11:45:32.71 Index 3 (MAXSALX) +11:45:32.71 Index 4 (MINSALX) +11:45:32.71 Relation 129 (JOB) is ok + +11:45:32.71 Relation 130 (DEPARTMENT) +11:45:32.71 process pointer page 0 of 1 +11:45:32.71 Index 1 (RDB$4) +11:45:32.71 Index 2 (RDB$PRIMARY5) +11:45:32.71 Index 3 (RDB$FOREIGN6) +11:45:32.71 Index 4 (BUDGETX) +11:45:32.71 Index 5 (RDB$FOREIGN10) +11:45:32.71 Relation 130 (DEPARTMENT) is ok + +11:45:32.71 Relation 131 (EMPLOYEE) +11:45:32.71 process pointer page 0 of 1 +11:45:32.71 Index 1 (RDB$PRIMARY7) +11:45:32.71 Index 2 (RDB$FOREIGN8) +11:45:32.71 Index 3 (RDB$FOREIGN9) +11:45:32.71 Index 4 (NAMEX) +11:45:32.71 Relation 131 (EMPLOYEE) is ok + +11:45:32.71 Relation 133 (PROJECT) +11:45:32.71 process pointer page 0 of 1 +11:45:32.71 Index 1 (RDB$11) +11:45:32.71 Index 2 (RDB$PRIMARY12) +11:45:32.71 Index 3 (RDB$FOREIGN13) +11:45:32.71 Index 4 (PRODTYPEX) +11:45:32.71 Relation 133 (PROJECT) is ok + +11:45:32.72 Relation 134 (EMPLOYEE_PROJECT) +11:45:32.72 process pointer page 0 of 1 +11:45:32.72 Index 1 (RDB$PRIMARY14) +11:45:32.72 Index 2 (RDB$FOREIGN15) +11:45:32.72 Index 3 (RDB$FOREIGN16) +11:45:32.72 Relation 134 (EMPLOYEE_PROJECT) is ok + +11:45:32.72 Relation 135 (PROJ_DEPT_BUDGET) +11:45:32.72 process pointer page 0 of 1 +11:45:32.72 Index 1 (RDB$PRIMARY17) +11:45:32.72 Index 2 (RDB$FOREIGN18) +11:45:32.72 Index 3 (RDB$FOREIGN19) +11:45:32.73 Relation 135 (PROJ_DEPT_BUDGET) is ok + +11:45:32.73 Relation 136 (SALARY_HISTORY) +11:45:32.73 process pointer page 0 of 1 +11:45:32.73 Index 1 (RDB$PRIMARY20) +11:45:32.73 Index 2 (RDB$FOREIGN21) +11:45:32.73 Index 3 (CHANGEX) +11:45:32.73 Index 4 (UPDATERX) +11:45:32.73 Relation 136 (SALARY_HISTORY) is ok + +11:45:32.73 Relation 137 (CUSTOMER) +11:45:32.73 process pointer page 0 of 1 +11:45:32.73 Index 1 (RDB$PRIMARY22) +11:45:32.73 Index 2 (RDB$FOREIGN23) +11:45:32.73 Index 3 (CUSTNAMEX) +11:45:32.73 Index 4 (CUSTREGION) +11:45:32.73 Relation 137 (CUSTOMER) is ok + +11:45:32.73 Relation 138 (SALES) +11:45:32.73 process pointer page 0 of 1 +11:45:32.73 Index 1 (RDB$PRIMARY24) +11:45:32.73 Index 2 (RDB$FOREIGN25) +11:45:32.73 Index 3 (RDB$FOREIGN26) +11:45:32.73 Index 4 (NEEDX) +11:45:32.73 Index 5 (QTYX) +11:45:32.73 Index 6 (SALESTATX) +11:45:32.73 Relation 138 (SALES) is ok -10:41:08.76 Validation finished +11:45:32.73 Validation finished Normal Validation @@ -13315,9 +13315,9 @@ DEPT_KEY_PATH = 000 (Charset = UTF8 Code Rows printed = 2 -Current memory = 19,649,408 +Current memory = 19,665,456 Delta memory = 16,032 -Max memory = 19,744,992 +Max memory = 19,761,040 Elapsed time= 0.001 sec Cpu = 0.000 sec Buffers = 2048 @@ -13583,10 +13583,10 @@ DEPT_KEY_PATH = 000 (Charset = UTF8 Code Rows printed = 2 -Current memory = 19,649,408 +Current memory = 19,665,456 Delta memory = 16,032 -Max memory = 19,744,992 -Elapsed time= 0.105 sec +Max memory = 19,761,040 +Elapsed time= 0.102 sec Cpu = 0.000 sec Buffers = 2048 Reads = 2 @@ -15204,14 +15204,14 @@ Create Table LotsOfData ( MyText VarChar(1024), Primary Key (RowID) ); -Loading data into database table. Started at 22/2/2021 10:42:05.275 -Data load completed at 22/2/2021 10:43:41.417 Elapsed Time = 96143 ms, 100000 records loaded - MD5 checksum = 7887a4d19dd095ad551ca8b5dc788e29 -Database Read started at 22/2/2021 10:43:41.438 -Read Dataset completed at 22/2/2021 10:44:12.873 Elapsed Time = 31435 ms, 100000 records read - MD5 checksum = 7887a4d19dd095ad551ca8b5dc788e29 +Loading data into database table. Started at 07/7/2021 11:46:17.204 +Data load completed at 07/7/2021 11:48:00.164 Elapsed Time = 102960 ms, 100000 records loaded + MD5 checksum = 1c66cd114720b84a4fa21d01f8a0ba2b +Database Read started at 07/7/2021 11:48:00.174 +Read Dataset completed at 07/7/2021 11:48:38.470 Elapsed Time = 38296 ms, 100000 records read + MD5 checksum = 1c66cd114720b84a4fa21d01f8a0ba2b Test Completed successfully -22/2/2021 10:44:12.873 Test 21 passes as long as the MD5 sums are identical +07/7/2021 11:48:38.470 Test 21 passes as long as the MD5 sums are identical ------------------------------------------------------