I have found one other post about this problem, but it had no replies. I'm hoping a better Subject will have better results.

I need to count the number of acknowledged and unacknowledged records that have data in a field.

The SQL query works:


The HQL version My HQL query looks like this:


However, it fails with the following:


If I try to use an alias, I get:

which is followed by a NullPointerException in HqlSqlWalker.setAlias().

If I try to use field numbers in the group by clause, I get :


I've tried sticking it in a subquery and in a "new Map", but I always get one of the errors mentioned above.

I can move it to the where clause and just execute it twice, but I don't want to make an extra trip to the DB, and IT SHOULD WORK, DARN IT! :-/

I'm using MySQL 5.0.37 and Hibernate 3.2.4.

Funny syntax IMHO. I assume you specified MySQL dialect in hibernate settings. Try looking into the code and figure out why AST is not able to parse/generate code correctly.

Again, I don't use MySQL - but do you need to use "smth is null" in group by clause? I would expect just column name there, without any expressions, eg.



From what I've found in mysql doco, IS NULL is an expression and IMO you should not tell database to group by an expression, it should be a column or possibly concatenation of columns, but not smth. like "column1 is null"