[teiid-issues] [JBoss JIRA] Resolved: (TEIID-183) user "or" and "in" criteria should generate multiple queries in some situations

[ https://jira.jboss.org/jira/browse/TEIID-183?page=com.atlassian.jira.plug... ] Steven Hawkins resolved TEIID-183. ---------------------------------- Resolution: Deferred both the xml connector and proc relational now support in. The only scenario that is not covered is the use of or - which for multiple parameter values should just be written as an in. In general there's a case to be made to support a or b as a and not(b) union all b and not(a) union all a and b OR for distinct results as a union b. This query expansion should only be done when both a and b are both separately supported for pushdown and result in significantly less rows being returned than the query without criteria. Marking as deferred until a compelling use case comes up for this scenario. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira