I have been trying to group by an object as in the following example code from the reference page.

select cat, count( elements(cat.kittens) )
from eg.Cat cat group by cat

The sql that is generated only ever groups by the id of the object instead of each of the fields selected to create the object. Obviously this causes sql exceptions stating that e.g. cat.name must be grouped by or used in an aggregate function.

Is there something that I am likely missing? I can't seem to find that anyone else is having this problem. When looking at the code for the GroupByParser, however, I noticed a comment that said that it was basically just a refactor of OrderByParser. It would make sense for the OrderByParser to only care about the id of the object, but this is not the case for order by.

Any help would be appreciated.

Thanks in advance,
Scott

This is a known issue : http://www.hibernate.org/74.html#A14 - it might someday get "fixed".

I'd would very much like to see this issue fixed. My HQL with the group by clause looks a little ugly right now.
(BTW, the url to the specific FAQ is http://www.hibernate.org/74.html#A12 )