You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2021/09/01 14:07:00 UTC
[jira] [Commented] (IGNITE-15407) Wrong warn about non-colocated
join.
[ https://issues.apache.org/jira/browse/IGNITE-15407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17408190#comment-17408190 ]
Ignite TC Bot commented on IGNITE-15407:
----------------------------------------
{panel:title=Branch: [pull/9366/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/9366/head] Base: [master] : New Tests (28)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 1{color} [[tests 28|https://ci.ignite.apache.org/viewLog.html?buildId=6159546]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.testWrongQueryButAllAffinityKeysAreUsed[join=RIGHT JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithComplexPrimaryKeySingleAffKey[join=RIGHT JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinWithPrimaryKey[join=RIGHT JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithComplexPrimaryKey[join=RIGHT JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithComplexPrimaryKey[join=INNER JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithPrimaryKey[join=INNER JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinPrimaryKeyAndAffinityKey[join=INNER JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithPrimaryAffinityKey[join=INNER JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithComplexPrimaryKeySingleAffKey[join=LEFT JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinWithPrimaryKey[join=LEFT JOIN] - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: CheckWarnJoinPartitionedTables.joinSameTableWithComplexPrimaryKey[join=LEFT JOIN] - PASSED{color}
... and 17 new tests
{panel}
[TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=6159567&buildTypeId=IgniteTests24Java8_RunAll]
> 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
> Priority: Major
> Time Spent: 20m
> 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.3.4#803005)