[
https://issues.apache.org/jira/browse/FLINK-23642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
xiaojin.wy updated FLINK-23642:
-------------------------------
Description:
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.
was:
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.
> 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
> 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)
