]
Steven Hawkins resolved TEIID-5707.
-----------------------------------
Fix Version/s: 11.2.3
12.1.1
Resolution: Done
The correlated reference visitor was not considering the case of having a subquery without
a from clause correctly.
Must pushdown correlated subquery without from fails
----------------------------------------------------
Key: TEIID-5707
URL:
https://issues.jboss.org/browse/TEIID-5707
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Major
Fix For: 12.2, 11.2.3, 12.1.1
A query such as:
select (select func(e1)) from g1
where func is a must pushdown function will fail due to not finding the correlated value
e1. This happens regardless of whether func is from the same source as g1 - because
currently the plan will be the same either way (we don't yet see a way to associate
the subplan with the g1 source).