ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/journaling/testsuite/FB3reference.log
(Generate patch)

Comparing ibx/trunk/testsuite/FB3reference.log (file contents):
Revision 349 by tony, Mon Oct 18 08:39:40 2021 UTC vs.
Revision 353 by tony, Sat Oct 23 14:11:37 2021 UTC

# Line 641 | Line 641 | DEPT_KEY_PATH = 000;900 (Charset = UTF8
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
# Line 1445 | Line 1445 | DPB: Item Count = 3
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
# Line 1454 | Line 1454 | 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
# Line 1477 | Line 1477 | TPB: Item Count = 3
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
# Line 1491 | Line 1491 | TPB: Item Count = 3
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
# Line 1506 | Line 1506 | DPB: Item Count = 4
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
# Line 1516 | Line 1516 | DPB: Item Count = 3
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   ------------------------------------------------------
# Line 1543 | Line 1543 | ODS Minor Version = 0
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
# Line 3168 | Line 3168 | SALARY = 32,000.00
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
# Line 3414 | Line 3414 | Terminated with Exception:exception 2
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
# Line 11913 | Line 11989 | Message File Location = /opt/firebird3.0
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
# Line 11999 | Line 12075 | EMPLOYEE_PROJECT (134)
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
# Line 12051 | Line 12127 | SALARY_HISTORY (136)
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
# Line 12073 | Line 12149 | Fill distribution:
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  
# Line 12083 | Line 12159 | zeus   Tue Jun  9 15:11:28 2020
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
# Line 13448 | Line 13524 | DEPT_KEY_PATH = 000 (Charset = UTF8 Code
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
# Line 13716 | Line 13792 | DEPT_KEY_PATH = 000 (Charset = UTF8 Code
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
# Line 15337 | Line 15413 | Create Table LotsOfData (
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   ------------------------------------------------------
# Line 15566 | Line 15642 | JOIN Depts D On D.DEPT_NO = A.DEPT_NO
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
# Line 15580 | Line 15656 | Plan:
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  
# Line 15594 | Line 15670 | Params:
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  

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines