[
https://issues.apache.org/jira/browse/IGNITE-22314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-22314:
----------------------------------------
Epic Link: IGNITE-22700
> 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
> Priority: Major
> Labels: ignite-3
>
> 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;
> the same for:
> SELECT i=ALL(SELECT i FROM integers 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)
