[jira] [Updated] (FLINK-21613) Parse Compute Column with `IN` expression throws NPE

["Yun Gao (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-21613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yun Gao updated FLINK-21613:
----------------------------
    Fix Version/s: 1.16.0

> Parse Compute Column with `IN` expression throws NPE
> ----------------------------------------------------
>
>                 Key: FLINK-21613
>                 URL: https://issues.apache.org/jira/browse/FLINK-21613
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / API
>    Affects Versions: 1.13.0
>            Reporter: Shuo Cheng
>            Priority: Minor
>              Labels: auto-deprioritized-major, auto-unassigned
>             Fix For: 1.15.0, 1.16.0
>
>
> Considering the following given sql:
> {code:sql}
> CREATE TABLE MyInputFormatTable (
>   `a` INT,
>   `b` BIGINT,
>   `c` STRING,
>   `d` as `c` IN ('Hi', 'Hello')
> ) WITH (
>   'connector' = 'values',
>   'data-id' = '$dataId',
>   'runtime-source' = 'InputFormat'
> )
> {code}
> NPE will be thrown during parsing the sql: 
> `select * from MyInputFormatTable`
> It seems it's the commit "[hotfix][table-planner-blink] Simplify SQL expression to RexNode conversion" which introduces this problem. This hotfix uses a method `SqlToRelConverter#convertExpression` and this method does not has any tests and is not used in Calcite anywhere, which is unsafe. Maybe reverting the hotfix is a good choice.
> CC [~twalthr]



--
This message was sent by Atlassian Jira
(v8.20.1#820001)