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

["Jark Wu (Jira)" <ji...@apache.org>]

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

Jark Wu commented on FLINK-15321:
---------------------------------

This is as expected. {{concat}} will return null if any argument is null. see the documentation [1].

[1]: https://ci.apache.org/projects/flink/flink-docs-master/dev/table/functions/systemFunctions.html

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