You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Maksim Timonin (Jira)" <ji...@apache.org> on 2021/08/31 14:47:00 UTC

[jira] [Created] (IGNITE-15407) Wrong warn about non-colocated join.

Maksim Timonin created IGNITE-15407:
---------------------------------------

             Summary: Wrong warn about non-colocated join.
                 Key: IGNITE-15407
                 URL: https://issues.apache.org/jira/browse/IGNITE-15407
             Project: Ignite
          Issue Type: New Feature
            Reporter: Maksim Timonin
            Assignee: Maksim Timonin


Reproducer: see CheckWarnJoinPartitionedTables

 

/** */
@Test
public void test() {
 execute(new SqlFieldsQuery(
 "CREATE TABLE t1 (k1 VARCHAR PRIMARY KEY, v2 VARCHAR);"));

 execute(new SqlFieldsQuery(
 "CREATE TABLE t2 (k1 VARCHAR, ak2 VARCHAR, v3 VARCHAR, PRIMARY KEY(k1, ak2)) with \"AFFINITY_KEY=ak2\";"));

 String joinType = "INNER JOIN";

 checkLogListener(false,
 "SELECT * FROM t1 " + joinType + " t2 on t1.k1 = t2.ak2");

 checkLogListener(false,
 "SELECT * FROM t1 " + joinType + " t2 on t1.k1 = t2.ak2 WHERE t2.k1 = ?;", "1");
}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)