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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.27.0
• Component/s: core
• Labels: pull-request-available
• Assignee: xiong duan
• Reporter: xiong duan
• Created: 27/Aug/21 11:08
• Updated: 13/Sep/21 08:39

Description

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: 

select 1 in (values(null),(null))
ERROR:
    java.lang.AssertionError: Conversion to relational algebra failed to preserve datatypes:
    validated type:
    RecordType(BOOLEAN NOT NULL EXPR$0) NOT NULL
    converted type:
    RecordType(BOOLEAN EXPR$0) NOT NULL
    rel:
    LogicalProject(EXPR$0=[IN(1, {
    LogicalValues(tuples=[[{ null }]])
    })])
      LogicalValues(tuples=[[{ 0 }]])
select 1 > some(values(null),(null))
ERROR:
    Suppressed: java.lang.RuntimeException: while resolving method 'voidValue' in class class java.lang.Void

This SQL should return NULL. But throw the runtime exception.

Issue Links

• Blocked: CALCITE-4758 When SOME sub-query is SqlNodeList, Calcite returns wrong result
• Blocked: CALCITE-4742 Implement "<> SOME" sub-query
• links to: GitHub Pull Request #2508