[
https://issues.apache.org/jira/browse/FLINK-23642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Caizhi Weng updated FLINK-23642:
--------------------------------
Component/s: (was: Table SQL / Runtime)
Table SQL / Planner
> 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 / Planner
> Affects Versions: 1.14.0
> Reporter: xiaojin.wy
> Priority: Major
>
> 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'.
> {code:java}
> SELECT ((CAST (((CAST (IS_ALPHA(-421305765) AS BOOLEAN)) OR (CAST ((SHA1(CAST
> ('鲇T' AS STRING ))) AS BOOLEAN))) AS BOOLEAN))) IS NULL
> {code}
> 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)
