[ 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. -- 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

[ https://jira.jboss.org/browse/TEIID-715?page=com.atlassian.jira.plugin.sy... ] Steve Hawkins updated TEIID-715: -------------------------------- Summary: Add support for nulls first/last (was: Allow the user to set null ordering behavior) Description: Add language and pushdown support for nulls first/last (was: 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.) Changing issue to be specifically about nulls first/last. At a later time it may be worthwhile to allow the engine default sorting behavior to be set. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/browse/TEIID-715?page=com.atlassian.jira.plugin.sy... ] Steve Hawkins closed TEIID-715. ------------------------------- -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira