[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5173) hql - average returns double but looses the decimal part

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5173?page=c... ] Pascal Thivent commented on HHH-5173: ------------------------------------- This is also true for Derby/JavaDB. The documentation of the [AVG function|http://db.apache.org/derby/docs/dev/ref/rrefsqlj32693.html] is very clear about the behavior: {quote} The resulting data type is the same as the expression on which it operates (it will never overflow). The following query, for example, returns the INTEGER 1, which might not be what you would expect: {code} SELECT AVG(c1) FROM (VALUES (1), (1), (1), (1), (2)) AS myTable (c1) {code} CAST the expression to another data type if you want more precision: {code} SELECT AVG(CAST (c1 AS DOUBLE PRECISION)) FROM (VALUES (1), (1), (1), (1), (2)) AS myTable (c1) {code} {quote} -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira