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

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2017/06/29 19:06:00 UTC

[jira] [Created] (CALCITE-1864) Allow NULL as argument

Julian Hyde created CALCITE-1864:
------------------------------------

             Summary: Allow NULL as argument
                 Key: CALCITE-1864
                 URL: https://issues.apache.org/jira/browse/CALCITE-1864
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


Even though the SQL standard does not allow raw (non-casted) NULL literals, most databases do. So we should allow {{1 = null}} or {{select * from emp where empno > null}}. Of course, these expressions always return UNKNOWN.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)