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.