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

Inconsistent decimal behavior for the IN predicate

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 3.0
    • Impala 2.13.0, Impala 3.1.0
    • Frontend
    • None
    • ghx-label-2

    Description

      The following query returns an error:

      select cast(2 as decimal(38,37)) in (cast(3 as decimal(38,1)), cast(2 as double))

      However, this query succeeds and returns true:

      select cast(2 as decimal(38,37)) in (cast(2 as double), cast(3 as decimal(38,1)))

      The only difference is that the elements in the list are in a different order. This behavior seems strange. Perhaps we should sort the elements before analyzing?

      Attachments

        Activity

          People

            fredyw Fredy Wijaya
            tarasbob Taras Bobrovytsky
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: