[jira] [Updated] (IGNITE-16693) Calcite engine. Merge join incorrectly works with null values

[Andrey Mashenkov (Jira)]

 [ 
https://issues.apache.org/jira/browse/IGNITE-16693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Andrey Mashenkov updated IGNITE-16693:
--
Labels: calcite  (was: calcite calcite3-required)

> 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
>Priority: Major
>  Labels: calcite
>  Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> 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.10#820010)

[jira] [Updated] (IGNITE-16693) Calcite engine. Merge join incorrectly works with null values

[Aleksey Plekhanov (Jira)]

 [ 
https://issues.apache.org/jira/browse/IGNITE-16693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aleksey Plekhanov updated IGNITE-16693:
---
Labels: calcite calcite3-required  (was: calcite calcite2-required 
calcite3-required)

> 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
>Priority: Major
>  Labels: calcite, calcite3-required
>  Time Spent: 50m
>  Remaining Estimate: 0h
>
> 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)