641 |
|
|
642 |
|
Rows printed = 42 |
643 |
|
|
644 |
< |
Current memory = 19,651,152 |
644 |
> |
Current memory = 19,651,872 |
645 |
|
Delta memory = 13,040 |
646 |
< |
Max memory = 19,779,424 |
647 |
< |
Elapsed time= 0.029 sec |
646 |
> |
Max memory = 19,780,144 |
647 |
> |
Elapsed time= 0.026 sec |
648 |
|
Cpu = 0.010 sec |
649 |
|
Buffers = 2048 |
650 |
|
Reads = 2 |
1445 |
|
isc_dpb_lc_ctype = UTF8 |
1446 |
|
|
1447 |
|
Before Disconnect |
1448 |
< |
inet://localhost/employee Disconnected after 20 ms |
1448 |
> |
inet://localhost/employee Disconnected after 19 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 3984 ms |
1457 |
> |
inet://localhost/employee Disconnected after 4018 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 1 ms |
1480 |
> |
Transaction Ended after 0 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 2000 ms |
1495 |
|
Idle Timer Expired for Test_Transaction_02 |
1496 |
|
Before Disconnect |
1497 |
< |
inet://localhost/employee Disconnected after 2051 ms |
1497 |
> |
inet://localhost/employee Disconnected after 2045 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 13 ms |
1509 |
> |
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 15 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 21 ms |
1520 |
|
|
1521 |
|
|
1522 |
|
------------------------------------------------------ |
1543 |
|
ODS Major Version = 12 |
1544 |
|
Page Size = 8192 |
1545 |
|
Version = LI-V6.3.5.33220 Firebird 3.0 |
1546 |
< |
Current Memory = 19233040 |
1546 |
> |
Current Memory = 19233760 |
1547 |
|
Forced Writes Enabled |
1548 |
< |
Max Memory = 19370320 |
1548 |
> |
Max Memory = 19371040 |
1549 |
|
Number of Buffers = 2048 |
1550 |
|
Sweep Interval = 20000 |
1551 |
|
User Names: SYSDBA |
3168 |
|
FULL_NAME = Guckenheimer, Mark |
3169 |
|
DEPT_PATH = Corporate Headquarters / Engineering / Software Products Div. / Quality Assurance (Charset Id = 4 Codepage = 65001) |
3170 |
|
DEPT_KEY_PATH = 000;600;620;622 (Charset Id = 4 Codepage = 65001) |
3171 |
< |
Current memory = 19,653,504 |
3171 |
> |
Current memory = 19,654,224 |
3172 |
|
Delta memory = 13,072 |
3173 |
< |
Max memory = 19,729,584 |
3173 |
> |
Max memory = 19,730,048 |
3174 |
|
Elapsed time= 0.023 sec |
3175 |
< |
Cpu = 0.010 sec |
3175 |
> |
Cpu = 0.020 sec |
3176 |
|
Buffers = 2048 |
3177 |
|
Reads = 2 |
3178 |
|
Writes = 0 |
3414 |
|
-Reassign the sales records before deleting this employee. |
3415 |
|
-At procedure 'DELETE_EMPLOYEE' line: 19, col: 3 |
3416 |
|
|
3417 |
+ |
Scollable Cursors |
3418 |
+ |
Do Fetch Next: |
3419 |
+ |
EMP_NO = 2 |
3420 |
+ |
FIRST_NAME = Robert |
3421 |
+ |
LAST_NAME = Nelson |
3422 |
+ |
PHONE_EXT = 250 |
3423 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
3424 |
+ |
DEPT_NO = 600 |
3425 |
+ |
JOB_CODE = VP |
3426 |
+ |
JOB_GRADE = 2 |
3427 |
+ |
JOB_COUNTRY = USA |
3428 |
+ |
SALARY = 105,900.00 |
3429 |
+ |
FULL_NAME = Nelson, Robert |
3430 |
+ |
Do Fetch Last: |
3431 |
+ |
EMP_NO = 145 |
3432 |
+ |
FIRST_NAME = Mark |
3433 |
+ |
LAST_NAME = Guckenheimer |
3434 |
+ |
PHONE_EXT = 221 |
3435 |
+ |
HIRE_DATE = 1994/05/02 00:00:00.0000 |
3436 |
+ |
DEPT_NO = 622 |
3437 |
+ |
JOB_CODE = Eng |
3438 |
+ |
JOB_GRADE = 5 |
3439 |
+ |
JOB_COUNTRY = USA |
3440 |
+ |
SALARY = 32,000.00 |
3441 |
+ |
FULL_NAME = Guckenheimer, Mark |
3442 |
+ |
Do Fetch Prior: |
3443 |
+ |
EMP_NO = 144 |
3444 |
+ |
FIRST_NAME = John |
3445 |
+ |
LAST_NAME = Montgomery |
3446 |
+ |
PHONE_EXT = 820 |
3447 |
+ |
HIRE_DATE = 1994/03/30 00:00:00.0000 |
3448 |
+ |
DEPT_NO = 672 |
3449 |
+ |
JOB_CODE = Eng |
3450 |
+ |
JOB_GRADE = 5 |
3451 |
+ |
JOB_COUNTRY = USA |
3452 |
+ |
SALARY = 35,000.00 |
3453 |
+ |
FULL_NAME = Montgomery, John |
3454 |
+ |
Do Fetch First: |
3455 |
+ |
EMP_NO = 2 |
3456 |
+ |
FIRST_NAME = Robert |
3457 |
+ |
LAST_NAME = Nelson |
3458 |
+ |
PHONE_EXT = 250 |
3459 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
3460 |
+ |
DEPT_NO = 600 |
3461 |
+ |
JOB_CODE = VP |
3462 |
+ |
JOB_GRADE = 2 |
3463 |
+ |
JOB_COUNTRY = USA |
3464 |
+ |
SALARY = 105,900.00 |
3465 |
+ |
FULL_NAME = Nelson, Robert |
3466 |
+ |
Do Fetch Abs 8 : |
3467 |
+ |
EMP_NO = 14 |
3468 |
+ |
FIRST_NAME = Stewart |
3469 |
+ |
LAST_NAME = Hall |
3470 |
+ |
PHONE_EXT = 227 |
3471 |
+ |
HIRE_DATE = 1990/06/04 00:00:00.0000 |
3472 |
+ |
DEPT_NO = 900 |
3473 |
+ |
JOB_CODE = Finan |
3474 |
+ |
JOB_GRADE = 3 |
3475 |
+ |
JOB_COUNTRY = USA |
3476 |
+ |
SALARY = 69,482.63 |
3477 |
+ |
FULL_NAME = Hall, Stewart |
3478 |
+ |
Do Fetch Relative -2 : |
3479 |
+ |
EMP_NO = 11 |
3480 |
+ |
FIRST_NAME = K. J. |
3481 |
+ |
LAST_NAME = Weston |
3482 |
+ |
PHONE_EXT = 34 |
3483 |
+ |
HIRE_DATE = 1990/01/17 00:00:00.0000 |
3484 |
+ |
DEPT_NO = 130 |
3485 |
+ |
JOB_CODE = SRep |
3486 |
+ |
JOB_GRADE = 4 |
3487 |
+ |
JOB_COUNTRY = USA |
3488 |
+ |
SALARY = 86,292.94 |
3489 |
+ |
FULL_NAME = Weston, K. J. |
3490 |
+ |
Do Fetch beyond EOF : |
3491 |
+ |
Fetch returned false |
3492 |
+ |
|
3493 |
|
|
3494 |
|
------------------------------------------------------ |
3495 |
|
Running Test 08: TIBDataset: Locate, Bookmark and Lookup |
11989 |
|
Database Statistics for employee |
11990 |
|
|
11991 |
|
Database "/opt/firebird3.0.5/examples/empbuild/employee.fdb" |
11992 |
< |
Gstat execution time Sun Oct 17 23:38:52 2021 |
11992 |
> |
Gstat execution time Sat Oct 23 13:38:43 2021 |
11993 |
|
|
11994 |
|
Database header page information: |
11995 |
|
Flags 0 |
11996 |
< |
Generation 3558 |
11996 |
> |
Generation 4226 |
11997 |
|
System Change Number 0 |
11998 |
|
Page size 8192 |
11999 |
|
ODS version 12.0 |
12000 |
< |
Oldest transaction 4013 |
12001 |
< |
Oldest active 4014 |
12002 |
< |
Oldest snapshot 4014 |
12003 |
< |
Next transaction 4014 |
12000 |
> |
Oldest transaction 4708 |
12001 |
> |
Oldest active 4709 |
12002 |
> |
Oldest snapshot 4709 |
12003 |
> |
Next transaction 4709 |
12004 |
|
Sequence number 0 |
12005 |
< |
Next attachment ID 3761 |
12005 |
> |
Next attachment ID 4314 |
12006 |
|
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc |
12007 |
|
Shadow count 0 |
12008 |
|
Page buffers 0 |
12075 |
|
Primary pointer page: 226, Index root page: 227 |
12076 |
|
Pointer pages: 1, data page slots: 1 |
12077 |
|
Data pages: 1, average fill: 10% |
12078 |
< |
Primary pages: 1, secondary pages: 0, swept pages: 1 |
12078 |
> |
Primary pages: 1, secondary pages: 0, swept pages: 0 |
12079 |
|
Empty pages: 0, full pages: 0 |
12080 |
|
Fill distribution: |
12081 |
|
0 - 19% = 1 |
12127 |
|
Primary pointer page: 246, Index root page: 247 |
12128 |
|
Pointer pages: 1, data page slots: 1 |
12129 |
|
Data pages: 1, average fill: 30% |
12130 |
< |
Primary pages: 1, secondary pages: 0, swept pages: 1 |
12130 |
> |
Primary pages: 1, secondary pages: 0, swept pages: 0 |
12131 |
|
Empty pages: 0, full pages: 0 |
12132 |
|
Fill distribution: |
12133 |
|
0 - 19% = 0 |
12149 |
|
60 - 79% = 0 |
12150 |
|
80 - 99% = 0 |
12151 |
|
|
12152 |
< |
Gstat completion time Sun Oct 17 23:38:52 2021 |
12152 |
> |
Gstat completion time Sat Oct 23 13:38:43 2021 |
12153 |
|
|
12154 |
|
|
12155 |
|
|
12159 |
|
bin/fbguard: guardian starting /opt/firebird3.0.5/bin/firebird |
12160 |
|
|
12161 |
|
Online Validation |
12162 |
< |
23:38:53.49 Validation started |
12162 |
> |
13:38:44.65 Validation started |
12163 |
|
|
12164 |
< |
23:38:53.49 Relation 128 (COUNTRY) |
12165 |
< |
23:38:53.49 process pointer page 0 of 1 |
12166 |
< |
23:38:53.49 Index 1 (RDB$PRIMARY1) |
12167 |
< |
23:38:53.49 Relation 128 (COUNTRY) is ok |
12168 |
< |
|
12169 |
< |
23:38:53.49 Relation 129 (JOB) |
12170 |
< |
23:38:53.49 process pointer page 0 of 1 |
12171 |
< |
23:38:53.49 Index 1 (RDB$PRIMARY2) |
12172 |
< |
23:38:53.49 Index 2 (RDB$FOREIGN3) |
12173 |
< |
23:38:53.49 Index 3 (MAXSALX) |
12174 |
< |
23:38:53.49 Index 4 (MINSALX) |
12175 |
< |
23:38:53.49 Relation 129 (JOB) is ok |
12176 |
< |
|
12177 |
< |
23:38:53.49 Relation 130 (DEPARTMENT) |
12178 |
< |
23:38:53.49 process pointer page 0 of 1 |
12179 |
< |
23:38:53.49 Index 1 (RDB$4) |
12180 |
< |
23:38:53.49 Index 2 (RDB$PRIMARY5) |
12181 |
< |
23:38:53.49 Index 3 (RDB$FOREIGN6) |
12182 |
< |
23:38:53.49 Index 4 (BUDGETX) |
12183 |
< |
23:38:53.49 Index 5 (RDB$FOREIGN10) |
12184 |
< |
23:38:53.49 Relation 130 (DEPARTMENT) is ok |
12185 |
< |
|
12186 |
< |
23:38:53.49 Relation 131 (EMPLOYEE) |
12187 |
< |
23:38:53.50 process pointer page 0 of 1 |
12188 |
< |
23:38:53.50 Index 1 (RDB$PRIMARY7) |
12189 |
< |
23:38:53.50 Index 2 (RDB$FOREIGN8) |
12190 |
< |
23:38:53.50 Index 3 (RDB$FOREIGN9) |
12191 |
< |
23:38:53.50 Index 4 (NAMEX) |
12192 |
< |
23:38:53.50 Relation 131 (EMPLOYEE) is ok |
12193 |
< |
|
12194 |
< |
23:38:53.50 Relation 133 (PROJECT) |
12195 |
< |
23:38:53.50 process pointer page 0 of 1 |
12196 |
< |
23:38:53.50 Index 1 (RDB$11) |
12197 |
< |
23:38:53.50 Index 2 (RDB$PRIMARY12) |
12198 |
< |
23:38:53.50 Index 3 (RDB$FOREIGN13) |
12199 |
< |
23:38:53.50 Index 4 (PRODTYPEX) |
12200 |
< |
23:38:53.50 Relation 133 (PROJECT) is ok |
12201 |
< |
|
12202 |
< |
23:38:53.50 Relation 134 (EMPLOYEE_PROJECT) |
12203 |
< |
23:38:53.50 process pointer page 0 of 1 |
12204 |
< |
23:38:53.50 Index 1 (RDB$PRIMARY14) |
12205 |
< |
23:38:53.50 Index 2 (RDB$FOREIGN15) |
12206 |
< |
23:38:53.50 Index 3 (RDB$FOREIGN16) |
12207 |
< |
23:38:53.50 Relation 134 (EMPLOYEE_PROJECT) is ok |
12208 |
< |
|
12209 |
< |
23:38:53.50 Relation 135 (PROJ_DEPT_BUDGET) |
12210 |
< |
23:38:53.50 process pointer page 0 of 1 |
12211 |
< |
23:38:53.50 Index 1 (RDB$PRIMARY17) |
12212 |
< |
23:38:53.50 Index 2 (RDB$FOREIGN18) |
12213 |
< |
23:38:53.50 Index 3 (RDB$FOREIGN19) |
12214 |
< |
23:38:53.50 Relation 135 (PROJ_DEPT_BUDGET) is ok |
12215 |
< |
|
12216 |
< |
23:38:53.50 Relation 136 (SALARY_HISTORY) |
12217 |
< |
23:38:53.50 process pointer page 0 of 1 |
12218 |
< |
23:38:53.50 Index 1 (RDB$PRIMARY20) |
12219 |
< |
23:38:53.50 Index 2 (RDB$FOREIGN21) |
12220 |
< |
23:38:53.50 Index 3 (CHANGEX) |
12221 |
< |
23:38:53.50 Index 4 (UPDATERX) |
12222 |
< |
23:38:53.50 Relation 136 (SALARY_HISTORY) is ok |
12223 |
< |
|
12224 |
< |
23:38:53.50 Relation 137 (CUSTOMER) |
12225 |
< |
23:38:53.50 process pointer page 0 of 1 |
12226 |
< |
23:38:53.50 Index 1 (RDB$PRIMARY22) |
12227 |
< |
23:38:53.50 Index 2 (RDB$FOREIGN23) |
12228 |
< |
23:38:53.50 Index 3 (CUSTNAMEX) |
12229 |
< |
23:38:53.50 Index 4 (CUSTREGION) |
12230 |
< |
23:38:53.50 Relation 137 (CUSTOMER) is ok |
12231 |
< |
|
12232 |
< |
23:38:53.50 Relation 138 (SALES) |
12233 |
< |
23:38:53.50 process pointer page 0 of 1 |
12234 |
< |
23:38:53.51 Index 1 (RDB$PRIMARY24) |
12235 |
< |
23:38:53.51 Index 2 (RDB$FOREIGN25) |
12236 |
< |
23:38:53.51 Index 3 (RDB$FOREIGN26) |
12237 |
< |
23:38:53.51 Index 4 (NEEDX) |
12238 |
< |
23:38:53.51 Index 5 (QTYX) |
12239 |
< |
23:38:53.51 Index 6 (SALESTATX) |
12240 |
< |
23:38:53.51 Relation 138 (SALES) is ok |
12164 |
> |
13:38:44.65 Relation 128 (COUNTRY) |
12165 |
> |
13:38:44.65 process pointer page 0 of 1 |
12166 |
> |
13:38:44.65 Index 1 (RDB$PRIMARY1) |
12167 |
> |
13:38:44.65 Relation 128 (COUNTRY) is ok |
12168 |
> |
|
12169 |
> |
13:38:44.65 Relation 129 (JOB) |
12170 |
> |
13:38:44.65 process pointer page 0 of 1 |
12171 |
> |
13:38:44.65 Index 1 (RDB$PRIMARY2) |
12172 |
> |
13:38:44.65 Index 2 (RDB$FOREIGN3) |
12173 |
> |
13:38:44.65 Index 3 (MAXSALX) |
12174 |
> |
13:38:44.67 Index 4 (MINSALX) |
12175 |
> |
13:38:44.68 Relation 129 (JOB) is ok |
12176 |
> |
|
12177 |
> |
13:38:44.68 Relation 130 (DEPARTMENT) |
12178 |
> |
13:38:44.68 process pointer page 0 of 1 |
12179 |
> |
13:38:44.68 Index 1 (RDB$4) |
12180 |
> |
13:38:44.68 Index 2 (RDB$PRIMARY5) |
12181 |
> |
13:38:44.68 Index 3 (RDB$FOREIGN6) |
12182 |
> |
13:38:44.68 Index 4 (BUDGETX) |
12183 |
> |
13:38:44.68 Index 5 (RDB$FOREIGN10) |
12184 |
> |
13:38:44.68 Relation 130 (DEPARTMENT) is ok |
12185 |
> |
|
12186 |
> |
13:38:44.68 Relation 131 (EMPLOYEE) |
12187 |
> |
13:38:44.68 process pointer page 0 of 1 |
12188 |
> |
13:38:44.68 Index 1 (RDB$PRIMARY7) |
12189 |
> |
13:38:44.68 Index 2 (RDB$FOREIGN8) |
12190 |
> |
13:38:44.68 Index 3 (RDB$FOREIGN9) |
12191 |
> |
13:38:44.68 Index 4 (NAMEX) |
12192 |
> |
13:38:44.68 Relation 131 (EMPLOYEE) is ok |
12193 |
> |
|
12194 |
> |
13:38:44.68 Relation 133 (PROJECT) |
12195 |
> |
13:38:44.68 process pointer page 0 of 1 |
12196 |
> |
13:38:44.68 Index 1 (RDB$11) |
12197 |
> |
13:38:44.68 Index 2 (RDB$PRIMARY12) |
12198 |
> |
13:38:44.68 Index 3 (RDB$FOREIGN13) |
12199 |
> |
13:38:44.68 Index 4 (PRODTYPEX) |
12200 |
> |
13:38:44.69 Relation 133 (PROJECT) is ok |
12201 |
> |
|
12202 |
> |
13:38:44.69 Relation 134 (EMPLOYEE_PROJECT) |
12203 |
> |
13:38:44.69 process pointer page 0 of 1 |
12204 |
> |
13:38:44.69 Index 1 (RDB$PRIMARY14) |
12205 |
> |
13:38:44.69 Index 2 (RDB$FOREIGN15) |
12206 |
> |
13:38:44.69 Index 3 (RDB$FOREIGN16) |
12207 |
> |
13:38:44.69 Relation 134 (EMPLOYEE_PROJECT) is ok |
12208 |
> |
|
12209 |
> |
13:38:44.69 Relation 135 (PROJ_DEPT_BUDGET) |
12210 |
> |
13:38:44.69 process pointer page 0 of 1 |
12211 |
> |
13:38:44.70 Index 1 (RDB$PRIMARY17) |
12212 |
> |
13:38:44.70 Index 2 (RDB$FOREIGN18) |
12213 |
> |
13:38:44.70 Index 3 (RDB$FOREIGN19) |
12214 |
> |
13:38:44.70 Relation 135 (PROJ_DEPT_BUDGET) is ok |
12215 |
> |
|
12216 |
> |
13:38:44.70 Relation 136 (SALARY_HISTORY) |
12217 |
> |
13:38:44.70 process pointer page 0 of 1 |
12218 |
> |
13:38:44.70 Index 1 (RDB$PRIMARY20) |
12219 |
> |
13:38:44.70 Index 2 (RDB$FOREIGN21) |
12220 |
> |
13:38:44.70 Index 3 (CHANGEX) |
12221 |
> |
13:38:44.70 Index 4 (UPDATERX) |
12222 |
> |
13:38:44.70 Relation 136 (SALARY_HISTORY) is ok |
12223 |
> |
|
12224 |
> |
13:38:44.70 Relation 137 (CUSTOMER) |
12225 |
> |
13:38:44.70 process pointer page 0 of 1 |
12226 |
> |
13:38:44.70 Index 1 (RDB$PRIMARY22) |
12227 |
> |
13:38:44.70 Index 2 (RDB$FOREIGN23) |
12228 |
> |
13:38:44.70 Index 3 (CUSTNAMEX) |
12229 |
> |
13:38:44.70 Index 4 (CUSTREGION) |
12230 |
> |
13:38:44.70 Relation 137 (CUSTOMER) is ok |
12231 |
> |
|
12232 |
> |
13:38:44.70 Relation 138 (SALES) |
12233 |
> |
13:38:44.70 process pointer page 0 of 1 |
12234 |
> |
13:38:44.70 Index 1 (RDB$PRIMARY24) |
12235 |
> |
13:38:44.70 Index 2 (RDB$FOREIGN25) |
12236 |
> |
13:38:44.70 Index 3 (RDB$FOREIGN26) |
12237 |
> |
13:38:44.70 Index 4 (NEEDX) |
12238 |
> |
13:38:44.70 Index 5 (QTYX) |
12239 |
> |
13:38:44.70 Index 6 (SALESTATX) |
12240 |
> |
13:38:44.70 Relation 138 (SALES) is ok |
12241 |
|
|
12242 |
< |
23:38:53.51 Validation finished |
12242 |
> |
13:38:44.70 Validation finished |
12243 |
|
|
12244 |
|
|
12245 |
|
Normal Validation |
13524 |
|
|
13525 |
|
Rows printed = 2 |
13526 |
|
|
13527 |
< |
Current memory = 19,651,616 |
13527 |
> |
Current memory = 19,652,336 |
13528 |
|
Delta memory = 12,688 |
13529 |
< |
Max memory = 19,780,240 |
13529 |
> |
Max memory = 19,780,960 |
13530 |
|
Elapsed time= 0.002 sec |
13531 |
|
Cpu = 0.000 sec |
13532 |
|
Buffers = 2048 |
13792 |
|
|
13793 |
|
Rows printed = 2 |
13794 |
|
|
13795 |
< |
Current memory = 19,651,616 |
13795 |
> |
Current memory = 19,652,336 |
13796 |
|
Delta memory = 12,688 |
13797 |
< |
Max memory = 19,780,240 |
13798 |
< |
Elapsed time= 0.103 sec |
13799 |
< |
Cpu = 0.000 sec |
13797 |
> |
Max memory = 19,780,960 |
13798 |
> |
Elapsed time= 0.104 sec |
13799 |
> |
Cpu = 0.010 sec |
13800 |
|
Buffers = 2048 |
13801 |
|
Reads = 2 |
13802 |
|
Writes = 0 |
15413 |
|
MyText VarChar(1024), |
15414 |
|
Primary Key (RowID) |
15415 |
|
); |
15416 |
< |
Loading data into database table. Started at 17/10/2021 23:39:39.221 |
15417 |
< |
Data load completed at 17/10/2021 23:41:18.349 Elapsed Time = 99128 ms, 100000 records loaded |
15418 |
< |
Message Hash = 0469fd0e0213f65f1bb40a36cc30b97b |
15419 |
< |
Database Read started at 17/10/2021 23:41:18.359 |
15420 |
< |
Read Dataset completed at 17/10/2021 23:41:48.428 Elapsed Time = 30069 ms, 100000 records read |
15421 |
< |
Message Hash = 0469fd0e0213f65f1bb40a36cc30b97b |
15416 |
> |
Loading data into database table. Started at 23/10/2021 13:39:35.904 |
15417 |
> |
Data load completed at 23/10/2021 13:41:21.474 Elapsed Time = 105570 ms, 100000 records loaded |
15418 |
> |
Message Hash = 74ca9d8999ced80d351dfb9f693ac23e |
15419 |
> |
Database Read started at 23/10/2021 13:41:21.484 |
15420 |
> |
Read Dataset completed at 23/10/2021 13:41:51.025 Elapsed Time = 29541 ms, 100000 records read |
15421 |
> |
Message Hash = 74ca9d8999ced80d351dfb9f693ac23e |
15422 |
|
Test Completed successfully |
15423 |
< |
17/10/2021 23:41:48.428 Test 21 passes as long as the checksums are identical |
15423 |
> |
23/10/2021 13:41:51.026 Test 21 passes as long as the checksums are identical |
15424 |
|
|
15425 |
|
|
15426 |
|
------------------------------------------------------ |
15642 |
|
|
15643 |
|
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 |
15644 |
|
From DEPARTMENT Where HEAD_DEPT is NULL |
15645 |
< |
UNION ALL |
15645 |
> |
UNION ALL |
15646 |
|
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 |
15647 |
|
OIN Depts On D.HEAD_DEPT = Depts.DEPT_NO |
15648 |
|
) |
15649 |
|
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 |
15656 |
|
Rows: |
15657 |
|
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 |
15658 |
|
From DEPARTMENT Where HEAD_DEPT is NULL |
15659 |
< |
UNION ALL |
15659 |
> |
UNION ALL |
15660 |
|
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 |
15661 |
|
OIN Depts On D.HEAD_DEPT = Depts.DEPT_NO |
15662 |
|
) |
15663 |
|
|
15670 |
|
Updated SQL |
15671 |
|
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 |
15672 |
|
From DEPARTMENT Where HEAD_DEPT is NULL |
15673 |
< |
UNION ALL |
15673 |
> |
UNION ALL |
15674 |
|
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 |
15675 |
|
OIN Depts On D.HEAD_DEPT = Depts.DEPT_NO |
15676 |
|
) |
15677 |
|
|