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

["xiaojin.wy (Jira)" <ji...@apache.org>]

xiaojin.wy created FLINK-15321:
----------------------------------

             Summary: 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


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'.



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