[CALCITE-4846] IN-list that includes NULL converted to Values throws exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.27.0
• Fix Version/s: 1.29.0
• Labels: pull-request-available
• Assignee: xiong duan
• Reporter: xiong duan
• Created: 11/Oct/21 01:28
• Updated: 04/Jan/22 08:27
• Resolved: 04/Jan/22 08:27

Description

Run this SQL in JdbcExample :

select * from foodmart.sales_fact_1997 as s where s.cust_id not in (null, 100) 

will throw an exception:

Caused by: org.apache.calcite.runtime.CalciteException: Cannot convert null to int

Because when convert ROW values generate the wrong RelDataType:

type=RecordType(JavaType(int) ROW_VALUE),tuples=[{ null }, { 100 }])

should be(nullable):

type=RecordType(INTEGER ROW_VALUE),tuples=[{ null }, { 100 }])

Issue Links

• links to: GitHub Pull Request #2607