[ http://issues.apache.org/jira/browse/DERBY-131?page=comments#action_58060 ] Rainer Gemulla commented on DERBY-131: --------------------------------------
Maybe you are right. I quickly checked the AVG() function in commercial database systems. IBM DB2 returns an integer (as Derby), while Oracle returns a double. Therefore, maybe it's best to leave it as it is. But, most probably, users will not be aware of this behaviour and therefore they may not get the results they expected. > 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
