[jira] [Created] (FLINK-21582) COALESCE not works when cast a variable return null

[Shang Yuanchun (Jira)]

Jerry created FLINK-21582:
-----------------------------

             Summary: COALESCE not works when cast a variable return null
                 Key: FLINK-21582
                 URL: https://issues.apache.org/jira/browse/FLINK-21582
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / API
    Affects Versions: 1.11.1
         Environment: Flink1.11.1

 
            Reporter: Jerry


select COALESCE(cast('aa' as int), 0);return NULL 

select COALESCE(NULL, 0); return 0 

The first case works failed, but the second case works successful

 



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