You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "xiaojin.wy (Jira)" <ji...@apache.org> on 2021/08/05 09:37:00 UTC
[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 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)