Maryann Xue created CALCITE-1055:
------------------------------------
Summary: Correlate rel instead of Join rel should be created for
correlated subqueries before decorrelation
Key: CALCITE-1055
URL: https://issues.apache.org/jira/browse/CALCITE-1055
Project: Calcite
Issue Type: Bug
Reporter: Maryann Xue
Assignee: Maryann Xue
Fix For: 1.6.0
In some cases of where correlated subqueries, the "variablesSet" didn't get
passed down to RelBuilder.join() and thus a Join rel was created while it
should have been a Correlate rel.
For example,
{code}
select order_id, quantity from orders o
where quantity = (
select max(quantity) from orders o2
where o.item_id = o2.item_id)
{code}
Does the same apply to PROJECT and JOIN subqueries, [~julianhyde]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
