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)
