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)

Reply via email to