Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7615

UNION ALL query returns the wrong result for the decimal value

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.14.0
    • 1.18.0
    • None

    Description

      The following query:

      select cast(1000 as decimal(10,1)) 
      union all 
      select 596.000 
      

      returns incorrect result:

      10.000
      596.000
      

      The expected result is 1000.000 for the first record.

      Attachments

        Issue Links

          Activity

            People

              volodymyr Vova Vysotskyi
              volodymyr Vova Vysotskyi
              Arina Ielchiieva Arina Ielchiieva
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: