[CALCITE-6485] AssertionError When an IN list containing NULL has an implicit coercion type converter

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.38.0
• Labels: pull-request-available
• Assignee: xiong duan
• Reporter: xiong duan
• Created: 19/Jul/24 11:22
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

  @Test void testInOperation() {
    sql("select 1 in (null, '2', '3') as f0 from (values (true, true, true))").ok();
  }

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 }]]) 

Issue Links

• links to: GitHub Pull Request #3873