zstan commented on code in PR #5454:
URL: https://github.com/apache/ignite-3/pull/5454#discussion_r2009939030
##########
modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/engine/ItJoinTest.java:
##########
@@ -1019,6 +1019,21 @@ public void testNatural(JoinType joinType) {
// .check();
}
+ @Test
+ public void testNonColocatedNaturalJoin() {
+ sqlScript("CREATE TABLE tbl1 (a INTEGER, b INTEGER, PRIMARY KEY(b));"
+ + "CREATE TABLE tbl2 (a INTEGER, c INTEGER, PRIMARY KEY(c));"
+ + "CREATE TABLE tbl3 (a INTEGER, b INTEGER, c INTEGER, PRIMARY
KEY(a))");
+
+ sql("INSERT INTO tbl1 VALUES (1, 2)");
+ sql("INSERT INTO tbl2 VALUES (1, 3), (2, 4)");
+ sql("INSERT INTO tbl3 VALUES (1, 2, 3)");
+
+ gatherStatistics();
+
+ sql("SELECT * FROM tbl1 NATURAL JOIN tbl2 NATURAL JOIN tbl3");
Review Comment:
seems we need to check some avoidance 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
