[FLINK-14361] Decorrelate subQuery fail when multi correlate in project

• Type: Bug
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Table SQL / Planner
• Labels: auto-deprioritized-major auto-deprioritized-minor auto-unassigned
• Assignee: Unassigned
• Reporter: Jingsong Lee
• Created: 10/Oct/19 06:55
• Updated: 20/Dec/21 10:39

Description

Blink planner run SQL:

SELECT (SELECT SUM(l.c) FROM l WHERE l.a = r.a and l.b = r.b) from r)

Will throw exception: unexpected correlate variable $cor

But:

SELECT (SELECT SUM(l.c) FROM l WHERE l.a = r.a) from r)

Single correlate in project can work.