[CALCITE-6475] RelToSql converter fails when the IN-list contains NULL and it is converted to VALUES

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

Description

The SQL

select * from "product" where ("product_id") in (12, null)

When we convert the IN-list to OR condition, it can run successfully. But when we convert it to VALUES, it will throw NPE:

java.lang.NullPointerException
    at org.apache.calcite.rel.rel2sql.SqlImplementor.toSql(SqlImplementor.java:1468)
    at org.apache.calcite.rel.rel2sql.SqlImplementor.toSql(SqlImplementor.java:1416)
    at org.apache.calcite.rel.rel2sql.SqlImplementor$Context.toSql(SqlImplementor.java:702)
    at org.apache.calcite.rel.rel2sql.RelToSqlConverter.lambda$exprList$17(RelToSqlConverter.java:1158)

Issue Links

• links to: GitHub Pull Request #3866