zstan commented on code in PR #2106:
URL: https://github.com/apache/ignite-3/pull/2106#discussion_r1608272585


##########
modules/sql-engine/src/integrationTest/sql/subquery/any_all/test_correlated_any_all.test:
##########
@@ -157,15 +146,13 @@ true
 true
 NULL
 
-# Ignore https://issues.apache.org/jira/browse/IGNITE-19401
-skipif ignite3
 query T
 SELECT i=ALL(SELECT i FROM integers WHERE i=i1.i OR i IS NULL) FROM integers 
i1 ORDER BY i;
 ----
-NULL
-NULL
-NULL
-NULL
+true

Review Comment:
   seems it kinda optimization here, other db found that `WHERE i=i1.i OR i IS 
NULL` more easy to return null if it observed once (i just suppose here)



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscr...@ignite.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to