[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615?page=c...
]
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira