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.
|Field||Original Value||New Value|
|Assignee||Michael Bouschen [ mbo ]|
|Fix Version/s||JDO 3 maintenance release 1 [ 12314921 ]|
|Component/s||tck [ 11652 ]|
|Assignee||Michael Bouschen [ mbo ]||Craig L Russell [ clr ]|
|Assignee||Craig L Russell [ clr ]||Michael Bouschen [ mbo ]|
|Status||Open [ 1 ]||Resolved [ 5 ]|
|Resolution||Fixed [ 1 ]|
|Summary||avg return type||The type of AVG should always be double (not the type of the field)|
|Status||Resolved [ 5 ]||Closed [ 6 ]|