If we checkout the java doc for Calcite EuqiJoin, there is definition for it: > for any join whose condition is based on column equality
But what about if there are function calls in the equi condition operands ? For example: Should we consider Select A.a, B.b from A join B on cast(A.a as int) = B.b as an equi join ? Now Calcite think it is not, which I think will lost some possibilities for sql plan promotion, e.g. join condition push down. Best, Danny Chan
