You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2026/08/21 08:56:00 UTC

[jira] [Assigned] (IGNITE-28341) Fix incorrect WHERE condition pushdown for LEFT OUTER JOIN in GridSqlQuerySplitter

     [ https://issues.apache.org/jira/browse/IGNITE-28341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Evgeny Stanilovsky reassigned IGNITE-28341:
-------------------------------------------

    Assignee: Evgeny Stanilovsky  (was: Kirill Anisimov)

> Fix incorrect WHERE condition pushdown for LEFT OUTER JOIN in GridSqlQuerySplitter
> ----------------------------------------------------------------------------------
>
>                 Key: IGNITE-28341
>                 URL: https://issues.apache.org/jira/browse/IGNITE-28341
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Kirill Anisimov
>            Assignee: Evgeny Stanilovsky
>            Priority: Major
>              Labels: ignite-2, ise
>          Time Spent: 3h
>  Remaining Estimate: 0h
>
> Queries with {{LEFT OUTER JOIN}} may return incorrect results because {{WHERE}} conditions can be pushed down into aliases from the right branch of the join during query splitting.
> For {{{}LEFT OUTER JOIN{}}}, such pushdown is not always valid and may break left join semantics.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)