You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "Jingsong Lee (Jira)" <ji...@apache.org> on 2019/10/10 06:56:00 UTC

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

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)