alex-plekhanov commented on a change in pull request #9606:
URL: https://github.com/apache/ignite/pull/9606#discussion_r758231504
##########
File path:
modules/calcite/src/test/sql/subquery/scalar/test_correlated_subquery_cte.test_ignore
##########
@@ -71,19 +66,19 @@ NULL NULL
query IT
SELECT i, EXISTS(WITH i2 AS (SELECT i FROM integers WHERE 1=0 AND i1.i=i)
SELECT i FROM i2) AS j FROM integers i1 ORDER BY i;
----
-NULL 0
-1 0
-2 0
-3 0
+NULL false
+1 false
+2 false
+3 false
# correlated ANY with WHERE clause that is always FALSE
query IT
SELECT i, i=ANY(WITH i2 AS (SELECT i FROM integers WHERE 1=0 AND i1.i=i)
SELECT i FROM i2) AS j FROM integers i1 ORDER BY i;
Review comment:
NULLS FIRST here by default
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
