You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Jay Narale (Jira)" <ji...@apache.org> on 2021/11/04 02:24:00 UTC

[jira] [Commented] (CALCITE-4875) NVL Function Incorrectly changes nullability field of its operands

    [ https://issues.apache.org/jira/browse/CALCITE-4875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17438457#comment-17438457 ] 

Jay Narale commented on CALCITE-4875:
-------------------------------------

PR at [https://github.com/apache/calcite/pull/2598|https://github.com/apache/calcite/pull/2598]

> NVL Function Incorrectly changes nullability field of its operands
> ------------------------------------------------------------------
>
>                 Key: CALCITE-4875
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4875
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Jay Narale
>            Priority: Major
>
> We rewrite the NVL function in _org/apache/calcite/sql2rel/StandardConvertletTable.java:303_  , during the rewrite we currently override the operands' nullability to be NOT NULL which is not needed. This causes issues if that operand is pushdown , since the input of that operand need not be not nullable whereas we forced that operand to be Not nullable
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)