[jira] [Created] (IGNITE-23555) Calcite. Incorrect results with operator ALL.

[Vladimir Steshin (Jira)]

Vladimir Steshin created IGNITE-23555:
-----------------------------------------

             Summary: Calcite. Incorrect results with operator ALL. 
                 Key: IGNITE-23555
                 URL: https://issues.apache.org/jira/browse/IGNITE-23555
             Project: Ignite
          Issue Type: Bug
            Reporter: Vladimir Steshin


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)