[jira] [Created] (CALCITE-5174) EnumerableHashJoin filter out NULL values for "IS NOT DISTINCT FROM"

["Vladimir Ozerov (Jira)" <ji...@apache.org>]

Vladimir Ozerov created CALCITE-5174:
----------------------------------------

             Summary: EnumerableHashJoin filter out NULL values for "IS NOT DISTINCT FROM"
                 Key: CALCITE-5174
                 URL: https://issues.apache.org/jira/browse/CALCITE-5174
             Project: Calcite
          Issue Type: Improvement
            Reporter: Vladimir Ozerov


The {{Join}} operator constructs the join info from the condition using {{JoinInfo.of}}. This method collects information whether {{NULL}} values should be filtered for the given pair of left/right key. However, this information is not exposed from the {{Join}} operator and also not used by the {{EnumerableHashJoin]}, yielding incorrect results for queries like {{ON a IS NOT DISTINCT FROM b}}. 

The problem is pretty important, because the {{IS NOT DISTINCT FROM}} may silently appear in the realtional tree due to various simplifications and optimizations.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)