| NODB | ESQLI | ECI | ECP | IFXODBC | SQLITE | PGODBC | PG8 | MYSQL |
| 11-04-2007 18-07-45 | 11-04-2007 19-30-06 | 11-04-2007 18-24-35 | 11-04-2007 18-46-34 | 11-04-2007 18-51-44 | 11-04-2007 19-04-31 | 11-04-2007 19-11-21 | 11-04-2007 20-53-30 | 11-04-2007 19-22-14 |
| 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 |
| Test No | | | | | | | | | | | Description |
| 14 |  |  |  |  |  |  |  |  |  | Simple foreach handling |
| 72 |  |  |  |  |  |  |  |  |  | Simple report checking when using ORDER BY (not ORDER EXTERNAL..) |
| 76 |  |  |  |  |  |  |  |  |  | Basic DB exercising of Datetimes |
| 95 |  |  |  |  |  |  |  |  |  | UPDATE ... WHERE CURRENT OF.. |
| 110 |  |  |  |  |  |  |  |  |  | Test for core dump in LOAD FROM |
| 207 |  |  |  |  |  |  |  |  |  | This test checks the validity of date/datetime comparisons Its more for the SQL side than 4GL.. |
| 270 |  |  |  |  |  |  |  |  |  | A quick test of the define variable like dbname:tablename.column and record like dbname:tablename.\< |
| 590 |  |  |  |  |  |  |  |  |  | SET EXPLAIN ON database statement. No run-time checking. Note that this test may fail because of Informix configuration issues. For example, if your oninit permissions look like this: -rwSr-sr-- 1 informix informix 8497828 Mar 3 2002 /opt/informix/bin/ |
| 591 |  |  |  |  |  |  |  |  |  | SET EXPLAIN OFF database statement. No run-time checking. |
| 626 |  |  |  |  |  |  |  |  |  | LOAD FROM ... INSERT INTO statement. No run-time checking. |
| 627 |  |  |  |  |  |  |  |  |  | LOAD FROM ... INSERT INTO with file name in variable. No run-time checking. |
| 628 |  |  |  |  |  |  |  |  |  | LOAD FROM with DELIMITER clause. No run-time checking. |
| 629 |  |  |  |  |  |  |  |  |  | LOAD FROM with INSERT statement in variable. No run-time checking. |
| 630 |  |  |  |  |  |  |  |  |  | LOAD FROM ... INSERT INTO with one column. No run-time checking. |
| 631 |  |  |  |  |  |  |  |  |  | LOAD FROM ... INSERT INTO with several columns. No run-time checking. |
| 632 |  |  |  |  |  |  |  |  |  | Simple UNLOAD TO statement. No run-time checking. |
| 633 |  |  |  |  |  |  |  |  |  | UNLOAD TO with file name in variable. No run-time checking. |
| 634 |  |  |  |  |  |  |  |  |  | UNLOAD with specified DELIMITER. No run-time checking. |
| 635 |  |  |  |  |  |  |  |  |  | UNLOAD TO with query string in variable. No run-time checking. |
| 636 |  |  |  |  |  |  |  |  |  | Complex UNLOAD statement. No run-time checking. |
| 716 |  |  |  |  |  |  |  |  |  | SELECT several columns. |
| 717 |  |  |  |  |  |  |  |  |  | SELECT ALL. |
| 718 |  |  |  |  |  |  |  |  |  | SELECT DISTINCT |
| 719 |  |  |  |  |  |  |  |  |  | SELECT AS |
| 731 |  |  |  |  |  |  |  |  |  | SELECT with named ORDER BY. |
| 732 |  |  |  |  |  |  |  |  |  | SELECT with numbered ORDER BY |
| 733 |  |  |  |  |  |  |  |  |  | SELECT with DEC and ASC ORDER BY clause |
| 738 |  |  |  |  |  |  |  |  |  | Check if a select into temp insert the correct values and then they are correctly fetched. |
| 741 |  |  |  |  |  |  |  |  |  | Check if a simple select with a NOT condition fetch the correct values. |
| 742 |  |  |  |  |  |  |  |  |  | Check if a simple select with a simple comparison condition fetch the correct values. |
| 743 |  |  |  |  |  |  |  |  |  | Check if a simple select with a IN subquery in where condition fetch the correct values. |
| 744 |  |  |  |  |  |  |  |  |  | Check if a simple select with a EXISTS subquery in where condition fetch the correct values |
| 745 |  |  |  |  |  |  |  |  |  | Check if a simple select with ALL subquery in where condition fetch the correct values. |
| 746 |  |  |  |  |  |  |  |  |  | Check if a simple select with between in where condition fetch the correct values. |
| 747 |  |  |  |  |  |  |  |  |  | Check if a simple select with IN expression (not subquery) in where condition fetch the correct values |
| 748 |  |  |  |  |  |  |  |  |  | Check if a simple select wth IN expression (not subquery) in where condition fetch the correct values. |
| 749 |  |  |  |  |  |  |  |  |  | Check if a simple select with LIKE in where condition fetch the correct values. |
| 750 |  |  |  |  |  |  |  |  |  | Check if a simple select with MATCHES in where condition fetch the correct values |
| 751 |  |  |  |  |  |  |  |  |  | Check if a simple select with MATCHES in where condition using a variable fetch the correct values. |
| 753 |  |  |  |  |  |  |  |  |  | Check if a simple select that uses the rowid fetch the correct values values |
| 755 |  |  |  |  |  |  |  |  |  | Check if a simple select with < operatoor on where condition fetch the correct values. |
| 756 |  |  |  |  |  |  |  |  |  | Check if a simple select with > operator on where condition fetch the correct values |
| 757 |  |  |  |  |  |  |  |  |  | Check if a simple select with <= operatoor on where condition fetch the correct values |
| 758 |  |  |  |  |  |  |  |  |  | Check if a simple select with LIKE in where condition using a variable fetch the correct values. |
| 763 |  |  |  |  |  |  |  |  |  | Check if a simple select with OR in where condition fetch the correct values. |
| 764 |  |  |  |  |  |  |  |  |  | Check if a simple select with LIKE in where condition using a variable fetch the correct values. |
| 768 |  |  |  |  |  |  |  |  |  | Check if a simple select with ANY subquery in where condition fetch the correct values. |
| 769 |  |  |  |  |  |  |  |  |  | Check if a simple select with SOME subquery in where condition fetch the correct values |
| 770 |  |  |  |  |  |  |  |  |  | Check if a simple select with NOT IN expression (not subquery) in where condition fetch the correct values. |
| 772 |  |  |  |  |  |  |  |  |  | Check if a simple select with NOT BETWEEN in where condition fetch the correct values. |
| 774 |  |  |  |  |  |  |  |  |  | Check if a simple select with NOT LIKE in where condition using a variable fetch the correct values. |
| 775 |  |  |  |  |  |  |  |  |  | Check if a simple select with NOT MATCHES in where condition fetch the correct values. |
| 776 |  |  |  |  |  |  |  |  |  | Check if a simple select with LIKE in where condition using a variable fetch the correct values. |
| 789 |  |  |  |  |  |  |  |  |  | Check with UNION in where condition fetch the correct values. |
| 790 |  |  |  |  |  |  |  |  |  | Check with UNION ALL in where condition fetch the correct values. |
| 792 |  |  |  |  |  |  |  |  |  | Check if the commit work statement after a transaction work |
| 910 |  |  |  |  |  |  |  |  |  | Test if the sqlca.sqlerrd[6] is assigned with last rowid inserted. |
| 912 |  |  |  |  |  |  |  |  |  | Test if the sqlca.sqlarn[2] is assigned with a W after a truncation in a select. |
| 913 |  |  |  |  |  |  |  |  |  | Test if the sqlca.sqlarn[2] is assigned with a W after using a database without transactions. |
| 1060 |  |  |  |  |  |  |  |  |  | Testing a way to pass values between shell and 4gl using a temporary file. |
| 1210 |  |  |  |  |  |  |  |  |  | handling of -ve decimal numbers |
| 1228 |  |  |  |  |  |  |  |  |  | MID 661 Note that for this test to work, in most cases, the database engine needs to have sufficient privileges to write to the test directory |
| 1245 |  |  |  |  |  |  |  |  |  | NULL in DATE |
| 1248 |  |  |  |  |  |  |  |  |  | Tests rolling back - mid 717 |
| 1249 |  |  |  |  |  |  |  |  |  | Date tests of some sort |
| 1250 |  |  |  |  |  |  |  |  |  | This is a test provided by Miguel Caldera which demonstates some corruption |
| 1413 |  |  |  |  |  |  |  |  |  | Example logical report layout testing |
| 1416 |  |  |  |  |  |  |  |  |  | Tests order by desc within a report |
| 1417 |  |  |  |  |  |  |  |  |  | Tests report order by |
| 1418 |  |  |  |  |  |  |  |  |  | Tests using datetimes in a report |
| 1420 |  |  |  |  |  |  |  |  |  | report linenumber test |
| 1421 |  |  |  |  |  |  |  |  |  | Another report test |
| 1600 |  |  |  |  |  |  |  |  |  | Do some ordering, before/after group with null values. Mantis bug 902. |
| 1617 |  |  |  |  |  |  |  |  |  | begin/commit work inside a report, end prematurly. MID 932. |
| 485 OK 7 Fail 463 Skip 98% OK | 404 OK Fail 559 Skip 100% OK | 399 OK Fail 564 Skip 100% OK | 254 OK 28 Fail 681 Skip 90% OK | 380 OK 21 Fail 562 Skip 94% OK | 275 OK 126 Fail 562 Skip 68% OK | 236 OK 74 Fail 653 Skip 76% OK | 306 OK 100 Fail 557 Skip 75% OK | 292 OK 114 Fail 557 Skip 71% OK |