[ https://issues.apache.org/jira/browse/FLINK-14361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Flink Jira Bot updated FLINK-14361: ----------------------------------- Labels: auto-deprioritized-major auto-unassigned (was: auto-unassigned stale-major) Priority: Minor (was: Major) This issue was labeled "stale-major" 7 ago and has not received any updates so it is being deprioritized. If this ticket is actually Major, please raise the priority and ask a committer to assign you the issue or revive the public discussion. > 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 > Priority: Minor > Labels: auto-deprioritized-major, auto-unassigned > > 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)