[teiid-issues] [JBoss JIRA] (TEIID-2936) Combining multiple 'in' criteria can prevent pushing criteria to database

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-2936.
-----------------------------------

    Fix Version/s: 8.8
       Resolution: Done


Allowing the optimizer to push and then split large in's (into multiple predicates, not queries) by also considering the max dependent sets.  However in some circumstances this may lead to source queries with too many bind values.  We'll address that scenario later if needed with more bookkeeping.
                
> Combining multiple 'in' criteria can prevent pushing criteria to database
> -------------------------------------------------------------------------
>
>                 Key: TEIID-2936
>                 URL: https://issues.jboss.org/browse/TEIID-2936
>             Project: Teiid
>          Issue Type: Feature Request
>    Affects Versions: 8.7
>            Reporter: Mike Higgins
>            Assignee: Steven Hawkins
>             Fix For: 8.8
>
>
> When two 'in' criteria containing constant values on the same field are combined with an 'or', Teiid will combine the two into a single 'in' operation.
> Since Oracle (for example)  has a 1000 item limit on the 'in' values, if the resulting combined list contains more than 1000 values, it can no longer be pushed down into Oracle for execution.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira