On Sybase ASE, avg() function returns a value in the type of the parameters --------------------------------------------------------------------------- Key: HHH-6424 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6424 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.6.0 Environment: Hibernate 3.6.6, Sybase ASE15.5, JDK 1.6, Windows XP Reporter: Ren Junyan Priority: Minor JPA specification ask avg() should return Double. In Reference Manual: When you average (signed or unsigned) int, smallint, tinyint data, Adaptive Server returns the result as an int value. But considering it as an ASE feature, it won't be fixed. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira