[ 
https://issues.apache.org/jira/browse/FLINK-15321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

xiaojin.wy updated FLINK-15321:
-------------------------------
    Description: 
The sql is :
SELECT concat('a', cast(null as varchar), 'c');

The result of the sql is NULL after you execute it in a sqlClient 
environment;But actually the result should be 'ac'.

The config is:
execution:
  planner: blink
  type: batch

  was:
The sql is :
SELECT concat('a', cast(null as varchar), 'c');

The result of the sql is NULL after you execute it in a sqlClient 
environment;But actually the result should be 'ac'.


> The result of sql(SELECT concat('a', cast(null as varchar), 'c');) is NULL;
> ---------------------------------------------------------------------------
>
>                 Key: FLINK-15321
>                 URL: https://issues.apache.org/jira/browse/FLINK-15321
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Client
>    Affects Versions: 1.10.0
>            Reporter: xiaojin.wy
>            Priority: Major
>
> The sql is :
> SELECT concat('a', cast(null as varchar), 'c');
> The result of the sql is NULL after you execute it in a sqlClient 
> environment;But actually the result should be 'ac'.
> The config is:
> execution:
>   planner: blink
>   type: batch



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to