[DRILL-7957] Unexpected query results when multiplying decimal column with constant (Parquet files)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.19.0
• Component/s: Functions - Drill, Storage - Parquet
• Assignee: Unassigned
• Reporter: Martin Puge Nielsen
• Created: 28/Jun/21 08:45
• Updated: 28/Jun/21 08:50

Description

I get unexpected results when trying to multiply a constant value with a decimal(29,6) column.

See attached files for sample data and a test script.
 

The correct/desired output should be 13.25 * 0.75 = 9.9375

EDIT:
I noticed that SUM(`Hours` * 0.75) returns 9.9375 which is the expected result. However, the other variations from TestScript.txt should logically all return 9.9375