[
https://issues.apache.org/jira/browse/FLINK-27795?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shengkai Fang updated FLINK-27795:
----------------------------------
Issue Type: New Feature (was: Bug)
> SqlValidatorException when insert null value
> --------------------------------------------
>
> Key: FLINK-27795
> URL: https://issues.apache.org/jira/browse/FLINK-27795
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API
> Affects Versions: 1.14.4
> Reporter: linqichen
> Priority: Major
>
> Hello , I found a problem， when i try to insert null value.
> i think it is very common to insert null to string type value. We should
> solve this instead of using cast (xx as string)
> -----------------------------------------------------------------
> Flink SQL> create table print_1(
> > name string
> > ) with(
> > 'connector'='print'
> > );
> [INFO] Execute statement succeed.
> Flink SQL> insert into print_1 (name) values (null);
> {color:#de350b}*[ERROR] Could not execute SQL statement. Reason:*{color}
> {color:#de350b}*org.apache.calcite.sql.validate.SqlValidatorException:
> Illegal use of 'NULL'*{color}
>
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
