[CASSANDRA-11485] ArithmeticException in avgFunctionForDecimal

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 3.0.6, 3.6
• Component/s: Legacy/CQL
• Severity: Low
• Assignee: Robert Stupp
• Reporter: Nico Haller

Authors

Robert Stupp

Reviewers

Tom Hobbs

• Created: 04/Apr/16 10:51
• Updated: 16/Apr/19 09:30
• Resolved: 15/Apr/16 18:34

Description

I am running into issues when using avg in queries on decimal values.
It throws an ArithmeticException in org/apache/cassandra/cql3/functions/AggregateFcts.java (Line 184).

So whenever an exact representation of the quotient is not possible it will throw that error and it never returns to the querying client.

I am not so sure if this is intended behavior or a bug, but in my opinion if an exact representation of the value is not possible, it should automatically round the value.
Specifying a rounding mode when calling the divide function should solve the issue