You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Lukas Eder (Jira)" <ji...@apache.org> on 2021/01/20 18:33:00 UTC

[jira] [Created] (IGNITE-14025) Wrong implementation of row value predicates with respect to NULLs

Lukas Eder created IGNITE-14025:
-----------------------------------

             Summary: Wrong implementation of row value predicates with respect to NULLs
                 Key: IGNITE-14025
                 URL: https://issues.apache.org/jira/browse/IGNITE-14025
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.9.1
            Reporter: Lukas Eder


It seems that row value predicates do not behave correctly with respect to nulls. For example:
{code:java}
SELECT (1, NULL) = (1, NULL);{code}
This should yield NULL, yet it evaluates to TRUE, which is incorrect according to the SQL conformance claims mentioned here: [https://ignite.apache.org/docs/latest/sql-reference/sql-conformance] (E061-06)

Likewise, this should yield TRUE:
{code:java}
SELECT (NULL, NULL) IS NULL;{code}
Yet it evaluates to FALSE



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