Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Reproducer:
executeSql("CREATE TABLE t1(i INT)"); executeSql("CREATE INDEX t1_i ON t1(i)"); executeSql("INSERT INTO t1 VALUES (0)"); executeSql("CREATE TABLE t2(i INT)"); executeSql("CREATE INDEX t2_i ON t2(i)"); executeSql("INSERT INTO t2 VALUES (0), (0), (0)"); assertQuery("SELECT /*+ DISABLE_RULE('CorrelatedNestedLoopJoin', 'NestedLoopJoinConverter') */ t1.i FROM t1 LEFT JOIN t2 ON t1.i = t2.i").returns(0).returns(0).returns(0).check();
Should return [0, 0, 0], but returns [0, 0].
Attachments
Issue Links
- blocks
-
IGNITE-15436 Calcite engine. Merge Calcite SQL Engine to Ignite 2.x
- Resolved
- is part of
-
IGNITE-12248 Apache Calcite based query execution engine
- Open
- links to