[ https://issues.apache.org/jira/browse/CALCITE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937229#comment-17937229 ]
Julian Hyde commented on CALCITE-6904: -------------------------------------- Please be sure to use UPPER CASE for SQL keywords in the summary. Otherwise the sentence is difficult to humans to parse. > Is not distinct from conversion error in ElementerableJoinRule > -------------------------------------------------------------- > > Key: CALCITE-6904 > URL: https://issues.apache.org/jira/browse/CALCITE-6904 > Project: Calcite > Issue Type: Bug > Reporter: Zhen Chen > Priority: Major > > The convert method of ElementerableJoinRule incorrectly converts the > condition of `is not distinct from`, which is considered an equivalence > condition in calcite and carries a `filterNulls` to save whether to perform > equivalence processing on null. However, when converting to > ElementerableJoin, the filterNulls are ignored, resulting in > `is_not_distinct_from ($0, $1)` being converted to `=($0, $1)`. -- This message was sent by Atlassian Jira (v8.20.10#820010)