Vladsz83 commented on a change in pull request #9606:
URL: https://github.com/apache/ignite/pull/9606#discussion_r757502052
##########
File path:
modules/calcite/src/test/sql/subquery/scalar/test_complex_correlated_subquery.test
##########
@@ -20,6 +20,24 @@ NULL NULL
2 2
3 3
+# implicit join with correlated expression in filter
+query II
+SELECT i, (SELECT s1.i FROM integers s1, integers s2 WHERE s1.i=s2.i AND
s1.i=4-i1.i) AS j FROM integers i1 ORDER BY i;
Review comment:
OK. Actual fix in #9601
##########
File path:
modules/calcite/src/test/sql/subquery/scalar/test_complex_correlated_subquery.test
##########
@@ -20,6 +20,24 @@ NULL NULL
2 2
3 3
+# implicit join with correlated expression in filter
+query II
+SELECT i, (SELECT s1.i FROM integers s1, integers s2 WHERE s1.i=s2.i AND
s1.i=4-i1.i) AS j FROM integers i1 ORDER BY i;
+----
+NULL NULL
+1 3
+2 2
+3 1
+
+# join with a correlated expression in the join condition
+query II
+SELECT i, (SELECT s1.i FROM integers s1 INNER JOIN integers s2 ON s1.i=s2.i
AND s1.i=4-i1.i) AS j FROM integers i1 ORDER BY i;
Review comment:
OK. Actual fix in #9601
--
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]
