[jira] [Created] (FLINK-14361) Decorrelate subQuery fail when multi correlate in project

[Shang Yuanchun (Jira)]

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)