Vladsz83 commented on a change in pull request #9606:
URL: https://github.com/apache/ignite/pull/9606#discussion_r757468645
##########
File path:
modules/calcite/src/test/sql/subquery/any_all/test_uncorrelated_any_subquery.test
##########
@@ -79,3 +79,53 @@ NULL NULL
1 NULL
2 NULL
3 true
+
+query IT
+SELECT i, i <> ANY(SELECT i FROM integers WHERE i>2) FROM integers ORDER BY i
NULLS FIRST
+----
+NULL NULL
+1 true
+2 true
+3 false
+
+query IT
+SELECT i, i <> ANY(SELECT i FROM integers WHERE i>2 OR i IS NULL) FROM
integers ORDER BY i NULLS FIRST
+----
+NULL NULL
+1 true
+2 true
+3 NULL
+
+# use a bunch of cross products to make bigger data sets (>
STANDARD_VECTOR_SIZE)
+query IT
+SELECT i, i = ANY(SELECT i1.i FROM integers i1, integers i2, integers i3,
integers i4, integers i5, integers i6 WHERE i1.i IS NOT NULL) FROM integers
ORDER BY i NULLS FIRST
Review comment:
Same here .As I can see, `NULLS FIRST` doesn't work:
Actual: [[1, true], [2, false], [3, true], [null, null]]
--
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]
