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
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
207										This test checks the validity of date/datetime comparisons Its more for the SQL side than 4GL..
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.\<
287										Another UNLOAD test
530										CREATE TABLE with database.owner specified. No run-time checking.
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.
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.
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.
576										DROP SYNONYM 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.
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.
625										Complex DELETE database statement. No run-time checking.
629										LOAD FROM with INSERT statement in variable. 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.
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.
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.
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.
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.
739										select into temp with no log..
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.
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.
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.
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
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.
905										Test if the sqlca.sqlerrd[2] is assigned with last serial inserted.
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.
936										Test if the SET LOG 4gl statement works OK
1009										cursor for update declared twice that second thime thinks it does not exist
1206										ord() server-side function in SELECT and UPDATE SQL statements
1249										Date tests of some sort
1251										date handling , mid 720
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
1413										Example logical report layout testing
	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