[
https://issues.apache.org/jira/browse/IGNITE-16261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrey Mashenkov updated IGNITE-16261:
--------------------------------------
Description:
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.
was:
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.
> 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)
