[
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)
