]
RH Bugzilla Integration commented on TEIID-2936:
------------------------------------------------
Alex Szczuczko <aszczucz(a)redhat.com> changed the Status of [bug
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
Components: Query Engine
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.