[ https://issues.apache.org/jira/browse/FLINK-14361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Leonard Xu updated FLINK-14361: ------------------------------- Fix Version/s: (was: 1.12.0) 1.13.0 > 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 > Fix For: 1.13.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)