[
https://issues.apache.org/jira/browse/IGNITE-16261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17474340#comment-17474340
]
Ignite TC Bot commented on IGNITE-16261:
----------------------------------------
{panel:title=Branch: [pull/9723/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/9723/head] Base: [master] : New Tests
(1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 1{color} [[tests
1|https://ci.ignite.apache.org/viewLog.html?buildId=6361632]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
IgniteCacheJoinPartitionedAndReplicatedTest.testSubquery - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci.ignite.apache.org/viewLog.html?buildId=6361656&buildTypeId=IgniteTests24Java8_RunAll]
> Query with 'in' condition with a sub-query returns multiplicative data.
> -----------------------------------------------------------------------
>
> Key: IGNITE-16261
> URL: https://issues.apache.org/jira/browse/IGNITE-16261
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Andrey Mashenkov
> Assignee: Andrey Mashenkov
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> A query like
> {code:java}
> select * from T1 where T1.col1 > 0 or T1.col1 in (select T2.col1 from T2)
> {code}
> where T1 is replicated and T2 is partitioned, may return duplicate rows on
> the multinode cluster.
>
> Ket's treat Replicated cache as Partitioned one, like we do when joining
> replicated cache to a partitioned.
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
