| 644 |
|
Current memory = 19,670,464 |
| 645 |
|
Delta memory = 16,384 |
| 646 |
|
Max memory = 19,765,360 |
| 647 |
< |
Elapsed time= 0.031 sec |
| 648 |
< |
Cpu = 0.020 sec |
| 647 |
> |
Elapsed time= 0.027 sec |
| 648 |
> |
Cpu = 0.010 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 18 ms |
| 1448 |
> |
inet://localhost/employee Disconnected after 16 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 4013 ms |
| 1457 |
> |
inet://localhost/employee Disconnected after 4023 ms |
| 1458 |
|
Idle Timer Expired for Test_Database_02 |
| 1459 |
|
Database Closed |
| 1460 |
|
Transaction Events |
| 1477 |
|
isc_tpb_read |
| 1478 |
|
|
| 1479 |
|
Transaction Ending |
| 1480 |
< |
Transaction Ended after 0 ms |
| 1480 |
> |
Transaction Ended after 1 ms |
| 1481 |
|
Transaction idle timer test |
| 1482 |
|
Requested TPB: Item Count = 3 |
| 1483 |
|
isc_tpb_concurrency |
| 1494 |
|
Transaction Ended after 2001 ms |
| 1495 |
|
Idle Timer Expired for Test_Transaction_02 |
| 1496 |
|
Before Disconnect |
| 1497 |
< |
inet://localhost/employee Disconnected after 2079 ms |
| 1497 |
> |
inet://localhost/employee Disconnected after 2042 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 16 ms |
| 1509 |
> |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 26 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 |
| 2393 |
|
F3 DecFloat(16), |
| 2394 |
|
F4 DecFloat(34), |
| 2395 |
|
F5 Numeric (24,6), |
| 2396 |
+ |
F6 INT128, |
| 2397 |
|
Primary Key(TableKey) |
| 2398 |
|
) SQL SECURITY DEFINER; |
| 2399 |
|
|
| 2419 |
|
F3 DECFLOAT(16), |
| 2420 |
|
F4 DECFLOAT(34), |
| 2421 |
|
F5 NUMERIC(24, 6), |
| 2422 |
+ |
F6 INT128, |
| 2423 |
|
PRIMARY KEY (TABLEKEY) |
| 2424 |
|
) SQL SECURITY DEFINER; |
| 2425 |
|
|
| 2442 |
|
F3 = 12345678912.1200 |
| 2443 |
|
F4 = 64100000000.011 |
| 2444 |
|
F5 = 123456123456123456123456.123456 |
| 2445 |
+ |
F6 = 123456789123456789 |
| 2446 |
|
|
| 2447 |
|
Rows printed = 1 |
| 2448 |
|
|
| 2456 |
|
F3 = 12345678912.1200 |
| 2457 |
|
F4 = 64100000000.011 |
| 2458 |
|
F5 = 123456123456123456123456.123456 |
| 2459 |
+ |
F6 = 123456789123456789 |
| 2460 |
|
|
| 2461 |
|
Rows printed = 1 |
| 2462 |
|
|
| 2468 |
|
F3 = 12345678912.1200 |
| 2469 |
|
F4 = 64100000000.011 |
| 2470 |
|
F5 = 123456123456123456123456.123456 |
| 2471 |
+ |
F6 = 123456789123456789 |
| 2472 |
|
|
| 2473 |
|
Rows printed = 1 |
| 2474 |
|
|
| 2480 |
|
F3 = 12345678912.1200 |
| 2481 |
|
F4 = 64100000000.011 |
| 2482 |
|
F5 = 123456123456123456123456.123456 |
| 2483 |
+ |
F6 = 123456789123456789 |
| 2484 |
|
|
| 2485 |
|
Rows printed = 1 |
| 2486 |
|
|
| 2492 |
|
F3 = 12345678912.1200 |
| 2493 |
|
F4 = 64100000000.011 |
| 2494 |
|
F5 = 123456123456123456123456.123456 |
| 2495 |
+ |
F6 = 123456789123456789 |
| 2496 |
|
|
| 2497 |
|
Rows printed = 1 |
| 2498 |
|
|
| 2504 |
|
F3 = 12345678912.1200 |
| 2505 |
|
F4 = 64100000000.011 |
| 2506 |
|
F5 = 123456123456123456123456.123456 |
| 2507 |
+ |
F6 = 123456789123456789 |
| 2508 |
|
|
| 2509 |
|
Rows printed = 1 |
| 2510 |
|
|
| 3300 |
|
Current memory = 19,651,184 |
| 3301 |
|
Delta memory = 16,416 |
| 3302 |
|
Max memory = 19,746,848 |
| 3303 |
< |
Elapsed time= 0.026 sec |
| 3304 |
< |
Cpu = 0.020 sec |
| 3303 |
> |
Elapsed time= 0.024 sec |
| 3304 |
> |
Cpu = 0.000 sec |
| 3305 |
|
Buffers = 2048 |
| 3306 |
|
Reads = 2 |
| 3307 |
|
Writes = 0 |
| 11779 |
|
Database Statistics for employee |
| 11780 |
|
|
| 11781 |
|
Database "/opt/firebird4rc1/examples/empbuild/employee.fdb" |
| 11782 |
< |
Gstat execution time Wed Feb 17 10:45:05 2021 |
| 11782 |
> |
Gstat execution time Thu Feb 18 17:07:27 2021 |
| 11783 |
|
|
| 11784 |
|
Database header page information: |
| 11785 |
|
Flags 0 |
| 11786 |
< |
Generation 659 |
| 11786 |
> |
Generation 1016 |
| 11787 |
|
System Change Number 0 |
| 11788 |
|
Page size 8192 |
| 11789 |
|
ODS version 13.0 |
| 11790 |
< |
Oldest transaction 727 |
| 11791 |
< |
Oldest active 728 |
| 11792 |
< |
Oldest snapshot 728 |
| 11793 |
< |
Next transaction 728 |
| 11790 |
> |
Oldest transaction 1192 |
| 11791 |
> |
Oldest active 1193 |
| 11792 |
> |
Oldest snapshot 1193 |
| 11793 |
> |
Next transaction 1193 |
| 11794 |
|
Sequence number 0 |
| 11795 |
< |
Next attachment ID 406 |
| 11795 |
> |
Next attachment ID 899 |
| 11796 |
|
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc |
| 11797 |
|
Shadow count 0 |
| 11798 |
|
Page buffers 0 |
| 11866 |
|
Primary pointer page: 258, Index root page: 259 |
| 11867 |
|
Pointer pages: 1, data page slots: 1 |
| 11868 |
|
Data pages: 1, average fill: 10% |
| 11869 |
< |
Primary pages: 1, secondary pages: 0, swept pages: 0 |
| 11869 |
> |
Primary pages: 1, secondary pages: 0, swept pages: 1 |
| 11870 |
|
Empty pages: 0, full pages: 0 |
| 11871 |
|
Fill distribution: |
| 11872 |
|
0 - 19% = 1 |
| 11918 |
|
Primary pointer page: 270, Index root page: 271 |
| 11919 |
|
Pointer pages: 1, data page slots: 1 |
| 11920 |
|
Data pages: 1, average fill: 30% |
| 11921 |
< |
Primary pages: 1, secondary pages: 0, swept pages: 0 |
| 11921 |
> |
Primary pages: 1, secondary pages: 0, swept pages: 1 |
| 11922 |
|
Empty pages: 0, full pages: 0 |
| 11923 |
|
Fill distribution: |
| 11924 |
|
0 - 19% = 0 |
| 11940 |
|
60 - 79% = 0 |
| 11941 |
|
80 - 99% = 0 |
| 11942 |
|
|
| 11943 |
< |
Gstat completion time Wed Feb 17 10:45:05 2021 |
| 11943 |
> |
Gstat completion time Thu Feb 18 17:07:28 2021 |
| 11944 |
|
|
| 11945 |
|
|
| 11946 |
|
|
| 11950 |
|
firebird4rc1/bin/fbguard: guardian starting /opt/firebird4rc1/bin/firebird |
| 11951 |
|
|
| 11952 |
|
Online Validation |
| 11953 |
< |
10:45:09.59 Validation started |
| 11953 |
> |
17:07:32.35 Validation started |
| 11954 |
|
|
| 11955 |
< |
10:45:09.59 Relation 128 (COUNTRY) |
| 11956 |
< |
10:45:09.59 process pointer page 0 of 1 |
| 11957 |
< |
10:45:09.59 Index 1 (RDB$PRIMARY1) |
| 11958 |
< |
10:45:09.59 Relation 128 (COUNTRY) is ok |
| 11959 |
< |
|
| 11960 |
< |
10:45:09.59 Relation 129 (JOB) |
| 11961 |
< |
10:45:09.59 process pointer page 0 of 1 |
| 11962 |
< |
10:45:09.59 Index 1 (RDB$PRIMARY2) |
| 11963 |
< |
10:45:09.59 Index 2 (RDB$FOREIGN3) |
| 11964 |
< |
10:45:09.59 Index 3 (MAXSALX) |
| 11965 |
< |
10:45:09.59 Index 4 (MINSALX) |
| 11966 |
< |
10:45:09.59 Relation 129 (JOB) is ok |
| 11967 |
< |
|
| 11968 |
< |
10:45:09.59 Relation 130 (DEPARTMENT) |
| 11969 |
< |
10:45:09.59 process pointer page 0 of 1 |
| 11970 |
< |
10:45:09.59 Index 1 (RDB$4) |
| 11971 |
< |
10:45:09.59 Index 2 (RDB$PRIMARY5) |
| 11972 |
< |
10:45:09.59 Index 3 (RDB$FOREIGN6) |
| 11973 |
< |
10:45:09.59 Index 4 (BUDGETX) |
| 11974 |
< |
10:45:09.59 Index 5 (RDB$FOREIGN10) |
| 11975 |
< |
10:45:09.59 Relation 130 (DEPARTMENT) is ok |
| 11976 |
< |
|
| 11977 |
< |
10:45:09.59 Relation 131 (EMPLOYEE) |
| 11978 |
< |
10:45:09.59 process pointer page 0 of 1 |
| 11979 |
< |
10:45:09.59 Index 1 (RDB$PRIMARY7) |
| 11980 |
< |
10:45:09.59 Index 2 (RDB$FOREIGN8) |
| 11981 |
< |
10:45:09.59 Index 3 (RDB$FOREIGN9) |
| 11982 |
< |
10:45:09.59 Index 4 (NAMEX) |
| 11983 |
< |
10:45:09.59 Relation 131 (EMPLOYEE) is ok |
| 11984 |
< |
|
| 11985 |
< |
10:45:09.59 Relation 133 (PROJECT) |
| 11986 |
< |
10:45:09.59 process pointer page 0 of 1 |
| 11987 |
< |
10:45:09.59 Index 1 (RDB$11) |
| 11988 |
< |
10:45:09.59 Index 2 (RDB$PRIMARY12) |
| 11989 |
< |
10:45:09.59 Index 3 (RDB$FOREIGN13) |
| 11990 |
< |
10:45:09.59 Index 4 (PRODTYPEX) |
| 11991 |
< |
10:45:09.59 Relation 133 (PROJECT) is ok |
| 11992 |
< |
|
| 11993 |
< |
10:45:09.60 Relation 134 (EMPLOYEE_PROJECT) |
| 11994 |
< |
10:45:09.60 process pointer page 0 of 1 |
| 11995 |
< |
10:45:09.60 Index 1 (RDB$PRIMARY14) |
| 11996 |
< |
10:45:09.60 Index 2 (RDB$FOREIGN15) |
| 11997 |
< |
10:45:09.60 Index 3 (RDB$FOREIGN16) |
| 11998 |
< |
10:45:09.60 Relation 134 (EMPLOYEE_PROJECT) is ok |
| 11999 |
< |
|
| 12000 |
< |
10:45:09.60 Relation 135 (PROJ_DEPT_BUDGET) |
| 12001 |
< |
10:45:09.60 process pointer page 0 of 1 |
| 12002 |
< |
10:45:09.60 Index 1 (RDB$PRIMARY17) |
| 12003 |
< |
10:45:09.60 Index 2 (RDB$FOREIGN18) |
| 12004 |
< |
10:45:09.61 Index 3 (RDB$FOREIGN19) |
| 12005 |
< |
10:45:09.61 Relation 135 (PROJ_DEPT_BUDGET) is ok |
| 12006 |
< |
|
| 12007 |
< |
10:45:09.61 Relation 136 (SALARY_HISTORY) |
| 12008 |
< |
10:45:09.61 process pointer page 0 of 1 |
| 12009 |
< |
10:45:09.61 Index 1 (RDB$PRIMARY20) |
| 12010 |
< |
10:45:09.61 Index 2 (RDB$FOREIGN21) |
| 12011 |
< |
10:45:09.61 Index 3 (CHANGEX) |
| 12012 |
< |
10:45:09.61 Index 4 (UPDATERX) |
| 12013 |
< |
10:45:09.61 Relation 136 (SALARY_HISTORY) is ok |
| 12014 |
< |
|
| 12015 |
< |
10:45:09.61 Relation 137 (CUSTOMER) |
| 12016 |
< |
10:45:09.61 process pointer page 0 of 1 |
| 12017 |
< |
10:45:09.61 Index 1 (RDB$PRIMARY22) |
| 12018 |
< |
10:45:09.61 Index 2 (RDB$FOREIGN23) |
| 12019 |
< |
10:45:09.61 Index 3 (CUSTNAMEX) |
| 12020 |
< |
10:45:09.61 Index 4 (CUSTREGION) |
| 12021 |
< |
10:45:09.61 Relation 137 (CUSTOMER) is ok |
| 12022 |
< |
|
| 12023 |
< |
10:45:09.61 Relation 138 (SALES) |
| 12024 |
< |
10:45:09.61 process pointer page 0 of 1 |
| 12025 |
< |
10:45:09.61 Index 1 (RDB$PRIMARY24) |
| 12026 |
< |
10:45:09.61 Index 2 (RDB$FOREIGN25) |
| 12027 |
< |
10:45:09.61 Index 3 (RDB$FOREIGN26) |
| 12028 |
< |
10:45:09.61 Index 4 (NEEDX) |
| 12029 |
< |
10:45:09.61 Index 5 (QTYX) |
| 12030 |
< |
10:45:09.61 Index 6 (SALESTATX) |
| 12031 |
< |
10:45:09.61 Relation 138 (SALES) is ok |
| 11955 |
> |
17:07:32.35 Relation 128 (COUNTRY) |
| 11956 |
> |
17:07:32.35 process pointer page 0 of 1 |
| 11957 |
> |
17:07:32.35 Index 1 (RDB$PRIMARY1) |
| 11958 |
> |
17:07:32.35 Relation 128 (COUNTRY) is ok |
| 11959 |
> |
|
| 11960 |
> |
17:07:32.35 Relation 129 (JOB) |
| 11961 |
> |
17:07:32.35 process pointer page 0 of 1 |
| 11962 |
> |
17:07:32.35 Index 1 (RDB$PRIMARY2) |
| 11963 |
> |
17:07:32.35 Index 2 (RDB$FOREIGN3) |
| 11964 |
> |
17:07:32.35 Index 3 (MAXSALX) |
| 11965 |
> |
17:07:32.35 Index 4 (MINSALX) |
| 11966 |
> |
17:07:32.35 Relation 129 (JOB) is ok |
| 11967 |
> |
|
| 11968 |
> |
17:07:32.35 Relation 130 (DEPARTMENT) |
| 11969 |
> |
17:07:32.35 process pointer page 0 of 1 |
| 11970 |
> |
17:07:32.35 Index 1 (RDB$4) |
| 11971 |
> |
17:07:32.35 Index 2 (RDB$PRIMARY5) |
| 11972 |
> |
17:07:32.35 Index 3 (RDB$FOREIGN6) |
| 11973 |
> |
17:07:32.35 Index 4 (BUDGETX) |
| 11974 |
> |
17:07:32.35 Index 5 (RDB$FOREIGN10) |
| 11975 |
> |
17:07:32.35 Relation 130 (DEPARTMENT) is ok |
| 11976 |
> |
|
| 11977 |
> |
17:07:32.35 Relation 131 (EMPLOYEE) |
| 11978 |
> |
17:07:32.35 process pointer page 0 of 1 |
| 11979 |
> |
17:07:32.35 Index 1 (RDB$PRIMARY7) |
| 11980 |
> |
17:07:32.35 Index 2 (RDB$FOREIGN8) |
| 11981 |
> |
17:07:32.35 Index 3 (RDB$FOREIGN9) |
| 11982 |
> |
17:07:32.35 Index 4 (NAMEX) |
| 11983 |
> |
17:07:32.35 Relation 131 (EMPLOYEE) is ok |
| 11984 |
> |
|
| 11985 |
> |
17:07:32.35 Relation 133 (PROJECT) |
| 11986 |
> |
17:07:32.35 process pointer page 0 of 1 |
| 11987 |
> |
17:07:32.35 Index 1 (RDB$11) |
| 11988 |
> |
17:07:32.35 Index 2 (RDB$PRIMARY12) |
| 11989 |
> |
17:07:32.35 Index 3 (RDB$FOREIGN13) |
| 11990 |
> |
17:07:32.35 Index 4 (PRODTYPEX) |
| 11991 |
> |
17:07:32.35 Relation 133 (PROJECT) is ok |
| 11992 |
> |
|
| 11993 |
> |
17:07:32.35 Relation 134 (EMPLOYEE_PROJECT) |
| 11994 |
> |
17:07:32.35 process pointer page 0 of 1 |
| 11995 |
> |
17:07:32.35 Index 1 (RDB$PRIMARY14) |
| 11996 |
> |
17:07:32.35 Index 2 (RDB$FOREIGN15) |
| 11997 |
> |
17:07:32.35 Index 3 (RDB$FOREIGN16) |
| 11998 |
> |
17:07:32.35 Relation 134 (EMPLOYEE_PROJECT) is ok |
| 11999 |
> |
|
| 12000 |
> |
17:07:32.35 Relation 135 (PROJ_DEPT_BUDGET) |
| 12001 |
> |
17:07:32.35 process pointer page 0 of 1 |
| 12002 |
> |
17:07:32.35 Index 1 (RDB$PRIMARY17) |
| 12003 |
> |
17:07:32.35 Index 2 (RDB$FOREIGN18) |
| 12004 |
> |
17:07:32.35 Index 3 (RDB$FOREIGN19) |
| 12005 |
> |
17:07:32.35 Relation 135 (PROJ_DEPT_BUDGET) is ok |
| 12006 |
> |
|
| 12007 |
> |
17:07:32.35 Relation 136 (SALARY_HISTORY) |
| 12008 |
> |
17:07:32.35 process pointer page 0 of 1 |
| 12009 |
> |
17:07:32.35 Index 1 (RDB$PRIMARY20) |
| 12010 |
> |
17:07:32.36 Index 2 (RDB$FOREIGN21) |
| 12011 |
> |
17:07:32.36 Index 3 (CHANGEX) |
| 12012 |
> |
17:07:32.36 Index 4 (UPDATERX) |
| 12013 |
> |
17:07:32.36 Relation 136 (SALARY_HISTORY) is ok |
| 12014 |
> |
|
| 12015 |
> |
17:07:32.36 Relation 137 (CUSTOMER) |
| 12016 |
> |
17:07:32.36 process pointer page 0 of 1 |
| 12017 |
> |
17:07:32.36 Index 1 (RDB$PRIMARY22) |
| 12018 |
> |
17:07:32.36 Index 2 (RDB$FOREIGN23) |
| 12019 |
> |
17:07:32.36 Index 3 (CUSTNAMEX) |
| 12020 |
> |
17:07:32.36 Index 4 (CUSTREGION) |
| 12021 |
> |
17:07:32.36 Relation 137 (CUSTOMER) is ok |
| 12022 |
> |
|
| 12023 |
> |
17:07:32.36 Relation 138 (SALES) |
| 12024 |
> |
17:07:32.36 process pointer page 0 of 1 |
| 12025 |
> |
17:07:32.36 Index 1 (RDB$PRIMARY24) |
| 12026 |
> |
17:07:32.36 Index 2 (RDB$FOREIGN25) |
| 12027 |
> |
17:07:32.36 Index 3 (RDB$FOREIGN26) |
| 12028 |
> |
17:07:32.36 Index 4 (NEEDX) |
| 12029 |
> |
17:07:32.36 Index 5 (QTYX) |
| 12030 |
> |
17:07:32.36 Index 6 (SALESTATX) |
| 12031 |
> |
17:07:32.36 Relation 138 (SALES) is ok |
| 12032 |
|
|
| 12033 |
< |
10:45:09.61 Validation finished |
| 12033 |
> |
17:07:32.36 Validation finished |
| 12034 |
|
|
| 12035 |
|
|
| 12036 |
|
Normal Validation |
| 13318 |
|
Current memory = 19,649,408 |
| 13319 |
|
Delta memory = 16,032 |
| 13320 |
|
Max memory = 19,744,992 |
| 13321 |
< |
Elapsed time= 0.002 sec |
| 13321 |
> |
Elapsed time= 0.001 sec |
| 13322 |
|
Cpu = 0.000 sec |
| 13323 |
|
Buffers = 2048 |
| 13324 |
|
Reads = 2 |
| 13362 |
|
|
| 13363 |
|
Rows printed = 2 |
| 13364 |
|
|
| 13365 |
< |
*Monitor* 17/2/2021 10:45:12.871 |
| 13366 |
< |
[Application: IBX Test Suite] |
| 13365 |
> |
33 ISQL Monitor Messages Received |
| 13366 |
> |
33 ISQL Monitor Messages written |
| 13367 |
> |
*Monitor* |
| 13368 |
> |
[Application: IBX Test Suite] |
| 13369 |
|
Test_Database_13: [Connect] |
| 13370 |
< |
*Monitor* 17/2/2021 10:45:12.871 |
| 13371 |
< |
[Application: IBX Test Suite] |
| 13370 |
> |
*Monitor* |
| 13371 |
> |
[Application: IBX Test Suite] |
| 13372 |
|
Test_Transaction_13: [Start transaction] |
| 13373 |
< |
*Monitor* 17/2/2021 10:45:12.878 |
| 13374 |
< |
[Application: IBX Test Suite] |
| 13373 |
> |
*Monitor* |
| 13374 |
> |
[Application: IBX Test Suite] |
| 13375 |
|
: [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 |
| 13376 |
< |
|
| 13376 |
> |
|
| 13377 |
|
Plan: |
| 13378 |
|
Select Expression |
| 13379 |
|
-> First N Records |
| 13382 |
|
-> Filter |
| 13383 |
|
-> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID |
| 13384 |
|
-> Bitmap |
| 13385 |
< |
|
| 13376 |
< |
*Monitor* 17/2/2021 10:45:12.878 -> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13385 |
> |
-> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13386 |
|
-> Filter |
| 13387 |
|
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
| 13388 |
|
-> Bitmap |
| 13391 |
|
-> Table "EMPLOYEE" as "A" Access By ID |
| 13392 |
|
-> Bitmap |
| 13393 |
|
-> Index "RDB$FOREIGN8" Range Scan (full match) |
| 13394 |
< |
*Monitor* 17/2/2021 10:45:12.895 |
| 13395 |
< |
[Application: IBX Test Suite] |
| 13394 |
> |
*Monitor* |
| 13395 |
> |
[Application: IBX Test Suite] |
| 13396 |
|
: [Start transaction] |
| 13397 |
< |
*Monitor* 17/2/2021 10:45:12.905 |
| 13398 |
< |
[Application: IBX Test Suite] |
| 13397 |
> |
*Monitor* |
| 13398 |
> |
[Application: IBX Test Suite] |
| 13399 |
|
: [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)) |
| 13400 |
< |
|
| 13400 |
> |
|
| 13401 |
|
Plan: |
| 13402 |
|
Select Expression |
| 13403 |
|
-> Nested Loop Join (inner) |
| 13409 |
|
-> Table "RDB$FIELDS" as "F" Access By ID |
| 13410 |
|
-> Bitmap |
| 13411 |
|
-> Index "RDB$INDEX_2" Unique Scan |
| 13412 |
< |
*Monitor* 17/2/2021 10:45:12.905 |
| 13413 |
< |
[Application: IBX Test Suite] |
| 13412 |
> |
*Monitor* |
| 13413 |
> |
[Application: IBX Test Suite] |
| 13414 |
|
: [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)) |
| 13415 |
< |
|
| 13415 |
> |
|
| 13416 |
|
RELATION = EMPLOYEE |
| 13417 |
< |
*Monitor* 17/2/2021 10:45:12.905 |
| 13418 |
< |
[Application: IBX Test Suite] |
| 13417 |
> |
*Monitor* |
| 13418 |
> |
[Application: IBX Test Suite] |
| 13419 |
|
: [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)) |
| 13420 |
|
|
| 13421 |
< |
*Monitor* 17/2/2021 10:45:12.906 |
| 13422 |
< |
[Application: IBX Test Suite] |
| 13421 |
> |
*Monitor* |
| 13422 |
> |
[Application: IBX Test Suite] |
| 13423 |
|
: [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)) |
| 13424 |
|
|
| 13425 |
< |
*Monitor* 17/2/2021 10:45:12.906 |
| 13426 |
< |
[Application: IBX Test Suite] |
| 13425 |
> |
*Monitor* |
| 13426 |
> |
[Application: IBX Test Suite] |
| 13427 |
|
: [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)) |
| 13428 |
< |
|
| 13428 |
> |
|
| 13429 |
|
SEOFReached |
| 13430 |
< |
*Monitor* 17/2/2021 10:45:12.912 |
| 13431 |
< |
[Application: IBX Test Suite] |
| 13430 |
> |
*Monitor* |
| 13431 |
> |
[Application: IBX Test Suite] |
| 13432 |
|
: [Commit (Hard commit)] |
| 13433 |
< |
*Monitor* 17/2/2021 10:45:12.916 |
| 13434 |
< |
[Application: IBX Test Suite] |
| 13433 |
> |
*Monitor* |
| 13434 |
> |
[Application: IBX Test Suite] |
| 13435 |
|
: [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 |
| 13436 |
|
|
| 13437 |
< |
*Monitor* 17/2/2021 10:45:12.917 |
| 13438 |
< |
[Application: IBX Test Suite] |
| 13437 |
> |
*Monitor* |
| 13438 |
> |
[Application: IBX Test Suite] |
| 13439 |
|
: [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 |
| 13440 |
|
|
| 13441 |
< |
*Monitor* 17/2/2021 10:45:12.919 |
| 13442 |
< |
[Application: IBX Test Suite] |
| 13441 |
> |
*Monitor* |
| 13442 |
> |
[Application: IBX Test Suite] |
| 13443 |
|
: [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 |
| 13444 |
|
|
| 13445 |
< |
*Monitor* 17/2/2021 10:45:12.919 |
| 13446 |
< |
[Application: IBX Test Suite] |
| 13445 |
> |
*Monitor* |
| 13446 |
> |
[Application: IBX Test Suite] |
| 13447 |
|
: [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 |
| 13448 |
< |
|
| 13448 |
> |
|
| 13449 |
|
SEOFReached |
| 13450 |
< |
*Monitor* 17/2/2021 10:45:12.920 |
| 13451 |
< |
[Application: IBX Test Suite] |
| 13450 |
> |
*Monitor* |
| 13451 |
> |
[Application: IBX Test Suite] |
| 13452 |
|
Test_Transaction_13: [Commit (Hard commit)] |
| 13453 |
< |
*Monitor* 17/2/2021 10:45:12.943 |
| 13454 |
< |
[Application: IBX Test Suite] |
| 13453 |
> |
*Monitor* |
| 13454 |
> |
[Application: IBX Test Suite] |
| 13455 |
|
Test_Database_13: [Disconnect] |
| 13456 |
< |
*Monitor* 17/2/2021 10:45:12.974 |
| 13457 |
< |
[Application: IBX Test Suite] |
| 13456 |
> |
*Monitor* |
| 13457 |
> |
[Application: IBX Test Suite] |
| 13458 |
|
Test_Database_13: [Connect] |
| 13459 |
< |
*Monitor* 17/2/2021 10:45:12.974 |
| 13460 |
< |
[Application: IBX Test Suite] |
| 13459 |
> |
*Monitor* |
| 13460 |
> |
[Application: IBX Test Suite] |
| 13461 |
|
Test_Transaction_13: [Start transaction] |
| 13462 |
< |
*Monitor* 17/2/2021 10:45:12.980 |
| 13463 |
< |
[Application: IBX Test Suite] |
| 13462 |
> |
*Monitor* |
| 13463 |
> |
[Application: IBX Test Suite] |
| 13464 |
|
: [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 |
| 13465 |
< |
|
| 13465 |
> |
|
| 13466 |
|
Plan: |
| 13467 |
|
Select Expression |
| 13468 |
|
-> First N Records |
| 13471 |
|
-> Filter |
| 13472 |
|
-> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID |
| 13473 |
|
-> Bitmap |
| 13474 |
< |
|
| 13466 |
< |
*Monitor* 17/2/2021 10:45:12.980 -> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13474 |
> |
-> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13475 |
|
-> Filter |
| 13476 |
|
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
| 13477 |
|
-> Bitmap |
| 13480 |
|
-> Table "EMPLOYEE" as "A" Access By ID |
| 13481 |
|
-> Bitmap |
| 13482 |
|
-> Index "RDB$FOREIGN8" Range Scan (full match) |
| 13483 |
< |
*Monitor* 17/2/2021 10:45:12.989 |
| 13484 |
< |
[Application: IBX Test Suite] |
| 13483 |
> |
*Monitor* |
| 13484 |
> |
[Application: IBX Test Suite] |
| 13485 |
|
: [Start transaction] |
| 13486 |
< |
*Monitor* 17/2/2021 10:45:12.997 |
| 13487 |
< |
[Application: IBX Test Suite] |
| 13486 |
> |
*Monitor* |
| 13487 |
> |
[Application: IBX Test Suite] |
| 13488 |
|
: [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)) |
| 13489 |
< |
|
| 13489 |
> |
|
| 13490 |
|
Plan: |
| 13491 |
|
Select Expression |
| 13492 |
|
-> Nested Loop Join (inner) |
| 13498 |
|
-> Table "RDB$FIELDS" as "F" Access By ID |
| 13499 |
|
-> Bitmap |
| 13500 |
|
-> Index "RDB$INDEX_2" Unique Scan |
| 13501 |
< |
*Monitor* 17/2/2021 10:45:12.997 |
| 13502 |
< |
[Application: IBX Test Suite] |
| 13501 |
> |
*Monitor* |
| 13502 |
> |
[Application: IBX Test Suite] |
| 13503 |
|
: [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)) |
| 13504 |
< |
|
| 13504 |
> |
|
| 13505 |
|
RELATION = EMPLOYEE |
| 13506 |
< |
*Monitor* 17/2/2021 10:45:12.998 |
| 13507 |
< |
[Application: IBX Test Suite] |
| 13506 |
> |
*Monitor* |
| 13507 |
> |
[Application: IBX Test Suite] |
| 13508 |
|
: [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)) |
| 13509 |
|
|
| 13510 |
< |
*Monitor* 17/2/2021 10:45:12.998 |
| 13511 |
< |
[Application: IBX Test Suite] |
| 13510 |
> |
*Monitor* |
| 13511 |
> |
[Application: IBX Test Suite] |
| 13512 |
|
: [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)) |
| 13513 |
|
|
| 13514 |
< |
*Monitor* 17/2/2021 10:45:12.998 |
| 13515 |
< |
[Application: IBX Test Suite] |
| 13514 |
> |
*Monitor* |
| 13515 |
> |
[Application: IBX Test Suite] |
| 13516 |
|
: [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)) |
| 13517 |
< |
|
| 13517 |
> |
|
| 13518 |
|
SEOFReached |
| 13519 |
< |
*Monitor* 17/2/2021 10:45:12.999 |
| 13520 |
< |
[Application: IBX Test Suite] |
| 13519 |
> |
*Monitor* |
| 13520 |
> |
[Application: IBX Test Suite] |
| 13521 |
|
: [Commit (Hard commit)] |
| 13522 |
< |
*Monitor* 17/2/2021 10:45:13.000 |
| 13523 |
< |
[Application: IBX Test Suite] |
| 13522 |
> |
*Monitor* |
| 13523 |
> |
[Application: IBX Test Suite] |
| 13524 |
|
: [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 |
| 13525 |
|
|
| 13526 |
< |
*Monitor* 17/2/2021 10:45:13.002 |
| 13527 |
< |
[Application: IBX Test Suite] |
| 13526 |
> |
*Monitor* |
| 13527 |
> |
[Application: IBX Test Suite] |
| 13528 |
|
: [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 |
| 13529 |
|
|
| 13530 |
< |
*Monitor* 17/2/2021 10:45:13.002 |
| 13531 |
< |
[Application: IBX Test Suite] |
| 13530 |
> |
*Monitor* |
| 13531 |
> |
[Application: IBX Test Suite] |
| 13532 |
|
: [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 |
| 13533 |
|
|
| 13534 |
< |
*Monitor* 17/2/2021 10:45:13.002 |
| 13535 |
< |
[Application: IBX Test Suite] |
| 13534 |
> |
*Monitor* |
| 13535 |
> |
[Application: IBX Test Suite] |
| 13536 |
|
: [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 |
| 13537 |
< |
|
| 13537 |
> |
|
| 13538 |
|
SEOFReached |
| 13539 |
< |
*Monitor* 17/2/2021 10:45:13.003 |
| 13540 |
< |
[Application: IBX Test Suite] |
| 13539 |
> |
*Monitor* |
| 13540 |
> |
[Application: IBX Test Suite] |
| 13541 |
|
Test_Transaction_13: [Commit (Hard commit)] |
| 13542 |
< |
*Monitor* 17/2/2021 10:45:13.015 |
| 13543 |
< |
[Application: IBX Test Suite] |
| 13542 |
> |
*Monitor* |
| 13543 |
> |
[Application: IBX Test Suite] |
| 13544 |
|
Test_Database_13: [Disconnect] |
| 13545 |
+ |
33 ISQL Monitor Messages Received |
| 13546 |
|
|
| 13547 |
|
|
| 13548 |
|
------------------------------------------------------ |
| 13583 |
|
Current memory = 19,649,408 |
| 13584 |
|
Delta memory = 16,032 |
| 13585 |
|
Max memory = 19,744,992 |
| 13586 |
< |
Elapsed time= 0.001 sec |
| 13586 |
> |
Elapsed time= 0.102 sec |
| 13587 |
|
Cpu = 0.000 sec |
| 13588 |
|
Buffers = 2048 |
| 13589 |
|
Reads = 2 |
| 13627 |
|
|
| 13628 |
|
Rows printed = 2 |
| 13629 |
|
|
| 13630 |
< |
*Monitor* 17/2/2021 10:45:14 -> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13631 |
< |
-> Filter |
| 13623 |
< |
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
| 13624 |
< |
-> Bitmap |
| 13625 |
< |
-> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13626 |
< |
-> Filter |
| 13627 |
< |
-> Table "EMPLOYEE" as "A" Access By ID |
| 13628 |
< |
-> Bitmap |
| 13629 |
< |
-> Index "RDB$FOREIGN8" Range Scan (full match) |
| 13630 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13631 |
< |
[Application: IBX Test Suite] |
| 13632 |
< |
: [Start transaction] |
| 13633 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13634 |
< |
[Application: IBX Test Suite] |
| 13635 |
< |
: [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)) |
| 13636 |
< |
|
| 13637 |
< |
Plan: |
| 13638 |
< |
Select Expression |
| 13639 |
< |
-> Nested Loop Join (inner) |
| 13640 |
< |
-> Filter |
| 13641 |
< |
-> Table "RDB$RELATION_FIELDS" as "R" Access By ID |
| 13642 |
< |
-> Bitmap |
| 13643 |
< |
-> Index "RDB$INDEX_4" Range Scan (full match) |
| 13644 |
< |
-> Filter |
| 13645 |
< |
-> Table "RDB$FIELDS" as "F" Access By ID |
| 13646 |
< |
-> Bitmap |
| 13647 |
< |
-> Index "RDB$INDEX_2" Unique Scan |
| 13648 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13649 |
< |
[Application: IBX Test Suite] |
| 13650 |
< |
: [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)) |
| 13651 |
< |
|
| 13652 |
< |
RELATION = EMPLOYEE |
| 13653 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13654 |
< |
[Application: IBX Test Suite] |
| 13655 |
< |
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
| 13656 |
< |
|
| 13657 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13658 |
< |
[Application: IBX Test Suite] |
| 13659 |
< |
: [Fetch] Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE from RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = :RELATION and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or (not F.RDB$DEFAULT_VALUE is NULL) or ( not R.RDB$IDENTITY_TYPE is NULL)) |
| 13660 |
< |
|
| 13661 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13662 |
< |
[Application: IBX Test Suite] |
| 13663 |
< |
: [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)) |
| 13664 |
< |
|
| 13665 |
< |
SEOFReached |
| 13666 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13667 |
< |
[Application: IBX Test Suite] |
| 13668 |
< |
: [Commit (Hard commit)] |
| 13669 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13670 |
< |
[Application: IBX Test Suite] |
| 13671 |
< |
: [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 |
| 13672 |
< |
|
| 13673 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13674 |
< |
[Application: IBX Test Suite] |
| 13675 |
< |
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
| 13676 |
< |
|
| 13677 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13678 |
< |
[Application: IBX Test Suite] |
| 13679 |
< |
: [Fetch] with recursive Depts As ( Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH From DEPARTMENT Where HEAD_DEPT is NULL UNION ALL Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH || ' / ' || D.DEPARTMENT as DEPT_PATH,Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH From DEPARTMENT D JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO )Select First 2 A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH From EMPLOYEE A JOIN Depts D On D.DEPT_NO = A.DEPT_NO |
| 13680 |
< |
|
| 13681 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13682 |
< |
[Application: IBX Test Suite] |
| 13683 |
< |
: [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 |
| 13684 |
< |
|
| 13685 |
< |
SEOFReached |
| 13686 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13687 |
< |
[Application: IBX Test Suite] |
| 13688 |
< |
Test_Transaction_14: [Commit (Hard commit)] |
| 13689 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13690 |
< |
[Application: IBX Test Suite] |
| 13691 |
< |
Test_Database_14: [Disconnect] |
| 13692 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13630 |
> |
33 ISQL Monitor Messages written |
| 13631 |
> |
*Monitor* |
| 13632 |
|
[Application: IBX Test Suite] |
| 13633 |
|
Test_Database_14: [Connect] |
| 13634 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13634 |
> |
*Monitor* |
| 13635 |
|
[Application: IBX Test Suite] |
| 13636 |
|
Test_Transaction_14: [Start transaction] |
| 13637 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13637 |
> |
*Monitor* |
| 13638 |
|
[Application: IBX Test Suite] |
| 13639 |
|
: [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 |
| 13640 |
|
|
| 13646 |
|
-> Filter |
| 13647 |
|
-> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID |
| 13648 |
|
-> Bitmap |
| 13710 |
– |
|
| 13711 |
– |
*Monitor* 17/2/2021 10:45:14 -> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13712 |
– |
-> Filter |
| 13713 |
– |
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
| 13714 |
– |
-> Bitmap |
| 13649 |
|
-> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13716 |
– |
-> Filter |
| 13717 |
– |
-> Table "EMPLOYEE" as "A" Access By ID |
| 13718 |
– |
-> Bitmap |
| 13719 |
– |
-> Index "RDB$FOREIGN8" Range Scan (full match) |
| 13720 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13721 |
– |
[Application: IBX Test Suite] |
| 13722 |
– |
: [Start transaction] |
| 13723 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13724 |
– |
[Application: IBX Test Suite] |
| 13725 |
– |
: [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)) |
| 13726 |
– |
|
| 13727 |
– |
Plan: |
| 13728 |
– |
Select Expression |
| 13729 |
– |
-> Nested Loop Join (inner) |
| 13730 |
– |
-> Filter |
| 13731 |
– |
-> Table "RDB$RELATION_FIELDS" as "R" Access By ID |
| 13732 |
– |
-> Bitmap |
| 13733 |
– |
-> Index "RDB$INDEX_4" Range Scan (full match) |
| 13734 |
– |
-> Filter |
| 13735 |
– |
-> Table "RDB$FIELDS" as "F" Access By ID |
| 13736 |
– |
-> Bitmap |
| 13737 |
– |
-> Index "RDB$INDEX_2" Unique Scan |
| 13738 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13739 |
– |
[Application: IBX Test Suite] |
| 13740 |
– |
: [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)) |
| 13741 |
– |
|
| 13742 |
– |
RELATION = EMPLOYEE |
| 13743 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13744 |
– |
[Application: IBX Test Suite] |
| 13745 |
– |
: [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)) |
| 13746 |
– |
|
| 13747 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13748 |
– |
[Application: IBX Test Suite] |
| 13749 |
– |
: [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)) |
| 13750 |
– |
|
| 13751 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13752 |
– |
[Application: IBX Test Suite] |
| 13753 |
– |
: [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)) |
| 13754 |
– |
|
| 13755 |
– |
SEOFReached |
| 13756 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13757 |
– |
[Application: IBX Test Suite] |
| 13758 |
– |
: [Commit (Hard commit)] |
| 13759 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13760 |
– |
[Application: IBX Test Suite] |
| 13761 |
– |
: [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 |
| 13762 |
– |
|
| 13763 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13764 |
– |
[Application: IBX Test Suite] |
| 13765 |
– |
: [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 |
| 13766 |
– |
|
| 13767 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13768 |
– |
[Application: IBX Test Suite] |
| 13769 |
– |
: [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 |
| 13770 |
– |
|
| 13771 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13772 |
– |
[Application: IBX Test Suite] |
| 13773 |
– |
: [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 |
| 13774 |
– |
|
| 13775 |
– |
SEOFReached |
| 13776 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13777 |
– |
[Application: IBX Test Suite] |
| 13778 |
– |
Test_Transaction_14: [Commit (Hard commit)] |
| 13779 |
– |
*Monitor* 17/2/2021 10:45:14 |
| 13780 |
– |
[Application: IBX Test Suite] |
| 13781 |
– |
Test_Database_14: [Disconnect] |
| 13782 |
– |
*Monitor* 17/2/2021 10:45:14 -> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13650 |
|
-> Filter |
| 13651 |
|
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
| 13652 |
|
-> Bitmap |
| 13655 |
|
-> Table "EMPLOYEE" as "A" Access By ID |
| 13656 |
|
-> Bitmap |
| 13657 |
|
-> Index "RDB$FOREIGN8" Range Scan (full match) |
| 13658 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13658 |
> |
*Monitor* |
| 13659 |
|
[Application: IBX Test Suite] |
| 13660 |
|
: [Start transaction] |
| 13661 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13661 |
> |
*Monitor* |
| 13662 |
|
[Application: IBX Test Suite] |
| 13663 |
|
: [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)) |
| 13664 |
|
|
| 13673 |
|
-> Table "RDB$FIELDS" as "F" Access By ID |
| 13674 |
|
-> Bitmap |
| 13675 |
|
-> Index "RDB$INDEX_2" Unique Scan |
| 13676 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13676 |
> |
*Monitor* |
| 13677 |
|
[Application: IBX Test Suite] |
| 13678 |
|
: [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)) |
| 13679 |
|
|
| 13680 |
|
RELATION = EMPLOYEE |
| 13681 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13681 |
> |
*Monitor* |
| 13682 |
|
[Application: IBX Test Suite] |
| 13683 |
|
: [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)) |
| 13684 |
|
|
| 13685 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13685 |
> |
*Monitor* |
| 13686 |
|
[Application: IBX Test Suite] |
| 13687 |
|
: [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)) |
| 13688 |
|
|
| 13689 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13689 |
> |
*Monitor* |
| 13690 |
|
[Application: IBX Test Suite] |
| 13691 |
|
: [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)) |
| 13692 |
|
|
| 13693 |
|
SEOFReached |
| 13694 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13694 |
> |
*Monitor* |
| 13695 |
|
[Application: IBX Test Suite] |
| 13696 |
|
: [Commit (Hard commit)] |
| 13697 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13697 |
> |
*Monitor* |
| 13698 |
|
[Application: IBX Test Suite] |
| 13699 |
|
: [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 |
| 13700 |
|
|
| 13701 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13701 |
> |
*Monitor* |
| 13702 |
|
[Application: IBX Test Suite] |
| 13703 |
|
: [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 |
| 13704 |
|
|
| 13705 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13705 |
> |
*Monitor* |
| 13706 |
|
[Application: IBX Test Suite] |
| 13707 |
|
: [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 |
| 13708 |
|
|
| 13709 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13709 |
> |
*Monitor* |
| 13710 |
|
[Application: IBX Test Suite] |
| 13711 |
|
: [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 |
| 13712 |
|
|
| 13713 |
|
SEOFReached |
| 13714 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13714 |
> |
*Monitor* |
| 13715 |
|
[Application: IBX Test Suite] |
| 13716 |
|
Test_Transaction_14: [Commit (Hard commit)] |
| 13717 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13717 |
> |
*Monitor* |
| 13718 |
|
[Application: IBX Test Suite] |
| 13719 |
|
Test_Database_14: [Disconnect] |
| 13720 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13720 |
> |
*Monitor* |
| 13721 |
|
[Application: IBX Test Suite] |
| 13722 |
|
Test_Database_14: [Connect] |
| 13723 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13723 |
> |
*Monitor* |
| 13724 |
|
[Application: IBX Test Suite] |
| 13725 |
|
Test_Transaction_14: [Start transaction] |
| 13726 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13726 |
> |
*Monitor* |
| 13727 |
|
[Application: IBX Test Suite] |
| 13728 |
|
: [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 |
| 13729 |
|
|
| 13735 |
|
-> Filter |
| 13736 |
|
-> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID |
| 13737 |
|
-> Bitmap |
| 13738 |
< |
|
| 13872 |
< |
*Monitor* 17/2/2021 10:45:14 -> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13738 |
> |
-> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13739 |
|
-> Filter |
| 13740 |
|
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
| 13741 |
|
-> Bitmap |
| 13744 |
|
-> Table "EMPLOYEE" as "A" Access By ID |
| 13745 |
|
-> Bitmap |
| 13746 |
|
-> Index "RDB$FOREIGN8" Range Scan (full match) |
| 13747 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13747 |
> |
*Monitor* |
| 13748 |
|
[Application: IBX Test Suite] |
| 13749 |
|
: [Start transaction] |
| 13750 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13750 |
> |
*Monitor* |
| 13751 |
|
[Application: IBX Test Suite] |
| 13752 |
|
: [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)) |
| 13753 |
|
|
| 13762 |
|
-> Table "RDB$FIELDS" as "F" Access By ID |
| 13763 |
|
-> Bitmap |
| 13764 |
|
-> Index "RDB$INDEX_2" Unique Scan |
| 13765 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13765 |
> |
*Monitor* |
| 13766 |
|
[Application: IBX Test Suite] |
| 13767 |
|
: [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)) |
| 13768 |
|
|
| 13769 |
|
RELATION = EMPLOYEE |
| 13770 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13770 |
> |
*Monitor* |
| 13771 |
|
[Application: IBX Test Suite] |
| 13772 |
|
: [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)) |
| 13773 |
|
|
| 13774 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13774 |
> |
*Monitor* |
| 13775 |
|
[Application: IBX Test Suite] |
| 13776 |
|
: [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)) |
| 13777 |
|
|
| 13778 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13778 |
> |
*Monitor* |
| 13779 |
|
[Application: IBX Test Suite] |
| 13780 |
|
: [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)) |
| 13781 |
|
|
| 13782 |
|
SEOFReached |
| 13783 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13783 |
> |
*Monitor* |
| 13784 |
|
[Application: IBX Test Suite] |
| 13785 |
|
: [Commit (Hard commit)] |
| 13786 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13786 |
> |
*Monitor* |
| 13787 |
|
[Application: IBX Test Suite] |
| 13788 |
|
: [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 |
| 13789 |
|
|
| 13790 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13790 |
> |
*Monitor* |
| 13791 |
|
[Application: IBX Test Suite] |
| 13792 |
|
: [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 |
| 13793 |
|
|
| 13794 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13794 |
> |
*Monitor* |
| 13795 |
|
[Application: IBX Test Suite] |
| 13796 |
|
: [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 |
| 13797 |
|
|
| 13798 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13798 |
> |
*Monitor* |
| 13799 |
|
[Application: IBX Test Suite] |
| 13800 |
|
: [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 |
| 13801 |
|
|
| 13802 |
|
SEOFReached |
| 13803 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13803 |
> |
*Monitor* |
| 13804 |
|
[Application: IBX Test Suite] |
| 13805 |
|
Test_Transaction_14: [Commit (Hard commit)] |
| 13806 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13806 |
> |
*Monitor* |
| 13807 |
|
[Application: IBX Test Suite] |
| 13808 |
|
Test_Database_14: [Disconnect] |
| 13809 |
+ |
33 ISQL Monitor Messages Received |
| 13810 |
|
|
| 13811 |
|
|
| 13812 |
|
------------------------------------------------------ |
| 15198 |
|
MyText VarChar(1024), |
| 15199 |
|
Primary Key (RowID) |
| 15200 |
|
); |
| 15201 |
< |
Loading data into database table. Started at 17/2/2021 10:45:33.536 |
| 15202 |
< |
Data load completed at 17/2/2021 10:47:12.797 Elapsed Time = 99261 ms, 100000 records loaded |
| 15203 |
< |
MD5 checksum = 3c3d659173420c4374844a9e400fa99c |
| 15204 |
< |
Database Read started at 17/2/2021 10:47:12.808 |
| 15205 |
< |
Read Dataset completed at 17/2/2021 10:47:43.727 Elapsed Time = 30919 ms, 100000 records read |
| 15206 |
< |
MD5 checksum = 3c3d659173420c4374844a9e400fa99c |
| 15201 |
> |
Loading data into database table. Started at 18/2/2021 17:08:20.034 |
| 15202 |
> |
Data load completed at 18/2/2021 17:09:56.119 Elapsed Time = 96085 ms, 100000 records loaded |
| 15203 |
> |
MD5 checksum = 78516f380a41fc5a972b7c9b5ac14024 |
| 15204 |
> |
Database Read started at 18/2/2021 17:09:56.141 |
| 15205 |
> |
Read Dataset completed at 18/2/2021 17:10:29.759 Elapsed Time = 33618 ms, 100000 records read |
| 15206 |
> |
MD5 checksum = 78516f380a41fc5a972b7c9b5ac14024 |
| 15207 |
|
Test Completed successfully |
| 15208 |
|
|
| 15209 |
|
|
