1) We dont have NEW JDBC DRIVER 4.10 for informix.
Currently in ADS, for Informix we have "com.informix.jdbc.IfxDrivers 3.0"
2) SQL compatibility: Below features are tested and it works fine.
LIMIT clause
COMPRESSED option for indexes
COMPRESSED option for tables
3) CASE expressions in the ORDER BY clause of SELECT statements does not works and Issue has been filed already while testing QB.
4) How to check "Support for JSON in databases" ?
1) We dont have NEW JDBC DRIVER 4.10 for informix.
Currently in ADS, for Informix we have "com.informix.jdbc.IfxDrivers 3.0"
2) SQL compatibility: Below features are tested and it works fine.
LIMIT clause
COMPRESSED option for indexes
COMPRESSED option for tables
3) CASE expressions in the ORDER BY clause of SELECT statements does not works and Issue has been filed already while testing QB.
4) How to check "Support for JSON in databases" ?
Json, LIMIT clause, COMPRESSED option for indexes,COMPRESSED option for tables works propely.
Verified in : Aqua Data Studio 16.0.0-dev-46
For "Informix JDBC version" and "CASE expressions in the ORDER BY clause of SELECT statements" bug has been filed.
Json, LIMIT clause, COMPRESSED option for indexes,COMPRESSED option for tables works propely.
Verified in : Aqua Data Studio 16.0.0-dev-46
For "Informix JDBC version" and "CASE expressions in the ORDER BY clause of SELECT statements" bug has been filed.
Issue #12467 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v15.0.0-beta-37 |
| No time estimate |
1 issue link |
relates to #12616
Issue #12616INFORMIX 12.1 : Add new datatypes BSON, JSON in create table GUI and ER Modeler |
Support added. ERM support not added yet as there is a problem with ERM and informix. I filled the issue separate #12474