[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1615) GROUP BY entity does not work

[Christian Bauer (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615?page=comments#action_24527 ] 

Christian Bauer commented on HHH-1615:
--------------------------------------

This has nothing to do with the database dialect. Hibernate simply doesn't expand entity properties in the GROUP BY clause. The examples and tests work because the entity there has no expandable properties, only an identifier. Would you like to submit a patch that implements this feature?


> GROUP BY entity does not work
> -----------------------------
>
>          Key: HHH-1615
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615
>      Project: Hibernate3
>         Type: Improvement

>   Components: query-hql
>     Versions: 3.1.3
>  Environment: PostgreSQL 8.1.3, Hibernate 3.1.3
>     Reporter: Xavier Bugaud
>     Priority: Minor

>
>
> The query : "select cat, count(*) from Cat cat group by cat" does not work.
> ERROR: column "xxxx" must appear in the GROUP BY clause or be used in an aggregate function
> See :
>  - http://forum.hibernate.org/viewtopic.php?t=953716
>  - http://jira.nhibernate.org/browse/NH-528

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira