ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/journaling/testsuite/FB3reference.log
(Generate patch)

Comparing ibx/trunk/testsuite/FB3reference.log (file contents):
Revision 315 by tony, Thu Feb 25 11:56:36 2021 UTC vs.
Revision 319 by tony, Thu Feb 25 12:05:40 2021 UTC

# Line 644 | Line 644 | Rows printed = 42
644   Current memory = 19,651,152
645   Delta memory = 13,040
646   Max memory = 19,779,424
647 < Elapsed time= 0.023 sec
648 < Cpu = 0.010 sec
647 > Elapsed time= 0.026 sec
648 > Cpu = 0.020 sec
649   Buffers = 2048
650   Reads = 2
651   Writes = 0
# Line 1445 | Line 1445 | DPB: Item Count = 3
1445    isc_dpb_lc_ctype = UTF8
1446  
1447   Before Disconnect
1448 < inet://localhost/employee Disconnected after 23 ms
1448 > inet://localhost/employee Disconnected after 24 ms
1449   Before Connect
1450   Connected to inet://localhost/employee
1451   DPB: Item Count = 3
# Line 1454 | Line 1454 | DPB: Item Count = 3
1454    isc_dpb_lc_ctype = UTF8
1455  
1456   Before Disconnect
1457 < inet://localhost/employee Disconnected after 3990 ms
1457 > inet://localhost/employee Disconnected after 4005 ms
1458   Idle Timer Expired for Test_Database_02
1459   Database Closed
1460   Transaction Events
# Line 1494 | Line 1494 | Transaction Ending
1494   Transaction Ended after 2000 ms
1495   Idle Timer Expired for Test_Transaction_02
1496   Before Disconnect
1497 < inet://localhost/employee Disconnected after 2037 ms
1497 > inet://localhost/employee Disconnected after 2036 ms
1498   SQL Dialect Downgrade test
1499   Before Connect
1500   Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
# Line 1506 | Line 1506 | DPB: Item Count = 4
1506  
1507   inet://localhost//tmp/ibx-testsuite/testsuite1.fdb created
1508   Before Disconnect
1509 < inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms
1509 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 24 ms
1510   Before Connect
1511   Warning: SQL Dialect Downgrade of inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
1512   Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
# Line 1516 | Line 1516 | DPB: Item Count = 3
1516    isc_dpb_lc_ctype = UTF8
1517  
1518   Before Disconnect
1519 < inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 21 ms
1519 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 26 ms
1520  
1521  
1522   ------------------------------------------------------
# Line 11659 | Line 11659 | Message File Location = /opt/firebird3.0
11659   Database Statistics for employee
11660  
11661   Database "/opt/firebird3.0.5/examples/empbuild/employee.fdb"
11662 < Gstat execution time Wed Feb 17 10:39:32 2021
11662 > Gstat execution time Thu Feb 18 17:01:35 2021
11663  
11664   Database header page information:
11665   Flags                   0
11666 < Generation              1865
11666 > Generation              1989
11667   System Change Number    0
11668   Page size               8192
11669   ODS version             12.0
11670 < Oldest transaction      2037
11671 < Oldest active           2038
11672 < Oldest snapshot         2038
11673 < Next transaction        2038
11670 > Oldest transaction      2191
11671 > Oldest active           2192
11672 > Oldest snapshot         2192
11673 > Next transaction        2192
11674   Sequence number         0
11675 < Next attachment ID      1752
11675 > Next attachment ID      1924
11676   Implementation          HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
11677   Shadow count            0
11678   Page buffers            0
# Line 11819 | Line 11819 | Fill distribution:
11819   60 - 79% = 0
11820   80 - 99% = 0
11821  
11822 < Gstat completion time Wed Feb 17 10:39:32 2021
11822 > Gstat completion time Thu Feb 18 17:01:35 2021
11823  
11824  
11825  
# Line 11829 | Line 11829 | zeus   Tue Jun  9 15:11:28 2020
11829   bin/fbguard: guardian starting /opt/firebird3.0.5/bin/firebird
11830  
11831   Online Validation
11832 < 10:39:32.49 Validation started
11832 > 17:01:36.08 Validation started
11833  
11834 < 10:39:32.49 Relation 128 (COUNTRY)
11835 < 10:39:32.49   process pointer page    0 of    1
11836 < 10:39:32.49 Index 1 (RDB$PRIMARY1)
11837 < 10:39:32.49 Relation 128 (COUNTRY) is ok
11838 <
11839 < 10:39:32.49 Relation 129 (JOB)
11840 < 10:39:32.49   process pointer page    0 of    1
11841 < 10:39:32.49 Index 1 (RDB$PRIMARY2)
11842 < 10:39:32.49 Index 2 (RDB$FOREIGN3)
11843 < 10:39:32.49 Index 3 (MAXSALX)
11844 < 10:39:32.49 Index 4 (MINSALX)
11845 < 10:39:32.49 Relation 129 (JOB) is ok
11846 <
11847 < 10:39:32.49 Relation 130 (DEPARTMENT)
11848 < 10:39:32.49   process pointer page    0 of    1
11849 < 10:39:32.49 Index 1 (RDB$4)
11850 < 10:39:32.49 Index 2 (RDB$PRIMARY5)
11851 < 10:39:32.49 Index 3 (RDB$FOREIGN6)
11852 < 10:39:32.49 Index 4 (BUDGETX)
11853 < 10:39:32.49 Index 5 (RDB$FOREIGN10)
11854 < 10:39:32.49 Relation 130 (DEPARTMENT) is ok
11855 <
11856 < 10:39:32.49 Relation 131 (EMPLOYEE)
11857 < 10:39:32.49   process pointer page    0 of    1
11858 < 10:39:32.49 Index 1 (RDB$PRIMARY7)
11859 < 10:39:32.49 Index 2 (RDB$FOREIGN8)
11860 < 10:39:32.49 Index 3 (RDB$FOREIGN9)
11861 < 10:39:32.49 Index 4 (NAMEX)
11862 < 10:39:32.49 Relation 131 (EMPLOYEE) is ok
11863 <
11864 < 10:39:32.49 Relation 133 (PROJECT)
11865 < 10:39:32.49   process pointer page    0 of    1
11866 < 10:39:32.49 Index 1 (RDB$11)
11867 < 10:39:32.49 Index 2 (RDB$PRIMARY12)
11868 < 10:39:32.49 Index 3 (RDB$FOREIGN13)
11869 < 10:39:32.49 Index 4 (PRODTYPEX)
11870 < 10:39:32.49 Relation 133 (PROJECT) is ok
11871 <
11872 < 10:39:32.49 Relation 134 (EMPLOYEE_PROJECT)
11873 < 10:39:32.49   process pointer page    0 of    1
11874 < 10:39:32.49 Index 1 (RDB$PRIMARY14)
11875 < 10:39:32.49 Index 2 (RDB$FOREIGN15)
11876 < 10:39:32.50 Index 3 (RDB$FOREIGN16)
11877 < 10:39:32.50 Relation 134 (EMPLOYEE_PROJECT) is ok
11878 <
11879 < 10:39:32.50 Relation 135 (PROJ_DEPT_BUDGET)
11880 < 10:39:32.50   process pointer page    0 of    1
11881 < 10:39:32.50 Index 1 (RDB$PRIMARY17)
11882 < 10:39:32.50 Index 2 (RDB$FOREIGN18)
11883 < 10:39:32.50 Index 3 (RDB$FOREIGN19)
11884 < 10:39:32.50 Relation 135 (PROJ_DEPT_BUDGET) is ok
11885 <
11886 < 10:39:32.50 Relation 136 (SALARY_HISTORY)
11887 < 10:39:32.50   process pointer page    0 of    1
11888 < 10:39:32.50 Index 1 (RDB$PRIMARY20)
11889 < 10:39:32.50 Index 2 (RDB$FOREIGN21)
11890 < 10:39:32.50 Index 3 (CHANGEX)
11891 < 10:39:32.50 Index 4 (UPDATERX)
11892 < 10:39:32.50 Relation 136 (SALARY_HISTORY) is ok
11893 <
11894 < 10:39:32.50 Relation 137 (CUSTOMER)
11895 < 10:39:32.50   process pointer page    0 of    1
11896 < 10:39:32.50 Index 1 (RDB$PRIMARY22)
11897 < 10:39:32.50 Index 2 (RDB$FOREIGN23)
11898 < 10:39:32.50 Index 3 (CUSTNAMEX)
11899 < 10:39:32.50 Index 4 (CUSTREGION)
11900 < 10:39:32.50 Relation 137 (CUSTOMER) is ok
11901 <
11902 < 10:39:32.50 Relation 138 (SALES)
11903 < 10:39:32.50   process pointer page    0 of    1
11904 < 10:39:32.50 Index 1 (RDB$PRIMARY24)
11905 < 10:39:32.50 Index 2 (RDB$FOREIGN25)
11906 < 10:39:32.51 Index 3 (RDB$FOREIGN26)
11907 < 10:39:32.51 Index 4 (NEEDX)
11908 < 10:39:32.51 Index 5 (QTYX)
11909 < 10:39:32.51 Index 6 (SALESTATX)
11910 < 10:39:32.51 Relation 138 (SALES) is ok
11834 > 17:01:36.08 Relation 128 (COUNTRY)
11835 > 17:01:36.08   process pointer page    0 of    1
11836 > 17:01:36.08 Index 1 (RDB$PRIMARY1)
11837 > 17:01:36.08 Relation 128 (COUNTRY) is ok
11838 >
11839 > 17:01:36.08 Relation 129 (JOB)
11840 > 17:01:36.08   process pointer page    0 of    1
11841 > 17:01:36.08 Index 1 (RDB$PRIMARY2)
11842 > 17:01:36.08 Index 2 (RDB$FOREIGN3)
11843 > 17:01:36.08 Index 3 (MAXSALX)
11844 > 17:01:36.08 Index 4 (MINSALX)
11845 > 17:01:36.08 Relation 129 (JOB) is ok
11846 >
11847 > 17:01:36.08 Relation 130 (DEPARTMENT)
11848 > 17:01:36.08   process pointer page    0 of    1
11849 > 17:01:36.08 Index 1 (RDB$4)
11850 > 17:01:36.08 Index 2 (RDB$PRIMARY5)
11851 > 17:01:36.08 Index 3 (RDB$FOREIGN6)
11852 > 17:01:36.08 Index 4 (BUDGETX)
11853 > 17:01:36.08 Index 5 (RDB$FOREIGN10)
11854 > 17:01:36.08 Relation 130 (DEPARTMENT) is ok
11855 >
11856 > 17:01:36.08 Relation 131 (EMPLOYEE)
11857 > 17:01:36.08   process pointer page    0 of    1
11858 > 17:01:36.08 Index 1 (RDB$PRIMARY7)
11859 > 17:01:36.08 Index 2 (RDB$FOREIGN8)
11860 > 17:01:36.08 Index 3 (RDB$FOREIGN9)
11861 > 17:01:36.08 Index 4 (NAMEX)
11862 > 17:01:36.08 Relation 131 (EMPLOYEE) is ok
11863 >
11864 > 17:01:36.08 Relation 133 (PROJECT)
11865 > 17:01:36.08   process pointer page    0 of    1
11866 > 17:01:36.08 Index 1 (RDB$11)
11867 > 17:01:36.08 Index 2 (RDB$PRIMARY12)
11868 > 17:01:36.08 Index 3 (RDB$FOREIGN13)
11869 > 17:01:36.08 Index 4 (PRODTYPEX)
11870 > 17:01:36.08 Relation 133 (PROJECT) is ok
11871 >
11872 > 17:01:36.08 Relation 134 (EMPLOYEE_PROJECT)
11873 > 17:01:36.08   process pointer page    0 of    1
11874 > 17:01:36.08 Index 1 (RDB$PRIMARY14)
11875 > 17:01:36.09 Index 2 (RDB$FOREIGN15)
11876 > 17:01:36.09 Index 3 (RDB$FOREIGN16)
11877 > 17:01:36.09 Relation 134 (EMPLOYEE_PROJECT) is ok
11878 >
11879 > 17:01:36.09 Relation 135 (PROJ_DEPT_BUDGET)
11880 > 17:01:36.09   process pointer page    0 of    1
11881 > 17:01:36.09 Index 1 (RDB$PRIMARY17)
11882 > 17:01:36.09 Index 2 (RDB$FOREIGN18)
11883 > 17:01:36.09 Index 3 (RDB$FOREIGN19)
11884 > 17:01:36.09 Relation 135 (PROJ_DEPT_BUDGET) is ok
11885 >
11886 > 17:01:36.09 Relation 136 (SALARY_HISTORY)
11887 > 17:01:36.09   process pointer page    0 of    1
11888 > 17:01:36.09 Index 1 (RDB$PRIMARY20)
11889 > 17:01:36.09 Index 2 (RDB$FOREIGN21)
11890 > 17:01:36.09 Index 3 (CHANGEX)
11891 > 17:01:36.09 Index 4 (UPDATERX)
11892 > 17:01:36.09 Relation 136 (SALARY_HISTORY) is ok
11893 >
11894 > 17:01:36.09 Relation 137 (CUSTOMER)
11895 > 17:01:36.09   process pointer page    0 of    1
11896 > 17:01:36.09 Index 1 (RDB$PRIMARY22)
11897 > 17:01:36.09 Index 2 (RDB$FOREIGN23)
11898 > 17:01:36.09 Index 3 (CUSTNAMEX)
11899 > 17:01:36.09 Index 4 (CUSTREGION)
11900 > 17:01:36.09 Relation 137 (CUSTOMER) is ok
11901 >
11902 > 17:01:36.10 Relation 138 (SALES)
11903 > 17:01:36.10   process pointer page    0 of    1
11904 > 17:01:36.10 Index 1 (RDB$PRIMARY24)
11905 > 17:01:36.10 Index 2 (RDB$FOREIGN25)
11906 > 17:01:36.10 Index 3 (RDB$FOREIGN26)
11907 > 17:01:36.10 Index 4 (NEEDX)
11908 > 17:01:36.10 Index 5 (QTYX)
11909 > 17:01:36.10 Index 6 (SALESTATX)
11910 > 17:01:36.10 Relation 138 (SALES) is ok
11911  
11912 < 10:39:32.51 Validation finished
11912 > 17:01:36.10 Validation finished
11913  
11914  
11915   Normal Validation
# Line 13241 | Line 13241 | DEPT_KEY_PATH = 000 (Charset = UTF8 Code
13241  
13242   Rows printed = 2
13243  
13244 < *Monitor* 17/2/2021 10:39:34.784
13245 < [Application: IBX Test Suite]
13244 > 33 ISQL Monitor Messages Received
13245 > 33 ISQL Monitor Messages written
13246 > *Monitor*  
13247 > [Application: IBX Test Suite]
13248   Test_Database_13: [Connect]
13249 < *Monitor* 17/2/2021 10:39:34.784
13250 < [Application: IBX Test Suite]
13249 > *Monitor*  
13250 > [Application: IBX Test Suite]
13251   Test_Transaction_13: [Start transaction]
13252 < *Monitor* 17/2/2021 10:39:34.794
13253 < [Application: IBX Test Suite]
13252 > *Monitor*  
13253 > [Application: IBX Test Suite]
13254   : [Prepare] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13255 <
13255 >
13256    Plan:
13257   Select Expression
13258      -> First N Records
# Line 13259 | Line 13261 | Select Expression
13261                  -> Filter
13262                      -> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID
13263                          -> Bitmap
13264 <  
13263 < *Monitor* 17/2/2021 10:39:34.794                          -> Index "RDB$FOREIGN6" Range Scan (full match)
13264 >                            -> Index "RDB$FOREIGN6" Range Scan (full match)
13265                  -> Filter
13266                      -> Table "DEPARTMENT" as "DEPTS D" Access By ID
13267                          -> Bitmap
# Line 13269 | Line 13270 | Select Expression
13270                  -> Table "EMPLOYEE" as "A" Access By ID
13271                      -> Bitmap
13272                          -> Index "RDB$FOREIGN8" Range Scan (full match)
13273 < *Monitor* 17/2/2021 10:39:34.803
13274 < [Application: IBX Test Suite]
13273 > *Monitor*  
13274 > [Application: IBX Test Suite]
13275   : [Start transaction]
13276 < *Monitor* 17/2/2021 10:39:34.810
13277 < [Application: IBX Test Suite]
13276 > *Monitor*  
13277 > [Application: IBX Test Suite]
13278   : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13279 <
13279 >
13280    Plan:
13281   Select Expression
13282      -> Nested Loop Join (inner)
# Line 13287 | Line 13288 | Select Expression
13288              -> Table "RDB$FIELDS" as "F" Access By ID
13289                  -> Bitmap
13290                      -> Index "RDB$INDEX_2" Unique Scan
13291 < *Monitor* 17/2/2021 10:39:34.810
13292 < [Application: IBX Test Suite]
13291 > *Monitor*  
13292 > [Application: IBX Test Suite]
13293   : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13294 <
13294 >
13295    RELATION = EMPLOYEE
13296 < *Monitor* 17/2/2021 10:39:34.811
13297 < [Application: IBX Test Suite]
13296 > *Monitor*  
13297 > [Application: IBX Test Suite]
13298   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13299  
13300 < *Monitor* 17/2/2021 10:39:34.811
13301 < [Application: IBX Test Suite]
13300 > *Monitor*  
13301 > [Application: IBX Test Suite]
13302   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13303  
13304 < *Monitor* 17/2/2021 10:39:34.811
13305 < [Application: IBX Test Suite]
13304 > *Monitor*  
13305 > [Application: IBX Test Suite]
13306   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13307 <
13307 >
13308    SEOFReached
13309 < *Monitor* 17/2/2021 10:39:34.813
13310 < [Application: IBX Test Suite]
13309 > *Monitor*  
13310 > [Application: IBX Test Suite]
13311   : [Commit (Hard commit)]
13312 < *Monitor* 17/2/2021 10:39:34.820
13313 < [Application: IBX Test Suite]
13312 > *Monitor*  
13313 > [Application: IBX Test Suite]
13314   : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13315  
13316 < *Monitor* 17/2/2021 10:39:34.821
13317 < [Application: IBX Test Suite]
13316 > *Monitor*  
13317 > [Application: IBX Test Suite]
13318   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13319  
13320 < *Monitor* 17/2/2021 10:39:34.822
13321 < [Application: IBX Test Suite]
13320 > *Monitor*  
13321 > [Application: IBX Test Suite]
13322   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13323  
13324 < *Monitor* 17/2/2021 10:39:34.822
13325 < [Application: IBX Test Suite]
13324 > *Monitor*  
13325 > [Application: IBX Test Suite]
13326   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13327 <
13327 >
13328    SEOFReached
13329 < *Monitor* 17/2/2021 10:39:34.823
13330 < [Application: IBX Test Suite]
13329 > *Monitor*  
13330 > [Application: IBX Test Suite]
13331   Test_Transaction_13: [Commit (Hard commit)]
13332 < *Monitor* 17/2/2021 10:39:34.836
13333 < [Application: IBX Test Suite]
13332 > *Monitor*  
13333 > [Application: IBX Test Suite]
13334   Test_Database_13: [Disconnect]
13335 < *Monitor* 17/2/2021 10:39:34.888
13336 < [Application: IBX Test Suite]
13335 > *Monitor*  
13336 > [Application: IBX Test Suite]
13337   Test_Database_13: [Connect]
13338 < *Monitor* 17/2/2021 10:39:34.889
13339 < [Application: IBX Test Suite]
13338 > *Monitor*  
13339 > [Application: IBX Test Suite]
13340   Test_Transaction_13: [Start transaction]
13341 < *Monitor* 17/2/2021 10:39:34.899
13342 < [Application: IBX Test Suite]
13341 > *Monitor*  
13342 > [Application: IBX Test Suite]
13343   : [Prepare] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13344 <
13344 >
13345    Plan:
13346   Select Expression
13347      -> First N Records
# Line 13349 | Line 13350 | Select Expression
13350                  -> Filter
13351                      -> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID
13352                          -> Bitmap
13353 <  
13353 < *Monitor* 17/2/2021 10:39:34.899                          -> Index "RDB$FOREIGN6" Range Scan (full match)
13353 >                            -> Index "RDB$FOREIGN6" Range Scan (full match)
13354                  -> Filter
13355                      -> Table "DEPARTMENT" as "DEPTS D" Access By ID
13356                          -> Bitmap
# Line 13359 | Line 13359 | Select Expression
13359                  -> Table "EMPLOYEE" as "A" Access By ID
13360                      -> Bitmap
13361                          -> Index "RDB$FOREIGN8" Range Scan (full match)
13362 < *Monitor* 17/2/2021 10:39:34.908
13363 < [Application: IBX Test Suite]
13362 > *Monitor*  
13363 > [Application: IBX Test Suite]
13364   : [Start transaction]
13365 < *Monitor* 17/2/2021 10:39:34.913
13366 < [Application: IBX Test Suite]
13365 > *Monitor*  
13366 > [Application: IBX Test Suite]
13367   : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13368 <
13368 >
13369    Plan:
13370   Select Expression
13371      -> Nested Loop Join (inner)
# Line 13377 | Line 13377 | Select Expression
13377              -> Table "RDB$FIELDS" as "F" Access By ID
13378                  -> Bitmap
13379                      -> Index "RDB$INDEX_2" Unique Scan
13380 < *Monitor* 17/2/2021 10:39:34.913
13381 < [Application: IBX Test Suite]
13380 > *Monitor*  
13381 > [Application: IBX Test Suite]
13382   : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13383 <
13383 >
13384    RELATION = EMPLOYEE
13385 < *Monitor* 17/2/2021 10:39:34.914
13386 < [Application: IBX Test Suite]
13385 > *Monitor*  
13386 > [Application: IBX Test Suite]
13387   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13388  
13389 < *Monitor* 17/2/2021 10:39:34.914
13390 < [Application: IBX Test Suite]
13389 > *Monitor*  
13390 > [Application: IBX Test Suite]
13391   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13392  
13393 < *Monitor* 17/2/2021 10:39:34.914
13394 < [Application: IBX Test Suite]
13393 > *Monitor*  
13394 > [Application: IBX Test Suite]
13395   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13396 <
13396 >
13397    SEOFReached
13398 < *Monitor* 17/2/2021 10:39:34.920
13399 < [Application: IBX Test Suite]
13398 > *Monitor*  
13399 > [Application: IBX Test Suite]
13400   : [Commit (Hard commit)]
13401 < *Monitor* 17/2/2021 10:39:34.922
13402 < [Application: IBX Test Suite]
13401 > *Monitor*  
13402 > [Application: IBX Test Suite]
13403   : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13404  
13405 < *Monitor* 17/2/2021 10:39:34.924
13406 < [Application: IBX Test Suite]
13405 > *Monitor*  
13406 > [Application: IBX Test Suite]
13407   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13408  
13409 < *Monitor* 17/2/2021 10:39:34.924
13410 < [Application: IBX Test Suite]
13409 > *Monitor*  
13410 > [Application: IBX Test Suite]
13411   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13412  
13413 < *Monitor* 17/2/2021 10:39:34.925
13414 < [Application: IBX Test Suite]
13413 > *Monitor*  
13414 > [Application: IBX Test Suite]
13415   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13416 <
13416 >
13417    SEOFReached
13418 < *Monitor* 17/2/2021 10:39:34.926
13419 < [Application: IBX Test Suite]
13418 > *Monitor*  
13419 > [Application: IBX Test Suite]
13420   Test_Transaction_13: [Commit (Hard commit)]
13421 < *Monitor* 17/2/2021 10:39:34.936
13422 < [Application: IBX Test Suite]
13421 > *Monitor*  
13422 > [Application: IBX Test Suite]
13423   Test_Database_13: [Disconnect]
13424 + 33 ISQL Monitor Messages Received
13425  
13426  
13427   ------------------------------------------------------
# Line 13461 | Line 13462 | Rows printed = 2
13462   Current memory = 19,651,616
13463   Delta memory = 12,688
13464   Max memory = 19,780,240
13465 < Elapsed time= 0.002 sec
13465 > Elapsed time= 0.102 sec
13466   Cpu = 0.000 sec
13467   Buffers = 2048
13468   Reads = 2
# Line 13505 | Line 13506 | DEPT_KEY_PATH = 000 (Charset = UTF8 Code
13506  
13507   Rows printed = 2
13508  
13509 < *Monitor* 17/2/2021 10:31:31
13510 < [Application: IBX Test Suite]
13510 < : [Start transaction]
13511 < *Monitor* 17/2/2021 10:31:31
13512 < [Application: IBX Test Suite]
13513 < : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13514 <
13515 <  Plan:
13516 < PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
13517 < *Monitor* 17/2/2021 10:31:31
13518 < [Application: IBX Test Suite]
13519 < : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13520 <
13521 <  RELATION = EMPLOYEE
13522 < *Monitor* 17/2/2021 10:31:31
13523 < [Application: IBX Test Suite]
13524 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13525 <
13526 < *Monitor* 17/2/2021 10:31:31
13527 < [Application: IBX Test Suite]
13528 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13529 <
13530 < *Monitor* 17/2/2021 10:31:31
13531 < [Application: IBX Test Suite]
13532 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13533 <
13534 <  SEOFReached
13535 < *Monitor* 17/2/2021 10:31:31
13536 < [Application: IBX Test Suite]
13537 < : [Commit (Hard commit)]
13538 < *Monitor* 17/2/2021 10:31:31
13539 < [Application: IBX Test Suite]
13540 < : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13541 <
13542 < *Monitor* 17/2/2021 10:31:31
13543 < [Application: IBX Test Suite]
13544 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13545 <
13546 < *Monitor* 17/2/2021 10:31:31
13547 < [Application: IBX Test Suite]
13548 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13549 <
13550 < *Monitor* 17/2/2021 10:31:31
13551 < [Application: IBX Test Suite]
13552 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13553 <
13554 <  SEOFReached
13555 < *Monitor* 17/2/2021 10:31:31
13556 < [Application: IBX Test Suite]
13557 < Test_Transaction_14: [Commit (Hard commit)]
13558 < *Monitor* 17/2/2021 10:31:31
13559 < [Application: IBX Test Suite]
13560 < Test_Database_14: [Disconnect]
13561 < *Monitor* 17/2/2021 10:31:31
13509 > 33 ISQL Monitor Messages written
13510 > *Monitor*  
13511   [Application: IBX Test Suite]
13512   Test_Database_14: [Connect]
13513 < *Monitor* 17/2/2021 10:31:31
13513 > *Monitor*  
13514   [Application: IBX Test Suite]
13515   Test_Transaction_14: [Start transaction]
13516 < *Monitor* 17/2/2021 10:31:31
13568 < [Application: IBX Test Suite]
13569 < : [Prepare] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13570 <
13571 <  Plan:
13572 < PLAN JOIN ((DEPTS DEPARTMENT INDEX (RDB$FOREIGN6))
13573 < PLAN (DEPTS D INDEX (RDB$FOREIGN6)), A INDEX (RDB$FOREIGN8))
13574 < *Monitor* 17/2/2021 10:31:31
13575 < [Application: IBX Test Suite]
13576 < : [Start transaction]
13577 < *Monitor* 17/2/2021 10:31:31
13578 < [Application: IBX Test Suite]
13579 < : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13580 <
13581 <  Plan:
13582 < PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
13583 < *Monitor* 17/2/2021 10:31:31
13584 < [Application: IBX Test Suite]
13585 < : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13586 <
13587 <  RELATION = EMPLOYEE
13588 < *Monitor* 17/2/2021 10:31:31
13589 < [Application: IBX Test Suite]
13590 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13591 <
13592 < *Monitor* 17/2/2021 10:31:31
13593 < [Application: IBX Test Suite]
13594 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13595 <
13596 < *Monitor* 17/2/2021 10:31:31
13597 < [Application: IBX Test Suite]
13598 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13599 <
13600 <  SEOFReached
13601 < *Monitor* 17/2/2021 10:31:31
13602 < [Application: IBX Test Suite]
13603 < : [Commit (Hard commit)]
13604 < *Monitor* 17/2/2021 10:31:31
13605 < [Application: IBX Test Suite]
13606 < : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13607 <
13608 < *Monitor* 17/2/2021 10:31:31
13609 < [Application: IBX Test Suite]
13610 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13611 <
13612 < *Monitor* 17/2/2021 10:31:31
13613 < [Application: IBX Test Suite]
13614 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13615 <
13616 < *Monitor* 17/2/2021 10:31:31
13617 < [Application: IBX Test Suite]
13618 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13619 <
13620 <  SEOFReached
13621 < *Monitor* 17/2/2021 10:31:31
13622 < [Application: IBX Test Suite]
13623 < Test_Transaction_14: [Commit (Hard commit)]
13624 < *Monitor* 17/2/2021 10:31:31
13625 < [Application: IBX Test Suite]
13626 < Test_Database_14: [Disconnect]
13627 < *Monitor* 17/2/2021 10:31:31
13628 < [Application: IBX Test Suite]
13629 < : [Start transaction]
13630 < *Monitor* 17/2/2021 10:31:31
13631 < [Application: IBX Test Suite]
13632 < : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13633 <
13634 <  Plan:
13635 < PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
13636 < *Monitor* 17/2/2021 10:31:31
13637 < [Application: IBX Test Suite]
13638 < : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13639 <
13640 <  RELATION = EMPLOYEE
13641 < *Monitor* 17/2/2021 10:31:31
13642 < [Application: IBX Test Suite]
13643 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13644 <
13645 < *Monitor* 17/2/2021 10:31:31
13646 < [Application: IBX Test Suite]
13647 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13648 <
13649 < *Monitor* 17/2/2021 10:31:31
13650 < [Application: IBX Test Suite]
13651 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13652 <
13653 <  SEOFReached
13654 < *Monitor* 17/2/2021 10:31:31
13655 < [Application: IBX Test Suite]
13656 < : [Commit (Hard commit)]
13657 < *Monitor* 17/2/2021 10:31:31
13658 < [Application: IBX Test Suite]
13659 < : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13660 <
13661 < *Monitor* 17/2/2021 10:31:31
13662 < [Application: IBX Test Suite]
13663 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13664 <
13665 < *Monitor* 17/2/2021 10:31:31
13666 < [Application: IBX Test Suite]
13667 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13668 <
13669 < *Monitor* 17/2/2021 10:31:31
13670 < [Application: IBX Test Suite]
13671 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13672 <
13673 <  SEOFReached
13674 < *Monitor* 17/2/2021 10:31:31
13675 < [Application: IBX Test Suite]
13676 < Test_Transaction_14: [Commit (Hard commit)]
13677 < *Monitor* 17/2/2021 10:31:31
13678 < [Application: IBX Test Suite]
13679 < Test_Database_14: [Disconnect]
13680 < *Monitor* 17/2/2021 10:31:31
13681 < [Application: IBX Test Suite]
13682 < Test_Database_14: [Connect]
13683 < *Monitor* 17/2/2021 10:31:31
13684 < [Application: IBX Test Suite]
13685 < Test_Transaction_14: [Start transaction]
13686 < *Monitor* 17/2/2021 10:31:31
13687 < [Application: IBX Test Suite]
13688 < : [Prepare] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13689 <
13690 <  Plan:
13691 < PLAN JOIN ((DEPTS DEPARTMENT INDEX (RDB$FOREIGN6))
13692 < PLAN (DEPTS D INDEX (RDB$FOREIGN6)), A INDEX (RDB$FOREIGN8))
13693 < *Monitor* 17/2/2021 10:31:31
13694 < [Application: IBX Test Suite]
13695 < : [Start transaction]
13696 < *Monitor* 17/2/2021 10:31:31
13697 < [Application: IBX Test Suite]
13698 < : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13699 <
13700 <  Plan:
13701 < PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
13702 < *Monitor* 17/2/2021 10:31:31
13703 < [Application: IBX Test Suite]
13704 < : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13705 <
13706 <  RELATION = EMPLOYEE
13707 < *Monitor* 17/2/2021 10:31:31
13708 < [Application: IBX Test Suite]
13709 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13710 <
13711 < *Monitor* 17/2/2021 10:31:31
13712 < [Application: IBX Test Suite]
13713 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13714 <
13715 < *Monitor* 17/2/2021 10:31:31
13716 < [Application: IBX Test Suite]
13717 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,  R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL))
13718 <
13719 <  SEOFReached
13720 < *Monitor* 17/2/2021 10:31:31
13721 < [Application: IBX Test Suite]
13722 < : [Commit (Hard commit)]
13723 < *Monitor* 17/2/2021 10:31:31
13724 < [Application: IBX Test Suite]
13725 < : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13726 <
13727 < *Monitor* 17/2/2021 10:31:31
13728 < [Application: IBX Test Suite]
13729 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13730 <
13731 < *Monitor* 17/2/2021 10:31:31
13732 < [Application: IBX Test Suite]
13733 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13734 <
13735 < *Monitor* 17/2/2021 10:31:31
13736 < [Application: IBX Test Suite]
13737 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13738 <
13739 <  SEOFReached
13740 < *Monitor* 17/2/2021 10:31:31
13741 < [Application: IBX Test Suite]
13742 < Test_Transaction_14: [Commit (Hard commit)]
13743 < *Monitor* 17/2/2021 10:31:31
13744 < [Application: IBX Test Suite]
13745 < Test_Database_14: [Disconnect]
13746 < *Monitor* 17/2/2021 10:39:34
13747 < [Application: IBX Test Suite]
13748 < Test_Database_13: [Connect]
13749 < *Monitor* 17/2/2021 10:39:34
13750 < [Application: IBX Test Suite]
13751 < Test_Transaction_13: [Start transaction]
13752 < *Monitor* 17/2/2021 10:39:34
13516 > *Monitor*  
13517   [Application: IBX Test Suite]
13518   : [Prepare] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13519  
# Line 13761 | Line 13525 | Select Expression
13525                  -> Filter
13526                      -> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID
13527                          -> Bitmap
13764  
13765 *Monitor* 17/2/2021 10:39:34                          -> Index "RDB$FOREIGN6" Range Scan (full match)
13766                -> Filter
13767                    -> Table "DEPARTMENT" as "DEPTS D" Access By ID
13768                        -> Bitmap
13528                              -> Index "RDB$FOREIGN6" Range Scan (full match)
13770            -> Filter
13771                -> Table "EMPLOYEE" as "A" Access By ID
13772                    -> Bitmap
13773                        -> Index "RDB$FOREIGN8" Range Scan (full match)
13774 *Monitor* 17/2/2021 10:39:34
13775 [Application: IBX Test Suite]
13776 : [Start transaction]
13777 *Monitor* 17/2/2021 10:39:34
13778 [Application: IBX Test Suite]
13779 : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13780
13781  Plan:
13782 Select Expression
13783    -> Nested Loop Join (inner)
13784        -> Filter
13785            -> Table "RDB$RELATION_FIELDS" as "R" Access By ID
13786                -> Bitmap
13787                    -> Index "RDB$INDEX_4" Range Scan (full match)
13788        -> Filter
13789            -> Table "RDB$FIELDS" as "F" Access By ID
13790                -> Bitmap
13791                    -> Index "RDB$INDEX_2" Unique Scan
13792 *Monitor* 17/2/2021 10:39:34
13793 [Application: IBX Test Suite]
13794 : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13795
13796  RELATION = EMPLOYEE
13797 *Monitor* 17/2/2021 10:39:34
13798 [Application: IBX Test Suite]
13799 : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13800
13801 *Monitor* 17/2/2021 10:39:34
13802 [Application: IBX Test Suite]
13803 : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13804
13805 *Monitor* 17/2/2021 10:39:34
13806 [Application: IBX Test Suite]
13807 : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13808
13809  SEOFReached
13810 *Monitor* 17/2/2021 10:39:34
13811 [Application: IBX Test Suite]
13812 : [Commit (Hard commit)]
13813 *Monitor* 17/2/2021 10:39:34
13814 [Application: IBX Test Suite]
13815 : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13816
13817 *Monitor* 17/2/2021 10:39:34
13818 [Application: IBX Test Suite]
13819 : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13820
13821 *Monitor* 17/2/2021 10:39:34
13822 [Application: IBX Test Suite]
13823 : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13824
13825 *Monitor* 17/2/2021 10:39:34
13826 [Application: IBX Test Suite]
13827 : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13828
13829  SEOFReached
13830 *Monitor* 17/2/2021 10:39:34
13831 [Application: IBX Test Suite]
13832 Test_Transaction_13: [Commit (Hard commit)]
13833 *Monitor* 17/2/2021 10:39:34
13834 [Application: IBX Test Suite]
13835 Test_Database_13: [Disconnect]
13836 *Monitor* 17/2/2021 10:39:34
13837 [Application: IBX Test Suite]
13838 Test_Database_13: [Connect]
13839 *Monitor* 17/2/2021 10:39:34
13840 [Application: IBX Test Suite]
13841 Test_Transaction_13: [Start transaction]
13842 *Monitor* 17/2/2021 10:39:34
13843 [Application: IBX Test Suite]
13844 : [Prepare] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13845
13846  Plan:
13847 Select Expression
13848    -> First N Records
13849        -> Nested Loop Join (inner)
13850            -> Recursion
13851                -> Filter
13852                    -> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID
13853                        -> Bitmap
13854  
13855 *Monitor* 17/2/2021 10:39:34                          -> Index "RDB$FOREIGN6" Range Scan (full match)
13529                  -> Filter
13530                      -> Table "DEPARTMENT" as "DEPTS D" Access By ID
13531                          -> Bitmap
# Line 13861 | Line 13534 | Select Expression
13534                  -> Table "EMPLOYEE" as "A" Access By ID
13535                      -> Bitmap
13536                          -> Index "RDB$FOREIGN8" Range Scan (full match)
13537 < *Monitor* 17/2/2021 10:39:34
13537 > *Monitor*  
13538   [Application: IBX Test Suite]
13539   : [Start transaction]
13540 < *Monitor* 17/2/2021 10:39:34
13540 > *Monitor*  
13541   [Application: IBX Test Suite]
13542   : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13543  
# Line 13879 | Line 13552 | Select Expression
13552              -> Table "RDB$FIELDS" as "F" Access By ID
13553                  -> Bitmap
13554                      -> Index "RDB$INDEX_2" Unique Scan
13555 < *Monitor* 17/2/2021 10:39:34
13555 > *Monitor*  
13556   [Application: IBX Test Suite]
13557   : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13558  
13559    RELATION = EMPLOYEE
13560 < *Monitor* 17/2/2021 10:39:34
13560 > *Monitor*  
13561   [Application: IBX Test Suite]
13562   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13563  
13564 < *Monitor* 17/2/2021 10:39:34
13564 > *Monitor*  
13565   [Application: IBX Test Suite]
13566   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13567  
13568 < *Monitor* 17/2/2021 10:39:34
13568 > *Monitor*  
13569   [Application: IBX Test Suite]
13570   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13571  
13572    SEOFReached
13573 < *Monitor* 17/2/2021 10:39:34
13573 > *Monitor*  
13574   [Application: IBX Test Suite]
13575   : [Commit (Hard commit)]
13576 < *Monitor* 17/2/2021 10:39:34
13576 > *Monitor*  
13577   [Application: IBX Test Suite]
13578   : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13579  
13580 < *Monitor* 17/2/2021 10:39:34
13580 > *Monitor*  
13581   [Application: IBX Test Suite]
13582   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13583  
13584 < *Monitor* 17/2/2021 10:39:34
13584 > *Monitor*  
13585   [Application: IBX Test Suite]
13586   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13587  
13588 < *Monitor* 17/2/2021 10:39:34
13588 > *Monitor*  
13589   [Application: IBX Test Suite]
13590   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13591  
13592    SEOFReached
13593 < *Monitor* 17/2/2021 10:39:34
13921 < [Application: IBX Test Suite]
13922 < Test_Transaction_13: [Commit (Hard commit)]
13923 < *Monitor* 17/2/2021 10:39:34
13924 < [Application: IBX Test Suite]
13925 < Test_Database_13: [Disconnect]
13926 < *Monitor* 17/2/2021 10:39:36
13927 < [Application: IBX Test Suite]
13928 < Test_Database_14: [Connect]
13929 < *Monitor* 17/2/2021 10:39:36
13930 < [Application: IBX Test Suite]
13931 < Test_Transaction_14: [Start transaction]
13932 < *Monitor* 17/2/2021 10:39:36
13933 < [Application: IBX Test Suite]
13934 < : [Prepare] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13935 <
13936 <  Plan:
13937 < Select Expression
13938 <    -> First N Records
13939 <        -> Nested Loop Join (inner)
13940 <            -> Recursion
13941 <                -> Filter
13942 <                    -> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID
13943 <                        -> Bitmap
13944 <  
13945 < *Monitor* 17/2/2021 10:39:36                          -> Index "RDB$FOREIGN6" Range Scan (full match)
13946 <                -> Filter
13947 <                    -> Table "DEPARTMENT" as "DEPTS D" Access By ID
13948 <                        -> Bitmap
13949 <                            -> Index "RDB$FOREIGN6" Range Scan (full match)
13950 <            -> Filter
13951 <                -> Table "EMPLOYEE" as "A" Access By ID
13952 <                    -> Bitmap
13953 <                        -> Index "RDB$FOREIGN8" Range Scan (full match)
13954 < *Monitor* 17/2/2021 10:39:36
13955 < [Application: IBX Test Suite]
13956 < : [Start transaction]
13957 < *Monitor* 17/2/2021 10:39:36
13958 < [Application: IBX Test Suite]
13959 < : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13960 <
13961 <  Plan:
13962 < Select Expression
13963 <    -> Nested Loop Join (inner)
13964 <        -> Filter
13965 <            -> Table "RDB$RELATION_FIELDS" as "R" Access By ID
13966 <                -> Bitmap
13967 <                    -> Index "RDB$INDEX_4" Range Scan (full match)
13968 <        -> Filter
13969 <            -> Table "RDB$FIELDS" as "F" Access By ID
13970 <                -> Bitmap
13971 <                    -> Index "RDB$INDEX_2" Unique Scan
13972 < *Monitor* 17/2/2021 10:39:36
13973 < [Application: IBX Test Suite]
13974 < : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13975 <
13976 <  RELATION = EMPLOYEE
13977 < *Monitor* 17/2/2021 10:39:36
13978 < [Application: IBX Test Suite]
13979 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13980 <
13981 < *Monitor* 17/2/2021 10:39:36
13982 < [Application: IBX Test Suite]
13983 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13984 <
13985 < *Monitor* 17/2/2021 10:39:36
13986 < [Application: IBX Test Suite]
13987 < : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13988 <
13989 <  SEOFReached
13990 < *Monitor* 17/2/2021 10:39:36
13991 < [Application: IBX Test Suite]
13992 < : [Commit (Hard commit)]
13993 < *Monitor* 17/2/2021 10:39:36
13994 < [Application: IBX Test Suite]
13995 < : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13996 <
13997 < *Monitor* 17/2/2021 10:39:36
13998 < [Application: IBX Test Suite]
13999 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
14000 <
14001 < *Monitor* 17/2/2021 10:39:36
14002 < [Application: IBX Test Suite]
14003 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
14004 <
14005 < *Monitor* 17/2/2021 10:39:36
14006 < [Application: IBX Test Suite]
14007 < : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
14008 <
14009 <  SEOFReached
14010 < *Monitor* 17/2/2021 10:39:36
13593 > *Monitor*  
13594   [Application: IBX Test Suite]
13595   Test_Transaction_14: [Commit (Hard commit)]
13596 < *Monitor* 17/2/2021 10:39:36
13596 > *Monitor*  
13597   [Application: IBX Test Suite]
13598   Test_Database_14: [Disconnect]
13599 < *Monitor* 17/2/2021 10:39:36
13599 > *Monitor*  
13600   [Application: IBX Test Suite]
13601   Test_Database_14: [Connect]
13602 < *Monitor* 17/2/2021 10:39:36
13602 > *Monitor*  
13603   [Application: IBX Test Suite]
13604   Test_Transaction_14: [Start transaction]
13605 < *Monitor* 17/2/2021 10:39:36
13605 > *Monitor*  
13606   [Application: IBX Test Suite]
13607   : [Prepare] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13608  
# Line 14031 | Line 13614 | Select Expression
13614                  -> Filter
13615                      -> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID
13616                          -> Bitmap
13617 <  
14035 < *Monitor* 17/2/2021 10:39:36                          -> Index "RDB$FOREIGN6" Range Scan (full match)
13617 >                            -> Index "RDB$FOREIGN6" Range Scan (full match)
13618                  -> Filter
13619                      -> Table "DEPARTMENT" as "DEPTS D" Access By ID
13620                          -> Bitmap
# Line 14041 | Line 13623 | Select Expression
13623                  -> Table "EMPLOYEE" as "A" Access By ID
13624                      -> Bitmap
13625                          -> Index "RDB$FOREIGN8" Range Scan (full match)
13626 < *Monitor* 17/2/2021 10:39:36
13626 > *Monitor*  
13627   [Application: IBX Test Suite]
13628   : [Start transaction]
13629 < *Monitor* 17/2/2021 10:39:36
13629 > *Monitor*  
13630   [Application: IBX Test Suite]
13631   : [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13632  
# Line 14059 | Line 13641 | Select Expression
13641              -> Table "RDB$FIELDS" as "F" Access By ID
13642                  -> Bitmap
13643                      -> Index "RDB$INDEX_2" Unique Scan
13644 < *Monitor* 17/2/2021 10:39:36
13644 > *Monitor*  
13645   [Application: IBX Test Suite]
13646   : [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13647  
13648    RELATION = EMPLOYEE
13649 < *Monitor* 17/2/2021 10:39:36
13649 > *Monitor*  
13650   [Application: IBX Test Suite]
13651   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13652  
13653 < *Monitor* 17/2/2021 10:39:36
13653 > *Monitor*  
13654   [Application: IBX Test Suite]
13655   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13656  
13657 < *Monitor* 17/2/2021 10:39:36
13657 > *Monitor*  
13658   [Application: IBX Test Suite]
13659   : [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or      (not F.RDB$DEFAULT_VALUE is NULL) or      ( not R.RDB$IDENTITY_TYPE is NULL))
13660  
13661    SEOFReached
13662 < *Monitor* 17/2/2021 10:39:36
13662 > *Monitor*  
13663   [Application: IBX Test Suite]
13664   : [Commit (Hard commit)]
13665 < *Monitor* 17/2/2021 10:39:36
13665 > *Monitor*  
13666   [Application: IBX Test Suite]
13667   : [Execute] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13668  
13669 < *Monitor* 17/2/2021 10:39:36
13669 > *Monitor*  
13670   [Application: IBX Test Suite]
13671   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13672  
13673 < *Monitor* 17/2/2021 10:39:36
13673 > *Monitor*  
13674   [Application: IBX Test Suite]
13675   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13676  
13677 < *Monitor* 17/2/2021 10:39:36
13677 > *Monitor*  
13678   [Application: IBX Test Suite]
13679   : [Fetch] 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 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 First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO
13680  
13681    SEOFReached
13682 < *Monitor* 17/2/2021 10:39:36
13682 > *Monitor*  
13683   [Application: IBX Test Suite]
13684   Test_Transaction_14: [Commit (Hard commit)]
13685 < *Monitor* 17/2/2021 10:39:36
13685 > *Monitor*  
13686   [Application: IBX Test Suite]
13687   Test_Database_14: [Disconnect]
13688 + 33 ISQL Monitor Messages Received
13689  
13690  
13691   ------------------------------------------------------
# Line 15494 | Line 15077 | Create Table LotsOfData (
15077      MyText VarChar(1024),
15078      Primary Key (RowID)
15079    );                
15080 < Loading data into database table. Started at 17/2/2021 10:39:56.328
15081 < Data load completed at 17/2/2021 10:41:26.558 Elapsed Time = 90230 ms, 100000 records loaded
15082 < MD5 checksum = bab48fcf928b5720e5e1735e5401803e
15083 < Database Read started at 17/2/2021 10:41:26.568
15084 < Read Dataset completed at 17/2/2021 10:41:57.747 Elapsed Time = 31179 ms, 100000 records read
15085 < MD5 checksum = bab48fcf928b5720e5e1735e5401803e
15080 > Loading data into database table. Started at 18/2/2021 17:02:23.963
15081 > Data load completed at 18/2/2021 17:04:01.973 Elapsed Time = 98010 ms, 100000 records loaded
15082 > MD5 checksum = e299f7080fd2afa5d1b70b92831668b0
15083 > Database Read started at 18/2/2021 17:04:01.983
15084 > Read Dataset completed at 18/2/2021 17:04:31.867 Elapsed Time = 29884 ms, 100000 records read
15085 > MD5 checksum = e299f7080fd2afa5d1b70b92831668b0
15086   Test Completed successfully
15087  
15088  

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines