[
https://issues.apache.org/jira/browse/IGNITE-27701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov reassigned IGNITE-27701:
-----------------------------------------
Assignee: Konstantin Orlov
> Sql. Wrong result is returned for query with LEFT JOIN
> ------------------------------------------------------
>
> Key: IGNITE-27701
> URL: https://issues.apache.org/jira/browse/IGNITE-27701
> Project: Ignite
> Issue Type: Bug
> Components: sql ai3
> Affects Versions: 3.1
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Critical
> Labels: ignite-3
>
> The minimal reproducer is available below:
> {code}
> CREATE TABLE test (id INT PRIMARY KEY, val VARCHAR(10));
> INSERT INTO test VALUES (1, ''), (2, '');
> SELECT *
> FROM test AS t1
> JOIN test as t2
> ON t1.val = t2.val AND t1.id < 0
> WHERE t1.val = ''
> {code}
> The problem seems to be related to handling of non-equi condition in
> {{LeftHashJoin}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
