Hi,

I have a table with an integer column "value". When using the Criteria queries to get the averange of some rows an INTEGER is returend where I would expect a DOUBLE or FLOAT. How can I get the double/float value? Do I have to make the column of type DOUBLE/FLOAT ?

Currently I'm using this code with Hibernate 3.0b4
Object o = criteria.setProjection( Projections.avg("value")).uniqueResult();

Thanks for any hints. Axel

Can you get this to work in pure SQL? That will give you your hint.

I have a suspicion that SQL aggregate queries return in the type of the column, but someone else will have to verify or refute this. I'm not sure.

from the log I can see that this SQL is created:
select avg(this_.value) as y0_ from [...]

When I use the command line SQL interface and paste the query, I get the result "3.5000" for the 2 matching items with "3" and "4" as value. I will test the same pure SQL query in Hibernate tomorrow to see what happen there.

This was a bug that has already been fixed for 3.0 final.

Hello Gavin, I am using an old version of hibernate. 2.1.6 I think.

Does this bug happens with it too?

I see that it returns an array of Objects[] and containing several Float, for each avg(field) on the select statement.

My question is....

Is there any way to make it return an array of BigDecimal?

Thanks in advance...