Evgeny Stanilovsky created IGNITE-27704:
-------------------------------------------
Summary: HashJoin return wrong results
Key: IGNITE-27704
URL: https://issues.apache.org/jira/browse/IGNITE-27704
Project: Ignite
Issue Type: Improvement
Components: sql ai3
Affects Versions: 3.1
Reporter: Evgeny Stanilovsky
{noformat}
CREATE TABLE EMP(EMPID INT PRIMARY KEY, NAME VARCHAR, DEPTID INT);
CREATE TABLE DEPT(DEPTID INT PRIMARY KEY, NAME VARCHAR);
INSERT INTO DEPT(DEPTID, NAME) VALUES (0, 'CORE');
INSERT INTO EMP(EMPID, NAME, DEPTID) VALUES (0, 'JOHN', 0);
INSERT INTO EMP(EMPID, NAME, DEPTID) VALUES (1, 'JACK', 0);
SELECT /*+ DISABLE_RULE('MergeJoinConverter', 'NestedLoopJoinConverter',
'CorrelatedNestedLoopJoin') */ * FROM DEPT LEFT JOIN EMP ON (EMP.DEPTID =
DEPT.DEPTID AND EMP.EMPID < DEPT.DEPTID);
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
