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

2019-12-18 Thread hehuiyuan (Jira) 


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

hehuiyuan edited comment on FLINK-15321 at 12/19/19 3:58 AM:
-

You can try 

{{CONCAT_WS()}}


was (Author: hehuiyuan):
You can try 

{{CONCAT_WS(string1, string2, string3,...)}}

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

[jira] [Comment Edited] (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:comment-tabpanel=16999718#comment-16999718
 ] 

xiaojin.wy edited comment on FLINK-15321 at 12/19/19 3:50 AM:
--

Ok, I will close it if it's expected.


was (Author: xiaojin.wy):
ok, I will close it if it's expected.

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