[
https://issues.apache.org/jira/browse/FLINK-21613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17308276#comment-17308276
]
jibiyr commented on FLINK-21613:
--------------------------------
[~twalthr] I seek advice from the calcite community, here is the discussion
link [CALCITE-4548|https://issues.apache.org/jira/browse/CALCITE-4548]
> 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: Major
>
> 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.3.4#803005)
