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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.14.0
    • Fix Version/s: 1.18.0
    • Component/s: None
    • Labels:

      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: