Benchao Li created CALCITE-5073: ----------------------------------- Summary: JoinConditionPushRule cannot infer 'LHS.C1 = LHS.C2' from 'LHS.C1 = RHS.C1 AND LHS.C2 = RHS.C1' Key: CALCITE-5073 URL: https://issues.apache.org/jira/browse/CALCITE-5073 Project: Calcite Issue Type: Improvement Components: core Affects Versions: 1.30.0 Reporter: Benchao Li Assignee: Benchao Li Fix For: 1.31.0
For the below SQL: {code:java} SELECT * FROM T1, T2, T3 WHERE T1.id = T3.id AND T2.id = T3.id{code} Currently, JoinConditionPushRule cannot infer the condition 'T1.id = T2.id' for the first join relation. -- This message was sent by Atlassian Jira (v8.20.1#820001)