[ http://issues.apache.org/jira/browse/DERBY-131?page=comments#action_58013 ] Jeremy Boynes commented on DERBY-131: -------------------------------------
I think what we are doing here currently is compatible. According to the spec, if the datatype is an exact numeric then the result is also an exact numeric. So in this case returning a DOUBLE would be incorrect as we would be converting the exact numeric INTEGER to an approximate numeric. The precision returned is implementation-defined. Derby defines this to be the precision of the original datatype, which in the absence of additional information seems reasonable as you can specify the output type by casting the input appropriately (although arguably the performance of the aggregation may be impacted if you sum as DECIMAL rather than as an INTEGER) > AVG precision is INTEGER instead of DOUBLE > ------------------------------------------ > > Key: DERBY-131 > URL: http://issues.apache.org/jira/browse/DERBY-131 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.0.2.1 > Reporter: Rainer Gemulla > > 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. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
