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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Shang Yuanchun (Jira)
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)