Konstantin Orlov created IGNITE-27701:
-----------------------------------------
Summary: 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
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)
