[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: ------------------------------------- H2 has the same "problem" (mentioned in [this question and answer|http://stackoverflow.com/questions/2791378/does-the-jpql-avg-aggre...] on stackoverflow.com). The documentation of the [AVG|http://www.h2database.com/html/functions.html#avg] function of H2 writes: _The returned value is of the same data type as the parameter_. Personally, I think that Hibernate does its job, it returns a {{Double}} (and I couldn't find anything about the expected behavior of AVG in SQL-99 so I don't know if we can call this a bug in HSQLDB or H2 and other databases with the same behavior). But it would clearly make sense to return a value with a decimal part even for INT column types at the SQL level. So indeed, it would be nice to do a cast in the dialect to avoid having to run a native query for these databases. -- 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