]
Steven Hawkins resolved TEIID-3659.
-----------------------------------
Resolution: Done
Added logic specific to exists so that we don't consider the original select columns.
subquery unnesting missed
-------------------------
Key: TEIID-3659
URL:
https://issues.jboss.org/browse/TEIID-3659
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.12
A query such as:
select b.SYMBOL from PRODUCT b where exists (select 1 from PRICES d where
d.SYMBOL=b.SYMBOL)
where there is no key between the symbol columns will not unnested when it should be
eligible.