[
https://issues.apache.org/jira/browse/IGNITE-27701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-27701:
--------------------------------------
Description:
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 = ''
----
Returns 4 rows while 2 is expected.
{code}
The problem seems to be related to handling of non-equi condition in
{{LeftHashJoin}}.
was:
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}}.
> 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 = ''
> ----
> Returns 4 rows while 2 is expected.
> {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)
