Iurii Gerzhedovich created IGNITE-22158:
-------------------------------------------

             Summary: 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


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