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

["Zhen Chen (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-5174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zhen Chen closed CALCITE-5174.
------------------------------
    Resolution: Fixed

> 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
>          Components: core
>    Affects Versions: 1.30.0
>            Reporter: Vladimir Ozerov
>            Priority: Major
>
> 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.10#820010)