Johnathon Lee created TEIID-2058: ------------------------------------ Summary: Optimization places WHERE clause incorrectly when criteria not supplied for tables with joins Key: TEIID-2058 URL: https://issues.jboss.org/browse/TEIID-2058 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7 Reporter: Johnathon Lee Assignee: Steven Hawkins Reproducible behavior with the following simplified query [1] Avoiding the error by including non-restricting criteria on tables not represented in the WHERE EXISTS clause [2]. ie: there seems to be a problem in the Optimization that writing the query similar to [2] will avoid. [1] SELECT 'X' as CMR_BPR_ID2 FROM Y93 INNER JOIN AG5 ON 1 = 1 LEFT OUTER JOIN MFSMFL.I58 as I58 ON 1 = 1 WHERE EXISTS (SELECT 'Y' FROM BH0 WHERE AG5.CONSENT_CLIENT_ID = 1 AND Y93.CMR_BPR_ID2 = 1 ) [2] SELECT 'X' as CMR_BPR_ID2 FROM Y93 INNER JOIN AG5 ON 1 = 1 LEFT OUTER JOIN MFSMFL.I58 as I58 ON 1 = 1 WHERE EXISTS (SELECT 'Y' FROM BH0 WHERE AG5.CONSENT_CLIENT_ID = 1 AND Y93.CMR_BPR_ID2 = 1 AND I58.FUND_CODE like '%') -- 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