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

["Kirill Anisimov (Jira)" <ji...@apache.org>]

Kirill Anisimov created IGNITE-28341:
----------------------------------------

             Summary: 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: Kirill Anisimov


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)