[jira] [Created] (CALCITE-4756) When subquery include NULL value, Calcite should return the right result

["duan xiong (Jira)" <ji...@apache.org>]

duan xiong created CALCITE-4756:
-----------------------------------

             Summary: When subquery include NULL value, Calcite should return the right result
                 Key: CALCITE-4756
                 URL: https://issues.apache.org/jira/browse/CALCITE-4756
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.27.0
            Reporter: duan xiong
            Assignee: duan xiong


When I try to design some unit tests for CALCITE-4742. I found Calcite can't handle NULL very well in some subquery. For example:
{code:java}
select 1 in (null,1);
select 1 <> some(null);{code}
This SQL should return NULL、UNKNOWN、TRUE、FALSE. But throw NPE.



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