× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2014-08-25T22:09:35Z  · tariqrahiman last modified 2014-12-04T00:42:47Z

INFORMIX 12.1 new feature support


Priority Low
Complexity Unknown
Component App - General
Version 16.0
support new features: 
 
NEW JDBC DRIVER 4.10
 
Support for JSON in databases
 
SQL compatibility: LIMIT clause allowed after the Projection clause
You can include the new LIMIT clause after the optional ORDER BY clause in a SELECT statement. Use the LIMIT clause to specify the maximum number of rows the query can return. The LIMIT clause has the same effect as the LIMIT option, except that the LIMIT option must be included in the Projection clause of the SELECT statement.
 
COMPRESSED option for indexes
COMPRESSED option for tables
 
--Below changes may impact our QB as I don't think we allow for expressions in the ORDER BY clause
CASE expressions in the ORDER BY clause of SELECT statements
The ORDER BY clause now can include a CASE expression immediately following the ORDER BY keywords. This expression allows sorting key specifications for query result sets to be based on evaluating multiple logical conditions.

Issue #12467

Closed
Fixed
Resolved 2014-08-27T22:11:50Z
 
 
Completion
No due date
Fixed Build v15.0.0-beta-37
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017