Aleksey Plekhanov created IGNITE-16693:
------------------------------------------
Summary: Calcite engine. Merge join incorrectly works with null
values
Key: IGNITE-16693
URL: https://issues.apache.org/jira/browse/IGNITE-16693
Project: Ignite
Issue Type: Bug
Reporter: Aleksey Plekhanov
Assignee: Aleksey Plekhanov
Reproducer:
{code:java}
executeSql("CREATE TABLE t(i INT)");
executeSql("CREATE INDEX t_i ON t(i)");
executeSql("INSERT INTO t VALUES (0), (null)");
assertQuery("SELECT t1.i FROM t t1 JOIN t t2 ON t1.i =
t2.i").returns(0).check();
{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)