[JDO-643] The type of AVG should always be double (not the type of the field)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: JDO 2 maintenance release 2 (2.2)
• Fix Version/s: JDO 3.1-rc1
• Component/s: specification, tck
• Assignee: Michael Bouschen
• Reporter: Guido Anzuoni
• Created: 12/Oct/09 10:45
• Updated: 12/Jun/15 12:51
• Resolved: 01/Sep/12 20:43

Description

Aggregate type specification at page 175 claims that avg(expression) return type is the same of the enclosed expression.
This is wrong from a strictly mathematical point of view.
In fact, if you select an avg on an int field member the result is truncated.
The result type should always be double.