[
https://issues.apache.org/jira/browse/IGNITE-16261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17474375#comment-17474375
]
Yury Gerzhedovich commented on IGNITE-16261:
--------------------------------------------
[~amashenkov], LGTM.
Thanks for the contribution!
> 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)
