[ https://issues.apache.org/jira/browse/FLINK-14361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Flink Jira Bot updated FLINK-14361: ----------------------------------- Labels: stale-assigned (was: ) > 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 > Assignee: godfrey he > Priority: Major > Labels: stale-assigned > > 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)