[teiid-issues] [JBoss JIRA] (TEIID-3660) Add support for unnesting anti semijoins
[
https://issues.jboss.org/browse/TEIID-3660?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-3660:
----------------------------------
Fix Version/s: 12.x
(was: 11.x)
Add support for unnesting anti semijoins
----------------------------------------
Key: TEIID-3660
URL: https://issues.jboss.org/browse/TEIID-3660
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Priority: Major
Fix For: 12.x
Currently we won't perform the rewrite if it's the anti case. A subquery used as
an anti semijoin can be unnested into a left outer join with a filter on the null rows.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)