Hello,
For us and certainly for others, it's strategic that Informix CSDK 4.50 still works with an Informix 15 server (in SMALL tables mode).
(Confirmed by John Lengyel in Informix 15 server / CSDK compatibility matrix | Informix)
I have already reported this issue in the other thread about V15 release, but wanted to make sure that it comes to the eyes of HCL people:
Using dbaccess of a CSDK 4.50 environment, as well as an ESQL/C program compiler with CSDK 4.50.
When a BOOLEAN column precedes a TEXT or BYTE column, we get an error when fetching rows:
$ esql -V
HCL Informix CSDK Version 4.50, HCL Informix-ESQL Version 4.50.FC11W1
$ type dbaccess
dbaccess is hashed (/opt3/dbs/ifx/HCL-CSDK-4.50.FC11W1/bin/dbaccess)
$ cat xx.sql
-- When using a BOOLEAN column before TEXT
-- => Error 408: Invalid message type received from the sqlexec process.
CREATE TEMP TABLE tt1( pkey INTEGER NOT NULL PRIMARY KEY, cbl BOOLEAN, ctx TEXT);
INSERT INTO tt1 VALUES ( 101, 't', NULL );
SELECT * FROM tt1;
-- When using a CHAR(1) instead of BOOLEAN for second column, no issue.
-- CREATE TEMP TABLE tt1( pkey INTEGER NOT NULL PRIMARY KEY, cbl CHAR(1), ctx TEXT);
$ dbaccess test1 xx.sql
Database selected.
Temporary table created.
1 row(s) inserted.
408: Invalid message type received from the sqlexec process.
Error in line 6
Near character position 1
Thanks for considering this.
A bug ID is welcome.
Seb
------------------------------
Sebastien FLAESCH
------------------------------