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