Evgeny Stanilovsky created IGNITE-22314:
-------------------------------------------
Summary: Sql. Incorrect result while using ALL operator.
Key: IGNITE-22314
URL: https://issues.apache.org/jira/browse/IGNITE-22314
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 3.0.0-beta1
Reporter: Evgeny Stanilovsky
Query:
{noformat}
CREATE TABLE integers(i INTEGER);
INSERT INTO integers VALUES (1), (2), (3), (NULL);
SELECT i=ALL(SELECT i FROM (values(null), (1)) integers(i) WHERE i=i1.i OR i IS
NULL) FROM integers i1 ORDER BY i;
{noformat}
returns incorrect result, need to be four NULL`s but four 'true' will return.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
