[DERBY-131] AVG precision is INTEGER instead of DOUBLE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 10.0.2.1
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Rainer Gemulla
• Created: 24/Jan/05 21:15
• Updated: 14/Aug/07 12:11
• Resolved: 06/Nov/06 18:09

Description

The AVG aggregator returns an INTEGER value, if the data tyoe of the respective attribute is INTEGER. This is wrong, because the average of a set of integers is not always an integer, too.