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/12/15 09:00:00 UTC

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

     [ https://issues.apache.org/jira/browse/IGNITE-15407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maksim Timonin updated IGNITE-15407:
------------------------------------
    Ignite Flags:   (was: Docs Required,Release Notes Required)

> Wrong warn about non-colocated join.
> ------------------------------------
>
>                 Key: IGNITE-15407
>                 URL: https://issues.apache.org/jira/browse/IGNITE-15407
>             Project: Ignite
>          Issue Type: New Feature
>          Components: sql
>            Reporter: Maksim Timonin
>            Assignee: Maksim Timonin
>            Priority: Major
>             Fix For: 2.12
>
>          Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> 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.20.1#820001)