Hi all,

I'm having a problem with using an aggregation in the where clause for an HQL query. it's pretty simple, something like this:



Basically, I get the following error:



Which is right at the "m" of "max"

I see the following documentation:

http://docs.jboss.org/hibernate/core/3. ... l-grouping

Actually mentions that MySQL is an example of a database that cannot use aggregates in the having clause, however, I can do that just fine on my database:



and, the mysql docs confirm that it can do this on anything newer than 3.23:

http://dev.mysql.com/doc/refman/4.1/en/select.html

Is there a reason this is restricted in hibernate when it works on current mysql versions?

Thanks!!

Shouldn't you compare max(job.end_time) with some value. Eg. having max(job.end_time) > foo. MySQL isn't very picky about such things as Hibernate (and other databases).