| 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 |