Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1810

Incorrect number of rows returned when this type of predicate is present: int IN (decimal, int)

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Impala 2.2
    • Fix Version/s: Impala 2.2
    • Component/s: None
    • Labels:

      Description

      Query:

      SELECT
      t1.month
      FROM alltypestiny t1
      WHERE
      (t1.tinyint_col) IN (154.58, t1.id)
      

      DB: Functional
      Expected Number of rows returned: 2
      Actual Number of rows returned: 0

      There are many queries that are affected by this bug. Another query:

      SELECT
      t1.tinyint_col
      FROM alltypestiny t1
      WHERE
      (t1.month) NOT IN (355.8, t1.tinyint_col)
      

      Expected Number of rows returned: 7
      Actual Number of rows returned: 8

        Attachments

          Activity

            People

            • Assignee:
              skye Skye Wanderman-Milne
              Reporter:
              tarasbob Taras Bobrovytsky
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: