CALCITE-3783 fixed PruneEmptyRules#JOIN_RIGHT_INSTANCE for join type ANTI:
Join(Scan(Emp), Empty, ANTI) becomes Scan(Emp)
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).
- is related to
-
CALCITE-3783 PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for JoinRelType.ANTI
-
- Closed
-
- links to