[
https://issues.apache.org/jira/browse/IGNITE-23555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Steshin updated IGNITE-23555:
--------------------------------------
Labels: calcite ignite-2 ise (was: )
> Calcite. Incorrect results with operator ALL.
> ----------------------------------------------
>
> Key: IGNITE-23555
> URL: https://issues.apache.org/jira/browse/IGNITE-23555
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.14
> Reporter: Vladimir Steshin
> Priority: Major
> Labels: calcite, ignite-2, ise
>
> Reproducer:
> {code:java}
> sql("CREATE TABLE integers(i INTEGER);");
> sql("INSERT INTO integers VALUES (1), (2), (3), (NULL);");
> assertQuery("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;")
> .returns(new Object[]{null})
> .returns(new Object[]{null})
> .returns(new Object[]{null})
> .returns(new Object[]{null})
> .check();
> {code}
> Result:
> {code:java}
> java.lang.AssertionError: Collections are not equal (position 0):
> Expected: [[null], [null], [null], [null]]
> Actual: [[true], [true], [true], [true]]
> {code}
> Probably, should be fixed with #CALCITE-6418
> Adoption of #IGNITE-22314
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
