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)

Reply via email to