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 16 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 4023 ms |
1457 |
> |
inet://localhost/employee Disconnected after 4019 ms |
1458 |
|
Idle Timer Expired for Test_Database_02 |
1459 |
|
Database Closed |
1460 |
|
Transaction Events |
1491 |
|
isc_tpb_read |
1492 |
|
|
1493 |
|
Transaction Ending |
1494 |
< |
Transaction Ended after 2001 ms |
1494 |
> |
Transaction Ended after 1999 ms |
1495 |
|
Idle Timer Expired for Test_Transaction_02 |
1496 |
|
Before Disconnect |
1497 |
< |
inet://localhost/employee Disconnected after 2042 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 22 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.024 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 Thu Feb 18 17:07:27 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 1016 |
11786 |
> |
Generation 438 |
11787 |
|
System Change Number 0 |
11788 |
|
Page size 8192 |
11789 |
|
ODS version 13.0 |
11790 |
< |
Oldest transaction 1192 |
11791 |
< |
Oldest active 1193 |
11792 |
< |
Oldest snapshot 1193 |
11793 |
< |
Next transaction 1193 |
11790 |
> |
Oldest transaction 456 |
11791 |
> |
Oldest active 457 |
11792 |
> |
Oldest snapshot 457 |
11793 |
> |
Next transaction 457 |
11794 |
|
Sequence number 0 |
11795 |
< |
Next attachment ID 899 |
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 Thu Feb 18 17:07:28 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 |
< |
17:07:32.35 Validation started |
11953 |
> |
11:45:32.71 Validation started |
11954 |
|
|
11955 |
< |
17:07:32.35 Relation 128 (COUNTRY) |
11956 |
< |
17:07:32.35 process pointer page 0 of 1 |
11957 |
< |
17:07:32.35 Index 1 (RDB$PRIMARY1) |
11958 |
< |
17:07:32.35 Relation 128 (COUNTRY) is ok |
11959 |
< |
|
11960 |
< |
17:07:32.35 Relation 129 (JOB) |
11961 |
< |
17:07:32.35 process pointer page 0 of 1 |
11962 |
< |
17:07:32.35 Index 1 (RDB$PRIMARY2) |
11963 |
< |
17:07:32.35 Index 2 (RDB$FOREIGN3) |
11964 |
< |
17:07:32.35 Index 3 (MAXSALX) |
11965 |
< |
17:07:32.35 Index 4 (MINSALX) |
11966 |
< |
17:07:32.35 Relation 129 (JOB) is ok |
11967 |
< |
|
11968 |
< |
17:07:32.35 Relation 130 (DEPARTMENT) |
11969 |
< |
17:07:32.35 process pointer page 0 of 1 |
11970 |
< |
17:07:32.35 Index 1 (RDB$4) |
11971 |
< |
17:07:32.35 Index 2 (RDB$PRIMARY5) |
11972 |
< |
17:07:32.35 Index 3 (RDB$FOREIGN6) |
11973 |
< |
17:07:32.35 Index 4 (BUDGETX) |
11974 |
< |
17:07:32.35 Index 5 (RDB$FOREIGN10) |
11975 |
< |
17:07:32.35 Relation 130 (DEPARTMENT) is ok |
11976 |
< |
|
11977 |
< |
17:07:32.35 Relation 131 (EMPLOYEE) |
11978 |
< |
17:07:32.35 process pointer page 0 of 1 |
11979 |
< |
17:07:32.35 Index 1 (RDB$PRIMARY7) |
11980 |
< |
17:07:32.35 Index 2 (RDB$FOREIGN8) |
11981 |
< |
17:07:32.35 Index 3 (RDB$FOREIGN9) |
11982 |
< |
17:07:32.35 Index 4 (NAMEX) |
11983 |
< |
17:07:32.35 Relation 131 (EMPLOYEE) is ok |
11984 |
< |
|
11985 |
< |
17:07:32.35 Relation 133 (PROJECT) |
11986 |
< |
17:07:32.35 process pointer page 0 of 1 |
11987 |
< |
17:07:32.35 Index 1 (RDB$11) |
11988 |
< |
17:07:32.35 Index 2 (RDB$PRIMARY12) |
11989 |
< |
17:07:32.35 Index 3 (RDB$FOREIGN13) |
11990 |
< |
17:07:32.35 Index 4 (PRODTYPEX) |
11991 |
< |
17:07:32.35 Relation 133 (PROJECT) is ok |
11992 |
< |
|
11993 |
< |
17:07:32.35 Relation 134 (EMPLOYEE_PROJECT) |
11994 |
< |
17:07:32.35 process pointer page 0 of 1 |
11995 |
< |
17:07:32.35 Index 1 (RDB$PRIMARY14) |
11996 |
< |
17:07:32.35 Index 2 (RDB$FOREIGN15) |
11997 |
< |
17:07:32.35 Index 3 (RDB$FOREIGN16) |
11998 |
< |
17:07:32.35 Relation 134 (EMPLOYEE_PROJECT) is ok |
11999 |
< |
|
12000 |
< |
17:07:32.35 Relation 135 (PROJ_DEPT_BUDGET) |
12001 |
< |
17:07:32.35 process pointer page 0 of 1 |
12002 |
< |
17:07:32.35 Index 1 (RDB$PRIMARY17) |
12003 |
< |
17:07:32.35 Index 2 (RDB$FOREIGN18) |
12004 |
< |
17:07:32.35 Index 3 (RDB$FOREIGN19) |
12005 |
< |
17:07:32.35 Relation 135 (PROJ_DEPT_BUDGET) is ok |
12006 |
< |
|
12007 |
< |
17:07:32.35 Relation 136 (SALARY_HISTORY) |
12008 |
< |
17:07:32.35 process pointer page 0 of 1 |
12009 |
< |
17:07:32.35 Index 1 (RDB$PRIMARY20) |
12010 |
< |
17:07:32.36 Index 2 (RDB$FOREIGN21) |
12011 |
< |
17:07:32.36 Index 3 (CHANGEX) |
12012 |
< |
17:07:32.36 Index 4 (UPDATERX) |
12013 |
< |
17:07:32.36 Relation 136 (SALARY_HISTORY) is ok |
12014 |
< |
|
12015 |
< |
17:07:32.36 Relation 137 (CUSTOMER) |
12016 |
< |
17:07:32.36 process pointer page 0 of 1 |
12017 |
< |
17:07:32.36 Index 1 (RDB$PRIMARY22) |
12018 |
< |
17:07:32.36 Index 2 (RDB$FOREIGN23) |
12019 |
< |
17:07:32.36 Index 3 (CUSTNAMEX) |
12020 |
< |
17:07:32.36 Index 4 (CUSTREGION) |
12021 |
< |
17:07:32.36 Relation 137 (CUSTOMER) is ok |
12022 |
< |
|
12023 |
< |
17:07:32.36 Relation 138 (SALES) |
12024 |
< |
17:07:32.36 process pointer page 0 of 1 |
12025 |
< |
17:07:32.36 Index 1 (RDB$PRIMARY24) |
12026 |
< |
17:07:32.36 Index 2 (RDB$FOREIGN25) |
12027 |
< |
17:07:32.36 Index 3 (RDB$FOREIGN26) |
12028 |
< |
17:07:32.36 Index 4 (NEEDX) |
12029 |
< |
17:07:32.36 Index 5 (QTYX) |
12030 |
< |
17:07:32.36 Index 6 (SALESTATX) |
12031 |
< |
17:07:32.36 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 |
< |
17:07:32.36 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 |
13542 |
|
*Monitor* |
13543 |
|
[Application: IBX Test Suite] |
13544 |
|
Test_Database_13: [Disconnect] |
13545 |
+ |
*Monitor* |
13546 |
+ |
[Application: IBX Test Suite] |
13547 |
+ |
Monitoring Disabled |
13548 |
|
33 ISQL Monitor Messages Received |
13549 |
|
|
13550 |
|
|
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 |
13588 |
> |
Max memory = 19,761,040 |
13589 |
|
Elapsed time= 0.102 sec |
13590 |
|
Cpu = 0.000 sec |
13591 |
|
Buffers = 2048 |
13809 |
|
*Monitor* |
13810 |
|
[Application: IBX Test Suite] |
13811 |
|
Test_Database_14: [Disconnect] |
13812 |
+ |
*Monitor* |
13813 |
+ |
[Application: IBX Test Suite] |
13814 |
+ |
Monitoring Disabled |
13815 |
|
33 ISQL Monitor Messages Received |
13816 |
|
|
13817 |
|
|
15204 |
|
MyText VarChar(1024), |
15205 |
|
Primary Key (RowID) |
15206 |
|
); |
15207 |
< |
Loading data into database table. Started at 18/2/2021 17:08:20.034 |
15208 |
< |
Data load completed at 18/2/2021 17:09:56.119 Elapsed Time = 96085 ms, 100000 records loaded |
15209 |
< |
MD5 checksum = 78516f380a41fc5a972b7c9b5ac14024 |
15210 |
< |
Database Read started at 18/2/2021 17:09:56.141 |
15211 |
< |
Read Dataset completed at 18/2/2021 17:10:29.759 Elapsed Time = 33618 ms, 100000 records read |
15212 |
< |
MD5 checksum = 78516f380a41fc5a972b7c9b5ac14024 |
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 |
+ |
07/7/2021 11:48:38.470 Test 21 passes as long as the MD5 sums are identical |
15215 |
|
|
15216 |
|
|
15217 |
|
------------------------------------------------------ |