[jira] [Created] (FLINK-23642) A result of SELECT (not (CAST (((CAST (IS_ALPHA(-421305765) AS BOOLEAN)) OR (CAST ((SHA1(CAST ('鲇T' AS STRING ))) AS BOOLEAN))) AS BOOLEAN))) IS NULL should return true

[xiaojin.wy (Jira)]

xiaojin.wy created FLINK-23642:
----------------------------------

             Summary: A result of SELECT (not (CAST (((CAST 
(IS_ALPHA(-421305765) AS BOOLEAN)) OR (CAST ((SHA1(CAST ('鲇T' AS STRING ))) AS 
BOOLEAN))) AS BOOLEAN))) IS NULL should return true
                 Key: FLINK-23642
                 URL: https://issues.apache.org/jira/browse/FLINK-23642
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Runtime
    Affects Versions: 1.14.0
            Reporter: xiaojin.wy



The sql below we get returns a 'false' value

{code:java}
SELECT (not (CAST (((CAST (IS_ALPHA(-421305765) AS BOOLEAN)) OR (CAST 
((SHA1(CAST ('鲇T' AS STRING ))) AS BOOLEAN))) AS BOOLEAN))) IS NULL
{code}

But the sql below returns a 'true',  I think the two sql`s result is both true. 
Because SELECT NULL IS NULL return true, and SELECT (NOT NULL) IS NULL  return 
true.




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