hello

I was wondering why the folling query gives crashes with the message "Invalid use of group function" (MySQL)

When I order the query by c.ID everything works fine, but I can't order it by an aggregated field.

Does anyone know why and how it should work???
The query already looks like the examples in the Hibernate documentation...


select c, max(log.date), count(log.ID)
from LoginLog log, Customer c, User u
WHERE ...
group by c.ID
order by max(log.date)

Thanks for help
Lars

maybe try setting an alias, like:

select c, max(log.date) as maxDate, count(log.ID) as countID
from LoginLog log, Customer c, User u
WHERE ...
group by c.ID
order by maxDate

Just guessing. For better debugging I suggest you set show_sql=true and look at the SQL it generates.

Old versions of MySQL don't support ordering by aggregate functions' result.