[PHOENIX-2483] Aggregate functions on floating point values have a fixed scale of 4

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 4.6.0
• Labels: aggregate double float metadata phoenix
• Assignee: Unassigned
• Reporter: Kevin Liew
• Created: 02/Dec/15 21:55
• Updated: 18/Dec/15 21:27
• Resolved: 18/Dec/15 21:27

Description

Doing a sum with the first column being a FLOAT or DOUBLE will return a DECIMAL with a fixed scale of 4.

Doing any multiplication or division will also result in a DECIMAL with scale 4.

I propose that the return value should either:
-always be DECIMAL with appropriate scale
or
-match the metadata of the first column

Issue Links

• is a clone of: PHOENIX-2536 Return of aggregation functions do not have the correct data type and precision