[jira] [Created] (CALCITE-6485) IN-list contains NULL throws Exception

[xiong duan (Jira)]

xiong duan created CALCITE-6485:
-----------------------------------

             Summary: IN-list contains NULL throws Exception
                 Key: CALCITE-6485
                 URL: https://issues.apache.org/jira/browse/CALCITE-6485
             Project: Calcite
          Issue Type: Improvement
            Reporter: xiong duan


{code:java}
  @Test void testInOperation() {
    sql("select 1 in (null, '2', '3') as f0 from (values (true, true, 
true))").ok();
  }
{code}
{code:java}
Conversion to relational algebra failed to preserve datatypes:
validated type:
RecordType(BOOLEAN NOT NULL F0) NOT NULL
converted type:
RecordType(BOOLEAN F0) NOT NULL
rel:
LogicalValues(tuples=[[{ null }]]) {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)