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

JDBC plugin returns incorrect precision for SUM(DECIMAL) queries

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.19.0
    • Fix Version/s: 1.19.0
    • Component/s: None
    • Labels:
      None

      Description

      The following query:

      SELECT sum(decimal_field * smallint_field) AS `order_total`
      FROM mysql.`drill_mysql_test`.person e
      

      returns order_total field with DECIMAL(42, 2) type, but Drill supports max presision of 38.

        Attachments

          Activity

            People

            • Assignee:
              volodymyr Vova Vysotskyi
              Reporter:
              volodymyr Vova Vysotskyi
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: