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)