| 3 |
|
|
| 4 |
|
Starting Tests |
| 5 |
|
Client API Version = 4.0 |
| 6 |
< |
Firebird Environment Variable = /opt/firebird4rc1 |
| 7 |
< |
Firebird Bin Directory = /opt/firebird4rc1/bin |
| 8 |
< |
Firebird Conf Directory = /opt/firebird4rc1/ |
| 9 |
< |
Firebird Client Library Path = /opt/firebird4rc1/lib/libfbclient.so |
| 6 |
> |
Firebird Environment Variable = /opt/firebird4.0.0 |
| 7 |
> |
Firebird Bin Directory = /opt/firebird4.0.0/bin |
| 8 |
> |
Firebird Conf Directory = /opt/firebird4.0.0/ |
| 9 |
> |
Firebird Client Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
| 10 |
|
Running Test 01: Open and read from Employee Database |
| 11 |
|
Read dataset unidirectional buffering |
| 12 |
|
Row No = 1 |
| 641 |
|
|
| 642 |
|
Rows printed = 42 |
| 643 |
|
|
| 644 |
< |
Current memory = 19,670,464 |
| 644 |
> |
Current memory = 19,686,512 |
| 645 |
|
Delta memory = 16,384 |
| 646 |
< |
Max memory = 19,765,360 |
| 647 |
< |
Elapsed time= 0.031 sec |
| 648 |
< |
Cpu = 0.020 sec |
| 646 |
> |
Max memory = 19,781,408 |
| 647 |
> |
Elapsed time= 0.015 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 20 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 4019 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 |
| 1491 |
|
isc_tpb_read |
| 1492 |
|
|
| 1493 |
|
Transaction Ending |
| 1494 |
< |
Transaction Ended after 2001 ms |
| 1494 |
> |
Transaction Ended after 1999 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 2038 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 29 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 22 ms |
| 1519 |
> |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 76 ms |
| 1520 |
|
|
| 1521 |
|
|
| 1522 |
|
------------------------------------------------------ |
| 1524 |
|
Authentication Method = Srp256 |
| 1525 |
|
Remote Protocol = TCPv4 |
| 1526 |
|
Attachment SQLDialect = 3 |
| 1527 |
< |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1" |
| 1528 |
< |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ" |
| 1529 |
< |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ" |
| 1527 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
| 1528 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
| 1529 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
| 1530 |
|
on disk structure version 13.0 |
| 1531 |
< |
FB Version: Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1", Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ", Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ", on disk structure version 13.0 |
| 1532 |
< |
Firebird Library Pathname = /opt/firebird4rc1/lib/libfbclient.so |
| 1531 |
> |
FB Version: Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0", Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ", Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ", on disk structure version 13.0 |
| 1532 |
> |
Firebird Library Pathname = /opt/firebird4.0.0/lib/libfbclient.so |
| 1533 |
|
DB SQLDialect = 3 |
| 1534 |
|
Allocation = 346 |
| 1535 |
|
Base Level = 4 |
| 1536 |
< |
DB File Name = /opt/firebird4rc1/examples/empbuild/employee.fdb |
| 1536 |
> |
DB File Name = /opt/firebird4.0.0/examples/empbuild/employee.fdb |
| 1537 |
|
DB Site Name = zeus |
| 1538 |
|
DB Implementation No = 7 |
| 1539 |
< |
Database Created: 01/2/2021 14:57:08 |
| 1539 |
> |
Database Created: 29/5/2021 16:47:30 |
| 1540 |
|
DB Implementation Class = 0 |
| 1541 |
|
Space is Reserved |
| 1542 |
|
ODS Minor Version = 0 |
| 1543 |
|
ODS Major Version = 13 |
| 1544 |
|
Page Size = 8192 |
| 1545 |
< |
Version = LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1 |
| 1546 |
< |
Current Memory = 19485440 |
| 1545 |
> |
Version = LI-V6.3.0.2496 Firebird 4.0 |
| 1546 |
> |
Current Memory = 19501200 |
| 1547 |
|
Forced Writes Enabled |
| 1548 |
< |
Max Memory = 19612048 |
| 1548 |
> |
Max Memory = 19627808 |
| 1549 |
|
Number of Buffers = 2048 |
| 1550 |
|
Sweep Interval = 20000 |
| 1551 |
|
User Names: SYSDBA |
| 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 |
|
|
| 3297 |
|
FULL_NAME = Guckenheimer, Mark |
| 3298 |
|
DEPT_PATH = Corporate Headquarters / Engineering / Software Products Div. / Quality Assurance (Charset Id = 4 Codepage = 65001) |
| 3299 |
|
DEPT_KEY_PATH = 000;600;620;622 (Charset Id = 4 Codepage = 65001) |
| 3300 |
< |
Current memory = 19,651,184 |
| 3300 |
> |
Current memory = 19,667,232 |
| 3301 |
|
Delta memory = 16,416 |
| 3302 |
< |
Max memory = 19,746,848 |
| 3302 |
> |
Max memory = 19,762,896 |
| 3303 |
|
Elapsed time= 0.026 sec |
| 3304 |
|
Cpu = 0.020 sec |
| 3305 |
|
Buffers = 2048 |
| 11764 |
|
|
| 11765 |
|
------------------------------------------------------ |
| 11766 |
|
Running Test 12: Test use of Services Connection |
| 11767 |
< |
Firebird Library PathName = /opt/firebird4rc1/lib/libfbclient.so |
| 11767 |
> |
Firebird Library PathName = /opt/firebird4.0.0/lib/libfbclient.so |
| 11768 |
|
Connect String = localhost:service_mgr |
| 11769 |
< |
Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1 |
| 11769 |
> |
Server Version = LI-V4.0.0.2496 Firebird 4.0 |
| 11770 |
|
Server Implementation = Firebird/Linux/AMD/Intel/x64 |
| 11771 |
|
Service Version = 2 |
| 11772 |
< |
Firebird Release = 4.0.0 (Build no. 2353) |
| 11772 |
> |
Firebird Release = 4.0.0 (Build no. 2496) |
| 11773 |
|
No. of attachments = 0 |
| 11774 |
|
No. of databases = 0 |
| 11775 |
< |
Base Location = /opt/firebird4rc1/ |
| 11775 |
> |
Base Location = /opt/firebird4.0.0/ |
| 11776 |
|
Lock File Location = /tmp/firebird/ |
| 11777 |
< |
Security Database Location = /opt/firebird4rc1/security4.fdb |
| 11778 |
< |
Message File Location = /opt/firebird4rc1/ |
| 11777 |
> |
Security Database Location = /opt/firebird4.0.0/security4.fdb |
| 11778 |
> |
Message File Location = /opt/firebird4.0.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 |
| 11781 |
> |
Database "/opt/firebird4.0.0/examples/empbuild/employee.fdb" |
| 11782 |
> |
Gstat execution time Wed Jul 7 11:45:32 2021 |
| 11783 |
|
|
| 11784 |
|
Database header page information: |
| 11785 |
|
Flags 0 |
| 11786 |
< |
Generation 659 |
| 11786 |
> |
Generation 438 |
| 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 456 |
| 11791 |
> |
Oldest active 457 |
| 11792 |
> |
Oldest snapshot 457 |
| 11793 |
> |
Next transaction 457 |
| 11794 |
|
Sequence number 0 |
| 11795 |
< |
Next attachment ID 406 |
| 11795 |
> |
Next attachment ID 274 |
| 11796 |
|
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc |
| 11797 |
|
Shadow count 0 |
| 11798 |
|
Page buffers 0 |
| 11799 |
|
Next header page 0 |
| 11800 |
|
Database dialect 3 |
| 11801 |
< |
Creation date Feb 1, 2021 14:57:08 |
| 11801 |
> |
Creation date May 29, 2021 15:47:30 |
| 11802 |
|
Attributes force write |
| 11803 |
|
|
| 11804 |
|
Variable header data: |
| 11805 |
< |
Database GUID: {22038096-B66F-4FBA-B3DF-A02ECCE5380E} |
| 11805 |
> |
Database GUID: {7D20C88E-C496-4598-99F9-E33293AFA7E3} |
| 11806 |
|
*END* |
| 11807 |
|
|
| 11808 |
|
|
| 11809 |
|
Database file sequence: |
| 11810 |
< |
File /opt/firebird4rc1/examples/empbuild/employee.fdb is the only file |
| 11810 |
> |
File /opt/firebird4.0.0/examples/empbuild/employee.fdb is the only file |
| 11811 |
|
|
| 11812 |
|
Analyzing database pages ... |
| 11813 |
|
COUNTRY (128) |
| 11940 |
|
60 - 79% = 0 |
| 11941 |
|
80 - 99% = 0 |
| 11942 |
|
|
| 11943 |
< |
Gstat completion time Wed Feb 17 10:45:05 2021 |
| 11943 |
> |
Gstat completion time Wed Jul 7 11:45:32 2021 |
| 11944 |
|
|
| 11945 |
|
|
| 11946 |
|
|
| 11947 |
|
Server Log |
| 11948 |
|
|
| 11949 |
< |
zeus Thu Feb 11 14:23:45 2021 |
| 11950 |
< |
firebird4rc1/bin/fbguard: guardian starting /opt/firebird4rc1/bin/firebird |
| 11949 |
> |
zeus Wed Jun 9 10:07:18 2021 |
| 11950 |
> |
firebird4/bin/fbguard: guardian starting /opt/firebird4/bin/firebird |
| 11951 |
|
|
| 11952 |
|
Online Validation |
| 11953 |
< |
10:45:09.59 Validation started |
| 11953 |
> |
11:45:32.71 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 |
> |
11:45:32.71 Relation 128 (COUNTRY) |
| 11956 |
> |
11:45:32.71 process pointer page 0 of 1 |
| 11957 |
> |
11:45:32.71 Index 1 (RDB$PRIMARY1) |
| 11958 |
> |
11:45:32.71 Relation 128 (COUNTRY) is ok |
| 11959 |
> |
|
| 11960 |
> |
11:45:32.71 Relation 129 (JOB) |
| 11961 |
> |
11:45:32.71 process pointer page 0 of 1 |
| 11962 |
> |
11:45:32.71 Index 1 (RDB$PRIMARY2) |
| 11963 |
> |
11:45:32.71 Index 2 (RDB$FOREIGN3) |
| 11964 |
> |
11:45:32.71 Index 3 (MAXSALX) |
| 11965 |
> |
11:45:32.71 Index 4 (MINSALX) |
| 11966 |
> |
11:45:32.71 Relation 129 (JOB) is ok |
| 11967 |
> |
|
| 11968 |
> |
11:45:32.71 Relation 130 (DEPARTMENT) |
| 11969 |
> |
11:45:32.71 process pointer page 0 of 1 |
| 11970 |
> |
11:45:32.71 Index 1 (RDB$4) |
| 11971 |
> |
11:45:32.71 Index 2 (RDB$PRIMARY5) |
| 11972 |
> |
11:45:32.71 Index 3 (RDB$FOREIGN6) |
| 11973 |
> |
11:45:32.71 Index 4 (BUDGETX) |
| 11974 |
> |
11:45:32.71 Index 5 (RDB$FOREIGN10) |
| 11975 |
> |
11:45:32.71 Relation 130 (DEPARTMENT) is ok |
| 11976 |
> |
|
| 11977 |
> |
11:45:32.71 Relation 131 (EMPLOYEE) |
| 11978 |
> |
11:45:32.71 process pointer page 0 of 1 |
| 11979 |
> |
11:45:32.71 Index 1 (RDB$PRIMARY7) |
| 11980 |
> |
11:45:32.71 Index 2 (RDB$FOREIGN8) |
| 11981 |
> |
11:45:32.71 Index 3 (RDB$FOREIGN9) |
| 11982 |
> |
11:45:32.71 Index 4 (NAMEX) |
| 11983 |
> |
11:45:32.71 Relation 131 (EMPLOYEE) is ok |
| 11984 |
> |
|
| 11985 |
> |
11:45:32.71 Relation 133 (PROJECT) |
| 11986 |
> |
11:45:32.71 process pointer page 0 of 1 |
| 11987 |
> |
11:45:32.71 Index 1 (RDB$11) |
| 11988 |
> |
11:45:32.71 Index 2 (RDB$PRIMARY12) |
| 11989 |
> |
11:45:32.71 Index 3 (RDB$FOREIGN13) |
| 11990 |
> |
11:45:32.71 Index 4 (PRODTYPEX) |
| 11991 |
> |
11:45:32.71 Relation 133 (PROJECT) is ok |
| 11992 |
> |
|
| 11993 |
> |
11:45:32.72 Relation 134 (EMPLOYEE_PROJECT) |
| 11994 |
> |
11:45:32.72 process pointer page 0 of 1 |
| 11995 |
> |
11:45:32.72 Index 1 (RDB$PRIMARY14) |
| 11996 |
> |
11:45:32.72 Index 2 (RDB$FOREIGN15) |
| 11997 |
> |
11:45:32.72 Index 3 (RDB$FOREIGN16) |
| 11998 |
> |
11:45:32.72 Relation 134 (EMPLOYEE_PROJECT) is ok |
| 11999 |
> |
|
| 12000 |
> |
11:45:32.72 Relation 135 (PROJ_DEPT_BUDGET) |
| 12001 |
> |
11:45:32.72 process pointer page 0 of 1 |
| 12002 |
> |
11:45:32.72 Index 1 (RDB$PRIMARY17) |
| 12003 |
> |
11:45:32.72 Index 2 (RDB$FOREIGN18) |
| 12004 |
> |
11:45:32.72 Index 3 (RDB$FOREIGN19) |
| 12005 |
> |
11:45:32.73 Relation 135 (PROJ_DEPT_BUDGET) is ok |
| 12006 |
> |
|
| 12007 |
> |
11:45:32.73 Relation 136 (SALARY_HISTORY) |
| 12008 |
> |
11:45:32.73 process pointer page 0 of 1 |
| 12009 |
> |
11:45:32.73 Index 1 (RDB$PRIMARY20) |
| 12010 |
> |
11:45:32.73 Index 2 (RDB$FOREIGN21) |
| 12011 |
> |
11:45:32.73 Index 3 (CHANGEX) |
| 12012 |
> |
11:45:32.73 Index 4 (UPDATERX) |
| 12013 |
> |
11:45:32.73 Relation 136 (SALARY_HISTORY) is ok |
| 12014 |
> |
|
| 12015 |
> |
11:45:32.73 Relation 137 (CUSTOMER) |
| 12016 |
> |
11:45:32.73 process pointer page 0 of 1 |
| 12017 |
> |
11:45:32.73 Index 1 (RDB$PRIMARY22) |
| 12018 |
> |
11:45:32.73 Index 2 (RDB$FOREIGN23) |
| 12019 |
> |
11:45:32.73 Index 3 (CUSTNAMEX) |
| 12020 |
> |
11:45:32.73 Index 4 (CUSTREGION) |
| 12021 |
> |
11:45:32.73 Relation 137 (CUSTOMER) is ok |
| 12022 |
> |
|
| 12023 |
> |
11:45:32.73 Relation 138 (SALES) |
| 12024 |
> |
11:45:32.73 process pointer page 0 of 1 |
| 12025 |
> |
11:45:32.73 Index 1 (RDB$PRIMARY24) |
| 12026 |
> |
11:45:32.73 Index 2 (RDB$FOREIGN25) |
| 12027 |
> |
11:45:32.73 Index 3 (RDB$FOREIGN26) |
| 12028 |
> |
11:45:32.73 Index 4 (NEEDX) |
| 12029 |
> |
11:45:32.73 Index 5 (QTYX) |
| 12030 |
> |
11:45:32.73 Index 6 (SALESTATX) |
| 12031 |
> |
11:45:32.73 Relation 138 (SALES) is ok |
| 12032 |
|
|
| 12033 |
< |
10:45:09.61 Validation finished |
| 12033 |
> |
11:45:32.73 Validation finished |
| 12034 |
|
|
| 12035 |
|
|
| 12036 |
|
Normal Validation |
| 13315 |
|
|
| 13316 |
|
Rows printed = 2 |
| 13317 |
|
|
| 13318 |
< |
Current memory = 19,649,408 |
| 13318 |
> |
Current memory = 19,665,456 |
| 13319 |
|
Delta memory = 16,032 |
| 13320 |
< |
Max memory = 19,744,992 |
| 13321 |
< |
Elapsed time= 0.002 sec |
| 13320 |
> |
Max memory = 19,761,040 |
| 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 |
+ |
*Monitor* |
| 13546 |
+ |
[Application: IBX Test Suite] |
| 13547 |
+ |
Monitoring Disabled |
| 13548 |
+ |
33 ISQL Monitor Messages Received |
| 13549 |
|
|
| 13550 |
|
|
| 13551 |
|
------------------------------------------------------ |
| 13583 |
|
|
| 13584 |
|
Rows printed = 2 |
| 13585 |
|
|
| 13586 |
< |
Current memory = 19,649,408 |
| 13586 |
> |
Current memory = 19,665,456 |
| 13587 |
|
Delta memory = 16,032 |
| 13588 |
< |
Max memory = 19,744,992 |
| 13589 |
< |
Elapsed time= 0.001 sec |
| 13588 |
> |
Max memory = 19,761,040 |
| 13589 |
> |
Elapsed time= 0.102 sec |
| 13590 |
|
Cpu = 0.000 sec |
| 13591 |
|
Buffers = 2048 |
| 13592 |
|
Reads = 2 |
| 13630 |
|
|
| 13631 |
|
Rows printed = 2 |
| 13632 |
|
|
| 13633 |
< |
*Monitor* 17/2/2021 10:45:14 -> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13634 |
< |
-> 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 |
| 13633 |
> |
33 ISQL Monitor Messages written |
| 13634 |
> |
*Monitor* |
| 13635 |
|
[Application: IBX Test Suite] |
| 13636 |
|
Test_Database_14: [Connect] |
| 13637 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13637 |
> |
*Monitor* |
| 13638 |
|
[Application: IBX Test Suite] |
| 13639 |
|
Test_Transaction_14: [Start transaction] |
| 13640 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13640 |
> |
*Monitor* |
| 13641 |
|
[Application: IBX Test Suite] |
| 13642 |
|
: [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 |
| 13643 |
|
|
| 13649 |
|
-> Filter |
| 13650 |
|
-> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID |
| 13651 |
|
-> 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 |
| 13652 |
|
-> 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) |
| 13653 |
|
-> Filter |
| 13654 |
|
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
| 13655 |
|
-> Bitmap |
| 13658 |
|
-> Table "EMPLOYEE" as "A" Access By ID |
| 13659 |
|
-> Bitmap |
| 13660 |
|
-> Index "RDB$FOREIGN8" Range Scan (full match) |
| 13661 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13661 |
> |
*Monitor* |
| 13662 |
|
[Application: IBX Test Suite] |
| 13663 |
|
: [Start transaction] |
| 13664 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13664 |
> |
*Monitor* |
| 13665 |
|
[Application: IBX Test Suite] |
| 13666 |
|
: [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)) |
| 13667 |
|
|
| 13676 |
|
-> Table "RDB$FIELDS" as "F" Access By ID |
| 13677 |
|
-> Bitmap |
| 13678 |
|
-> Index "RDB$INDEX_2" Unique Scan |
| 13679 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13679 |
> |
*Monitor* |
| 13680 |
|
[Application: IBX Test Suite] |
| 13681 |
|
: [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)) |
| 13682 |
|
|
| 13683 |
|
RELATION = EMPLOYEE |
| 13684 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13684 |
> |
*Monitor* |
| 13685 |
|
[Application: IBX Test Suite] |
| 13686 |
|
: [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)) |
| 13687 |
|
|
| 13688 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13688 |
> |
*Monitor* |
| 13689 |
|
[Application: IBX Test Suite] |
| 13690 |
|
: [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)) |
| 13691 |
|
|
| 13692 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13692 |
> |
*Monitor* |
| 13693 |
|
[Application: IBX Test Suite] |
| 13694 |
|
: [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)) |
| 13695 |
|
|
| 13696 |
|
SEOFReached |
| 13697 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13697 |
> |
*Monitor* |
| 13698 |
|
[Application: IBX Test Suite] |
| 13699 |
|
: [Commit (Hard commit)] |
| 13700 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13700 |
> |
*Monitor* |
| 13701 |
|
[Application: IBX Test Suite] |
| 13702 |
|
: [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 |
| 13703 |
|
|
| 13704 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13704 |
> |
*Monitor* |
| 13705 |
|
[Application: IBX Test Suite] |
| 13706 |
|
: [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 |
| 13707 |
|
|
| 13708 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13708 |
> |
*Monitor* |
| 13709 |
|
[Application: IBX Test Suite] |
| 13710 |
|
: [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 |
| 13711 |
|
|
| 13712 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13712 |
> |
*Monitor* |
| 13713 |
|
[Application: IBX Test Suite] |
| 13714 |
|
: [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 |
| 13715 |
|
|
| 13716 |
|
SEOFReached |
| 13717 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13717 |
> |
*Monitor* |
| 13718 |
|
[Application: IBX Test Suite] |
| 13719 |
|
Test_Transaction_14: [Commit (Hard commit)] |
| 13720 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13720 |
> |
*Monitor* |
| 13721 |
|
[Application: IBX Test Suite] |
| 13722 |
|
Test_Database_14: [Disconnect] |
| 13723 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13723 |
> |
*Monitor* |
| 13724 |
|
[Application: IBX Test Suite] |
| 13725 |
|
Test_Database_14: [Connect] |
| 13726 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13726 |
> |
*Monitor* |
| 13727 |
|
[Application: IBX Test Suite] |
| 13728 |
|
Test_Transaction_14: [Start transaction] |
| 13729 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13729 |
> |
*Monitor* |
| 13730 |
|
[Application: IBX Test Suite] |
| 13731 |
|
: [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 |
| 13732 |
|
|
| 13738 |
|
-> Filter |
| 13739 |
|
-> Table "DEPARTMENT" as "DEPTS DEPARTMENT" Access By ID |
| 13740 |
|
-> Bitmap |
| 13741 |
< |
|
| 13872 |
< |
*Monitor* 17/2/2021 10:45:14 -> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13741 |
> |
-> Index "RDB$FOREIGN6" Range Scan (full match) |
| 13742 |
|
-> Filter |
| 13743 |
|
-> Table "DEPARTMENT" as "DEPTS D" Access By ID |
| 13744 |
|
-> Bitmap |
| 13747 |
|
-> Table "EMPLOYEE" as "A" Access By ID |
| 13748 |
|
-> Bitmap |
| 13749 |
|
-> Index "RDB$FOREIGN8" Range Scan (full match) |
| 13750 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13750 |
> |
*Monitor* |
| 13751 |
|
[Application: IBX Test Suite] |
| 13752 |
|
: [Start transaction] |
| 13753 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13753 |
> |
*Monitor* |
| 13754 |
|
[Application: IBX Test Suite] |
| 13755 |
|
: [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)) |
| 13756 |
|
|
| 13765 |
|
-> Table "RDB$FIELDS" as "F" Access By ID |
| 13766 |
|
-> Bitmap |
| 13767 |
|
-> Index "RDB$INDEX_2" Unique Scan |
| 13768 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13768 |
> |
*Monitor* |
| 13769 |
|
[Application: IBX Test Suite] |
| 13770 |
|
: [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)) |
| 13771 |
|
|
| 13772 |
|
RELATION = EMPLOYEE |
| 13773 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13773 |
> |
*Monitor* |
| 13774 |
|
[Application: IBX Test Suite] |
| 13775 |
|
: [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)) |
| 13776 |
|
|
| 13777 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13777 |
> |
*Monitor* |
| 13778 |
|
[Application: IBX Test Suite] |
| 13779 |
|
: [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)) |
| 13780 |
|
|
| 13781 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13781 |
> |
*Monitor* |
| 13782 |
|
[Application: IBX Test Suite] |
| 13783 |
|
: [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)) |
| 13784 |
|
|
| 13785 |
|
SEOFReached |
| 13786 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13786 |
> |
*Monitor* |
| 13787 |
|
[Application: IBX Test Suite] |
| 13788 |
|
: [Commit (Hard commit)] |
| 13789 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13789 |
> |
*Monitor* |
| 13790 |
|
[Application: IBX Test Suite] |
| 13791 |
|
: [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 |
| 13792 |
|
|
| 13793 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13793 |
> |
*Monitor* |
| 13794 |
|
[Application: IBX Test Suite] |
| 13795 |
|
: [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 |
| 13796 |
|
|
| 13797 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13797 |
> |
*Monitor* |
| 13798 |
|
[Application: IBX Test Suite] |
| 13799 |
|
: [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 |
| 13800 |
|
|
| 13801 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13801 |
> |
*Monitor* |
| 13802 |
|
[Application: IBX Test Suite] |
| 13803 |
|
: [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 |
| 13804 |
|
|
| 13805 |
|
SEOFReached |
| 13806 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13806 |
> |
*Monitor* |
| 13807 |
|
[Application: IBX Test Suite] |
| 13808 |
|
Test_Transaction_14: [Commit (Hard commit)] |
| 13809 |
< |
*Monitor* 17/2/2021 10:45:14 |
| 13809 |
> |
*Monitor* |
| 13810 |
|
[Application: IBX Test Suite] |
| 13811 |
|
Test_Database_14: [Disconnect] |
| 13812 |
+ |
*Monitor* |
| 13813 |
+ |
[Application: IBX Test Suite] |
| 13814 |
+ |
Monitoring Disabled |
| 13815 |
+ |
33 ISQL Monitor Messages Received |
| 13816 |
|
|
| 13817 |
|
|
| 13818 |
|
------------------------------------------------------ |
| 15204 |
|
MyText VarChar(1024), |
| 15205 |
|
Primary Key (RowID) |
| 15206 |
|
); |
| 15207 |
< |
Loading data into database table. Started at 17/2/2021 10:45:33.536 |
| 15208 |
< |
Data load completed at 17/2/2021 10:47:12.797 Elapsed Time = 99261 ms, 100000 records loaded |
| 15209 |
< |
MD5 checksum = 3c3d659173420c4374844a9e400fa99c |
| 15210 |
< |
Database Read started at 17/2/2021 10:47:12.808 |
| 15211 |
< |
Read Dataset completed at 17/2/2021 10:47:43.727 Elapsed Time = 30919 ms, 100000 records read |
| 15212 |
< |
MD5 checksum = 3c3d659173420c4374844a9e400fa99c |
| 15207 |
> |
Loading data into database table. Started at 07/7/2021 11:46:17.204 |
| 15208 |
> |
Data load completed at 07/7/2021 11:48:00.164 Elapsed Time = 102960 ms, 100000 records loaded |
| 15209 |
> |
MD5 checksum = 1c66cd114720b84a4fa21d01f8a0ba2b |
| 15210 |
> |
Database Read started at 07/7/2021 11:48:00.174 |
| 15211 |
> |
Read Dataset completed at 07/7/2021 11:48:38.470 Elapsed Time = 38296 ms, 100000 records read |
| 15212 |
> |
MD5 checksum = 1c66cd114720b84a4fa21d01f8a0ba2b |
| 15213 |
|
Test Completed successfully |
| 15214 |
+ |
07/7/2021 11:48:38.470 Test 21 passes as long as the MD5 sums are identical |
| 15215 |
|
|
| 15216 |
|
|
| 15217 |
|
------------------------------------------------------ |
