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
36										Test a foreach when an open has already been done
95										UPDATE ... WHERE CURRENT OF..
106										SELECT FIRST and SQL - END SQL block
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.\<
286										This is a test for the UNLOAD bug reported
287										Another UNLOAD test
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.
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.
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.
606										RENAME COLUMN database statement. 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.
639										SET LOCK MODE TO WAIT with seconds specified. 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.
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.
675										UPDATE SYNONYM 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.
695										UPDATE SET WHERE CURRENT OF (std. syntax) No run-time checking.
696										UPDATE with THRU syntax. 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.
713										DELETE on synonym. No run-time checking.
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.
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
761										Check if a simple select with MATCHES and characters escaped 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.
776										Check if a simple select with LIKE in where condition using a variable fetch the correct values.
791										Check if a ROLLBACK WORK works ok.
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.
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.
912										Test if the sqlca.sqlarn[2] is assigned with a W after a truncation in a select.
914										Test if the sqlca.sqlawarn[3] is assigned with a W after a null in an agregate function of a select.
936										Test if the SET LOG 4gl statement works OK
1009										cursor for update declared twice that second thime thinks it does not exist
1200										This is a fairly comprehensive declare/open test for input/output binding
1220										Tests the SQL drivers ability to select fewer or more columns than variables
1246										Tests a rollback work
1248										Tests rolling back - mid 717
1249										Date tests of some sort
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)
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.
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
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