[teiid-issues] [JBoss JIRA] (TEIID-3156) Provide a mechanism to turn off string sorting

[Steven Hawkins (JIRA)]

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

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


Added the translator property collationLocale which if different than the system property org.teiid.collationLocale will inhibit the pushdown of order by string values for join processing and with the system property org.teiid.requireTeiidCollation set will inhibit any pushdown of a string ordering where the locales do not match.

> Provide a mechanism to turn off string sorting
> ----------------------------------------------
>
>                 Key: TEIID-3156
>                 URL: https://issues.jboss.org/browse/TEIID-3156
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.9
>
>
> Currently we don't have a fine grained mechanism to turn off source sorting of specifically string data.  If a source is using a different collation for example and cannot be set on a session basis (that could be configured on the datasource) to an ansi/utf collation, then at least for join scenarios we have to process the sort in the engine.  Optionally the user may wan the Teiid default collation enforced even for other sorts.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)