--- ibx/trunk/testsuite/FB3reference.log 2021/10/18 08:39:40 349 +++ ibx/trunk/testsuite/FB3reference.log 2021/10/23 14:11:37 353 @@ -641,10 +641,10 @@ DEPT_KEY_PATH = 000;900 (Charset = UTF8 Rows printed = 42 -Current memory = 19,651,152 +Current memory = 19,651,872 Delta memory = 13,040 -Max memory = 19,779,424 -Elapsed time= 0.029 sec +Max memory = 19,780,144 +Elapsed time= 0.026 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 20 ms +inet://localhost/employee Disconnected after 19 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 3984 ms +inet://localhost/employee Disconnected after 4018 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 1 ms +Transaction Ended after 0 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 2001 ms +Transaction Ended after 2000 ms Idle Timer Expired for Test_Transaction_02 Before Disconnect -inet://localhost/employee Disconnected after 2051 ms +inet://localhost/employee Disconnected after 2045 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 13 ms +inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 15 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 22 ms +inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 21 ms ------------------------------------------------------ @@ -1543,9 +1543,9 @@ ODS Minor Version = 0 ODS Major Version = 12 Page Size = 8192 Version = LI-V6.3.5.33220 Firebird 3.0 -Current Memory = 19233040 +Current Memory = 19233760 Forced Writes Enabled -Max Memory = 19370320 +Max Memory = 19371040 Number of Buffers = 2048 Sweep Interval = 20000 User Names: SYSDBA @@ -3168,11 +3168,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,653,504 +Current memory = 19,654,224 Delta memory = 13,072 -Max memory = 19,729,584 +Max memory = 19,730,048 Elapsed time= 0.023 sec -Cpu = 0.010 sec +Cpu = 0.020 sec Buffers = 2048 Reads = 2 Writes = 0 @@ -3414,6 +3414,82 @@ Terminated with Exception:exception 2 -Reassign the sales records before deleting this employee. -At procedure 'DELETE_EMPLOYEE' line: 19, col: 3 +Scollable Cursors +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: +EMP_NO = 145 +FIRST_NAME = Mark +LAST_NAME = Guckenheimer +PHONE_EXT = 221 +HIRE_DATE = 1994/05/02 00:00:00.0000 +DEPT_NO = 622 +JOB_CODE = Eng +JOB_GRADE = 5 +JOB_COUNTRY = USA +SALARY = 32,000.00 +FULL_NAME = Guckenheimer, Mark +Do Fetch Prior: +EMP_NO = 144 +FIRST_NAME = John +LAST_NAME = Montgomery +PHONE_EXT = 820 +HIRE_DATE = 1994/03/30 00:00:00.0000 +DEPT_NO = 672 +JOB_CODE = Eng +JOB_GRADE = 5 +JOB_COUNTRY = USA +SALARY = 35,000.00 +FULL_NAME = Montgomery, John +Do Fetch First: +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 Abs 8 : +EMP_NO = 14 +FIRST_NAME = Stewart +LAST_NAME = Hall +PHONE_EXT = 227 +HIRE_DATE = 1990/06/04 00:00:00.0000 +DEPT_NO = 900 +JOB_CODE = Finan +JOB_GRADE = 3 +JOB_COUNTRY = USA +SALARY = 69,482.63 +FULL_NAME = Hall, Stewart +Do Fetch Relative -2 : +EMP_NO = 11 +FIRST_NAME = K. J. +LAST_NAME = Weston +PHONE_EXT = 34 +HIRE_DATE = 1990/01/17 00:00:00.0000 +DEPT_NO = 130 +JOB_CODE = SRep +JOB_GRADE = 4 +JOB_COUNTRY = USA +SALARY = 86,292.94 +FULL_NAME = Weston, K. J. +Do Fetch beyond EOF : +Fetch returned false + ------------------------------------------------------ Running Test 08: TIBDataset: Locate, Bookmark and Lookup @@ -11913,20 +11989,20 @@ Message File Location = /opt/firebird3.0 Database Statistics for employee Database "/opt/firebird3.0.5/examples/empbuild/employee.fdb" -Gstat execution time Sun Oct 17 23:38:52 2021 +Gstat execution time Sat Oct 23 13:38:43 2021 Database header page information: Flags 0 -Generation 3558 +Generation 4226 System Change Number 0 Page size 8192 ODS version 12.0 -Oldest transaction 4013 -Oldest active 4014 -Oldest snapshot 4014 -Next transaction 4014 +Oldest transaction 4708 +Oldest active 4709 +Oldest snapshot 4709 +Next transaction 4709 Sequence number 0 -Next attachment ID 3761 +Next attachment ID 4314 Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc Shadow count 0 Page buffers 0 @@ -11999,7 +12075,7 @@ EMPLOYEE_PROJECT (134) Primary pointer page: 226, Index root page: 227 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 @@ -12051,7 +12127,7 @@ SALARY_HISTORY (136) Primary pointer page: 246, Index root page: 247 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 @@ -12073,7 +12149,7 @@ Fill distribution: 60 - 79% = 0 80 - 99% = 0 -Gstat completion time Sun Oct 17 23:38:52 2021 +Gstat completion time Sat Oct 23 13:38:43 2021 @@ -12083,87 +12159,87 @@ zeus Tue Jun 9 15:11:28 2020 bin/fbguard: guardian starting /opt/firebird3.0.5/bin/firebird Online Validation -23:38:53.49 Validation started +13:38:44.65 Validation started -23:38:53.49 Relation 128 (COUNTRY) -23:38:53.49 process pointer page 0 of 1 -23:38:53.49 Index 1 (RDB$PRIMARY1) -23:38:53.49 Relation 128 (COUNTRY) is ok - -23:38:53.49 Relation 129 (JOB) -23:38:53.49 process pointer page 0 of 1 -23:38:53.49 Index 1 (RDB$PRIMARY2) -23:38:53.49 Index 2 (RDB$FOREIGN3) -23:38:53.49 Index 3 (MAXSALX) -23:38:53.49 Index 4 (MINSALX) -23:38:53.49 Relation 129 (JOB) is ok - -23:38:53.49 Relation 130 (DEPARTMENT) -23:38:53.49 process pointer page 0 of 1 -23:38:53.49 Index 1 (RDB$4) -23:38:53.49 Index 2 (RDB$PRIMARY5) -23:38:53.49 Index 3 (RDB$FOREIGN6) -23:38:53.49 Index 4 (BUDGETX) -23:38:53.49 Index 5 (RDB$FOREIGN10) -23:38:53.49 Relation 130 (DEPARTMENT) is ok - -23:38:53.49 Relation 131 (EMPLOYEE) -23:38:53.50 process pointer page 0 of 1 -23:38:53.50 Index 1 (RDB$PRIMARY7) -23:38:53.50 Index 2 (RDB$FOREIGN8) -23:38:53.50 Index 3 (RDB$FOREIGN9) -23:38:53.50 Index 4 (NAMEX) -23:38:53.50 Relation 131 (EMPLOYEE) is ok - -23:38:53.50 Relation 133 (PROJECT) -23:38:53.50 process pointer page 0 of 1 -23:38:53.50 Index 1 (RDB$11) -23:38:53.50 Index 2 (RDB$PRIMARY12) -23:38:53.50 Index 3 (RDB$FOREIGN13) -23:38:53.50 Index 4 (PRODTYPEX) -23:38:53.50 Relation 133 (PROJECT) is ok - -23:38:53.50 Relation 134 (EMPLOYEE_PROJECT) -23:38:53.50 process pointer page 0 of 1 -23:38:53.50 Index 1 (RDB$PRIMARY14) -23:38:53.50 Index 2 (RDB$FOREIGN15) -23:38:53.50 Index 3 (RDB$FOREIGN16) -23:38:53.50 Relation 134 (EMPLOYEE_PROJECT) is ok - -23:38:53.50 Relation 135 (PROJ_DEPT_BUDGET) -23:38:53.50 process pointer page 0 of 1 -23:38:53.50 Index 1 (RDB$PRIMARY17) -23:38:53.50 Index 2 (RDB$FOREIGN18) -23:38:53.50 Index 3 (RDB$FOREIGN19) -23:38:53.50 Relation 135 (PROJ_DEPT_BUDGET) is ok - -23:38:53.50 Relation 136 (SALARY_HISTORY) -23:38:53.50 process pointer page 0 of 1 -23:38:53.50 Index 1 (RDB$PRIMARY20) -23:38:53.50 Index 2 (RDB$FOREIGN21) -23:38:53.50 Index 3 (CHANGEX) -23:38:53.50 Index 4 (UPDATERX) -23:38:53.50 Relation 136 (SALARY_HISTORY) is ok - -23:38:53.50 Relation 137 (CUSTOMER) -23:38:53.50 process pointer page 0 of 1 -23:38:53.50 Index 1 (RDB$PRIMARY22) -23:38:53.50 Index 2 (RDB$FOREIGN23) -23:38:53.50 Index 3 (CUSTNAMEX) -23:38:53.50 Index 4 (CUSTREGION) -23:38:53.50 Relation 137 (CUSTOMER) is ok - -23:38:53.50 Relation 138 (SALES) -23:38:53.50 process pointer page 0 of 1 -23:38:53.51 Index 1 (RDB$PRIMARY24) -23:38:53.51 Index 2 (RDB$FOREIGN25) -23:38:53.51 Index 3 (RDB$FOREIGN26) -23:38:53.51 Index 4 (NEEDX) -23:38:53.51 Index 5 (QTYX) -23:38:53.51 Index 6 (SALESTATX) -23:38:53.51 Relation 138 (SALES) is ok +13:38:44.65 Relation 128 (COUNTRY) +13:38:44.65 process pointer page 0 of 1 +13:38:44.65 Index 1 (RDB$PRIMARY1) +13:38:44.65 Relation 128 (COUNTRY) is ok + +13:38:44.65 Relation 129 (JOB) +13:38:44.65 process pointer page 0 of 1 +13:38:44.65 Index 1 (RDB$PRIMARY2) +13:38:44.65 Index 2 (RDB$FOREIGN3) +13:38:44.65 Index 3 (MAXSALX) +13:38:44.67 Index 4 (MINSALX) +13:38:44.68 Relation 129 (JOB) is ok + +13:38:44.68 Relation 130 (DEPARTMENT) +13:38:44.68 process pointer page 0 of 1 +13:38:44.68 Index 1 (RDB$4) +13:38:44.68 Index 2 (RDB$PRIMARY5) +13:38:44.68 Index 3 (RDB$FOREIGN6) +13:38:44.68 Index 4 (BUDGETX) +13:38:44.68 Index 5 (RDB$FOREIGN10) +13:38:44.68 Relation 130 (DEPARTMENT) is ok + +13:38:44.68 Relation 131 (EMPLOYEE) +13:38:44.68 process pointer page 0 of 1 +13:38:44.68 Index 1 (RDB$PRIMARY7) +13:38:44.68 Index 2 (RDB$FOREIGN8) +13:38:44.68 Index 3 (RDB$FOREIGN9) +13:38:44.68 Index 4 (NAMEX) +13:38:44.68 Relation 131 (EMPLOYEE) is ok + +13:38:44.68 Relation 133 (PROJECT) +13:38:44.68 process pointer page 0 of 1 +13:38:44.68 Index 1 (RDB$11) +13:38:44.68 Index 2 (RDB$PRIMARY12) +13:38:44.68 Index 3 (RDB$FOREIGN13) +13:38:44.68 Index 4 (PRODTYPEX) +13:38:44.69 Relation 133 (PROJECT) is ok + +13:38:44.69 Relation 134 (EMPLOYEE_PROJECT) +13:38:44.69 process pointer page 0 of 1 +13:38:44.69 Index 1 (RDB$PRIMARY14) +13:38:44.69 Index 2 (RDB$FOREIGN15) +13:38:44.69 Index 3 (RDB$FOREIGN16) +13:38:44.69 Relation 134 (EMPLOYEE_PROJECT) is ok + +13:38:44.69 Relation 135 (PROJ_DEPT_BUDGET) +13:38:44.69 process pointer page 0 of 1 +13:38:44.70 Index 1 (RDB$PRIMARY17) +13:38:44.70 Index 2 (RDB$FOREIGN18) +13:38:44.70 Index 3 (RDB$FOREIGN19) +13:38:44.70 Relation 135 (PROJ_DEPT_BUDGET) is ok + +13:38:44.70 Relation 136 (SALARY_HISTORY) +13:38:44.70 process pointer page 0 of 1 +13:38:44.70 Index 1 (RDB$PRIMARY20) +13:38:44.70 Index 2 (RDB$FOREIGN21) +13:38:44.70 Index 3 (CHANGEX) +13:38:44.70 Index 4 (UPDATERX) +13:38:44.70 Relation 136 (SALARY_HISTORY) is ok + +13:38:44.70 Relation 137 (CUSTOMER) +13:38:44.70 process pointer page 0 of 1 +13:38:44.70 Index 1 (RDB$PRIMARY22) +13:38:44.70 Index 2 (RDB$FOREIGN23) +13:38:44.70 Index 3 (CUSTNAMEX) +13:38:44.70 Index 4 (CUSTREGION) +13:38:44.70 Relation 137 (CUSTOMER) is ok + +13:38:44.70 Relation 138 (SALES) +13:38:44.70 process pointer page 0 of 1 +13:38:44.70 Index 1 (RDB$PRIMARY24) +13:38:44.70 Index 2 (RDB$FOREIGN25) +13:38:44.70 Index 3 (RDB$FOREIGN26) +13:38:44.70 Index 4 (NEEDX) +13:38:44.70 Index 5 (QTYX) +13:38:44.70 Index 6 (SALESTATX) +13:38:44.70 Relation 138 (SALES) is ok -23:38:53.51 Validation finished +13:38:44.70 Validation finished Normal Validation @@ -13448,9 +13524,9 @@ DEPT_KEY_PATH = 000 (Charset = UTF8 Code Rows printed = 2 -Current memory = 19,651,616 +Current memory = 19,652,336 Delta memory = 12,688 -Max memory = 19,780,240 +Max memory = 19,780,960 Elapsed time= 0.002 sec Cpu = 0.000 sec Buffers = 2048 @@ -13716,11 +13792,11 @@ DEPT_KEY_PATH = 000 (Charset = UTF8 Code Rows printed = 2 -Current memory = 19,651,616 +Current memory = 19,652,336 Delta memory = 12,688 -Max memory = 19,780,240 -Elapsed time= 0.103 sec -Cpu = 0.000 sec +Max memory = 19,780,960 +Elapsed time= 0.104 sec +Cpu = 0.010 sec Buffers = 2048 Reads = 2 Writes = 0 @@ -15337,14 +15413,14 @@ Create Table LotsOfData ( MyText VarChar(1024), Primary Key (RowID) ); -Loading data into database table. Started at 17/10/2021 23:39:39.221 -Data load completed at 17/10/2021 23:41:18.349 Elapsed Time = 99128 ms, 100000 records loaded - Message Hash = 0469fd0e0213f65f1bb40a36cc30b97b -Database Read started at 17/10/2021 23:41:18.359 -Read Dataset completed at 17/10/2021 23:41:48.428 Elapsed Time = 30069 ms, 100000 records read - Message Hash = 0469fd0e0213f65f1bb40a36cc30b97b +Loading data into database table. Started at 23/10/2021 13:39:35.904 +Data load completed at 23/10/2021 13:41:21.474 Elapsed Time = 105570 ms, 100000 records loaded + Message Hash = 74ca9d8999ced80d351dfb9f693ac23e +Database Read started at 23/10/2021 13:41:21.484 +Read Dataset completed at 23/10/2021 13:41:51.025 Elapsed Time = 29541 ms, 100000 records read + Message Hash = 74ca9d8999ced80d351dfb9f693ac23e Test Completed successfully -17/10/2021 23:41:48.428 Test 21 passes as long as the checksums are identical +23/10/2021 13:41:51.026 Test 21 passes as long as the checksums are identical ------------------------------------------------------ @@ -15566,7 +15642,7 @@ JOIN Depts D On D.DEPT_NO = A.DEPT_NO CTE0 recursive: Depts as (Select DEPT_NO, DEPARTMENT, "HEAD_DEPT", cast(DEPARTMENT as VarChar(256)) as DEPT_PATH ,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL -UNION ALL +UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO ) Select: distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, 2.2, 2..30 A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH @@ -15580,7 +15656,7 @@ Plan: Rows: SQL: WITH RECURSIVE Depts AS (Select DEPT_NO, DEPARTMENT, "HEAD_DEPT", cast(DEPARTMENT as VarChar(256)) as DEPT_PATH ,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL -UNION ALL +UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO ) @@ -15594,7 +15670,7 @@ Params: Updated SQL WITH RECURSIVE Depts AS (Select DEPT_NO, DEPARTMENT, "HEAD_DEPT", cast(DEPARTMENT as VarChar(256)) as DEPT_PATH ,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL -UNION ALL +UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )