| 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.027 sec |
| 646 |
> |
Max memory = 19,781,408 |
| 647 |
> |
Elapsed time= 0.015 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 17 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 4027 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 2000 ms |
| 1494 |
> |
Transaction Ended after 1999 ms |
| 1495 |
|
Idle Timer Expired for Test_Transaction_02 |
| 1496 |
|
Before Disconnect |
| 1497 |
< |
inet://localhost/employee Disconnected after 2035 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 26 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 23 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 |
| 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 |
| 3303 |
< |
Elapsed time= 0.009 sec |
| 3304 |
< |
Cpu = 0.000 sec |
| 3302 |
> |
Max memory = 19,762,896 |
| 3303 |
> |
Elapsed time= 0.026 sec |
| 3304 |
> |
Cpu = 0.020 sec |
| 3305 |
|
Buffers = 2048 |
| 3306 |
|
Reads = 2 |
| 3307 |
|
Writes = 0 |
| 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 Mon Feb 22 10:41:04 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 1138 |
| 11786 |
> |
Generation 438 |
| 11787 |
|
System Change Number 0 |
| 11788 |
|
Page size 8192 |
| 11789 |
|
ODS version 13.0 |
| 11790 |
< |
Oldest transaction 1346 |
| 11791 |
< |
Oldest active 1347 |
| 11792 |
< |
Oldest snapshot 1347 |
| 11793 |
< |
Next transaction 1347 |
| 11790 |
> |
Oldest transaction 456 |
| 11791 |
> |
Oldest active 457 |
| 11792 |
> |
Oldest snapshot 457 |
| 11793 |
> |
Next transaction 457 |
| 11794 |
|
Sequence number 0 |
| 11795 |
< |
Next attachment ID 1067 |
| 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) |
| 11866 |
|
Primary pointer page: 258, Index root page: 259 |
| 11867 |
|
Pointer pages: 1, data page slots: 1 |
| 11868 |
|
Data pages: 1, average fill: 10% |
| 11869 |
< |
Primary pages: 1, secondary pages: 0, swept pages: 1 |
| 11869 |
> |
Primary pages: 1, secondary pages: 0, swept pages: 0 |
| 11870 |
|
Empty pages: 0, full pages: 0 |
| 11871 |
|
Fill distribution: |
| 11872 |
|
0 - 19% = 1 |
| 11918 |
|
Primary pointer page: 270, Index root page: 271 |
| 11919 |
|
Pointer pages: 1, data page slots: 1 |
| 11920 |
|
Data pages: 1, average fill: 30% |
| 11921 |
< |
Primary pages: 1, secondary pages: 0, swept pages: 1 |
| 11921 |
> |
Primary pages: 1, secondary pages: 0, swept pages: 0 |
| 11922 |
|
Empty pages: 0, full pages: 0 |
| 11923 |
|
Fill distribution: |
| 11924 |
|
0 - 19% = 0 |
| 11940 |
|
60 - 79% = 0 |
| 11941 |
|
80 - 99% = 0 |
| 11942 |
|
|
| 11943 |
< |
Gstat completion time Mon Feb 22 10:41:04 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:41:08.75 Validation started |
| 11953 |
> |
11:45:32.71 Validation started |
| 11954 |
|
|
| 11955 |
< |
10:41:08.75 Relation 128 (COUNTRY) |
| 11956 |
< |
10:41:08.75 process pointer page 0 of 1 |
| 11957 |
< |
10:41:08.75 Index 1 (RDB$PRIMARY1) |
| 11958 |
< |
10:41:08.75 Relation 128 (COUNTRY) is ok |
| 11959 |
< |
|
| 11960 |
< |
10:41:08.75 Relation 129 (JOB) |
| 11961 |
< |
10:41:08.75 process pointer page 0 of 1 |
| 11962 |
< |
10:41:08.75 Index 1 (RDB$PRIMARY2) |
| 11963 |
< |
10:41:08.75 Index 2 (RDB$FOREIGN3) |
| 11964 |
< |
10:41:08.75 Index 3 (MAXSALX) |
| 11965 |
< |
10:41:08.75 Index 4 (MINSALX) |
| 11966 |
< |
10:41:08.75 Relation 129 (JOB) is ok |
| 11967 |
< |
|
| 11968 |
< |
10:41:08.75 Relation 130 (DEPARTMENT) |
| 11969 |
< |
10:41:08.75 process pointer page 0 of 1 |
| 11970 |
< |
10:41:08.75 Index 1 (RDB$4) |
| 11971 |
< |
10:41:08.75 Index 2 (RDB$PRIMARY5) |
| 11972 |
< |
10:41:08.75 Index 3 (RDB$FOREIGN6) |
| 11973 |
< |
10:41:08.75 Index 4 (BUDGETX) |
| 11974 |
< |
10:41:08.75 Index 5 (RDB$FOREIGN10) |
| 11975 |
< |
10:41:08.75 Relation 130 (DEPARTMENT) is ok |
| 11976 |
< |
|
| 11977 |
< |
10:41:08.75 Relation 131 (EMPLOYEE) |
| 11978 |
< |
10:41:08.75 process pointer page 0 of 1 |
| 11979 |
< |
10:41:08.75 Index 1 (RDB$PRIMARY7) |
| 11980 |
< |
10:41:08.75 Index 2 (RDB$FOREIGN8) |
| 11981 |
< |
10:41:08.75 Index 3 (RDB$FOREIGN9) |
| 11982 |
< |
10:41:08.75 Index 4 (NAMEX) |
| 11983 |
< |
10:41:08.75 Relation 131 (EMPLOYEE) is ok |
| 11984 |
< |
|
| 11985 |
< |
10:41:08.75 Relation 133 (PROJECT) |
| 11986 |
< |
10:41:08.75 process pointer page 0 of 1 |
| 11987 |
< |
10:41:08.75 Index 1 (RDB$11) |
| 11988 |
< |
10:41:08.75 Index 2 (RDB$PRIMARY12) |
| 11989 |
< |
10:41:08.75 Index 3 (RDB$FOREIGN13) |
| 11990 |
< |
10:41:08.76 Index 4 (PRODTYPEX) |
| 11991 |
< |
10:41:08.76 Relation 133 (PROJECT) is ok |
| 11992 |
< |
|
| 11993 |
< |
10:41:08.76 Relation 134 (EMPLOYEE_PROJECT) |
| 11994 |
< |
10:41:08.76 process pointer page 0 of 1 |
| 11995 |
< |
10:41:08.76 Index 1 (RDB$PRIMARY14) |
| 11996 |
< |
10:41:08.76 Index 2 (RDB$FOREIGN15) |
| 11997 |
< |
10:41:08.76 Index 3 (RDB$FOREIGN16) |
| 11998 |
< |
10:41:08.76 Relation 134 (EMPLOYEE_PROJECT) is ok |
| 11999 |
< |
|
| 12000 |
< |
10:41:08.76 Relation 135 (PROJ_DEPT_BUDGET) |
| 12001 |
< |
10:41:08.76 process pointer page 0 of 1 |
| 12002 |
< |
10:41:08.76 Index 1 (RDB$PRIMARY17) |
| 12003 |
< |
10:41:08.76 Index 2 (RDB$FOREIGN18) |
| 12004 |
< |
10:41:08.76 Index 3 (RDB$FOREIGN19) |
| 12005 |
< |
10:41:08.76 Relation 135 (PROJ_DEPT_BUDGET) is ok |
| 12006 |
< |
|
| 12007 |
< |
10:41:08.76 Relation 136 (SALARY_HISTORY) |
| 12008 |
< |
10:41:08.76 process pointer page 0 of 1 |
| 12009 |
< |
10:41:08.76 Index 1 (RDB$PRIMARY20) |
| 12010 |
< |
10:41:08.76 Index 2 (RDB$FOREIGN21) |
| 12011 |
< |
10:41:08.76 Index 3 (CHANGEX) |
| 12012 |
< |
10:41:08.76 Index 4 (UPDATERX) |
| 12013 |
< |
10:41:08.76 Relation 136 (SALARY_HISTORY) is ok |
| 12014 |
< |
|
| 12015 |
< |
10:41:08.76 Relation 137 (CUSTOMER) |
| 12016 |
< |
10:41:08.76 process pointer page 0 of 1 |
| 12017 |
< |
10:41:08.76 Index 1 (RDB$PRIMARY22) |
| 12018 |
< |
10:41:08.76 Index 2 (RDB$FOREIGN23) |
| 12019 |
< |
10:41:08.76 Index 3 (CUSTNAMEX) |
| 12020 |
< |
10:41:08.76 Index 4 (CUSTREGION) |
| 12021 |
< |
10:41:08.76 Relation 137 (CUSTOMER) is ok |
| 12022 |
< |
|
| 12023 |
< |
10:41:08.76 Relation 138 (SALES) |
| 12024 |
< |
10:41:08.76 process pointer page 0 of 1 |
| 12025 |
< |
10:41:08.76 Index 1 (RDB$PRIMARY24) |
| 12026 |
< |
10:41:08.76 Index 2 (RDB$FOREIGN25) |
| 12027 |
< |
10:41:08.76 Index 3 (RDB$FOREIGN26) |
| 12028 |
< |
10:41:08.76 Index 4 (NEEDX) |
| 12029 |
< |
10:41:08.76 Index 5 (QTYX) |
| 12030 |
< |
10:41:08.76 Index 6 (SALESTATX) |
| 12031 |
< |
10:41:08.76 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:41:08.76 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 |
| 13320 |
> |
Max memory = 19,761,040 |
| 13321 |
|
Elapsed time= 0.001 sec |
| 13322 |
|
Cpu = 0.000 sec |
| 13323 |
|
Buffers = 2048 |
| 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.105 sec |
| 13588 |
> |
Max memory = 19,761,040 |
| 13589 |
> |
Elapsed time= 0.102 sec |
| 13590 |
|
Cpu = 0.000 sec |
| 13591 |
|
Buffers = 2048 |
| 13592 |
|
Reads = 2 |
| 15204 |
|
MyText VarChar(1024), |
| 15205 |
|
Primary Key (RowID) |
| 15206 |
|
); |
| 15207 |
< |
Loading data into database table. Started at 22/2/2021 10:42:05.275 |
| 15208 |
< |
Data load completed at 22/2/2021 10:43:41.417 Elapsed Time = 96143 ms, 100000 records loaded |
| 15209 |
< |
MD5 checksum = 7887a4d19dd095ad551ca8b5dc788e29 |
| 15210 |
< |
Database Read started at 22/2/2021 10:43:41.438 |
| 15211 |
< |
Read Dataset completed at 22/2/2021 10:44:12.873 Elapsed Time = 31435 ms, 100000 records read |
| 15212 |
< |
MD5 checksum = 7887a4d19dd095ad551ca8b5dc788e29 |
| 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 |
< |
22/2/2021 10:44:12.873 Test 21 passes as long as the MD5 sums are identical |
| 15214 |
> |
07/7/2021 11:48:38.470 Test 21 passes as long as the MD5 sums are identical |
| 15215 |
|
|
| 15216 |
|
|
| 15217 |
|
------------------------------------------------------ |
