644 |
|
Current memory = 19,651,152 |
645 |
|
Delta memory = 13,040 |
646 |
|
Max memory = 19,779,424 |
647 |
< |
Elapsed time= 0.023 sec |
648 |
< |
Cpu = 0.010 sec |
647 |
> |
Elapsed time= 0.026 sec |
648 |
> |
Cpu = 0.020 sec |
649 |
|
Buffers = 2048 |
650 |
|
Reads = 2 |
651 |
|
Writes = 0 |
1445 |
|
isc_dpb_lc_ctype = UTF8 |
1446 |
|
|
1447 |
|
Before Disconnect |
1448 |
< |
inet://localhost/employee Disconnected after 23 ms |
1448 |
> |
inet://localhost/employee Disconnected after 24 ms |
1449 |
|
Before Connect |
1450 |
|
Connected to inet://localhost/employee |
1451 |
|
DPB: Item Count = 3 |
1454 |
|
isc_dpb_lc_ctype = UTF8 |
1455 |
|
|
1456 |
|
Before Disconnect |
1457 |
< |
inet://localhost/employee Disconnected after 3990 ms |
1457 |
> |
inet://localhost/employee Disconnected after 4005 ms |
1458 |
|
Idle Timer Expired for Test_Database_02 |
1459 |
|
Database Closed |
1460 |
|
Transaction Events |
1494 |
|
Transaction Ended after 2000 ms |
1495 |
|
Idle Timer Expired for Test_Transaction_02 |
1496 |
|
Before Disconnect |
1497 |
< |
inet://localhost/employee Disconnected after 2037 ms |
1497 |
> |
inet://localhost/employee Disconnected after 2036 ms |
1498 |
|
SQL Dialect Downgrade test |
1499 |
|
Before Connect |
1500 |
|
Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb |
1506 |
|
|
1507 |
|
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb created |
1508 |
|
Before Disconnect |
1509 |
< |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms |
1509 |
> |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 24 ms |
1510 |
|
Before Connect |
1511 |
|
Warning: SQL Dialect Downgrade of inet://localhost//tmp/ibx-testsuite/testsuite1.fdb |
1512 |
|
Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb |
1516 |
|
isc_dpb_lc_ctype = UTF8 |
1517 |
|
|
1518 |
|
Before Disconnect |
1519 |
< |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 21 ms |
1519 |
> |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 26 ms |
1520 |
|
|
1521 |
|
|
1522 |
|
------------------------------------------------------ |
11659 |
|
Database Statistics for employee |
11660 |
|
|
11661 |
|
Database "/opt/firebird3.0.5/examples/empbuild/employee.fdb" |
11662 |
< |
Gstat execution time Wed Feb 17 10:39:32 2021 |
11662 |
> |
Gstat execution time Thu Feb 18 17:01:35 2021 |
11663 |
|
|
11664 |
|
Database header page information: |
11665 |
|
Flags 0 |
11666 |
< |
Generation 1865 |
11666 |
> |
Generation 1989 |
11667 |
|
System Change Number 0 |
11668 |
|
Page size 8192 |
11669 |
|
ODS version 12.0 |
11670 |
< |
Oldest transaction 2037 |
11671 |
< |
Oldest active 2038 |
11672 |
< |
Oldest snapshot 2038 |
11673 |
< |
Next transaction 2038 |
11670 |
> |
Oldest transaction 2191 |
11671 |
> |
Oldest active 2192 |
11672 |
> |
Oldest snapshot 2192 |
11673 |
> |
Next transaction 2192 |
11674 |
|
Sequence number 0 |
11675 |
< |
Next attachment ID 1752 |
11675 |
> |
Next attachment ID 1924 |
11676 |
|
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc |
11677 |
|
Shadow count 0 |
11678 |
|
Page buffers 0 |
11819 |
|
60 - 79% = 0 |
11820 |
|
80 - 99% = 0 |
11821 |
|
|
11822 |
< |
Gstat completion time Wed Feb 17 10:39:32 2021 |
11822 |
> |
Gstat completion time Thu Feb 18 17:01:35 2021 |
11823 |
|
|
11824 |
|
|
11825 |
|
|
11829 |
|
bin/fbguard: guardian starting /opt/firebird3.0.5/bin/firebird |
11830 |
|
|
11831 |
|
Online Validation |
11832 |
< |
10:39:32.49 Validation started |
11832 |
> |
17:01:36.08 Validation started |
11833 |
|
|
11834 |
< |
10:39:32.49 Relation 128 (COUNTRY) |
11835 |
< |
10:39:32.49 process pointer page 0 of 1 |
11836 |
< |
10:39:32.49 Index 1 (RDB$PRIMARY1) |
11837 |
< |
10:39:32.49 Relation 128 (COUNTRY) is ok |
11838 |
< |
|
11839 |
< |
10:39:32.49 Relation 129 (JOB) |
11840 |
< |
10:39:32.49 process pointer page 0 of 1 |
11841 |
< |
10:39:32.49 Index 1 (RDB$PRIMARY2) |
11842 |
< |
10:39:32.49 Index 2 (RDB$FOREIGN3) |
11843 |
< |
10:39:32.49 Index 3 (MAXSALX) |
11844 |
< |
10:39:32.49 Index 4 (MINSALX) |
11845 |
< |
10:39:32.49 Relation 129 (JOB) is ok |
11846 |
< |
|
11847 |
< |
10:39:32.49 Relation 130 (DEPARTMENT) |
11848 |
< |
10:39:32.49 process pointer page 0 of 1 |
11849 |
< |
10:39:32.49 Index 1 (RDB$4) |
11850 |
< |
10:39:32.49 Index 2 (RDB$PRIMARY5) |
11851 |
< |
10:39:32.49 Index 3 (RDB$FOREIGN6) |
11852 |
< |
10:39:32.49 Index 4 (BUDGETX) |
11853 |
< |
10:39:32.49 Index 5 (RDB$FOREIGN10) |
11854 |
< |
10:39:32.49 Relation 130 (DEPARTMENT) is ok |
11855 |
< |
|
11856 |
< |
10:39:32.49 Relation 131 (EMPLOYEE) |
11857 |
< |
10:39:32.49 process pointer page 0 of 1 |
11858 |
< |
10:39:32.49 Index 1 (RDB$PRIMARY7) |
11859 |
< |
10:39:32.49 Index 2 (RDB$FOREIGN8) |
11860 |
< |
10:39:32.49 Index 3 (RDB$FOREIGN9) |
11861 |
< |
10:39:32.49 Index 4 (NAMEX) |
11862 |
< |
10:39:32.49 Relation 131 (EMPLOYEE) is ok |
11863 |
< |
|
11864 |
< |
10:39:32.49 Relation 133 (PROJECT) |
11865 |
< |
10:39:32.49 process pointer page 0 of 1 |
11866 |
< |
10:39:32.49 Index 1 (RDB$11) |
11867 |
< |
10:39:32.49 Index 2 (RDB$PRIMARY12) |
11868 |
< |
10:39:32.49 Index 3 (RDB$FOREIGN13) |
11869 |
< |
10:39:32.49 Index 4 (PRODTYPEX) |
11870 |
< |
10:39:32.49 Relation 133 (PROJECT) is ok |
11871 |
< |
|
11872 |
< |
10:39:32.49 Relation 134 (EMPLOYEE_PROJECT) |
11873 |
< |
10:39:32.49 process pointer page 0 of 1 |
11874 |
< |
10:39:32.49 Index 1 (RDB$PRIMARY14) |
11875 |
< |
10:39:32.49 Index 2 (RDB$FOREIGN15) |
11876 |
< |
10:39:32.50 Index 3 (RDB$FOREIGN16) |
11877 |
< |
10:39:32.50 Relation 134 (EMPLOYEE_PROJECT) is ok |
11878 |
< |
|
11879 |
< |
10:39:32.50 Relation 135 (PROJ_DEPT_BUDGET) |
11880 |
< |
10:39:32.50 process pointer page 0 of 1 |
11881 |
< |
10:39:32.50 Index 1 (RDB$PRIMARY17) |
11882 |
< |
10:39:32.50 Index 2 (RDB$FOREIGN18) |
11883 |
< |
10:39:32.50 Index 3 (RDB$FOREIGN19) |
11884 |
< |
10:39:32.50 Relation 135 (PROJ_DEPT_BUDGET) is ok |
11885 |
< |
|
11886 |
< |
10:39:32.50 Relation 136 (SALARY_HISTORY) |
11887 |
< |
10:39:32.50 process pointer page 0 of 1 |
11888 |
< |
10:39:32.50 Index 1 (RDB$PRIMARY20) |
11889 |
< |
10:39:32.50 Index 2 (RDB$FOREIGN21) |
11890 |
< |
10:39:32.50 Index 3 (CHANGEX) |
11891 |
< |
10:39:32.50 Index 4 (UPDATERX) |
11892 |
< |
10:39:32.50 Relation 136 (SALARY_HISTORY) is ok |
11893 |
< |
|
11894 |
< |
10:39:32.50 Relation 137 (CUSTOMER) |
11895 |
< |
10:39:32.50 process pointer page 0 of 1 |
11896 |
< |
10:39:32.50 Index 1 (RDB$PRIMARY22) |
11897 |
< |
10:39:32.50 Index 2 (RDB$FOREIGN23) |
11898 |
< |
10:39:32.50 Index 3 (CUSTNAMEX) |
11899 |
< |
10:39:32.50 Index 4 (CUSTREGION) |
11900 |
< |
10:39:32.50 Relation 137 (CUSTOMER) is ok |
11901 |
< |
|
11902 |
< |
10:39:32.50 Relation 138 (SALES) |
11903 |
< |
10:39:32.50 process pointer page 0 of 1 |
11904 |
< |
10:39:32.50 Index 1 (RDB$PRIMARY24) |
11905 |
< |
10:39:32.50 Index 2 (RDB$FOREIGN25) |
11906 |
< |
10:39:32.51 Index 3 (RDB$FOREIGN26) |
11907 |
< |
10:39:32.51 Index 4 (NEEDX) |
11908 |
< |
10:39:32.51 Index 5 (QTYX) |
11909 |
< |
10:39:32.51 Index 6 (SALESTATX) |
11910 |
< |
10:39:32.51 Relation 138 (SALES) is ok |
11834 |
> |
17:01:36.08 Relation 128 (COUNTRY) |
11835 |
> |
17:01:36.08 process pointer page 0 of 1 |
11836 |
> |
17:01:36.08 Index 1 (RDB$PRIMARY1) |
11837 |
> |
17:01:36.08 Relation 128 (COUNTRY) is ok |
11838 |
> |
|
11839 |
> |
17:01:36.08 Relation 129 (JOB) |
11840 |
> |
17:01:36.08 process pointer page 0 of 1 |
11841 |
> |
17:01:36.08 Index 1 (RDB$PRIMARY2) |
11842 |
> |
17:01:36.08 Index 2 (RDB$FOREIGN3) |
11843 |
> |
17:01:36.08 Index 3 (MAXSALX) |
11844 |
> |
17:01:36.08 Index 4 (MINSALX) |
11845 |
> |
17:01:36.08 Relation 129 (JOB) is ok |
11846 |
> |
|
11847 |
> |
17:01:36.08 Relation 130 (DEPARTMENT) |
11848 |
> |
17:01:36.08 process pointer page 0 of 1 |
11849 |
> |
17:01:36.08 Index 1 (RDB$4) |
11850 |
> |
17:01:36.08 Index 2 (RDB$PRIMARY5) |
11851 |
> |
17:01:36.08 Index 3 (RDB$FOREIGN6) |
11852 |
> |
17:01:36.08 Index 4 (BUDGETX) |
11853 |
> |
17:01:36.08 Index 5 (RDB$FOREIGN10) |
11854 |
> |
17:01:36.08 Relation 130 (DEPARTMENT) is ok |
11855 |
> |
|
11856 |
> |
17:01:36.08 Relation 131 (EMPLOYEE) |
11857 |
> |
17:01:36.08 process pointer page 0 of 1 |
11858 |
> |
17:01:36.08 Index 1 (RDB$PRIMARY7) |
11859 |
> |
17:01:36.08 Index 2 (RDB$FOREIGN8) |
11860 |
> |
17:01:36.08 Index 3 (RDB$FOREIGN9) |
11861 |
> |
17:01:36.08 Index 4 (NAMEX) |
11862 |
> |
17:01:36.08 Relation 131 (EMPLOYEE) is ok |
11863 |
> |
|
11864 |
> |
17:01:36.08 Relation 133 (PROJECT) |
11865 |
> |
17:01:36.08 process pointer page 0 of 1 |
11866 |
> |
17:01:36.08 Index 1 (RDB$11) |
11867 |
> |
17:01:36.08 Index 2 (RDB$PRIMARY12) |
11868 |
> |
17:01:36.08 Index 3 (RDB$FOREIGN13) |
11869 |
> |
17:01:36.08 Index 4 (PRODTYPEX) |
11870 |
> |
17:01:36.08 Relation 133 (PROJECT) is ok |
11871 |
> |
|
11872 |
> |
17:01:36.08 Relation 134 (EMPLOYEE_PROJECT) |
11873 |
> |
17:01:36.08 process pointer page 0 of 1 |
11874 |
> |
17:01:36.08 Index 1 (RDB$PRIMARY14) |
11875 |
> |
17:01:36.09 Index 2 (RDB$FOREIGN15) |
11876 |
> |
17:01:36.09 Index 3 (RDB$FOREIGN16) |
11877 |
> |
17:01:36.09 Relation 134 (EMPLOYEE_PROJECT) is ok |
11878 |
> |
|
11879 |
> |
17:01:36.09 Relation 135 (PROJ_DEPT_BUDGET) |
11880 |
> |
17:01:36.09 process pointer page 0 of 1 |
11881 |
> |
17:01:36.09 Index 1 (RDB$PRIMARY17) |
11882 |
> |
17:01:36.09 Index 2 (RDB$FOREIGN18) |
11883 |
> |
17:01:36.09 Index 3 (RDB$FOREIGN19) |
11884 |
> |
17:01:36.09 Relation 135 (PROJ_DEPT_BUDGET) is ok |
11885 |
> |
|
11886 |
> |
17:01:36.09 Relation 136 (SALARY_HISTORY) |
11887 |
> |
17:01:36.09 process pointer page 0 of 1 |
11888 |
> |
17:01:36.09 Index 1 (RDB$PRIMARY20) |
11889 |
> |
17:01:36.09 Index 2 (RDB$FOREIGN21) |
11890 |
> |
17:01:36.09 Index 3 (CHANGEX) |
11891 |
> |
17:01:36.09 Index 4 (UPDATERX) |
11892 |
> |
17:01:36.09 Relation 136 (SALARY_HISTORY) is ok |
11893 |
> |
|
11894 |
> |
17:01:36.09 Relation 137 (CUSTOMER) |
11895 |
> |
17:01:36.09 process pointer page 0 of 1 |
11896 |
> |
17:01:36.09 Index 1 (RDB$PRIMARY22) |
11897 |
> |
17:01:36.09 Index 2 (RDB$FOREIGN23) |
11898 |
> |
17:01:36.09 Index 3 (CUSTNAMEX) |
11899 |
> |
17:01:36.09 Index 4 (CUSTREGION) |
11900 |
> |
17:01:36.09 Relation 137 (CUSTOMER) is ok |
11901 |
> |
|
11902 |
> |
17:01:36.10 Relation 138 (SALES) |
11903 |
> |
17:01:36.10 process pointer page 0 of 1 |
11904 |
> |
17:01:36.10 Index 1 (RDB$PRIMARY24) |
11905 |
> |
17:01:36.10 Index 2 (RDB$FOREIGN25) |
11906 |
> |
17:01:36.10 Index 3 (RDB$FOREIGN26) |
11907 |
> |
17:01:36.10 Index 4 (NEEDX) |
11908 |
> |
17:01:36.10 Index 5 (QTYX) |
11909 |
> |
17:01:36.10 Index 6 (SALESTATX) |
11910 |
> |
17:01:36.10 Relation 138 (SALES) is ok |
11911 |
|
|
11912 |
< |
10:39:32.51 Validation finished |
11912 |
> |
17:01:36.10 Validation finished |
11913 |
|
|
11914 |
|
|
11915 |
|
Normal Validation |
13241 |
|
|
13242 |
|
Rows printed = 2 |
13243 |
|
|
13244 |
< |
*Monitor* 17/2/2021 10:39:34.784 |
13245 |
< |
[Application: IBX Test Suite] |
13244 |
> |
33 ISQL Monitor Messages Received |
13245 |
> |
33 ISQL Monitor Messages written |
13246 |
> |
*Monitor* |
13247 |
> |
[Application: IBX Test Suite] |
13248 |
|
Test_Database_13: [Connect] |
13249 |
< |
*Monitor* 17/2/2021 10:39:34.784 |
13250 |
< |
[Application: IBX Test Suite] |
13249 |
> |
*Monitor* |
13250 |
> |
[Application: IBX Test Suite] |
13251 |
|
Test_Transaction_13: [Start transaction] |
13252 |
< |
*Monitor* 17/2/2021 10:39:34.794 |
13253 |
< |
[Application: IBX Test Suite] |
13252 |
> |
*Monitor* |
13253 |
> |
[Application: IBX Test Suite] |
13254 |
|
: [Prepare] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13255 |
< |
|
13255 |
> |
|
13256 |
|
Plan: |
13257 |
|
Select Expression |
13258 |
|
-> First N Records |
13261 |
|
-> Filter |
13262 |
|
-> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID |
13263 |
|
-> Bitmap |
13264 |
< |
|
13263 |
< |
*Monitor* 17/2/2021 10:39:34.794 -> Index "RDB$FOREIGN6" Range Scan (full match) |
13264 |
> |
-> Index "RDB$FOREIGN6" Range Scan (full match) |
13265 |
|
-> Filter |
13266 |
|
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
13267 |
|
-> Bitmap |
13270 |
|
-> Table "EMPLOYEE" as "A" Access By ID |
13271 |
|
-> Bitmap |
13272 |
|
-> Index "RDB$FOREIGN8" Range Scan (full match) |
13273 |
< |
*Monitor* 17/2/2021 10:39:34.803 |
13274 |
< |
[Application: IBX Test Suite] |
13273 |
> |
*Monitor* |
13274 |
> |
[Application: IBX Test Suite] |
13275 |
|
: [Start transaction] |
13276 |
< |
*Monitor* 17/2/2021 10:39:34.810 |
13277 |
< |
[Application: IBX Test Suite] |
13276 |
> |
*Monitor* |
13277 |
> |
[Application: IBX Test Suite] |
13278 |
|
: [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13279 |
< |
|
13279 |
> |
|
13280 |
|
Plan: |
13281 |
|
Select Expression |
13282 |
|
-> Nested Loop Join (inner) |
13288 |
|
-> Table "RDB$FIELDS" as "F" Access By ID |
13289 |
|
-> Bitmap |
13290 |
|
-> Index "RDB$INDEX_2" Unique Scan |
13291 |
< |
*Monitor* 17/2/2021 10:39:34.810 |
13292 |
< |
[Application: IBX Test Suite] |
13291 |
> |
*Monitor* |
13292 |
> |
[Application: IBX Test Suite] |
13293 |
|
: [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13294 |
< |
|
13294 |
> |
|
13295 |
|
RELATION = EMPLOYEE |
13296 |
< |
*Monitor* 17/2/2021 10:39:34.811 |
13297 |
< |
[Application: IBX Test Suite] |
13296 |
> |
*Monitor* |
13297 |
> |
[Application: IBX Test Suite] |
13298 |
|
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13299 |
|
|
13300 |
< |
*Monitor* 17/2/2021 10:39:34.811 |
13301 |
< |
[Application: IBX Test Suite] |
13300 |
> |
*Monitor* |
13301 |
> |
[Application: IBX Test Suite] |
13302 |
|
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13303 |
|
|
13304 |
< |
*Monitor* 17/2/2021 10:39:34.811 |
13305 |
< |
[Application: IBX Test Suite] |
13304 |
> |
*Monitor* |
13305 |
> |
[Application: IBX Test Suite] |
13306 |
|
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13307 |
< |
|
13307 |
> |
|
13308 |
|
SEOFReached |
13309 |
< |
*Monitor* 17/2/2021 10:39:34.813 |
13310 |
< |
[Application: IBX Test Suite] |
13309 |
> |
*Monitor* |
13310 |
> |
[Application: IBX Test Suite] |
13311 |
|
: [Commit (Hard commit)] |
13312 |
< |
*Monitor* 17/2/2021 10:39:34.820 |
13313 |
< |
[Application: IBX Test Suite] |
13312 |
> |
*Monitor* |
13313 |
> |
[Application: IBX Test Suite] |
13314 |
|
: [Execute] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13315 |
|
|
13316 |
< |
*Monitor* 17/2/2021 10:39:34.821 |
13317 |
< |
[Application: IBX Test Suite] |
13316 |
> |
*Monitor* |
13317 |
> |
[Application: IBX Test Suite] |
13318 |
|
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13319 |
|
|
13320 |
< |
*Monitor* 17/2/2021 10:39:34.822 |
13321 |
< |
[Application: IBX Test Suite] |
13320 |
> |
*Monitor* |
13321 |
> |
[Application: IBX Test Suite] |
13322 |
|
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13323 |
|
|
13324 |
< |
*Monitor* 17/2/2021 10:39:34.822 |
13325 |
< |
[Application: IBX Test Suite] |
13324 |
> |
*Monitor* |
13325 |
> |
[Application: IBX Test Suite] |
13326 |
|
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13327 |
< |
|
13327 |
> |
|
13328 |
|
SEOFReached |
13329 |
< |
*Monitor* 17/2/2021 10:39:34.823 |
13330 |
< |
[Application: IBX Test Suite] |
13329 |
> |
*Monitor* |
13330 |
> |
[Application: IBX Test Suite] |
13331 |
|
Test_Transaction_13: [Commit (Hard commit)] |
13332 |
< |
*Monitor* 17/2/2021 10:39:34.836 |
13333 |
< |
[Application: IBX Test Suite] |
13332 |
> |
*Monitor* |
13333 |
> |
[Application: IBX Test Suite] |
13334 |
|
Test_Database_13: [Disconnect] |
13335 |
< |
*Monitor* 17/2/2021 10:39:34.888 |
13336 |
< |
[Application: IBX Test Suite] |
13335 |
> |
*Monitor* |
13336 |
> |
[Application: IBX Test Suite] |
13337 |
|
Test_Database_13: [Connect] |
13338 |
< |
*Monitor* 17/2/2021 10:39:34.889 |
13339 |
< |
[Application: IBX Test Suite] |
13338 |
> |
*Monitor* |
13339 |
> |
[Application: IBX Test Suite] |
13340 |
|
Test_Transaction_13: [Start transaction] |
13341 |
< |
*Monitor* 17/2/2021 10:39:34.899 |
13342 |
< |
[Application: IBX Test Suite] |
13341 |
> |
*Monitor* |
13342 |
> |
[Application: IBX Test Suite] |
13343 |
|
: [Prepare] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13344 |
< |
|
13344 |
> |
|
13345 |
|
Plan: |
13346 |
|
Select Expression |
13347 |
|
-> First N Records |
13350 |
|
-> Filter |
13351 |
|
-> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID |
13352 |
|
-> Bitmap |
13353 |
< |
|
13353 |
< |
*Monitor* 17/2/2021 10:39:34.899 -> Index "RDB$FOREIGN6" Range Scan (full match) |
13353 |
> |
-> Index "RDB$FOREIGN6" Range Scan (full match) |
13354 |
|
-> Filter |
13355 |
|
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
13356 |
|
-> Bitmap |
13359 |
|
-> Table "EMPLOYEE" as "A" Access By ID |
13360 |
|
-> Bitmap |
13361 |
|
-> Index "RDB$FOREIGN8" Range Scan (full match) |
13362 |
< |
*Monitor* 17/2/2021 10:39:34.908 |
13363 |
< |
[Application: IBX Test Suite] |
13362 |
> |
*Monitor* |
13363 |
> |
[Application: IBX Test Suite] |
13364 |
|
: [Start transaction] |
13365 |
< |
*Monitor* 17/2/2021 10:39:34.913 |
13366 |
< |
[Application: IBX Test Suite] |
13365 |
> |
*Monitor* |
13366 |
> |
[Application: IBX Test Suite] |
13367 |
|
: [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13368 |
< |
|
13368 |
> |
|
13369 |
|
Plan: |
13370 |
|
Select Expression |
13371 |
|
-> Nested Loop Join (inner) |
13377 |
|
-> Table "RDB$FIELDS" as "F" Access By ID |
13378 |
|
-> Bitmap |
13379 |
|
-> Index "RDB$INDEX_2" Unique Scan |
13380 |
< |
*Monitor* 17/2/2021 10:39:34.913 |
13381 |
< |
[Application: IBX Test Suite] |
13380 |
> |
*Monitor* |
13381 |
> |
[Application: IBX Test Suite] |
13382 |
|
: [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13383 |
< |
|
13383 |
> |
|
13384 |
|
RELATION = EMPLOYEE |
13385 |
< |
*Monitor* 17/2/2021 10:39:34.914 |
13386 |
< |
[Application: IBX Test Suite] |
13385 |
> |
*Monitor* |
13386 |
> |
[Application: IBX Test Suite] |
13387 |
|
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13388 |
|
|
13389 |
< |
*Monitor* 17/2/2021 10:39:34.914 |
13390 |
< |
[Application: IBX Test Suite] |
13389 |
> |
*Monitor* |
13390 |
> |
[Application: IBX Test Suite] |
13391 |
|
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13392 |
|
|
13393 |
< |
*Monitor* 17/2/2021 10:39:34.914 |
13394 |
< |
[Application: IBX Test Suite] |
13393 |
> |
*Monitor* |
13394 |
> |
[Application: IBX Test Suite] |
13395 |
|
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
13396 |
< |
|
13396 |
> |
|
13397 |
|
SEOFReached |
13398 |
< |
*Monitor* 17/2/2021 10:39:34.920 |
13399 |
< |
[Application: IBX Test Suite] |
13398 |
> |
*Monitor* |
13399 |
> |
[Application: IBX Test Suite] |
13400 |
|
: [Commit (Hard commit)] |
13401 |
< |
*Monitor* 17/2/2021 10:39:34.922 |
13402 |
< |
[Application: IBX Test Suite] |
13401 |
> |
*Monitor* |
13402 |
> |
[Application: IBX Test Suite] |
13403 |
|
: [Execute] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13404 |
|
|
13405 |
< |
*Monitor* 17/2/2021 10:39:34.924 |
13406 |
< |
[Application: IBX Test Suite] |
13405 |
> |
*Monitor* |
13406 |
> |
[Application: IBX Test Suite] |
13407 |
|
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13408 |
|
|
13409 |
< |
*Monitor* 17/2/2021 10:39:34.924 |
13410 |
< |
[Application: IBX Test Suite] |
13409 |
> |
*Monitor* |
13410 |
> |
[Application: IBX Test Suite] |
13411 |
|
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13412 |
|
|
13413 |
< |
*Monitor* 17/2/2021 10:39:34.925 |
13414 |
< |
[Application: IBX Test Suite] |
13413 |
> |
*Monitor* |
13414 |
> |
[Application: IBX Test Suite] |
13415 |
|
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13416 |
< |
|
13416 |
> |
|
13417 |
|
SEOFReached |
13418 |
< |
*Monitor* 17/2/2021 10:39:34.926 |
13419 |
< |
[Application: IBX Test Suite] |
13418 |
> |
*Monitor* |
13419 |
> |
[Application: IBX Test Suite] |
13420 |
|
Test_Transaction_13: [Commit (Hard commit)] |
13421 |
< |
*Monitor* 17/2/2021 10:39:34.936 |
13422 |
< |
[Application: IBX Test Suite] |
13421 |
> |
*Monitor* |
13422 |
> |
[Application: IBX Test Suite] |
13423 |
|
Test_Database_13: [Disconnect] |
13424 |
+ |
33 ISQL Monitor Messages Received |
13425 |
|
|
13426 |
|
|
13427 |
|
------------------------------------------------------ |
13462 |
|
Current memory = 19,651,616 |
13463 |
|
Delta memory = 12,688 |
13464 |
|
Max memory = 19,780,240 |
13465 |
< |
Elapsed time= 0.002 sec |
13465 |
> |
Elapsed time= 0.102 sec |
13466 |
|
Cpu = 0.000 sec |
13467 |
|
Buffers = 2048 |
13468 |
|
Reads = 2 |
13506 |
|
|
13507 |
|
Rows printed = 2 |
13508 |
|
|
13509 |
< |
*Monitor* 17/2/2021 10:31:31 |
13510 |
< |
[Application: IBX Test Suite] |
13510 |
< |
: [Start transaction] |
13511 |
< |
*Monitor* 17/2/2021 10:31:31 |
13512 |
< |
[Application: IBX Test Suite] |
13513 |
< |
: [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13514 |
< |
|
13515 |
< |
Plan: |
13516 |
< |
PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2)) |
13517 |
< |
*Monitor* 17/2/2021 10:31:31 |
13518 |
< |
[Application: IBX Test Suite] |
13519 |
< |
: [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13520 |
< |
|
13521 |
< |
RELATION = EMPLOYEE |
13522 |
< |
*Monitor* 17/2/2021 10:31:31 |
13523 |
< |
[Application: IBX Test Suite] |
13524 |
< |
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13525 |
< |
|
13526 |
< |
*Monitor* 17/2/2021 10:31:31 |
13527 |
< |
[Application: IBX Test Suite] |
13528 |
< |
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13529 |
< |
|
13530 |
< |
*Monitor* 17/2/2021 10:31:31 |
13531 |
< |
[Application: IBX Test Suite] |
13532 |
< |
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13533 |
< |
|
13534 |
< |
SEOFReached |
13535 |
< |
*Monitor* 17/2/2021 10:31:31 |
13536 |
< |
[Application: IBX Test Suite] |
13537 |
< |
: [Commit (Hard commit)] |
13538 |
< |
*Monitor* 17/2/2021 10:31:31 |
13539 |
< |
[Application: IBX Test Suite] |
13540 |
< |
: [Execute] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13541 |
< |
|
13542 |
< |
*Monitor* 17/2/2021 10:31:31 |
13543 |
< |
[Application: IBX Test Suite] |
13544 |
< |
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13545 |
< |
|
13546 |
< |
*Monitor* 17/2/2021 10:31:31 |
13547 |
< |
[Application: IBX Test Suite] |
13548 |
< |
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13549 |
< |
|
13550 |
< |
*Monitor* 17/2/2021 10:31:31 |
13551 |
< |
[Application: IBX Test Suite] |
13552 |
< |
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13553 |
< |
|
13554 |
< |
SEOFReached |
13555 |
< |
*Monitor* 17/2/2021 10:31:31 |
13556 |
< |
[Application: IBX Test Suite] |
13557 |
< |
Test_Transaction_14: [Commit (Hard commit)] |
13558 |
< |
*Monitor* 17/2/2021 10:31:31 |
13559 |
< |
[Application: IBX Test Suite] |
13560 |
< |
Test_Database_14: [Disconnect] |
13561 |
< |
*Monitor* 17/2/2021 10:31:31 |
13509 |
> |
33 ISQL Monitor Messages written |
13510 |
> |
*Monitor* |
13511 |
|
[Application: IBX Test Suite] |
13512 |
|
Test_Database_14: [Connect] |
13513 |
< |
*Monitor* 17/2/2021 10:31:31 |
13513 |
> |
*Monitor* |
13514 |
|
[Application: IBX Test Suite] |
13515 |
|
Test_Transaction_14: [Start transaction] |
13516 |
< |
*Monitor* 17/2/2021 10:31:31 |
13568 |
< |
[Application: IBX Test Suite] |
13569 |
< |
: [Prepare] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13570 |
< |
|
13571 |
< |
Plan: |
13572 |
< |
PLAN JOIN ((DEPTS DEPARTMENT INDEX (RDB$FOREIGN6)) |
13573 |
< |
PLAN (DEPTS D INDEX (RDB$FOREIGN6)), A INDEX (RDB$FOREIGN8)) |
13574 |
< |
*Monitor* 17/2/2021 10:31:31 |
13575 |
< |
[Application: IBX Test Suite] |
13576 |
< |
: [Start transaction] |
13577 |
< |
*Monitor* 17/2/2021 10:31:31 |
13578 |
< |
[Application: IBX Test Suite] |
13579 |
< |
: [Prepare] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13580 |
< |
|
13581 |
< |
Plan: |
13582 |
< |
PLAN JOIN (R INDEX (RDB$INDEX_4), F INDEX (RDB$INDEX_2)) |
13583 |
< |
*Monitor* 17/2/2021 10:31:31 |
13584 |
< |
[Application: IBX Test Suite] |
13585 |
< |
: [Execute] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13586 |
< |
|
13587 |
< |
RELATION = EMPLOYEE |
13588 |
< |
*Monitor* 17/2/2021 10:31:31 |
13589 |
< |
[Application: IBX Test Suite] |
13590 |
< |
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13591 |
< |
|
13592 |
< |
*Monitor* 17/2/2021 10:31:31 |
13593 |
< |
[Application: IBX Test Suite] |
13594 |
< |
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13595 |
< |
|
13596 |
< |
*Monitor* 17/2/2021 10:31:31 |
13597 |
< |
[Application: IBX Test Suite] |
13598 |
< |
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL)) |
13599 |
< |
|
13600 |
< |
SEOFReached |
13601 |
< |
*Monitor* 17/2/2021 10:31:31 |
13602 |
< |
[Application: IBX Test Suite] |
13603 |
< |
: [Commit (Hard commit)] |
13604 |
< |
*Monitor* 17/2/2021 10:31:31 |
13605 |
< |
[Application: IBX Test Suite] |
13606 |
< |
: [Execute] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13607 |
< |
|
13608 |
< |
*Monitor* 17/2/2021 10:31:31 |
13609 |
< |
[Application: IBX Test Suite] |
13610 |
< |
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13611 |
< |
|
13612 |
< |
*Monitor* 17/2/2021 10:31:31 |
13613 |
< |
[Application: IBX Test Suite] |
13614 |
< |
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13615 |
< |
|
13616 |
< |
*Monitor* 17/2/2021 10:31:31 |
13617 |
< |
[Application: IBX Test Suite] |
13618 |
< |
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
13619 |
< |
|
13620 |
< |
SEOFReached |
13621 |
< |
*Monitor* 17/2/2021 10:31:31 |
13622 |
< |
[Application: IBX Test Suite] |
13623 |
< |
Test_Transaction_14: [Commit (Hard commit)] |
13624 |
< |
*Monitor* 17/2/2021 10:31:31 |
13625 |
< |
[Application: IBX Test Suite] |
13626 |
< |
Test_Database_14: [Disconnect] |
13627 |
< |
|