Claude Brisson created CALCITE-6144:
---------------------------------------
Summary: JoinInfo is not aware of the IS NOT DISTINCT FROM operator
Key: CALCITE-6144
URL: https://issues.apache.org/jira/browse/CALCITE-6144
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.35.0
Reporter: Claude Brisson
A join equi-condition can use either EQUALS or IS NOT DISTINCT FROM operator to
compare key columns.
The JoinInfo class looses this information, and the method
JoinInfo.getEquiCondition() always generate a conjunction of equalities, which
is erroneous if some of the conditions were initially using IS NOT DISTINCT
FROM.
The JoinInfo class would need to store a vector of booleans (indicating the
nulls comparison mode for each key pair) to be able to re-generate the full
equi-condition.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
