[ https://issues.apache.org/jira/browse/CALCITE-6485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-6485: ------------------------------------ Labels: pull-request-available (was: ) > AssertionError When an IN list containing NULL has an implicit coercion type > converter > -------------------------------------------------------------------------------------- > > Key: CALCITE-6485 > URL: https://issues.apache.org/jira/browse/CALCITE-6485 > Project: Calcite > Issue Type: Improvement > Reporter: xiong duan > Assignee: xiong duan > Priority: Major > Labels: pull-request-available > > {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)