You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Isaac Zhu (Jira)" <ji...@apache.org> on 2020/07/01 17:17:00 UTC
[jira] [Commented] (IGNITE-5359) Non-collocated SQL subqueries
return wrong results.
[ https://issues.apache.org/jira/browse/IGNITE-5359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17149571#comment-17149571 ]
Isaac Zhu commented on IGNITE-5359:
-----------------------------------
See the same problem in 2.8.0
I have two partitioned tables TASK and SUBTASK, both has "ID" column as primary key and affinity key. SUBTASK table has column "PARENT_ID" that points to TASK table.
With "distributedJoin=true", queries using join:
_select * from TASK join SUBTASK on TASK.id = SUBTASK.parent_id;_
_select * from TASK left join SUBTASK on TASK.id = SUBTASK.parent_id;_
works correctly.
While using sub queries like:
_select * from SUBTASK where parent_id in (select id from TASK);_
It returns wrong result - much less rows are returned than expected.
From the result I got, I guess the "distrubtedJoin=true" setting doesn't affect sub queries, because it returns same thing no matter this flag on or off.
> Non-collocated SQL subqueries return wrong results.
> ---------------------------------------------------
>
> Key: IGNITE-5359
> URL: https://issues.apache.org/jira/browse/IGNITE-5359
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.0
> Reporter: Andrey Mashenkov
> Priority: Critical
> Labels: sql-engine
> Attachments: JoinWithAggr.java
>
>
> PFA repro attached.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)