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
1										Test setting some basic types to null
14										Simple foreach handling
36										Test a foreach when an open has already been done
68										Null string date/datetime checking
72										Simple report checking when using ORDER BY (not ORDER EXTERNAL..)
76										Basic DB exercising of Datetimes
95										UPDATE ... WHERE CURRENT OF..
98										Some basic testing of sqlerrd[2] and sqlerrd[6] (SERIAL)
106										SELECT FIRST and SQL - END SQL block
109										Test for core dump when opening a cursor
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..
212										VALIDATE check
227										This is a test to check some bug fixes reported by Art Kagel
240										This is a test of the USING keyword
257										This is a test for MID 512
258										Tests mantis bug 516 (private bug) ecpg crashed on declare cursor for select statement - the select statement has an 'into clause' of 3 members of a structure. It works fine when the number is less than 3.
270										A quick test of the define variable like dbname:tablename.column and record like dbname:tablename.\<
286										This is a test for the UNLOAD bug reported
287										Another UNLOAD test
376										Validate with 'star' notation
530										CREATE TABLE with database.owner specified. No run-time checking.
531										CREATE TABLE with all (Informix) data types. No run-time checking.
535										CREATE TABLE with storage information. No run-time checking.
543										CREATE TABLE with DEFAULT clause. No run-time checking. NOTE: fails with -ifx-p.
551										Simple ALTER TABLE. No run-time checking.
552										ALTER TABLE with ADD clause. No run-time ckecking.
553										ALTER TABLE with DROP clause. No run-time checking.
554										ALTER TABLE with ADD CONSTRAINT clause. No run-time checking. NOTE: fails to compile with -ifx-p.
555										ALTER TABLE with DROP CONSTRAINT clause. No run-time ckecking. NOTE: fails to compile with -ifx-p.
556										ALTER TABLE with NEXT SIZE clause. No run-time checking.
557										ALTER TABLE with LOCK MODE clause. No run-time checking.
558										ALTER TABLE ... ADD with all (Informix) types. No run-time checking. NOTE: fails to compile with -ifx-p.
559										ALTER TABLE ADD with BEFORE clause. No run-time checking.
560										ALTER TABLE with MODIFY (all Informix types). No run-time checking. NOTE: fails to compile with -ifx-p.
561										ALTER TABLE ... MODIFY with column CONSTRAINT clause. No run-time checking. NOTE: fails to compile with -ifx-p.
562										ALTER TABLE ... ADD with column CONSTRAINT clause. No run-time checking. NOTE: fails to compile with -ifx-p.
569										Complex CREATE INDEX. No run-time checking. NOTE: fails to compile with -ifx-p.
570										CREATE SYNONYM statement. No run-time checking.
571										CREATE PUBLIC SYNONYM database statement. No run-time checking. NOTE: fails to compile with -ifx-p.
572										CREATE PRIVATE SYNONYM database statement. No run-time checking. NOTE: fails to compile with -ifx-p.
574										DROP INDEX database statement. No run-time checking.
576										DROP SYNONYM database statement. No run-time checking.
580										DROP INDEX database statement. No run-time checking.
584										EXECUTE prepared database statement. No run-time checking.
587										FREE prepared and executed statement. No run-time checking.
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.
594										Simple UPDATE STATISTICS. No run-time checking.
595										LOCK TABLE with SHARED MODE. No run-time checking.
596										LOCK TABLE with EXCLUSIVE MODE. No run-time checking.
598										UNLOCK TABLE database statement. No run-time checking.
605										RENAME TABLE database statement. No run-time checking.
606										RENAME COLUMN database statement. No run-time checking.
610										CREATE VIEW ... AS SELECT with named columns. No run-time checking.
611										CREATE VIEW with CHECK OPTION. No run-time checking.
612										Complex CREATE VIEW database statement. No run-time checking.
620										DELETE with WHERE CURRENT OF clause. No run-time checking.
621										DELETE with sub-query No run-time checking.
622										DELETE with EXISTS sub-query. No run-time checking.
623										DELETE ... WHERE ALL/SOME/ANY. No run-time checking.
624										DELETE with IS NOT NULL. No run-time checking.
625										Complex DELETE 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.
639										SET LOCK MODE TO WAIT with seconds specified. No run-time checking.
642										SET ISOLATION TO DIRTY READ directive. No run-time checking. NOTE: requires transaction support.
644										SET ISOLATION TO REPEATABLE READ directive. No run-time checking.
645										GRANT TO ... PUBLIC database statement. No run-time checking.
646										GRANT ... TO user database statement. No run-time checking.
647										GRANT table privileges with TO PUBLIC clause. No run-time checking.
648										GRANT on table to user list. No run-time checking.
649										GRANT INSERT on table to user. No run-time checking.
650										GRANT DELETE on table to user list. No run-time checking.
651										GRANT UPDATE on table to user list. No run-time checking.
652										GRANT INDEX on table to user list. No run-time checking.
653										GRANT ALTER on table to user list. No run-time checking.
654										GRANT on table will full name.
655										Complex GRANT on table. No run-time checking.
656										REVOKE ... FROM PUBLIC database statement. No run-time checking.
658										REVOKE on table from PUBLIC database statement. No run-time checking.
659										REVOKE on table from user list. No run-time checking.
666										GRANT SELECT in all variants. No run-time checking.
667										GRANT on table with GRANT OPTION. No run-time checking.
668										GRANT on table AS GRANTOR No run-time checking.
670										INSERT with all (Informix) data types. No run-time checking. Need minimum version 7.31 of Ifx to work with -ifx-p
675										UPDATE SYNONYM No run-time checking.
676										UPDATE on VIEW No run-time checking.
678										UPDATE with Informic-style SET syntax (column=value) No run-time checking.
679										UPDATE with Informix-style SET syntax (multiple columns/values) No run-time checking.
680										UPDATE with dot-star notation (Informix syntax) No run-time checking.
681										UPDATE with constants in SET clause (Informix syntax) No run-time checking.
682										UPDATE with expresion in SET and column list (Informix syntax) No run-time checking.
683										UPDATE with function calls in expresion (Informix syntax) No run-time checking.
685										UPDATE with variables in SET clause (Informix syntax). No run-tiem checking.
686										UPDATE with SET sub-expression (Informix syntax) No run-time checking.
687										UPDATE ... SET with UNITS. No run-time checking.
689										UPDATE VIEW with Informix-style SET. No run-time checking.
692										UPDATE standard SET with SQL expression. No run-time checking.
693										UPDATE SET with SELECT (std ANSI SQL 92 syntax) No run-time checking.
695										UPDATE SET WHERE CURRENT OF (std. syntax) No run-time checking.
696										UPDATE with THRU syntax. No run-time checking.
697										Complex UPDATE. No run-time checking.
698										INSERT into VIEW. No run-time checking.
700										INSERT on synonym. NO run-time checking.
701										UPDATE SET with sub-expression (std syntax). No run-time checking.
702										UPDATE SET with function call in expression (std syntax). No run-time checking.
704										UPDATE SET with sub-expression (std syntax). No run-time checking.
706										Select with constants and expresions, all combinations. Informix specific syntax.
711										DELETE from view. No run-time checking.
713										DELETE on synonym. No run-time checking.
716										SELECT several columns.
717										SELECT ALL.
718										SELECT DISTINCT
719										SELECT AS
721										Check if column expressions is correctly fetched.
724										Check if a select with \< fetch all correct values.
725										Check if a select with \< fetch all correct values.
726										Check if a select with over two tables fetch the correct values.
728										Check if a select with over two tables with outer fetch the correct values.
729										Check if a select with over two tables with two outer fetch the correct values.
730										Check if a select with over two tables with two outer fetch the correct values.
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.
739										select into temp with no log..
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
754										Check if a simple select with LIKE and characters escaped in where condition fetch the correct 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.
761										Check if a simple select with MATCHES and characters escaped in where condition 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.
766										Tests to exemplify the behaviour of cursor location with aubit and standard 4gl.
767										Testing if the values returned by fgl_keyval is equal to the values of informix.
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.
783										Check if a simple select with COUNT distinct in select list fetch the correct values.
784										Check if a simple select with MAX(ALL) in select list fetch the correct values.
785										Check if a simple select with AVG(ALL) in select list fetch the correct values.
786										Check if a simple select with MIN(ALL) in select list fetch the correct values.
787										Check if a simple select with SUM ALL in select list 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.
791										Check if a ROLLBACK WORK works ok.
792										Check if the commit work statement after a transaction work
798										Check if a simple select with rowid in select list fetch the correct values.
902										Test if the sqlca.sqlerrm is assigned with an obvious sql error.
904										Test if the sqlca.sqlerrd[1] is assigned with NOTFOUND sql error.
905										Test if the sqlca.sqlerrd[2] is assigned with last serial inserted.
906										Test if the sqlca.sqlerrd[2] is assigned with the ISAM error with a lock
908										Test if the sqlca.sqlerrd[4] is assigned with the estimated cost of query.
909										Test if the sqlca.sqlerrd[5] is assigned with the offset of an error in an wrong sql statement.
910										Test if the sqlca.sqlerrd[6] is assigned with last rowid inserted.
911										Test if the sqlca.sqlarn[1] is assigned with a W
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.
914										Test if the sqlca.sqlawarn[3] is assigned with a W after a null in an agregate function of a select.
915										Test if the sqlca.sqlawarn[4] is assigned with a W after a select with more on a select list then on into
936										Test if the SET LOG 4gl statement works OK
962										Test the decimal variable limits.
1009										cursor for update declared twice that second thime thinks it does not exist
1060										Testing a way to pass values between shell and 4gl using a temporary file.
1200										This is a fairly comprehensive declare/open test for input/output binding
1201										Test behavious of status variable. No run-time checking
1206										ord() server-side function in SELECT and UPDATE SQL statements
1210										handling of -ve decimal numbers
1220										Tests the SQL drivers ability to select fewer or more columns than variables
1221										Tests empty foreach loops (bug reported by James Scott)
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
1246										Tests a rollback work
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
1251										date handling , mid 720
1254										Tests use of a dynamic field
1257										This tests for a core dump when using a specific unload routine, known to fail on some platforms (they should remove the #define KAGEL_UNLOAD from lib/libsql/esqlc/esql.ec if set)
1262										Checks sqlerrd[3] is set after a LOAD
1265										Checks the value of variables after a fetch with too few columns in the select
1273										Tests selecting into from a union'd statement with no cursor
1274										Various DATETIME variants inserted
1301										CREATE TABLE with DEFAULT clause. No run-time checking. NOTE: fails with -ifx-p.
1302										UPDATE with constants in SET clause (Informix syntax) No run-time checking.
1303										UPDATE with expresion in SET and column list (Informix syntax) No run-time checking.
1304										Check if a simple select with GREATER or equal the in where condition fetch the correct values.
1305										Null string date/datetime checking
1406										Checks the usage of a blank string in an SQL statement , basically making sure it not treated as null
1410										test wordwrap - MID 755
1411										When using substring in a column with alias, the table alias is removed and an ambigous column error may be thrown
1413										Example logical report layout testing
1415										BUGFIX:cant substr if @ in fieldname
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.
1608										Use of tab and arrow keys during multi line field, mantis bug 909 (related 755).
1610										Selecting varchar return string padded with spaces up to the maximun length, mantis bug 915.
1617										begin/commit work inside a report, end prematurly. MID 932.
1622										SQL with mulitply money field, not all decimals considered. MID 941.
	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