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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.19.0
• Assignee: Vova Vysotskyi
• Reporter: Vova Vysotskyi
• Created: 27/Mar/21 12:39
• Updated: 30/Mar/21 08:13
• Resolved: 30/Mar/21 08:13

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.