Ruben Q L created CALCITE-3837: ---------------------------------- Summary: AntiJoin with empty right input can always be transformed as its left input Key: CALCITE-3837 URL: https://issues.apache.org/jira/browse/CALCITE-3837 Project: Calcite Issue Type: Improvement Components: core Affects Versions: 1.22.0 Reporter: Ruben Q L Assignee: Ruben Q L
CALCITE-3783 fixed {{PruneEmptyRules#JOIN_RIGHT_INSTANCE}} for join type ANTI: {code} Join(Scan(Emp), Empty, ANTI) becomes Scan(Emp) {code} However, it performs this transformation only in case of anti equi-join (in case of non-equi, no transformation is made). Re-considering this, I believe this is a mistake, and the transformation can always be performed, independently of the join condition (equi / non-equi, it does not matter). -- This message was sent by Atlassian Jira (v8.3.4#803005)