[CALCITE-1055] SubQueryRemoveRule should create Correlate, not Join, for correlated sub-queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.6.0
• Assignee: Wei Xue
• Reporter: Wei Xue
• Created: 13/Jan/16 20:27
• Updated: 21/Jan/16 22:20
• Resolved: 14/Jan/16 23:24

Description

In some cases of FILTER 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,

select order_id, quantity from orders o
where quantity = (
    select max(quantity) from orders o2
    where o.item_id = o2.item_id)

Does the same apply to PROJECT and JOIN subqueries, julianhyde ?

Issue Links

• blocks: PHOENIX-2595 Upgrade Calcite-Phoenix to Calcite 1.6
• is broken by: CALCITE-816 Represent sub-query as a RexNode