[teiid-issues] [JBoss JIRA] (TEIID-5360) DatabaseMetaData nullsAreSortedLow should not be true

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5360.
-----------------------------------
    Resolution: Done


Resolved with a connection property rather than driving from the server side - since we aren't guaranteeing the sort behavior regardless.  The connection property allows the user to choose whatever is appropriate, especially for mostly pass through scenarios.

Another consideration would be to allow some vdb property so this doesn't need set on the client side - but that didn't seem necessary at this time and would potentially add more confusion with the existing system properties.

> DatabaseMetaData nullsAreSortedLow should not be true
> -----------------------------------------------------
>
>                 Key: TEIID-5360
>                 URL: https://issues.jboss.org/browse/TEIID-5360
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: JDBC Driver
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 11.0
>
>
> Since there isn't a hard guarantee of null sorts (without an explicit null sort) we should not indicate nulls are low in the DatabaseMetaData.  This will leave all of the null sort methods as false, which may be an issue for some clients so a flag should be added to control this behavior.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)