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

Comparing ibx/trunk/testsuite/FB2reference.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 642 | Line 642 | Rows printed = 42
642   Current memory = 960,760
643   Delta memory = 9,624
644   Max memory = 1,012,104
645 < Elapsed time= 0.034 sec
645 > Elapsed time= 0.033 sec
646   Cpu = 0.002 sec
647   Buffers = 75
648   Reads = 3
# Line 1443 | Line 1443 | DPB: Item Count = 3
1443    isc_dpb_lc_ctype = UTF8
1444  
1445   Before Disconnect
1446 < localhost:employee Disconnected after 22 ms
1446 > localhost:employee Disconnected after 21 ms
1447   Before Connect
1448   Connected to localhost:employee
1449   DPB: Item Count = 3
# Line 1452 | Line 1452 | DPB: Item Count = 3
1452    isc_dpb_lc_ctype = UTF8
1453  
1454   Before Disconnect
1455 < localhost:employee Disconnected after 3969 ms
1455 > localhost:employee Disconnected after 3989 ms
1456   Idle Timer Expired for Test_Database_02
1457   Database Closed
1458   Transaction Events
# Line 1489 | Line 1489 | TPB: Item Count = 3
1489    isc_tpb_read
1490  
1491   Transaction Ending
1492 < Transaction Ended after 2016 ms
1492 > Transaction Ended after 2012 ms
1493   Idle Timer Expired for Test_Transaction_02
1494   Before Disconnect
1495 < localhost:employee Disconnected after 2065 ms
1495 > localhost:employee Disconnected after 2056 ms
1496   SQL Dialect Downgrade test
1497   Before Connect
1498   Connected to localhost:/tmp/ibx-testsuite/testsuite1.fdb
# Line 1504 | Line 1504 | DPB: Item Count = 4
1504  
1505   localhost:/tmp/ibx-testsuite/testsuite1.fdb created
1506   Before Disconnect
1507 < localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms
1507 > localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 28 ms
1508   Before Connect
1509   Warning: SQL Dialect Downgrade of localhost:/tmp/ibx-testsuite/testsuite1.fdb
1510   Connected to localhost:/tmp/ibx-testsuite/testsuite1.fdb
# Line 1514 | Line 1514 | DPB: Item Count = 3
1514    isc_dpb_lc_ctype = UTF8
1515  
1516   Before Disconnect
1517 < localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms
1517 > localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 22 ms
1518  
1519  
1520   ------------------------------------------------------
# Line 3151 | Line 3151 | DEPT_KEY_PATH = 000;600;620;622
3151   Current memory = 952,624
3152   Delta memory = 9,608
3153   Max memory = 1,013,496
3154 < Elapsed time= 0.017 sec
3154 > Elapsed time= 0.032 sec
3155   Cpu = 0.001 sec
3156   Buffers = 75
3157   Reads = 3
# Line 10048 | Line 10048 | Message File Location = /opt/firebird2.5
10048   Database Statistics for employee
10049  
10050   Database "/opt/firebird2.5.9/examples/empbuild/employee.fdb"
10051 < Gstat execution time Wed Feb 17 10:31:26 2021
10051 > Gstat execution time Thu Feb 18 16:54:16 2021
10052  
10053   Database header page information:
10054   Flags                   0
10055   Checksum                12345
10056 < Generation              3119
10056 > Generation              3858
10057   Page size               4096
10058   ODS version             11.2
10059 < Oldest transaction      1816
10060 < Oldest active           1817
10061 < Oldest snapshot         1817
10062 < Next transaction        1817
10059 > Oldest transaction      2330
10060 > Oldest active           2331
10061 > Oldest snapshot         2331
10062 > Next transaction        2331
10063   Bumped transaction      1
10064   Sequence number         0
10065 < Next attachment ID      575
10065 > Next attachment ID      761
10066   Implementation ID       24
10067   Shadow count            0
10068   Page buffers            0
# Line 10187 | Line 10187 | zeus   Tue Jun  9 14:31:01 2020
10187   INET/inet_error: connect errno = 111
10188  
10189   Online Validation
10190 < 10:31:27.29 Validation started
10190 > 16:54:17.46 Validation started
10191  
10192 < 10:31:27.29 Relation 128 (COUNTRY)
10193 < 10:31:27.29   process pointer page    0 of    1
10194 < 10:31:27.29 Index 1 (RDB$PRIMARY1)
10195 < 10:31:27.29 Relation 128 (COUNTRY) is ok
10196 <
10197 < 10:31:27.29 Relation 129 (JOB)
10198 < 10:31:27.29   process pointer page    0 of    1
10199 < 10:31:27.30 Index 1 (RDB$PRIMARY2)
10200 < 10:31:27.30 Index 2 (RDB$FOREIGN3)
10201 < 10:31:27.30 Index 3 (MAXSALX)
10202 < 10:31:27.30 Index 4 (MINSALX)
10203 < 10:31:27.30 Relation 129 (JOB) is ok
10204 <
10205 < 10:31:27.30 Relation 130 (DEPARTMENT)
10206 < 10:31:27.30   process pointer page    0 of    1
10207 < 10:31:27.30 Index 1 (RDB$4)
10208 < 10:31:27.30 Index 2 (RDB$PRIMARY5)
10209 < 10:31:27.30 Index 3 (RDB$FOREIGN6)
10210 < 10:31:27.30 Index 4 (BUDGETX)
10211 < 10:31:27.30 Index 5 (RDB$FOREIGN10)
10212 < 10:31:27.30 Relation 130 (DEPARTMENT) is ok
10213 <
10214 < 10:31:27.30 Relation 131 (EMPLOYEE)
10215 < 10:31:27.30   process pointer page    0 of    1
10216 < 10:31:27.30 Index 1 (RDB$PRIMARY7)
10217 < 10:31:27.30 Index 2 (RDB$FOREIGN8)
10218 < 10:31:27.30 Index 3 (RDB$FOREIGN9)
10219 < 10:31:27.30 Index 4 (NAMEX)
10220 < 10:31:27.30 Relation 131 (EMPLOYEE) is ok
10221 <
10222 < 10:31:27.30 Relation 133 (PROJECT)
10223 < 10:31:27.30   process pointer page    0 of    1
10224 < 10:31:27.30 Index 1 (RDB$11)
10225 < 10:31:27.30 Index 2 (RDB$PRIMARY12)
10226 < 10:31:27.30 Index 3 (RDB$FOREIGN13)
10227 < 10:31:27.30 Index 4 (PRODTYPEX)
10228 < 10:31:27.30 Relation 133 (PROJECT) is ok
10229 <
10230 < 10:31:27.30 Relation 134 (EMPLOYEE_PROJECT)
10231 < 10:31:27.30   process pointer page    0 of    1
10232 < 10:31:27.30 Index 1 (RDB$PRIMARY14)
10233 < 10:31:27.30 Index 2 (RDB$FOREIGN15)
10234 < 10:31:27.30 Index 3 (RDB$FOREIGN16)
10235 < 10:31:27.30 Relation 134 (EMPLOYEE_PROJECT) is ok
10236 <
10237 < 10:31:27.30 Relation 135 (PROJ_DEPT_BUDGET)
10238 < 10:31:27.30   process pointer page    0 of    1
10239 < 10:31:27.30 Index 1 (RDB$PRIMARY17)
10240 < 10:31:27.30 Index 2 (RDB$FOREIGN18)
10241 < 10:31:27.30 Index 3 (RDB$FOREIGN19)
10242 < 10:31:27.30 Relation 135 (PROJ_DEPT_BUDGET) is ok
10243 <
10244 < 10:31:27.30 Relation 136 (SALARY_HISTORY)
10245 < 10:31:27.30   process pointer page    0 of    1
10246 < 10:31:27.30 Index 1 (RDB$PRIMARY20)
10247 < 10:31:27.30 Index 2 (RDB$FOREIGN21)
10248 < 10:31:27.30 Index 3 (CHANGEX)
10249 < 10:31:27.31 Index 4 (UPDATERX)
10250 < 10:31:27.31 Relation 136 (SALARY_HISTORY) is ok
10251 <
10252 < 10:31:27.31 Relation 137 (CUSTOMER)
10253 < 10:31:27.31   process pointer page    0 of    1
10254 < 10:31:27.31 Index 1 (RDB$PRIMARY22)
10255 < 10:31:27.31 Index 2 (RDB$FOREIGN23)
10256 < 10:31:27.31 Index 3 (CUSTNAMEX)
10257 < 10:31:27.31 Index 4 (CUSTREGION)
10258 < 10:31:27.31 Relation 137 (CUSTOMER) is ok
10259 <
10260 < 10:31:27.31 Relation 138 (SALES)
10261 < 10:31:27.31   process pointer page    0 of    1
10262 < 10:31:27.31 Index 1 (RDB$PRIMARY24)
10263 < 10:31:27.31 Index 2 (RDB$FOREIGN25)
10264 < 10:31:27.31 Index 3 (RDB$FOREIGN26)
10265 < 10:31:27.31 Index 4 (NEEDX)
10266 < 10:31:27.31 Index 5 (QTYX)
10267 < 10:31:27.31 Index 6 (SALESTATX)
10268 < 10:31:27.31 Relation 138 (SALES) is ok
10192 > 16:54:17.46 Relation 128 (COUNTRY)
10193 > 16:54:17.46   process pointer page    0 of    1
10194 > 16:54:17.46 Index 1 (RDB$PRIMARY1)
10195 > 16:54:17.46 Relation 128 (COUNTRY) is ok
10196 >
10197 > 16:54:17.46 Relation 129 (JOB)
10198 > 16:54:17.46   process pointer page    0 of    1
10199 > 16:54:17.46 Index 1 (RDB$PRIMARY2)
10200 > 16:54:17.46 Index 2 (RDB$FOREIGN3)
10201 > 16:54:17.46 Index 3 (MAXSALX)
10202 > 16:54:17.46 Index 4 (MINSALX)
10203 > 16:54:17.46 Relation 129 (JOB) is ok
10204 >
10205 > 16:54:17.46 Relation 130 (DEPARTMENT)
10206 > 16:54:17.46   process pointer page    0 of    1
10207 > 16:54:17.46 Index 1 (RDB$4)
10208 > 16:54:17.46 Index 2 (RDB$PRIMARY5)
10209 > 16:54:17.46 Index 3 (RDB$FOREIGN6)
10210 > 16:54:17.46 Index 4 (BUDGETX)
10211 > 16:54:17.46 Index 5 (RDB$FOREIGN10)
10212 > 16:54:17.46 Relation 130 (DEPARTMENT) is ok
10213 >
10214 > 16:54:17.46 Relation 131 (EMPLOYEE)
10215 > 16:54:17.46   process pointer page    0 of    1
10216 > 16:54:17.46 Index 1 (RDB$PRIMARY7)
10217 > 16:54:17.46 Index 2 (RDB$FOREIGN8)
10218 > 16:54:17.46 Index 3 (RDB$FOREIGN9)
10219 > 16:54:17.46 Index 4 (NAMEX)
10220 > 16:54:17.46 Relation 131 (EMPLOYEE) is ok
10221 >
10222 > 16:54:17.46 Relation 133 (PROJECT)
10223 > 16:54:17.46   process pointer page    0 of    1
10224 > 16:54:17.46 Index 1 (RDB$11)
10225 > 16:54:17.46 Index 2 (RDB$PRIMARY12)
10226 > 16:54:17.47 Index 3 (RDB$FOREIGN13)
10227 > 16:54:17.47 Index 4 (PRODTYPEX)
10228 > 16:54:17.47 Relation 133 (PROJECT) is ok
10229 >
10230 > 16:54:17.47 Relation 134 (EMPLOYEE_PROJECT)
10231 > 16:54:17.47   process pointer page    0 of    1
10232 > 16:54:17.47 Index 1 (RDB$PRIMARY14)
10233 > 16:54:17.47 Index 2 (RDB$FOREIGN15)
10234 > 16:54:17.47 Index 3 (RDB$FOREIGN16)
10235 > 16:54:17.47 Relation 134 (EMPLOYEE_PROJECT) is ok
10236 >
10237 > 16:54:17.47 Relation 135 (PROJ_DEPT_BUDGET)
10238 > 16:54:17.47   process pointer page    0 of    1
10239 > 16:54:17.47 Index 1 (RDB$PRIMARY17)
10240 > 16:54:17.47 Index 2 (RDB$FOREIGN18)
10241 > 16:54:17.47 Index 3 (RDB$FOREIGN19)
10242 > 16:54:17.47 Relation 135 (PROJ_DEPT_BUDGET) is ok
10243 >
10244 > 16:54:17.47 Relation 136 (SALARY_HISTORY)
10245 > 16:54:17.47   process pointer page    0 of    1
10246 > 16:54:17.47 Index 1 (RDB$PRIMARY20)
10247 > 16:54:17.47 Index 2 (RDB$FOREIGN21)
10248 > 16:54:17.47 Index 3 (CHANGEX)
10249 > 16:54:17.47 Index 4 (UPDATERX)
10250 > 16:54:17.48 Relation 136 (SALARY_HISTORY) is ok
10251 >
10252 > 16:54:17.48 Relation 137 (CUSTOMER)
10253 > 16:54:17.48   process pointer page    0 of    1
10254 > 16:54:17.48 Index 1 (RDB$PRIMARY22)
10255 > 16:54:17.48 Index 2 (RDB$FOREIGN23)
10256 > 16:54:17.48 Index 3 (CUSTNAMEX)
10257 > 16:54:17.48 Index 4 (CUSTREGION)
10258 > 16:54:17.48 Relation 137 (CUSTOMER) is ok
10259 >
10260 > 16:54:17.48 Relation 138 (SALES)
10261 > 16:54:17.48   process pointer page    0 of    1
10262 > 16:54:17.48 Index 1 (RDB$PRIMARY24)
10263 > 16:54:17.48 Index 2 (RDB$FOREIGN25)
10264 > 16:54:17.48 Index 3 (RDB$FOREIGN26)
10265 > 16:54:17.48 Index 4 (NEEDX)
10266 > 16:54:17.48 Index 5 (QTYX)
10267 > 16:54:17.48 Index 6 (SALESTATX)
10268 > 16:54:17.48 Relation 138 (SALES) is ok
10269  
10270 < 10:31:27.31 Validation finished
10270 > 16:54:17.48 Validation finished
10271  
10272  
10273   Normal Validation
# Line 11555 | Line 11555 | Rows printed = 2
11555   Current memory = 966,728
11556   Delta memory = 9,344
11557   Max memory = 1,012,400
11558 < Elapsed time= 0.004 sec
11558 > Elapsed time= 0.005 sec
11559   Cpu = 0.001 sec
11560   Buffers = 75
11561   Reads = 2
# Line 11599 | Line 11599 | DEPT_KEY_PATH = 000
11599  
11600   Rows printed = 2
11601  
11602 < *Monitor* 17/2/2021 10:31:29.646
11603 < [Application: IBX Test Suite]
11602 > 33 ISQL Monitor Messages Received
11603 > 33 ISQL Monitor Messages written
11604 > *Monitor*  
11605 > [Application: IBX Test Suite]
11606   Test_Database_13: [Connect]
11607 < *Monitor* 17/2/2021 10:31:29.654
11608 < [Application: IBX Test Suite]
11607 > *Monitor*  
11608 > [Application: IBX Test Suite]
11609   Test_Transaction_13: [Start transaction]
11610 < *Monitor* 17/2/2021 10:31:29.666
11611 < [Application: IBX Test Suite]
11610 > *Monitor*  
11611 > [Application: IBX Test Suite]
11612   : [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
11613 <
11613 >
11614    Plan:
11615   PLAN JOIN ((DEPTS DEPARTMENT INDEX (RDB$FOREIGN6))
11616   PLAN (DEPTS D INDEX (RDB$FOREIGN6)), A INDEX (RDB$FOREIGN8))
11617 < *Monitor* 17/2/2021 10:31:29.676
11618 < [Application: IBX Test Suite]
11617 > *Monitor*  
11618 > [Application: IBX Test Suite]
11619   : [Start transaction]
11620 < *Monitor* 17/2/2021 10:31:29.682
11621 < [Application: IBX Test Suite]
11620 > *Monitor*  
11621 > [Application: IBX Test Suite]
11622   : [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))
11623 <
11623 >
11624    Plan:
11625   PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
11626 < *Monitor* 17/2/2021 10:31:29.683
11627 < [Application: IBX Test Suite]
11626 > *Monitor*  
11627 > [Application: IBX Test Suite]
11628   : [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))
11629 <
11629 >
11630    RELATION = EMPLOYEE
11631 < *Monitor* 17/2/2021 10:31:29.684
11632 < [Application: IBX Test Suite]
11631 > *Monitor*  
11632 > [Application: IBX Test Suite]
11633   : [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))
11634  
11635 < *Monitor* 17/2/2021 10:31:29.684
11636 < [Application: IBX Test Suite]
11635 > *Monitor*  
11636 > [Application: IBX Test Suite]
11637   : [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))
11638  
11639 < *Monitor* 17/2/2021 10:31:29.684
11640 < [Application: IBX Test Suite]
11639 > *Monitor*  
11640 > [Application: IBX Test Suite]
11641   : [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))
11642 <
11642 >
11643    SEOFReached
11644 < *Monitor* 17/2/2021 10:31:29.696
11645 < [Application: IBX Test Suite]
11644 > *Monitor*  
11645 > [Application: IBX Test Suite]
11646   : [Commit (Hard commit)]
11647 < *Monitor* 17/2/2021 10:31:29.710
11648 < [Application: IBX Test Suite]
11647 > *Monitor*  
11648 > [Application: IBX Test Suite]
11649   : [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
11650  
11651 < *Monitor* 17/2/2021 10:31:29.711
11652 < [Application: IBX Test Suite]
11651 > *Monitor*  
11652 > [Application: IBX Test Suite]
11653   : [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
11654  
11655 < *Monitor* 17/2/2021 10:31:29.712
11656 < [Application: IBX Test Suite]
11655 > *Monitor*  
11656 > [Application: IBX Test Suite]
11657   : [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
11658  
11659 < *Monitor* 17/2/2021 10:31:29.712
11660 < [Application: IBX Test Suite]
11659 > *Monitor*  
11660 > [Application: IBX Test Suite]
11661   : [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
11662 <
11662 >
11663    SEOFReached
11664 < *Monitor* 17/2/2021 10:31:29.721
11665 < [Application: IBX Test Suite]
11664 > *Monitor*  
11665 > [Application: IBX Test Suite]
11666   Test_Transaction_13: [Commit (Hard commit)]
11667 < *Monitor* 17/2/2021 10:31:29.733
11668 < [Application: IBX Test Suite]
11667 > *Monitor*  
11668 > [Application: IBX Test Suite]
11669   Test_Database_13: [Disconnect]
11670 < *Monitor* 17/2/2021 10:31:29.808
11671 < [Application: IBX Test Suite]
11670 > *Monitor*  
11671 > [Application: IBX Test Suite]
11672   Test_Database_13: [Connect]
11673 < *Monitor* 17/2/2021 10:31:29.818
11674 < [Application: IBX Test Suite]
11673 > *Monitor*  
11674 > [Application: IBX Test Suite]
11675   Test_Transaction_13: [Start transaction]
11676 < *Monitor* 17/2/2021 10:31:29.836
11677 < [Application: IBX Test Suite]
11676 > *Monitor*  
11677 > [Application: IBX Test Suite]
11678   : [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
11679 <
11679 >
11680    Plan:
11681   PLAN JOIN ((DEPTS DEPARTMENT INDEX (RDB$FOREIGN6))
11682   PLAN (DEPTS D INDEX (RDB$FOREIGN6)), A INDEX (RDB$FOREIGN8))
11683 < *Monitor* 17/2/2021 10:31:29.846
11684 < [Application: IBX Test Suite]
11683 > *Monitor*  
11684 > [Application: IBX Test Suite]
11685   : [Start transaction]
11686 < *Monitor* 17/2/2021 10:31:29.851
11687 < [Application: IBX Test Suite]
11686 > *Monitor*  
11687 > [Application: IBX Test Suite]
11688   : [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))
11689 <
11689 >
11690    Plan:
11691   PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
11692 < *Monitor* 17/2/2021 10:31:29.852
11693 < [Application: IBX Test Suite]
11692 > *Monitor*  
11693 > [Application: IBX Test Suite]
11694   : [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))
11695 <
11695 >
11696    RELATION = EMPLOYEE
11697 < *Monitor* 17/2/2021 10:31:29.853
11698 < [Application: IBX Test Suite]
11697 > *Monitor*  
11698 > [Application: IBX Test Suite]
11699   : [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))
11700  
11701 < *Monitor* 17/2/2021 10:31:29.853
11702 < [Application: IBX Test Suite]
11701 > *Monitor*  
11702 > [Application: IBX Test Suite]
11703   : [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))
11704  
11705 < *Monitor* 17/2/2021 10:31:29.853
11706 < [Application: IBX Test Suite]
11705 > *Monitor*  
11706 > [Application: IBX Test Suite]
11707   : [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))
11708 <
11708 >
11709    SEOFReached
11710 < *Monitor* 17/2/2021 10:31:29.866
11711 < [Application: IBX Test Suite]
11710 > *Monitor*  
11711 > [Application: IBX Test Suite]
11712   : [Commit (Hard commit)]
11713 < *Monitor* 17/2/2021 10:31:29.869
11714 < [Application: IBX Test Suite]
11713 > *Monitor*  
11714 > [Application: IBX Test Suite]
11715   : [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
11716  
11717 < *Monitor* 17/2/2021 10:31:29.872
11718 < [Application: IBX Test Suite]
11717 > *Monitor*  
11718 > [Application: IBX Test Suite]
11719   : [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
11720  
11721 < *Monitor* 17/2/2021 10:31:29.873
11722 < [Application: IBX Test Suite]
11721 > *Monitor*  
11722 > [Application: IBX Test Suite]
11723   : [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
11724  
11725 < *Monitor* 17/2/2021 10:31:29.874
11726 < [Application: IBX Test Suite]
11725 > *Monitor*  
11726 > [Application: IBX Test Suite]
11727   : [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
11728 <
11728 >
11729    SEOFReached
11730 < *Monitor* 17/2/2021 10:31:29.882
11731 < [Application: IBX Test Suite]
11730 > *Monitor*  
11731 > [Application: IBX Test Suite]
11732   Test_Transaction_13: [Commit (Hard commit)]
11733 < *Monitor* 17/2/2021 10:31:29.895
11734 < [Application: IBX Test Suite]
11733 > *Monitor*  
11734 > [Application: IBX Test Suite]
11735   Test_Database_13: [Disconnect]
11736 + 33 ISQL Monitor Messages Received
11737  
11738  
11739   ------------------------------------------------------
# Line 11771 | Line 11774 | Rows printed = 2
11774   Current memory = 966,728
11775   Delta memory = 9,344
11776   Max memory = 1,012,400
11777 < Elapsed time= 0.005 sec
11777 > Elapsed time= 0.104 sec
11778   Cpu = 0.000 sec
11779   Buffers = 75
11780   Reads = 2
# Line 11815 | Line 11818 | DEPT_KEY_PATH = 000
11818  
11819   Rows printed = 2
11820  
11821 < *Monitor* 17/2/2021 10:31:31
11822 < [Application: IBX Test Suite]
11820 < : [Start transaction]
11821 < *Monitor* 17/2/2021 10:31:31
11822 < [Application: IBX Test Suite]
11823 < : [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))
11824 <
11825 <  Plan:
11826 < PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
11827 < *Monitor* 17/2/2021 10:31:31
11828 < [Application: IBX Test Suite]
11829 < : [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))
11830 <
11831 <  RELATION = EMPLOYEE
11832 < *Monitor* 17/2/2021 10:31:31
11833 < [Application: IBX Test Suite]
11834 < : [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))
11835 <
11836 < *Monitor* 17/2/2021 10:31:31
11837 < [Application: IBX Test Suite]
11838 < : [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))
11839 <
11840 < *Monitor* 17/2/2021 10:31:31
11841 < [Application: IBX Test Suite]
11842 < : [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))
11843 <
11844 <  SEOFReached
11845 < *Monitor* 17/2/2021 10:31:31
11846 < [Application: IBX Test Suite]
11847 < : [Commit (Hard commit)]
11848 < *Monitor* 17/2/2021 10:31:31
11849 < [Application: IBX Test Suite]
11850 < : [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
11851 <
11852 < *Monitor* 17/2/2021 10:31:31
11853 < [Application: IBX Test Suite]
11854 < : [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
11855 <
11856 < *Monitor* 17/2/2021 10:31:31
11857 < [Application: IBX Test Suite]
11858 < : [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
11859 <
11860 < *Monitor* 17/2/2021 10:31:31
11861 < [Application: IBX Test Suite]
11862 < : [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
11863 <
11864 <  SEOFReached
11865 < *Monitor* 17/2/2021 10:31:31
11866 < [Application: IBX Test Suite]
11867 < Test_Transaction_14: [Commit (Hard commit)]
11868 < *Monitor* 17/2/2021 10:31:31
11869 < [Application: IBX Test Suite]
11870 < Test_Database_14: [Disconnect]
11871 < *Monitor* 17/2/2021 10:31:31
11821 > 33 ISQL Monitor Messages written
11822 > *Monitor*  
11823   [Application: IBX Test Suite]
11824   Test_Database_14: [Connect]
11825 < *Monitor* 17/2/2021 10:31:31
11825 > *Monitor*  
11826   [Application: IBX Test Suite]
11827   Test_Transaction_14: [Start transaction]
11828 < *Monitor* 17/2/2021 10:31:31
11828 > *Monitor*  
11829   [Application: IBX Test Suite]
11830   : [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
11831  
11832    Plan:
11833   PLAN JOIN ((DEPTS DEPARTMENT INDEX (RDB$FOREIGN6))
11834   PLAN (DEPTS D INDEX (RDB$FOREIGN6)), A INDEX (RDB$FOREIGN8))
11835 < *Monitor* 17/2/2021 10:31:31
11885 < [Application: IBX Test Suite]
11886 < : [Start transaction]
11887 < *Monitor* 17/2/2021 10:31:31
11888 < [Application: IBX Test Suite]
11889 < : [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))
11890 <
11891 <  Plan:
11892 < PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
11893 < *Monitor* 17/2/2021 10:31:31
11894 < [Application: IBX Test Suite]
11895 < : [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))
11896 <
11897 <  RELATION = EMPLOYEE
11898 < *Monitor* 17/2/2021 10:31:31
11899 < [Application: IBX Test Suite]
11900 < : [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))
11901 <
11902 < *Monitor* 17/2/2021 10:31:31
11903 < [Application: IBX Test Suite]
11904 < : [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))
11905 <
11906 < *Monitor* 17/2/2021 10:31:31
11907 < [Application: IBX Test Suite]
11908 < : [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))
11909 <
11910 <  SEOFReached
11911 < *Monitor* 17/2/2021 10:31:31
11912 < [Application: IBX Test Suite]
11913 < : [Commit (Hard commit)]
11914 < *Monitor* 17/2/2021 10:31:31
11915 < [Application: IBX Test Suite]
11916 < : [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
11917 <
11918 < *Monitor* 17/2/2021 10:31:31
11919 < [Application: IBX Test Suite]
11920 < : [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
11921 <
11922 < *Monitor* 17/2/2021 10:31:31
11923 < [Application: IBX Test Suite]
11924 < : [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
11925 <
11926 < *Monitor* 17/2/2021 10:31:31
11927 < [Application: IBX Test Suite]
11928 < : [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
11929 <
11930 <  SEOFReached
11931 < *Monitor* 17/2/2021 10:31:31
11932 < [Application: IBX Test Suite]
11933 < Test_Transaction_14: [Commit (Hard commit)]
11934 < *Monitor* 17/2/2021 10:31:31
11935 < [Application: IBX Test Suite]
11936 < Test_Database_14: [Disconnect]
11937 < *Monitor* 17/2/2021 10:31:31
11835 > *Monitor*  
11836   [Application: IBX Test Suite]
11837   : [Start transaction]
11838 < *Monitor* 17/2/2021 10:31:31
11838 > *Monitor*  
11839   [Application: IBX Test Suite]
11840   : [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))
11841  
11842    Plan:
11843   PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
11844 < *Monitor* 17/2/2021 10:31:31
11844 > *Monitor*  
11845   [Application: IBX Test Suite]
11846   : [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))
11847  
11848    RELATION = EMPLOYEE
11849 < *Monitor* 17/2/2021 10:31:31
11849 > *Monitor*  
11850   [Application: IBX Test Suite]
11851   : [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))
11852  
11853 < *Monitor* 17/2/2021 10:31:31
11853 > *Monitor*  
11854   [Application: IBX Test Suite]
11855   : [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))
11856  
11857 < *Monitor* 17/2/2021 10:31:31
11857 > *Monitor*  
11858   [Application: IBX Test Suite]
11859   : [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))
11860  
11861    SEOFReached
11862 < *Monitor* 17/2/2021 10:31:31
11862 > *Monitor*  
11863   [Application: IBX Test Suite]
11864   : [Commit (Hard commit)]
11865 < *Monitor* 17/2/2021 10:31:31
11865 > *Monitor*  
11866   [Application: IBX Test Suite]
11867   : [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
11868  
11869 < *Monitor* 17/2/2021 10:31:31
11869 > *Monitor*  
11870   [Application: IBX Test Suite]
11871   : [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
11872  
11873 < *Monitor* 17/2/2021 10:31:31
11873 > *Monitor*  
11874   [Application: IBX Test Suite]
11875   : [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
11876  
11877 < *Monitor* 17/2/2021 10:31:31
11877 > *Monitor*  
11878   [Application: IBX Test Suite]
11879   : [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
11880  
11881    SEOFReached
11882 < *Monitor* 17/2/2021 10:31:31
11882 > *Monitor*  
11883   [Application: IBX Test Suite]
11884   Test_Transaction_14: [Commit (Hard commit)]
11885 < *Monitor* 17/2/2021 10:31:31
11885 > *Monitor*  
11886   [Application: IBX Test Suite]
11887   Test_Database_14: [Disconnect]
11888 < *Monitor* 17/2/2021 10:31:31
11888 > *Monitor*  
11889   [Application: IBX Test Suite]
11890   Test_Database_14: [Connect]
11891 < *Monitor* 17/2/2021 10:31:31
11891 > *Monitor*  
11892   [Application: IBX Test Suite]
11893   Test_Transaction_14: [Start transaction]
11894 < *Monitor* 17/2/2021 10:31:31
11894 > *Monitor*  
11895   [Application: IBX Test Suite]
11896   : [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
11897  
11898    Plan:
11899   PLAN JOIN ((DEPTS DEPARTMENT INDEX (RDB$FOREIGN6))
11900   PLAN (DEPTS D INDEX (RDB$FOREIGN6)), A INDEX (RDB$FOREIGN8))
11901 < *Monitor* 17/2/2021 10:31:31
11901 > *Monitor*  
11902   [Application: IBX Test Suite]
11903   : [Start transaction]
11904 < *Monitor* 17/2/2021 10:31:31
11904 > *Monitor*  
11905   [Application: IBX Test Suite]
11906   : [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))
11907  
11908    Plan:
11909   PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2))
11910 < *Monitor* 17/2/2021 10:31:31
11910 > *Monitor*  
11911   [Application: IBX Test Suite]
11912   : [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))
11913  
11914    RELATION = EMPLOYEE
11915 < *Monitor* 17/2/2021 10:31:31
11915 > *Monitor*  
11916   [Application: IBX Test Suite]
11917   : [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))
11918  
11919 < *Monitor* 17/2/2021 10:31:31
11919 > *Monitor*  
11920   [Application: IBX Test Suite]
11921   : [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))
11922  
11923 < *Monitor* 17/2/2021 10:31:31
11923 > *Monitor*  
11924   [Application: IBX Test Suite]
11925   : [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))
11926  
11927    SEOFReached
11928 < *Monitor* 17/2/2021 10:31:31
11928 > *Monitor*  
11929   [Application: IBX Test Suite]
11930   : [Commit (Hard commit)]
11931 < *Monitor* 17/2/2021 10:31:31
11931 > *Monitor*  
11932   [Application: IBX Test Suite]
11933   : [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
11934  
11935 < *Monitor* 17/2/2021 10:31:31
11935 > *Monitor*  
11936   [Application: IBX Test Suite]
11937   : [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
11938  
11939 < *Monitor* 17/2/2021 10:31:31
11939 > *Monitor*  
11940   [Application: IBX Test Suite]
11941   : [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
11942  
11943 < *Monitor* 17/2/2021 10:31:31
11943 > *Monitor*  
11944   [Application: IBX Test Suite]
11945   : [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
11946  
11947    SEOFReached
11948 < *Monitor* 17/2/2021 10:31:31
11948 > *Monitor*  
11949   [Application: IBX Test Suite]
11950   Test_Transaction_14: [Commit (Hard commit)]
11951 < *Monitor* 17/2/2021 10:31:31
11951 > *Monitor*  
11952   [Application: IBX Test Suite]
11953   Test_Database_14: [Disconnect]
11954 + 33 ISQL Monitor Messages Received
11955  
11956  
11957   ------------------------------------------------------
# Line 13211 | Line 13110 | Create Table LotsOfData (
13110      MyText VarChar(1024),
13111      Primary Key (RowID)
13112    );                
13113 < Loading data into database table. Started at 17/2/2021 10:31:44.947
13114 < Data load completed at 17/2/2021 10:34:33.174 Elapsed Time = 168227 ms, 100000 records loaded
13115 < MD5 checksum = 802ff3f1509b4e82f7b52a7421e97501
13116 < Database Read started at 17/2/2021 10:34:33.179
13117 < Read Dataset completed at 17/2/2021 10:35:10.674 Elapsed Time = 37495 ms, 100000 records read
13118 < MD5 checksum = 802ff3f1509b4e82f7b52a7421e97501
13113 > Loading data into database table. Started at 18/2/2021 16:55:02.151
13114 > Data load completed at 18/2/2021 16:58:00.820 Elapsed Time = 178669 ms, 100000 records loaded
13115 > MD5 checksum = 17ea6e3376ac304ecab02428b4872b52
13116 > Database Read started at 18/2/2021 16:58:00.841
13117 > Read Dataset completed at 18/2/2021 16:58:31.837 Elapsed Time = 30997 ms, 100000 records read
13118 > MD5 checksum = 17ea6e3376ac304ecab02428b4872b52
13119   Test Completed successfully
13120  
13121  

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines