[teiid-issues] [JBoss JIRA] Commented: (TEIID-715) Allow the user to set null ordering behavior
[
https://jira.jboss.org/jira/browse/TEIID-715?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIID-715:
--------------------------------------
Added logic to the JDBC connector to use SQL 2003 nulls first/nulls last as appropriate in
6.2 - this will ensure consistency with our results from Oracle, DB2, and newer version of
Derby, PostgreSQL. For 6.3 we should add null order specification as a proper language
feature/capability. If that were done, then adding a specific server default setting may
not be necessary.
Allow the user to set null ordering behavior
--------------------------------------------
Key: TEIID-715
URL: https://jira.jboss.org/jira/browse/TEIID-715
Project: Teiid
Issue Type: Feature Request
Components: Connector API, Query Engine
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 6.3.0
Sources that support order by may have different null ordering behavior than Teiid (which
currently treats null as low). We should support the option for the server to be
configured as nulls high, low, always high, or always low.
Connectors will need to indicate the sort mode they support so the appropriate push-down
and compensating actions can be taken.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira