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

Maksim Zhuravkov reassigned IGNITE-22158:
-----------------------------------------

    Assignee: Maksim Zhuravkov

> Sql. incorrect result of NATURAL JOIN for BIGINTEGER column on condition
> ------------------------------------------------------------------------
>
>                 Key: IGNITE-22158
>                 URL: https://issues.apache.org/jira/browse/IGNITE-22158
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Iurii Gerzhedovich
>            Assignee: Maksim Zhuravkov
>            Priority: Major
>              Labels: ignite-3
>
> If we do natural join for tables containing BIGINT columns we have an 
> incorrect empty result. 
> {code:java}
> CREATE TABLE t1 (a INTEGER, b INTEGER)
> INSERT INTO t1 VALUES (1, 2)
> CREATE TABLE t2 (a BIGINT, c BIGINT)
> INSERT INTO t2 VALUES (1, 3), (2, 4)
> SELECT * FROM t1 NATURAL JOIN t2 - return nothing {code}
> reference - test/sql/join/natural/natural_join.test



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to