[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-1615) GROUP BY entity does not work
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615?page=c...
]
Sandeep Tamhankar updated HHH-1615:
-----------------------------------
Attachment: hibernate-group-by.diff
Patch for converting entity refs in group by clauses in HQL to all of the entity fields in
SQL.
GROUP BY entity does not work
-----------------------------
Key: HHH-1615
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615
Project: Hibernate3
Issue Type: Improvement
Components: query-hql
Affects Versions: 3.1.3
Environment: PostgreSQL 8.1.3, Hibernate 3.1.3
Reporter: Xavier Bugaud
Priority: Critical
Attachments: hibernate-group-by.diff
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