[jira] [Updated] (FLINK-15321) The result of sql(SELECT concat('a', cast(null as varchar), 'c');) is NULL;

2019-12-18 Thread Jark Wu (Jira)


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

Jark Wu updated FLINK-15321:

Fix Version/s: 1.10.0

> 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
> Fix For: 1.10.0
>
>
> 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)


[jira] [Updated] (FLINK-15321) The result of sql(SELECT concat('a', cast(null as varchar), 'c');) is NULL;

2019-12-18 Thread xiaojin.wy (Jira)


 [ 
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)