[FLINK-27795] SqlValidatorException when insert null value

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.14.4
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: linqichen
• Created: 26/May/22 04:00
• Updated: 16/Jun/23 06:48
• Resolved: 16/Jun/23 06:48

Description

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);
[ERROR] Could not execute SQL statement. Reason:
org.apache.calcite.sql.validate.SqlValidatorException: Illegal use of 'NULL'

 

Issue Links

• duplicates: FLINK-17484 [FLIP-154] Enable type coercion