Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-22158

Sql. incorrect result of NATURAL JOIN for BIGINTEGER column on condition

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0-beta2
    • sql
    • Docs Required, Release Notes Required

    Description

      If we do natural join for tables containing BIGINT columns we have an incorrect empty result. 

      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 

      reference - test/sql/join/natural/natural_join.test

      Attachments

        Issue Links

          Activity

            People

              mzhuravkov Maksim Zhuravkov
              jooger Iurii Gerzhedovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 50m
                  1h 50m