[teiid-issues] [JBoss JIRA] Commented: (TEIID-715) Allow the user to set null ordering behavior

Thu Aug 6 12:39:29 EDT 2009

    [ https://jira.jboss.org/jira/browse/TEIID-715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12479296#action_12479296 ] 

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