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

["Shuo Cheng (Jira)" <ji...@apache.org>]

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)