[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5173?page=c... ] Gail Badner commented on HHH-5173: ---------------------------------- Please checkout the trunk version http://anonsvn.jboss.org/repos/hibernate/core/trunk/, update ASTParserLoadingTest.testAggregation() to reproduce your issues, and attach a patch using "svn diff". Thanks, Gail -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5173?page=c... ] Sébastien Peters commented on HHH-5173: --------------------------------------- Not the case on mysql database - this is only on hsqldb Also, we are not the only ones having this problem: http://www.jezzper.com/jezzper/Discussions.nsf/f72637182738a22ec125708200... According to hsqldb documentation the AVG function returns a value in the type of the column on which the AVG is calculated. http://www.hsqldb.org/doc/guide/ch09.html -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5173?page=c... ] Sébastien Peters commented on HHH-5173: --------------------------------------- This is correct -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5173?page=c... ] Steve Ebersole edited comment on HHH-5173 at 5/8/10 5:11 PM: ------------------------------------------------------------- One option is to alter the definition of the avg function in the HSQLDialect to use an explicit cast {code} registerFunction( "avg", new SQLFunctionTemplate( Hibernate.DOUBLE, "avg( cast( ?1 as double ) )" ) ); {code} Note the checking done in the base Dialect version wrt the number of columns. was (Author: steve): One option is to alter the definition of the avg function in the HSQLDialect to use an explicit cast {code} registerFunction( "avg", new SQLFunctionTemplate( Hibernate.DOUBLE, "avg( cast( ?1 as double )" ) ); {code} Note the checking done in the base Dialect version wrt the number of columns. -- 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

[ 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5173?page=c... ] Steve Ebersole commented on HHH-5173: ------------------------------------- As far as Derby is concerned, it sounds like DB2 in general has this issue -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5173?page=c... ] Steve Ebersole commented on HHH-5173: ------------------------------------- thanks for your help on this pascal. I went ahead and did the casting on the dialects you helpded identify -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5173?page=c... ] Steve Ebersole closed HHH-5173. ------------------------------- -- 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