Shuo Cheng created FLINK-21613:
----------------------------------
Summary: Parse Compute Column with `IN` expression throws NPE
Key: FLINK-21613
URL: https://issues.apache.org/jira/browse/FLINK-21613
Project: Flink
Issue Type: New Feature
Components: Table SQL / API
Affects Versions: 1.13.0
Reporter: Shuo Cheng
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)
