| 639 |
|
|
| 640 |
|
Rows printed = 42 |
| 641 |
|
|
| 642 |
< |
Current memory = 960,760 |
| 643 |
< |
Delta memory = 9,624 |
| 644 |
< |
Max memory = 1,012,104 |
| 645 |
< |
Elapsed time= 0.029 sec |
| 646 |
< |
Cpu = 0.001 sec |
| 642 |
> |
Current memory = 960,816 |
| 643 |
> |
Delta memory = 9,512 |
| 644 |
> |
Max memory = 1,012,160 |
| 645 |
> |
Elapsed time= 0.032 sec |
| 646 |
> |
Cpu = 0.003 sec |
| 647 |
|
Buffers = 75 |
| 648 |
|
Reads = 3 |
| 649 |
|
Writes = 0 |
| 1443 |
|
isc_dpb_lc_ctype = UTF8 |
| 1444 |
|
|
| 1445 |
|
Before Disconnect |
| 1446 |
< |
localhost:employee Disconnected after 21 ms |
| 1446 |
> |
localhost:employee Disconnected after 19 ms |
| 1447 |
|
Before Connect |
| 1448 |
|
Connected to localhost:employee |
| 1449 |
|
DPB: Item Count = 3 |
| 1452 |
|
isc_dpb_lc_ctype = UTF8 |
| 1453 |
|
|
| 1454 |
|
Before Disconnect |
| 1455 |
< |
localhost:employee Disconnected after 3965 ms |
| 1455 |
> |
localhost:employee Disconnected after 3982 ms |
| 1456 |
|
Idle Timer Expired for Test_Database_02 |
| 1457 |
|
Database Closed |
| 1458 |
|
Transaction Events |
| 1475 |
|
isc_tpb_read |
| 1476 |
|
|
| 1477 |
|
Transaction Ending |
| 1478 |
< |
Transaction Ended after 11 ms |
| 1478 |
> |
Transaction Ended after 8 ms |
| 1479 |
|
Transaction idle timer test |
| 1480 |
|
Requested TPB: Item Count = 3 |
| 1481 |
|
isc_tpb_concurrency |
| 1489 |
|
isc_tpb_read |
| 1490 |
|
|
| 1491 |
|
Transaction Ending |
| 1492 |
< |
Transaction Ended after 2026 ms |
| 1492 |
> |
Transaction Ended after 2020 ms |
| 1493 |
|
Idle Timer Expired for Test_Transaction_02 |
| 1494 |
|
Before Disconnect |
| 1495 |
|
localhost:employee Disconnected after 2065 ms |
| 1504 |
|
|
| 1505 |
|
localhost:/tmp/ibx-testsuite/testsuite1.fdb created |
| 1506 |
|
Before Disconnect |
| 1507 |
< |
localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 24 ms |
| 1507 |
> |
localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms |
| 1508 |
|
Before Connect |
| 1509 |
|
Warning: SQL Dialect Downgrade of localhost:/tmp/ibx-testsuite/testsuite1.fdb |
| 1510 |
|
Connected to localhost:/tmp/ibx-testsuite/testsuite1.fdb |
| 1514 |
|
isc_dpb_lc_ctype = UTF8 |
| 1515 |
|
|
| 1516 |
|
Before Disconnect |
| 1517 |
< |
localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 16 ms |
| 1517 |
> |
localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms |
| 1518 |
|
|
| 1519 |
|
|
| 1520 |
|
------------------------------------------------------ |
| 1541 |
|
ODS Major Version = 11 |
| 1542 |
|
Page Size = 4096 |
| 1543 |
|
Version = LI-V6.3.9.27139 Firebird 2.5 |
| 1544 |
< |
Current Memory = 876840 |
| 1544 |
> |
Current Memory = 876896 |
| 1545 |
|
Forced Writes Enabled |
| 1546 |
< |
Max Memory = 902432 |
| 1546 |
> |
Max Memory = 902656 |
| 1547 |
|
Number of Buffers = 75 |
| 1548 |
|
Sweep Interval = 20000 |
| 1549 |
|
User Names: SYSDBA |
| 3148 |
|
FULL_NAME = Guckenheimer, Mark |
| 3149 |
|
DEPT_PATH = Corporate Headquarters / Engineering / Software Products Div. / Quality Assurance |
| 3150 |
|
DEPT_KEY_PATH = 000;600;620;622 |
| 3151 |
< |
Current memory = 952,624 |
| 3152 |
< |
Delta memory = 9,608 |
| 3153 |
< |
Max memory = 1,013,496 |
| 3154 |
< |
Elapsed time= 0.030 sec |
| 3155 |
< |
Cpu = 0.002 sec |
| 3151 |
> |
Current memory = 952,680 |
| 3152 |
> |
Delta memory = 9,496 |
| 3153 |
> |
Max memory = 1,013,552 |
| 3154 |
> |
Elapsed time= 0.027 sec |
| 3155 |
> |
Cpu = 0.001 sec |
| 3156 |
|
Buffers = 75 |
| 3157 |
|
Reads = 3 |
| 3158 |
|
Writes = 0 |
| 9917 |
|
Database Statistics for employee |
| 9918 |
|
|
| 9919 |
|
Database "/opt/firebird2.5.9/examples/empbuild/employee.fdb" |
| 9920 |
< |
Gstat execution time Sun Oct 17 23:44:30 2021 |
| 9920 |
> |
Gstat execution time Sat Oct 23 13:25:30 2021 |
| 9921 |
|
|
| 9922 |
|
Database header page information: |
| 9923 |
|
Flags 0 |
| 9924 |
|
Checksum 12345 |
| 9925 |
< |
Generation 6857 |
| 9925 |
> |
Generation 8221 |
| 9926 |
|
Page size 4096 |
| 9927 |
|
ODS version 11.2 |
| 9928 |
< |
Oldest transaction 4110 |
| 9929 |
< |
Oldest active 4111 |
| 9930 |
< |
Oldest snapshot 4111 |
| 9931 |
< |
Next transaction 4111 |
| 9928 |
> |
Oldest transaction 4613 |
| 9929 |
> |
Oldest active 4894 |
| 9930 |
> |
Oldest snapshot 4894 |
| 9931 |
> |
Next transaction 4894 |
| 9932 |
|
Bumped transaction 1 |
| 9933 |
|
Sequence number 0 |
| 9934 |
< |
Next attachment ID 1404 |
| 9934 |
> |
Next attachment ID 1665 |
| 9935 |
|
Implementation ID 24 |
| 9936 |
|
Shadow count 0 |
| 9937 |
|
Page buffers 0 |
| 10056 |
|
INET/inet_error: connect errno = 111 |
| 10057 |
|
|
| 10058 |
|
Online Validation |
| 10059 |
< |
23:44:31.75 Validation started |
| 10059 |
> |
13:25:31.69 Validation started |
| 10060 |
|
|
| 10061 |
< |
23:44:31.75 Relation 128 (COUNTRY) |
| 10062 |
< |
23:44:31.75 process pointer page 0 of 1 |
| 10063 |
< |
23:44:31.75 Index 1 (RDB$PRIMARY1) |
| 10064 |
< |
23:44:31.75 Relation 128 (COUNTRY) is ok |
| 10065 |
< |
|
| 10066 |
< |
23:44:31.75 Relation 129 (JOB) |
| 10067 |
< |
23:44:31.75 process pointer page 0 of 1 |
| 10068 |
< |
23:44:31.75 Index 1 (RDB$PRIMARY2) |
| 10069 |
< |
23:44:31.75 Index 2 (RDB$FOREIGN3) |
| 10070 |
< |
23:44:31.75 Index 3 (MAXSALX) |
| 10071 |
< |
23:44:31.76 Index 4 (MINSALX) |
| 10072 |
< |
23:44:31.76 Relation 129 (JOB) is ok |
| 10073 |
< |
|
| 10074 |
< |
23:44:31.76 Relation 130 (DEPARTMENT) |
| 10075 |
< |
23:44:31.76 process pointer page 0 of 1 |
| 10076 |
< |
23:44:31.76 Index 1 (RDB$4) |
| 10077 |
< |
23:44:31.76 Index 2 (RDB$PRIMARY5) |
| 10078 |
< |
23:44:31.76 Index 3 (RDB$FOREIGN6) |
| 10079 |
< |
23:44:31.76 Index 4 (BUDGETX) |
| 10080 |
< |
23:44:31.76 Index 5 (RDB$FOREIGN10) |
| 10081 |
< |
23:44:31.76 Relation 130 (DEPARTMENT) is ok |
| 10082 |
< |
|
| 10083 |
< |
23:44:31.76 Relation 131 (EMPLOYEE) |
| 10084 |
< |
23:44:31.76 process pointer page 0 of 1 |
| 10085 |
< |
23:44:31.76 Index 1 (RDB$PRIMARY7) |
| 10086 |
< |
23:44:31.76 Index 2 (RDB$FOREIGN8) |
| 10087 |
< |
23:44:31.76 Index 3 (RDB$FOREIGN9) |
| 10088 |
< |
23:44:31.76 Index 4 (NAMEX) |
| 10089 |
< |
23:44:31.76 Relation 131 (EMPLOYEE) is ok |
| 10090 |
< |
|
| 10091 |
< |
23:44:31.76 Relation 133 (PROJECT) |
| 10092 |
< |
23:44:31.76 process pointer page 0 of 1 |
| 10093 |
< |
23:44:31.76 Index 1 (RDB$11) |
| 10094 |
< |
23:44:31.76 Index 2 (RDB$PRIMARY12) |
| 10095 |
< |
23:44:31.76 Index 3 (RDB$FOREIGN13) |
| 10096 |
< |
23:44:31.76 Index 4 (PRODTYPEX) |
| 10097 |
< |
23:44:31.76 Relation 133 (PROJECT) is ok |
| 10098 |
< |
|
| 10099 |
< |
23:44:31.76 Relation 134 (EMPLOYEE_PROJECT) |
| 10100 |
< |
23:44:31.76 process pointer page 0 of 1 |
| 10101 |
< |
23:44:31.76 Index 1 (RDB$PRIMARY14) |
| 10102 |
< |
23:44:31.76 Index 2 (RDB$FOREIGN15) |
| 10103 |
< |
23:44:31.76 Index 3 (RDB$FOREIGN16) |
| 10104 |
< |
23:44:31.76 Relation 134 (EMPLOYEE_PROJECT) is ok |
| 10105 |
< |
|
| 10106 |
< |
23:44:31.76 Relation 135 (PROJ_DEPT_BUDGET) |
| 10107 |
< |
23:44:31.76 process pointer page 0 of 1 |
| 10108 |
< |
23:44:31.76 Index 1 (RDB$PRIMARY17) |
| 10109 |
< |
23:44:31.76 Index 2 (RDB$FOREIGN18) |
| 10110 |
< |
23:44:31.76 Index 3 (RDB$FOREIGN19) |
| 10111 |
< |
23:44:31.76 Relation 135 (PROJ_DEPT_BUDGET) is ok |
| 10112 |
< |
|
| 10113 |
< |
23:44:31.76 Relation 136 (SALARY_HISTORY) |
| 10114 |
< |
23:44:31.76 process pointer page 0 of 1 |
| 10115 |
< |
23:44:31.76 Index 1 (RDB$PRIMARY20) |
| 10116 |
< |
23:44:31.76 Index 2 (RDB$FOREIGN21) |
| 10117 |
< |
23:44:31.76 Index 3 (CHANGEX) |
| 10118 |
< |
23:44:31.76 Index 4 (UPDATERX) |
| 10119 |
< |
23:44:31.76 Relation 136 (SALARY_HISTORY) is ok |
| 10120 |
< |
|
| 10121 |
< |
23:44:31.76 Relation 137 (CUSTOMER) |
| 10122 |
< |
23:44:31.76 process pointer page 0 of 1 |
| 10123 |
< |
23:44:31.76 Index 1 (RDB$PRIMARY22) |
| 10124 |
< |
23:44:31.76 Index 2 (RDB$FOREIGN23) |
| 10125 |
< |
23:44:31.77 Index 3 (CUSTNAMEX) |
| 10126 |
< |
23:44:31.77 Index 4 (CUSTREGION) |
| 10127 |
< |
23:44:31.77 Relation 137 (CUSTOMER) is ok |
| 10128 |
< |
|
| 10129 |
< |
23:44:31.77 Relation 138 (SALES) |
| 10130 |
< |
23:44:31.77 process pointer page 0 of 1 |
| 10131 |
< |
23:44:31.77 Index 1 (RDB$PRIMARY24) |
| 10132 |
< |
23:44:31.77 Index 2 (RDB$FOREIGN25) |
| 10133 |
< |
23:44:31.77 Index 3 (RDB$FOREIGN26) |
| 10134 |
< |
23:44:31.77 Index 4 (NEEDX) |
| 10135 |
< |
23:44:31.77 Index 5 (QTYX) |
| 10136 |
< |
23:44:31.77 Index 6 (SALESTATX) |
| 10137 |
< |
23:44:31.77 Relation 138 (SALES) is ok |
| 10061 |
> |
13:25:31.69 Relation 128 (COUNTRY) |
| 10062 |
> |
13:25:31.69 process pointer page 0 of 1 |
| 10063 |
> |
13:25:31.69 Index 1 (RDB$PRIMARY1) |
| 10064 |
> |
13:25:31.69 Relation 128 (COUNTRY) is ok |
| 10065 |
> |
|
| 10066 |
> |
13:25:31.69 Relation 129 (JOB) |
| 10067 |
> |
13:25:31.69 process pointer page 0 of 1 |
| 10068 |
> |
13:25:31.70 Index 1 (RDB$PRIMARY2) |
| 10069 |
> |
13:25:31.70 Index 2 (RDB$FOREIGN3) |
| 10070 |
> |
13:25:31.70 Index 3 (MAXSALX) |
| 10071 |
> |
13:25:31.70 Index 4 (MINSALX) |
| 10072 |
> |
13:25:31.70 Relation 129 (JOB) is ok |
| 10073 |
> |
|
| 10074 |
> |
13:25:31.70 Relation 130 (DEPARTMENT) |
| 10075 |
> |
13:25:31.70 process pointer page 0 of 1 |
| 10076 |
> |
13:25:31.70 Index 1 (RDB$4) |
| 10077 |
> |
13:25:31.70 Index 2 (RDB$PRIMARY5) |
| 10078 |
> |
13:25:31.70 Index 3 (RDB$FOREIGN6) |
| 10079 |
> |
13:25:31.70 Index 4 (BUDGETX) |
| 10080 |
> |
13:25:31.70 Index 5 (RDB$FOREIGN10) |
| 10081 |
> |
13:25:31.70 Relation 130 (DEPARTMENT) is ok |
| 10082 |
> |
|
| 10083 |
> |
13:25:31.70 Relation 131 (EMPLOYEE) |
| 10084 |
> |
13:25:31.70 process pointer page 0 of 1 |
| 10085 |
> |
13:25:31.70 Index 1 (RDB$PRIMARY7) |
| 10086 |
> |
13:25:31.70 Index 2 (RDB$FOREIGN8) |
| 10087 |
> |
13:25:31.70 Index 3 (RDB$FOREIGN9) |
| 10088 |
> |
13:25:31.70 Index 4 (NAMEX) |
| 10089 |
> |
13:25:31.70 Relation 131 (EMPLOYEE) is ok |
| 10090 |
> |
|
| 10091 |
> |
13:25:31.70 Relation 133 (PROJECT) |
| 10092 |
> |
13:25:31.70 process pointer page 0 of 1 |
| 10093 |
> |
13:25:31.70 Index 1 (RDB$11) |
| 10094 |
> |
13:25:31.70 Index 2 (RDB$PRIMARY12) |
| 10095 |
> |
13:25:31.70 Index 3 (RDB$FOREIGN13) |
| 10096 |
> |
13:25:31.70 Index 4 (PRODTYPEX) |
| 10097 |
> |
13:25:31.70 Relation 133 (PROJECT) is ok |
| 10098 |
> |
|
| 10099 |
> |
13:25:31.70 Relation 134 (EMPLOYEE_PROJECT) |
| 10100 |
> |
13:25:31.70 process pointer page 0 of 1 |
| 10101 |
> |
13:25:31.70 Index 1 (RDB$PRIMARY14) |
| 10102 |
> |
13:25:31.70 Index 2 (RDB$FOREIGN15) |
| 10103 |
> |
13:25:31.70 Index 3 (RDB$FOREIGN16) |
| 10104 |
> |
13:25:31.70 Relation 134 (EMPLOYEE_PROJECT) is ok |
| 10105 |
> |
|
| 10106 |
> |
13:25:31.70 Relation 135 (PROJ_DEPT_BUDGET) |
| 10107 |
> |
13:25:31.70 process pointer page 0 of 1 |
| 10108 |
> |
13:25:31.70 Index 1 (RDB$PRIMARY17) |
| 10109 |
> |
13:25:31.70 Index 2 (RDB$FOREIGN18) |
| 10110 |
> |
13:25:31.70 Index 3 (RDB$FOREIGN19) |
| 10111 |
> |
13:25:31.70 Relation 135 (PROJ_DEPT_BUDGET) is ok |
| 10112 |
> |
|
| 10113 |
> |
13:25:31.70 Relation 136 (SALARY_HISTORY) |
| 10114 |
> |
13:25:31.70 process pointer page 0 of 1 |
| 10115 |
> |
13:25:31.70 Index 1 (RDB$PRIMARY20) |
| 10116 |
> |
13:25:31.70 Index 2 (RDB$FOREIGN21) |
| 10117 |
> |
13:25:31.70 Index 3 (CHANGEX) |
| 10118 |
> |
13:25:31.70 Index 4 (UPDATERX) |
| 10119 |
> |
13:25:31.71 Relation 136 (SALARY_HISTORY) is ok |
| 10120 |
> |
|
| 10121 |
> |
13:25:31.71 Relation 137 (CUSTOMER) |
| 10122 |
> |
13:25:31.71 process pointer page 0 of 1 |
| 10123 |
> |
13:25:31.71 Index 1 (RDB$PRIMARY22) |
| 10124 |
> |
13:25:31.71 Index 2 (RDB$FOREIGN23) |
| 10125 |
> |
13:25:31.71 Index 3 (CUSTNAMEX) |
| 10126 |
> |
13:25:31.71 Index 4 (CUSTREGION) |
| 10127 |
> |
13:25:31.71 Relation 137 (CUSTOMER) is ok |
| 10128 |
> |
|
| 10129 |
> |
13:25:31.71 Relation 138 (SALES) |
| 10130 |
> |
13:25:31.71 process pointer page 0 of 1 |
| 10131 |
> |
13:25:31.71 Index 1 (RDB$PRIMARY24) |
| 10132 |
> |
13:25:31.71 Index 2 (RDB$FOREIGN25) |
| 10133 |
> |
13:25:31.71 Index 3 (RDB$FOREIGN26) |
| 10134 |
> |
13:25:31.71 Index 4 (NEEDX) |
| 10135 |
> |
13:25:31.71 Index 5 (QTYX) |
| 10136 |
> |
13:25:31.71 Index 6 (SALESTATX) |
| 10137 |
> |
13:25:31.71 Relation 138 (SALES) is ok |
| 10138 |
|
|
| 10139 |
< |
23:44:31.77 Validation finished |
| 10139 |
> |
13:25:31.71 Validation finished |
| 10140 |
|
|
| 10141 |
|
|
| 10142 |
|
Normal Validation |
| 11422 |
|
Rows printed = 2 |
| 11423 |
|
|
| 11424 |
|
Current memory = 966,728 |
| 11425 |
< |
Delta memory = 9,344 |
| 11425 |
> |
Delta memory = 9,232 |
| 11426 |
|
Max memory = 1,012,400 |
| 11427 |
< |
Elapsed time= 0.004 sec |
| 11427 |
> |
Elapsed time= 0.002 sec |
| 11428 |
|
Cpu = 0.000 sec |
| 11429 |
|
Buffers = 75 |
| 11430 |
|
Reads = 2 |
| 11644 |
|
Rows printed = 2 |
| 11645 |
|
|
| 11646 |
|
Current memory = 966,728 |
| 11647 |
< |
Delta memory = 9,344 |
| 11647 |
> |
Delta memory = 9,232 |
| 11648 |
|
Max memory = 1,012,400 |
| 11649 |
< |
Elapsed time= 0.104 sec |
| 11650 |
< |
Cpu = 0.000 sec |
| 11649 |
> |
Elapsed time= 0.102 sec |
| 11650 |
> |
Cpu = 0.001 sec |
| 11651 |
|
Buffers = 75 |
| 11652 |
|
Reads = 2 |
| 11653 |
|
Writes = 0 |
| 12985 |
|
MyText VarChar(1024), |
| 12986 |
|
Primary Key (RowID) |
| 12987 |
|
); |
| 12988 |
< |
Loading data into database table. Started at 17/10/2021 23:45:12.801 |
| 12989 |
< |
Data load completed at 17/10/2021 23:48:03.397 Elapsed Time = 170596 ms, 100000 records loaded |
| 12990 |
< |
Message Hash = b20198e47d7f7ff5fcbc316e429149cb |
| 12991 |
< |
Database Read started at 17/10/2021 23:48:03.416 |
| 12992 |
< |
Read Dataset completed at 17/10/2021 23:48:34.119 Elapsed Time = 30703 ms, 100000 records read |
| 12993 |
< |
Message Hash = b20198e47d7f7ff5fcbc316e429149cb |
| 12988 |
> |
Loading data into database table. Started at 23/10/2021 13:26:17.370 |
| 12989 |
> |
Data load completed at 23/10/2021 13:29:17.739 Elapsed Time = 180369 ms, 100000 records loaded |
| 12990 |
> |
Message Hash = 31f6aa48fd00beb29b2cd15d825a1f09 |
| 12991 |
> |
Database Read started at 23/10/2021 13:29:17.744 |
| 12992 |
> |
Read Dataset completed at 23/10/2021 13:29:47.865 Elapsed Time = 30121 ms, 100000 records read |
| 12993 |
> |
Message Hash = 31f6aa48fd00beb29b2cd15d825a1f09 |
| 12994 |
|
Test Completed successfully |
| 12995 |
< |
17/10/2021 23:48:34.120 Test 21 passes as long as the checksums are identical |
| 12995 |
> |
23/10/2021 13:29:47.865 Test 21 passes as long as the checksums are identical |
| 12996 |
|
|
| 12997 |
|
|
| 12998 |
|
------------------------------------------------------ |
| 13119 |
|
|
| 13120 |
|
CTE0 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 |
| 13121 |
|
From DEPARTMENT Where HEAD_DEPT is NULL |
| 13122 |
< |
UNION ALL |
| 13122 |
> |
UNION ALL |
| 13123 |
|
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 |
| 13124 |
|
OIN Depts On D.HEAD_DEPT = Depts.DEPT_NO |
| 13125 |
|
) |
| 13126 |
|
Select: distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, 2.2, 2..30 A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH |
| 13133 |
|
Rows: |
| 13134 |
|
SQL: 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 |
| 13135 |
|
From DEPARTMENT Where HEAD_DEPT is NULL |
| 13136 |
< |
UNION ALL |
| 13136 |
> |
UNION ALL |
| 13137 |
|
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 |
| 13138 |
|
OIN Depts On D.HEAD_DEPT = Depts.DEPT_NO |
| 13139 |
|
) |
| 13140 |
|
|
| 13147 |
|
Updated SQL |
| 13148 |
|
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 |
| 13149 |
|
From DEPARTMENT Where HEAD_DEPT is NULL |
| 13150 |
< |
UNION ALL |
| 13150 |
> |
UNION ALL |
| 13151 |
|
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 |
| 13152 |
|
OIN Depts On D.HEAD_DEPT = Depts.DEPT_NO |
| 13153 |
|
) |
| 13154 |
|
|
