You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Vova Vysotskyi (Jira)" <ji...@apache.org> on 2021/03/27 12:40:00 UTC

[jira] [Created] (DRILL-7887) JDBC plugin returns incorrect precision for SUM(DECIMAL) queries

Vova Vysotskyi created DRILL-7887:
-------------------------------------

             Summary: JDBC plugin returns incorrect precision for SUM(DECIMAL) queries
                 Key: DRILL-7887
                 URL: https://issues.apache.org/jira/browse/DRILL-7887
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.19.0
            Reporter: Vova Vysotskyi
            Assignee: Vova Vysotskyi
             Fix For: 1.19.0


The following query:
{code:sql}
SELECT sum(decimal_field * smallint_field) AS `order_total`
FROM mysql.`drill_mysql_test`.person e
{code}
returns {{order_total}} field with {{DECIMAL(42, 2)}} type, but Drill supports max presision of 38.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)