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

Comparing ibx/trunk/testsuite/FB4reference.log (file contents):
Revision 352 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,688,352
644 > Current memory = 19,687,232
645   Delta memory = 16,384
646 < Max memory = 19,783,248
647 < Elapsed time= 0.025 sec
648 < Cpu = 0.010 sec
646 > Max memory = 19,781,872
647 > Elapsed time= 0.027 sec
648 > Cpu = 0.020 sec
649   Buffers = 2048
650   Reads = 2
651   Writes = 0
# Line 1445 | Line 1445 | DPB: Item Count = 3
1445    isc_dpb_lc_ctype = UTF8
1446  
1447   Before Disconnect
1448 < inet://localhost/employee Disconnected after 42 ms
1448 > inet://localhost/employee Disconnected after 34 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 4039 ms
1457 > inet://localhost/employee Disconnected after 4041 ms
1458   Idle Timer Expired for Test_Database_02
1459   Database Closed
1460   Transaction Events
# 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 2040 ms
1497 > inet://localhost/employee Disconnected after 2047 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 24 ms
1509 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 25 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 26 ms
1519 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 22 ms
1520  
1521  
1522   ------------------------------------------------------
# Line 1543 | Line 1543 | ODS Minor Version = 0
1543   ODS Major Version = 13
1544   Page Size = 8192
1545   Version = LI-V6.3.0.2496 Firebird 4.0
1546 < Current Memory = 19503040
1546 > Current Memory = 19501920
1547   Forced Writes Enabled
1548 < Max Memory = 19629648
1548 > Max Memory = 19628528
1549   Number of Buffers = 2048
1550   Sweep Interval = 20000
1551   User Names: SYSDBA
1552 < Fetches = 1855
1552 > Fetches = 1847
1553   Marks = 8
1554   Reads = 100
1555   Writes = 2
1556 < Pages Free = 313
1557 < Pages Used = 762
1556 > Pages Free = 310
1557 > Pages Used = 765
1558   Transaction Count = 1
1559  
1560   Read Idx Count
# Line 1565 | Line 1565 | Read Idx Count
1565    RDB$SECURITY_CLASSES = 8
1566    RDB$TYPES = 2
1567    RDB$TRIGGERS = 25
1568 <  RDB$USER_PRIVILEGES = 816
1568 >  RDB$USER_PRIVILEGES = 811
1569    RDB$GENERATORS = 5
1570    RDB$CHARACTER_SETS = 2
1571    RDB$COLLATIONS = 2
1572    RDB$ROLES = 1
1573  
1574   Read Seq Count
1575 <  RDB$PAGES = 100
1575 >  RDB$PAGES = 98
1576    RDB$DATABASE = 25
1577 <  RDB$RELATIONS = 66
1577 >  RDB$RELATIONS = 65
1578  
1579   Database is Read/Write
1580   Hex Dump of Database Page 100:
# Line 3297 | Line 3297 | SALARY = 32,000.00
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,669,072
3300 > Current memory = 19,667,952
3301   Delta memory = 16,416
3302 < Max memory = 19,764,736
3303 < Elapsed time= 0.025 sec
3304 < Cpu = 0.020 sec
3302 > Max memory = 19,763,360
3303 > Elapsed time= 0.026 sec
3304 > Cpu = 0.010 sec
3305   Buffers = 2048
3306   Reads = 2
3307   Writes = 0
# Line 3543 | Line 3543 | Terminated with Exception:exception 2
3543   -Reassign the sales records before deleting this employee.
3544   -At procedure 'DELETE_EMPLOYEE' line: 19, col: 3
3545  
3546 + Scollable Cursors
3547 + Do Fetch Next:
3548 + EMP_NO = 2
3549 + FIRST_NAME = Robert
3550 + LAST_NAME = Nelson
3551 + PHONE_EXT = 250
3552 + HIRE_DATE = 1988/12/28 00:00:00.0000
3553 + DEPT_NO = 600
3554 + JOB_CODE = VP
3555 + JOB_GRADE = 2
3556 + JOB_COUNTRY = USA
3557 + SALARY = 105,900.00
3558 + FULL_NAME = Nelson, Robert
3559 + Do Fetch Last:
3560 + EMP_NO = 145
3561 + FIRST_NAME = Mark
3562 + LAST_NAME = Guckenheimer
3563 + PHONE_EXT = 221
3564 + HIRE_DATE = 1994/05/02 00:00:00.0000
3565 + DEPT_NO = 622
3566 + JOB_CODE = Eng
3567 + JOB_GRADE = 5
3568 + JOB_COUNTRY = USA
3569 + SALARY = 32,000.00
3570 + FULL_NAME = Guckenheimer, Mark
3571 + Do Fetch Prior:
3572 + EMP_NO = 144
3573 + FIRST_NAME = John
3574 + LAST_NAME = Montgomery
3575 + PHONE_EXT = 820
3576 + HIRE_DATE = 1994/03/30 00:00:00.0000
3577 + DEPT_NO = 672
3578 + JOB_CODE = Eng
3579 + JOB_GRADE = 5
3580 + JOB_COUNTRY = USA
3581 + SALARY = 35,000.00
3582 + FULL_NAME = Montgomery, John
3583 + Do Fetch First:
3584 + EMP_NO = 2
3585 + FIRST_NAME = Robert
3586 + LAST_NAME = Nelson
3587 + PHONE_EXT = 250
3588 + HIRE_DATE = 1988/12/28 00:00:00.0000
3589 + DEPT_NO = 600
3590 + JOB_CODE = VP
3591 + JOB_GRADE = 2
3592 + JOB_COUNTRY = USA
3593 + SALARY = 105,900.00
3594 + FULL_NAME = Nelson, Robert
3595 + Do Fetch Abs 8 :
3596 + EMP_NO = 14
3597 + FIRST_NAME = Stewart
3598 + LAST_NAME = Hall
3599 + PHONE_EXT = 227
3600 + HIRE_DATE = 1990/06/04 00:00:00.0000
3601 + DEPT_NO = 900
3602 + JOB_CODE = Finan
3603 + JOB_GRADE = 3
3604 + JOB_COUNTRY = USA
3605 + SALARY = 69,482.63
3606 + FULL_NAME = Hall, Stewart
3607 + Do Fetch Relative -2 :
3608 + EMP_NO = 11
3609 + FIRST_NAME = K. J.
3610 + LAST_NAME = Weston
3611 + PHONE_EXT = 34
3612 + HIRE_DATE = 1990/01/17 00:00:00.0000
3613 + DEPT_NO = 130
3614 + JOB_CODE = SRep
3615 + JOB_GRADE = 4
3616 + JOB_COUNTRY = USA
3617 + SALARY = 86,292.94
3618 + FULL_NAME = Weston, K. J.
3619 + Do Fetch beyond EOF :
3620 + Fetch returned false
3621 +
3622  
3623   ------------------------------------------------------
3624   Running Test 08: TIBDataset: Locate, Bookmark and Lookup
# Line 4005 | Line 4081 | CREATE TABLE JOB
4081   PRIMARY KEY (JOB_CODE, JOB_GRADE, JOB_COUNTRY)
4082   );
4083  
4008 – /* Table: LOTSOFDATA, Owner: SYSDBA */
4009 –
4010 – CREATE TABLE LOTSOFDATA
4011 – (
4012 –        ROWID   INTEGER NOT NULL,
4013 –        THEDATE TIMESTAMP,
4014 –        MYTEXT  VARCHAR(1024),
4015 – PRIMARY KEY (ROWID)
4016 – );
4017 –
4084   /* Table: PROJECT, Owner: SYSDBA */
4085  
4086   CREATE TABLE PROJECT
# Line 12037 | Line 12103 | Message File Location = /opt/firebird4.0
12103   Database Statistics for employee
12104  
12105   Database "/opt/firebird4.0.0/examples/empbuild/employee.fdb"
12106 < Gstat execution time Sun Oct 17 23:27:55 2021
12106 > Gstat execution time Sat Oct 23 14:18:37 2021
12107  
12108   Database header page information:
12109   Flags                   0
12110 < Generation              2732
12110 > Generation              4690
12111   System Change Number    0
12112   Page size               8192
12113   ODS version             13.0
12114 < Oldest transaction      3024
12115 < Oldest active           3025
12116 < Oldest snapshot         3025
12117 < Next transaction        3025
12114 > Oldest transaction      5176
12115 > Oldest active           5177
12116 > Oldest snapshot         5177
12117 > Next transaction        5177
12118   Sequence number         0
12119 < Next attachment ID      2444
12119 > Next attachment ID      4103
12120   Implementation          HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
12121   Shadow count            0
12122   Page buffers            0
# Line 12124 | Line 12190 | EMPLOYEE_PROJECT (134)
12190   Primary pointer page: 258, Index root page: 259
12191   Pointer pages: 1, data page slots: 1
12192   Data pages: 1, average fill: 10%
12193 < Primary pages: 1, secondary pages: 0, swept pages: 1
12193 > Primary pages: 1, secondary pages: 0, swept pages: 0
12194   Empty pages: 0, full pages: 0
12195   Fill distribution:
12196   0 - 19% = 1
# Line 12137 | Line 12203 | JOB (129)
12203   Primary pointer page: 229, Index root page: 230
12204   Pointer pages: 1, data page slots: 2
12205   Data pages: 2, average fill: 54%
12206 < Primary pages: 1, secondary pages: 1, swept pages: 1
12206 > Primary pages: 1, secondary pages: 1, swept pages: 0
12207   Empty pages: 0, full pages: 0
12208   Fill distribution:
12209   0 - 19% = 0
# Line 12146 | Line 12212 | Fill distribution:
12212   60 - 79% = 1
12213   80 - 99% = 0
12214  
12149 – LOTSOFDATA (140)
12150 – Primary pointer page: 285, Index root page: 311
12151 – Pointer pages: 1, data page slots: 0
12152 – Data pages: 0, average fill: 0%
12153 – Primary pages: 0, secondary pages: 0, swept pages: 0
12154 – Empty pages: 0, full pages: 0
12155 – Fill distribution:
12156 – 0 - 19% = 0
12157 – 20 - 39% = 0
12158 – 40 - 59% = 0
12159 – 60 - 79% = 0
12160 – 80 - 99% = 0
12161 –
12215   PROJECT (133)
12216   Primary pointer page: 251, Index root page: 252
12217   Pointer pages: 1, data page slots: 2
# Line 12189 | Line 12242 | SALARY_HISTORY (136)
12242   Primary pointer page: 270, Index root page: 271
12243   Pointer pages: 1, data page slots: 1
12244   Data pages: 1, average fill: 30%
12245 < Primary pages: 1, secondary pages: 0, swept pages: 1
12245 > Primary pages: 1, secondary pages: 0, swept pages: 0
12246   Empty pages: 0, full pages: 0
12247   Fill distribution:
12248   0 - 19% = 0
# Line 12211 | Line 12264 | Fill distribution:
12264   60 - 79% = 0
12265   80 - 99% = 0
12266  
12267 < Gstat completion time Sun Oct 17 23:27:56 2021
12267 > Gstat completion time Sat Oct 23 14:18:37 2021
12268  
12269  
12270  
# Line 12221 | Line 12274 | zeus   Wed Jun  9 10:07:18 2021
12274   firebird4/bin/fbguard: guardian starting /opt/firebird4/bin/firebird
12275  
12276   Online Validation
12277 < 23:27:56.66 Validation started
12277 > 14:18:37.67 Validation started
12278  
12279 < 23:27:56.66 Relation 128 (COUNTRY)
12280 < 23:27:56.66   process pointer page    0 of    1
12281 < 23:27:56.66 Index 1 (RDB$PRIMARY1)
12282 < 23:27:56.66 Relation 128 (COUNTRY) is ok
12283 <
12284 < 23:27:56.66 Relation 129 (JOB)
12285 < 23:27:56.66   process pointer page    0 of    1
12286 < 23:27:56.66 Index 1 (RDB$PRIMARY2)
12287 < 23:27:56.66 Index 2 (RDB$FOREIGN3)
12288 < 23:27:56.66 Index 3 (MAXSALX)
12289 < 23:27:56.69 Index 4 (MINSALX)
12290 < 23:27:56.69 Relation 129 (JOB) is ok
12291 <
12292 < 23:27:56.69 Relation 130 (DEPARTMENT)
12293 < 23:27:56.69   process pointer page    0 of    1
12294 < 23:27:56.69 Index 1 (RDB$4)
12295 < 23:27:56.69 Index 2 (RDB$PRIMARY5)
12296 < 23:27:56.69 Index 3 (RDB$FOREIGN6)
12297 < 23:27:56.69 Index 4 (BUDGETX)
12298 < 23:27:56.69 Index 5 (RDB$FOREIGN10)
12299 < 23:27:56.69 Relation 130 (DEPARTMENT) is ok
12300 <
12301 < 23:27:56.69 Relation 131 (EMPLOYEE)
12302 < 23:27:56.70   process pointer page    0 of    1
12303 < 23:27:56.70 Index 1 (RDB$PRIMARY7)
12304 < 23:27:56.70 Index 2 (RDB$FOREIGN8)
12305 < 23:27:56.70 Index 3 (RDB$FOREIGN9)
12306 < 23:27:56.70 Index 4 (NAMEX)
12307 < 23:27:56.70 Relation 131 (EMPLOYEE) is ok
12308 <
12309 < 23:27:56.70 Relation 133 (PROJECT)
12310 < 23:27:56.70   process pointer page    0 of    1
12311 < 23:27:56.70 Index 1 (RDB$11)
12312 < 23:27:56.70 Index 2 (RDB$PRIMARY12)
12313 < 23:27:56.72 Index 3 (RDB$FOREIGN13)
12314 < 23:27:56.72 Index 4 (PRODTYPEX)
12315 < 23:27:56.72 Relation 133 (PROJECT) is ok
12316 <
12317 < 23:27:56.72 Relation 134 (EMPLOYEE_PROJECT)
12318 < 23:27:56.72   process pointer page    0 of    1
12319 < 23:27:56.72 Index 1 (RDB$PRIMARY14)
12320 < 23:27:56.72 Index 2 (RDB$FOREIGN15)
12321 < 23:27:56.72 Index 3 (RDB$FOREIGN16)
12322 < 23:27:56.72 Relation 134 (EMPLOYEE_PROJECT) is ok
12323 <
12324 < 23:27:56.72 Relation 135 (PROJ_DEPT_BUDGET)
12325 < 23:27:56.72   process pointer page    0 of    1
12326 < 23:27:56.72 Index 1 (RDB$PRIMARY17)
12327 < 23:27:56.73 Index 2 (RDB$FOREIGN18)
12328 < 23:27:56.73 Index 3 (RDB$FOREIGN19)
12329 < 23:27:56.73 Relation 135 (PROJ_DEPT_BUDGET) is ok
12330 <
12331 < 23:27:56.73 Relation 136 (SALARY_HISTORY)
12332 < 23:27:56.73   process pointer page    0 of    1
12333 < 23:27:56.73 Index 1 (RDB$PRIMARY20)
12334 < 23:27:56.73 Index 2 (RDB$FOREIGN21)
12335 < 23:27:56.73 Index 3 (CHANGEX)
12336 < 23:27:56.73 Index 4 (UPDATERX)
12337 < 23:27:56.73 Relation 136 (SALARY_HISTORY) is ok
12338 <
12339 < 23:27:56.73 Relation 137 (CUSTOMER)
12340 < 23:27:56.73   process pointer page    0 of    1
12341 < 23:27:56.73 Index 1 (RDB$PRIMARY22)
12342 < 23:27:56.73 Index 2 (RDB$FOREIGN23)
12343 < 23:27:56.73 Index 3 (CUSTNAMEX)
12344 < 23:27:56.73 Index 4 (CUSTREGION)
12345 < 23:27:56.73 Relation 137 (CUSTOMER) is ok
12346 <
12347 < 23:27:56.73 Relation 138 (SALES)
12348 < 23:27:56.73   process pointer page    0 of    1
12349 < 23:27:56.73 Index 1 (RDB$PRIMARY24)
12350 < 23:27:56.73 Index 2 (RDB$FOREIGN25)
12351 < 23:27:56.73 Index 3 (RDB$FOREIGN26)
12352 < 23:27:56.73 Index 4 (NEEDX)
12353 < 23:27:56.73 Index 5 (QTYX)
12354 < 23:27:56.73 Index 6 (SALESTATX)
12355 < 23:27:56.73 Relation 138 (SALES) is ok
12303 <
12304 < 23:27:56.73 Relation 140 (LOTSOFDATA)
12305 < 23:27:56.73   process pointer page    0 of    1
12306 < 23:27:56.73 Index 1 (RDB$PRIMARY28)
12307 < 23:27:56.73 Relation 140 (LOTSOFDATA) is ok
12279 > 14:18:37.67 Relation 128 (COUNTRY)
12280 > 14:18:37.67   process pointer page    0 of    1
12281 > 14:18:37.67 Index 1 (RDB$PRIMARY1)
12282 > 14:18:37.67 Relation 128 (COUNTRY) is ok
12283 >
12284 > 14:18:37.67 Relation 129 (JOB)
12285 > 14:18:37.67   process pointer page    0 of    1
12286 > 14:18:37.67 Index 1 (RDB$PRIMARY2)
12287 > 14:18:37.67 Index 2 (RDB$FOREIGN3)
12288 > 14:18:37.67 Index 3 (MAXSALX)
12289 > 14:18:37.67 Index 4 (MINSALX)
12290 > 14:18:37.67 Relation 129 (JOB) is ok
12291 >
12292 > 14:18:37.67 Relation 130 (DEPARTMENT)
12293 > 14:18:37.67   process pointer page    0 of    1
12294 > 14:18:37.67 Index 1 (RDB$4)
12295 > 14:18:37.67 Index 2 (RDB$PRIMARY5)
12296 > 14:18:37.67 Index 3 (RDB$FOREIGN6)
12297 > 14:18:37.67 Index 4 (BUDGETX)
12298 > 14:18:37.67 Index 5 (RDB$FOREIGN10)
12299 > 14:18:37.67 Relation 130 (DEPARTMENT) is ok
12300 >
12301 > 14:18:37.67 Relation 131 (EMPLOYEE)
12302 > 14:18:37.67   process pointer page    0 of    1
12303 > 14:18:37.67 Index 1 (RDB$PRIMARY7)
12304 > 14:18:37.67 Index 2 (RDB$FOREIGN8)
12305 > 14:18:37.67 Index 3 (RDB$FOREIGN9)
12306 > 14:18:37.67 Index 4 (NAMEX)
12307 > 14:18:37.67 Relation 131 (EMPLOYEE) is ok
12308 >
12309 > 14:18:37.67 Relation 133 (PROJECT)
12310 > 14:18:37.67   process pointer page    0 of    1
12311 > 14:18:37.67 Index 1 (RDB$11)
12312 > 14:18:37.67 Index 2 (RDB$PRIMARY12)
12313 > 14:18:37.67 Index 3 (RDB$FOREIGN13)
12314 > 14:18:37.68 Index 4 (PRODTYPEX)
12315 > 14:18:37.68 Relation 133 (PROJECT) is ok
12316 >
12317 > 14:18:37.68 Relation 134 (EMPLOYEE_PROJECT)
12318 > 14:18:37.68   process pointer page    0 of    1
12319 > 14:18:37.68 Index 1 (RDB$PRIMARY14)
12320 > 14:18:37.68 Index 2 (RDB$FOREIGN15)
12321 > 14:18:37.68 Index 3 (RDB$FOREIGN16)
12322 > 14:18:37.68 Relation 134 (EMPLOYEE_PROJECT) is ok
12323 >
12324 > 14:18:37.68 Relation 135 (PROJ_DEPT_BUDGET)
12325 > 14:18:37.68   process pointer page    0 of    1
12326 > 14:18:37.68 Index 1 (RDB$PRIMARY17)
12327 > 14:18:37.68 Index 2 (RDB$FOREIGN18)
12328 > 14:18:37.68 Index 3 (RDB$FOREIGN19)
12329 > 14:18:37.68 Relation 135 (PROJ_DEPT_BUDGET) is ok
12330 >
12331 > 14:18:37.68 Relation 136 (SALARY_HISTORY)
12332 > 14:18:37.68   process pointer page    0 of    1
12333 > 14:18:37.68 Index 1 (RDB$PRIMARY20)
12334 > 14:18:37.68 Index 2 (RDB$FOREIGN21)
12335 > 14:18:37.68 Index 3 (CHANGEX)
12336 > 14:18:37.69 Index 4 (UPDATERX)
12337 > 14:18:37.69 Relation 136 (SALARY_HISTORY) is ok
12338 >
12339 > 14:18:37.69 Relation 137 (CUSTOMER)
12340 > 14:18:37.69   process pointer page    0 of    1
12341 > 14:18:37.69 Index 1 (RDB$PRIMARY22)
12342 > 14:18:37.69 Index 2 (RDB$FOREIGN23)
12343 > 14:18:37.69 Index 3 (CUSTNAMEX)
12344 > 14:18:37.69 Index 4 (CUSTREGION)
12345 > 14:18:37.69 Relation 137 (CUSTOMER) is ok
12346 >
12347 > 14:18:37.69 Relation 138 (SALES)
12348 > 14:18:37.69   process pointer page    0 of    1
12349 > 14:18:37.69 Index 1 (RDB$PRIMARY24)
12350 > 14:18:37.69 Index 2 (RDB$FOREIGN25)
12351 > 14:18:37.69 Index 3 (RDB$FOREIGN26)
12352 > 14:18:37.69 Index 4 (NEEDX)
12353 > 14:18:37.69 Index 5 (QTYX)
12354 > 14:18:37.69 Index 6 (SALESTATX)
12355 > 14:18:37.69 Relation 138 (SALES) is ok
12356  
12357 < 23:27:56.73 Validation finished
12357 > 14:18:37.69 Validation finished
12358  
12359  
12360   Normal Validation
# Line 12442 | Line 12490 | Employee Database is Online = FALSE
12490   Employee Database is Online = TRUE
12491  
12492   Starting Backup
12493 < Backup Completed - File Size = 81408 bytes
12493 > Backup Completed - File Size = 80384 bytes
12494   Restore Started
12495  
12496   Restore Completed
# Line 13591 | Line 13639 | DEPT_KEY_PATH = 000 (Charset = UTF8 Code
13639  
13640   Rows printed = 2
13641  
13642 < Current memory = 19,667,296
13642 > Current memory = 19,666,176
13643   Delta memory = 16,032
13644 < Max memory = 19,762,880
13644 > Max memory = 19,761,504
13645   Elapsed time= 0.002 sec
13646 < Cpu = 0.000 sec
13646 > Cpu = 0.010 sec
13647   Buffers = 2048
13648   Reads = 2
13649   Writes = 0
# Line 13859 | Line 13907 | DEPT_KEY_PATH = 000 (Charset = UTF8 Code
13907  
13908   Rows printed = 2
13909  
13910 < Current memory = 19,667,296
13910 > Current memory = 19,666,176
13911   Delta memory = 16,032
13912 < Max memory = 19,762,880
13912 > Max memory = 19,761,504
13913   Elapsed time= 0.102 sec
13914   Cpu = 0.000 sec
13915   Buffers = 2048
# Line 15480 | Line 15528 | Create Table LotsOfData (
15528      MyText VarChar(1024),
15529      Primary Key (RowID)
15530    );                
15531 < Loading data into database table. Started at 17/10/2021 23:28:45.143
15532 < Data load completed at 17/10/2021 23:30:25.163 Elapsed Time = 100020 ms, 100000 records loaded
15533 < Message Hash = 391fb63febbb58b57256c58708eeac65
15534 < Database Read started at 17/10/2021 23:30:25.174
15535 < Read Dataset completed at 17/10/2021 23:30:55.599 Elapsed Time = 30425 ms, 100000 records read
15536 < Message Hash = 391fb63febbb58b57256c58708eeac65
15531 > Loading data into database table. Started at 23/10/2021 14:19:28.924
15532 > Data load completed at 23/10/2021 14:21:13.893 Elapsed Time = 104969 ms, 100000 records loaded
15533 > Message Hash = 436daf51ddd32626a439935108ea69c8
15534 > Database Read started at 23/10/2021 14:21:13.906
15535 > Read Dataset completed at 23/10/2021 14:21:44.043 Elapsed Time = 30137 ms, 100000 records read
15536 > Message Hash = 436daf51ddd32626a439935108ea69c8
15537   Test Completed successfully
15538 < 17/10/2021 23:30:55.599 Test 21 passes as long as the checksums are identical
15538 > 23/10/2021 14:21:44.043 Test 21 passes as long as the checksums are identical
15539  
15540  
15541   ------------------------------------------------------
# Line 15709 | Line 15757 | JOIN Depts D On D.DEPT_NO = A.DEPT_NO
15757  
15758   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
15759   From DEPARTMENT Where HEAD_DEPT is NULL
15760 < UNION ALL
15760 > UNION ALL
15761   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
15762   OIN Depts On D.HEAD_DEPT = Depts.DEPT_NO
15763   )
15764   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 15723 | Line 15771 | Plan:
15771   Rows:
15772   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
15773   From DEPARTMENT Where HEAD_DEPT is NULL
15774 < UNION ALL
15774 > UNION ALL
15775   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
15776   OIN Depts On D.HEAD_DEPT = Depts.DEPT_NO
15777   )
15778  
# Line 15737 | Line 15785 | Params:
15785   Updated SQL
15786   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
15787   From DEPARTMENT Where HEAD_DEPT is NULL
15788 < UNION ALL
15788 > UNION ALL
15789   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
15790   OIN Depts On D.HEAD_DEPT = Depts.DEPT_NO
15791   )
15792  

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines