[teiid-issues] [JBoss JIRA] (TEIID-1966) supportsInCriteria is ignored
[
https://issues.jboss.org/browse/TEIID-1966?page=com.atlassian.jira.plugin...
]
Michal Navrkal commented on TEIID-1966:
---------------------------------------
Hi Steven,
we are running multiple source model which could be the reason why you are not able to
reproduce.
Anyway when I issue the first query mentioned in issue description (or any other user
connected to VDB containing that multiple source model), the translator associated with
that multiple source model gets the second query mentioned in issue description. Teiid
change the OR predicates to IN predicate even when the translator doesn't support IN
predicate and is telling this fact to TEIID in supportsInCriteria method of
EWSExecutionFactory.
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
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