[teiid-issues] [JBoss JIRA] (TEIID-1966) supportsInCriteria is ignored

[Steven Hawkins (JIRA)]

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

Steven Hawkins closed TEIID-1966.
---------------------------------


    
> supportsInCriteria is ignored
> -----------------------------
>
>                 Key: TEIID-1966
>                 URL: https://issues.jboss.org/browse/TEIID-1966
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 7.7.1
>         Environment: Win7
>            Reporter: Michal Navrkal
>            Assignee: Steven Hawkins
>             Fix For: 7.7.1, 8.0
>
>
> SQL query whose WHERE clause contains ORed conditions is sent down to custom translator as IN clause even when the custom translator doesn' support IN clause.
> public class EWSExecutionFactory extends
> ExecutionFactory<ConnectionFactory, EWSConnection> {
> ...
> @Override
>     public boolean supportsInCriteria()
>     {
>         return false;
>     }
>     @Override
>     public boolean supportsInCriteriaSubquery()
>     {
>         return false;
>     }
> }
> SELECT COUNT(*) FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA = '2D03' OR Storage.MVDETAIL.CUA = '2D07'
> is translated to 
> SELECT COUNT(*) FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA IN ('2D03', '2D07')

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira