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)
