Jingsong Lee created FLINK-14361:
------------------------------------
Summary: Decorrelate subQuery fail when multi correlate in project
Key: FLINK-14361
URL: https://issues.apache.org/jira/browse/FLINK-14361
Project: Flink
Issue Type: Bug
Components: Table SQL / Planner
Reporter: Jingsong Lee
Fix For: 1.10.0
Blink planner run SQL:
{code:java}
SELECT (SELECT SUM(l.c) FROM l WHERE l.a = r.a and l.b = r.b) from r)
{code}
Will throw exception: unexpected correlate variable $cor
But:
{code:java}
SELECT (SELECT SUM(l.c) FROM l WHERE l.a = r.a) from r){code}
Single correlate in project can work.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
