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
63
68										Null string date/datetime checking
72										Simple report checking when using ORDER BY (not ORDER EXTERNAL..)
73										declare.. into.. fetch (no var)
76										Basic DB exercising of Datetimes
80										Some simple form handling
91										Old makefile
94										insert,declare,foreach
95										UPDATE ... WHERE CURRENT OF..
98										Some basic testing of sqlerrd[2] and sqlerrd[6] (SERIAL)
99										Test of Aubit4GL extension - IN and EXISTS as 4GL expression
100										insert cursor (in a similar way to an order by report)
101										Tests for NOTFOUND status code after select statement executed on empty temporary table.
106										SELECT FIRST and SQL - END SQL block
107										UNLOAD TO with SELECT statement and WHERE part
108										Testing for invalid file name in UNLOAD
109										Test for core dump when opening a cursor
110										Test for core dump in LOAD FROM
113										Test for invalid cursor type & name detection that was causing : Warning - cursor FLUSH was previously thought to be a SELECT cursor but now turns out to be an INSERT cursor.You will need to add PRAGMA EMULATE INSERT CURSOR FOR FLUSH Note that this tes
114										Test for declaring insert cursor with static (not variable) value in insert cursor declaration This was causing Aubit to print EC code (INFORMIX dialect) with missing opening left curly bracket.
115										Statement re-use without closing
206										Simple test of what happens when a row is not returned from a select
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
234										This is a test of basic Insert Cursor/PUT functionality
244										This is a test to check for before/after fields in a construct MID 459
255										This tests the ability to create a table with a MONEY field
256										checks a select with an order by with into temp - tests whether STRIP_ORDER_BY_INTO_TEMP is required eg for use with postgres
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.
269										Tests if 'display at' correctly resets the status variable
270										A quick test of the define variable like dbname:tablename.column and record like dbname:tablename.\<
272										This checks 'continue construct' functionality
273										This checks that a fields default value (as defined in the form) is not used during a construct
274										This tests that an interrupted construct statement does NOT set the variable to 1=1
282										This is a test to see if a page header is run at the correct point in time. At the time of submitting this test - the declare isn't performed until something is printed in another block and hence isn't available in the on every row. Workaround is to pr
286										This is a test for the UNLOAD bug reported
287										Another UNLOAD test
289										Quick test on using foreach on a declare which used variables
290										This tests a problem with the use of datetime variables (reported by Fernando Ortiz)
298										This is a sample 4gl program which connects to a db specified via a variable and selects into an array
301										A program with database, a globals file and globals define
302										A database definition, a globals include file, modulars variables and a function.
303										A database definition and modular defines
309										Just a database statement
327										Database inside function
331										For loop with exit for
332										Foreach loop with into one var
333										Foreach loop with into two var(s)
334										Foreach loop with CONTINUE FOREACH
335										Foreach loop with CONTINUE FOREACH
352										DATABASE statement inside of the FUNCTION block No run-time checking
353										DATABASE as global declaration and in function block No run-time checking.
354										DATABASE in MAIN block. No run-time checking.
357										WHENEVER ERROR STOP in function, but not called from MAIN - FIXME< No run-time checking.
358										WHENEVER ERROR CALL test - not called from main - FIXME No run-time checking.
359										WHENEVER ERROR GOTO- not called from MAIN - FIXME No run-time checking.
360										WHENEVER WARNING STOP - not called from MAIN - FIXME No run-time checking.
361										WHENEVER WARNING CALL - not called from MAIN - FIXME No run-time checking.
362										WHENEVER WARNING GOTO - not called from MAIN No run-time checking.
363										WHENEVER ANY ERROR - not called from MAIN - FIXME No run-time checking.
364										WHENEVER SQLWARNING - not called from MAIN - fixme No run-time checking.
365										WHENEVER SQLERROR - not called from main. No run-time error checking.
366										WHENEVER NOT FOUND - not called from MAIN - FIXME No run-time checking.
367										WHENEVER ERROR CONTINUE - not called from MAIN - FIXME No run-time checking.
370										INITIALIZE record. No run-time checking.
371										Simple INITIALIZE ... LIKE ... No run-time checking.
372										List Initialize like with table
373										List Initialize like with dot-star notation
374										Simple validate
376										Validate with 'star' notation
476										DEFINE LIKE - all combinations. No run-tme checking.
477										DEFINE LIKE with dot-star notation. No run-time checking.
478										DEFINE RECORD LIKE with qualifier - all combinations. No run-time checking.
513										Simple CONSTRUCT. No run-time checking.
514										CONDSTRUCT on one field. No run-time checking.
515										CONSTRUCT on field list. No run-time checking.
516										CONSTRUCT BY NAME with all attributes. No run-time checking.
517										CONSTRUCT BY NAME with HELP No run-time checking.
518										CONSTRUCT with dot-star notation No run-time checking.
519										CONSTRUCT with BEFORE CONSTRUCT. No run-time checking.
520										CONSTRUCT with AFTER CONSTRUCT. No run-time checking.
521										CONSTRUCT with BEFORE FIELD. No run-time checking.
522										CONSTRUCT with BEFORE FIELD list No run-time checking.
523										CONSTRUCT with AFTER FIELD. No run-time checking.
524										CONSTRUCT with AFTER FIELD list. No run-time checking.
525										CONSTRUCT with ON KEY. No run-time checking.
526										CONSTRUCT with flow control (NEXT FIELD,CONTINUE...). No run-time checking.
528										Simple CREATE and DROP table. No run-time checking.
530										CREATE TABLE with database.owner specified. No run-time checking.
531										CREATE TABLE with all (Informix) data types. No run-time checking.
532										CREATE TABLE with NOT NULL. No run-time checking.
533										CREATE TEMP TABLE. No run-time checking.
534										CREATE TABLE ... WITH NO LOG No run-time checking.
535										CREATE TABLE with storage information. No run-time checking.
536										CREATE TABLE with PRIMARY KEY clause. No run-time checking. NOTE: fails with -ifx-p.
537										CREATE TABLE with 2 columns and PRIMARY KEY. No run-time checking. NOTE: fails with -ifx-p.
538										CREATE TABLE with UNIQUE clause. No run-time checking.
539										CREATE TABLE with 2 columns and UNIQUE/DISTINCT clause. No run-time checking.
540										CREATE TABLE with FOREIGN key. No run-time checking. NOTE: fails with -ifx-p.
541										CREATE TABLE with two columns and FOREIGN KEY with REFERENCES clause. No run-time checking. NOTE: fails with -ifx-p.
542										CREATE TABLE with CHECK clause. No run-time checking. NOTE: fails with -ifx-p.
543										CREATE TABLE with DEFAULT clause. No run-time checking. NOTE: fails with -ifx-p.
544										CREATE TABLE with DISTINCT/UNIQUE clause. No run-time checking.
549										DATABSE statement with complex names. No run-time checking.
550										Open DATABASE with EXCLUSIVE clause. 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.
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.
563										Simple CREATE INDEX. No run-time checking.
564										CREATE INDEX on several columns. No run-time checking.
565										CREATE UNIQUE INDEX. No run-time checking.
566										CREATE CLUSTER INDEX. No run-time checking.
567										CREATE INDEX with ASC clause. No run-time checking.
568										CREATE INDEX with DESC clause. No run-time checking.
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.
573										CREATE SYNONYM with full name.
574										DROP INDEX database statement. No run-time checking.
575										DROP INDEX with full name.
576										DROP SYNONYM database statement. No run-time checking.
577										DROP SYNONYM with full name.
578										DROP TABLE database statement. No run-time checking.
579										DROP TABLE with full names.
580										DROP INDEX database statement. No run-time checking.
581										DROP INDEX with full name.
584										EXECUTE prepared database statement. No run-time checking.
585										EXECUTE with USING clause. No run-time checking.
586										EXECUTE INTO with USING clause. No run-time checking. NOTE: compiles, but Aubit library code missing.
587										FREE prepared and executed statement. No run-time checking.
588										FREE a cursor. 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.
592										CREATE VIEW database statement. No run-time checking.
593										CREATE VIEW with full names.
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.
597										LOCK TABLE with full names.
598										UNLOCK TABLE database statement. No run-time checking.
599										UNLOCK TABLE with full names.
600										DROP TRIGGER database statement. Does not compile even with -ifx-p so probably invalid.
602										DROP VIEW database statement. No run-time checking.
603										DROP VIEW with full names.
605										RENAME TABLE database statement. No run-time checking.
606										RENAME COLUMN database statement. No run-time checking.
607										RENAME COLUMN with full names.
609										CREATE VIEW ... AS SELECT 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.
613										Simple INSERT. No run-time checking.
614										INSERT without naming columns. No run-time checking.
615										INSERT INTO ... SELECT FROM database statement. No run-time checking.
616										INSERT from procedure (Informix specific) No run-time checking. SEE NOTE IN THE CODE.
618										Simple DELETE database statement. No run-time checking.
619										DELETE with WHERE clause. 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.
637										Simple UPDATE database statement. No run-time checking.
638										SET LOCK MODE TO WAIT directive. No run-time checking.
639										SET LOCK MODE TO WAIT with seconds specified. No run-time checking.
640										SET LOCK MODE TO NOT WAIT directive. No run-time checking.
642										SET ISOLATION TO DIRTY READ directive. No run-time checking. NOTE: requires transaction support.
643										SET ISOLATION TO CURSOR STABILITY directive. No run-time checking.
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.
657										REVOKE ... from user list. 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.
660										REVOKE INSERT on table. No run-time checking.
661										REVOKE DELETE on table. No run-time checking.
662										REVOKE SELECT on table. No run-time checking.
663										REVOKE UPDATE on table. No run-time checking.
664										REVOKE INDEX on table. No run-time checking.
665										REVOKE ALTER on table. 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.
669										REVOKE on table with full names.
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.
677										UPDATE on multi-table 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.
690										UPDATE ... SET one column (ANSI SQL 92 standard syntax). No run-time checking.
691										UPDATE SET columns (ANSI SQL 92 syntax). 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.
694										UPDATE SET with variable (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.
699										INSERT on multi-table 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.
703										UPDATE SET with variable (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.
710										INSERT witl fully qualified table names.
711										DELETE from view. No run-time checking.
712										DELETE on multi-table view. No run-time checking.
713										DELETE on synonym. No run-time checking.
714										DELETE with fully qualified table names.
715										Simple SELECT test.
716										SELECT several columns.
717										SELECT ALL.
718										SELECT DISTINCT
719										SELECT AS
720										SELECT with quoted strings.
721										Check if column expressions is correctly fetched.
722										SELECT with expresion. Informix SQL dialect (<).
723										Check if select with substring fecth the correct values.
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.
727										Check if a select with over two tables fetch the correct values AS ALIAS.
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
734										SELECT with complex ORDER BY.
735										Check if a named group by fetches the correct values. .
736										Check if a numbered group by fetches the correct values.
737										Check if a numbered group by fetches the correct values. Mixed GROUP BY.
738										Check if a select into temp insert the correct values and then they are correctly fetched.
739										select into temp with no log..
740										Check if a select with a join between two tables fetch the correct values.
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.
759										Check if a simple select with GREATER or equal the in where condition fetch the correct values.
760										Check if a simple select with diferent the 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.
762										Check if a simple select with AND 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.
765										Test a select from a column to a smaller variable
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.
771										Check if a select without a join between two tables fetch the correct cartesian product.
772										Check if a simple select with NOT BETWEEN in where condition fetch the correct values.
773										Check if a simple select with IS NULL in where condition using a variable 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.
778										Check if a simple select with COUNT(<) in select list fetch the correct values.
779										Check if a simple select with AVG in select list fetch the correct values..
780										Check if a simple select with MAX in select list fetch the correct values.
781										Check if a simple select with MIN in select list fetch the correct values.
782										Check if a simple select with SUM in select list 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.
788										Check if a simple select with HAVING 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.
791										Check if a ROLLBACK WORK works ok.
792										Check if the commit work statement after a transaction work
793										Check if the create audit statement works. Note that this statement only works on Informix SE
794										Check if the drop audit statement works. Note that this statement only works on Informix SE
795										Check if the RECOVER TABLE statement works Note that this statement only works on Informix SE.
796										Check if the ROLLFORWARD DATABASE statement works. Note that this statement only works on Informix SE.
798										Check if a simple select with rowid in select list fetch the correct values.
901										Test if the sqlca.sqlcode is assigned with NOTFOUND sql error.
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
907										Test if the sqlca.sqlerrd[3] is assigned with the number of rows inserted updated and deleted.
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
937										Test if the START DATABASE 4gl statement works OK. Note - This test only works with SE engine
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
1208										Simple unload test for MID 591 Note that for this test to work, in most cases, the database engine needs to have sufficient privileges to write to the test directory
1210										handling of -ve decimal numbers
1211										This checks a reports output can be set within the report
1220										Tests the SQL drivers ability to select fewer or more columns than variables
1221										Tests empty foreach loops (bug reported by James Scott)
1223										after group clauses where there is no every row
1227										MID 666
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
1236										Test for MID 677 - construct it is not allowing criteria mark as noentry in a form
1241										Keyword 'user' test
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
1252										Yes another report test , mid 721 (varchars)
1253										Tests a bug using consecutive constructs not blanking the field properly
1256										LOAD FROM from test. Uses FILESCHEMA as database type when compiling
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)
1258										This tests the summation of nulls within a report
1262										Checks sqlerrd[3] is set after a LOAD
1263										Test sqlerrd[3] is set after a fetch
1264										Another test for sqlerrd[3] not being set for a fetch
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
1300										CREATE TABLE with PRIMARY KEY clause. No run-time checking. NOTE: fails with -ifx-p.
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
1408										DECLARE CURSOR and FOREACH ... INTO
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
1414										Select smallint into char
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
1419										Tests running a report several times
1420										report linenumber test
1421										Another report test
1600										Do some ordering, before/after group with null values. Mantis bug 902.
1609										Load of text file without END OF LINE (EOL) fails, mantis bug 912.
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