[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615?page=c...
]
Bob Tiernay commented on HHH-1615:
----------------------------------
This is, in my opinion, a huge bug. It also breaks compliance with jpql:
"groupby_clause ::= GROUP BY groupby_item {, groupby_item}*
groupby_item ::= single_valued_path_expression | identification_variable
... The requirements for the SELECT clause when GROUP BY is used follow those of SQL:
namely, any item that appears in the SELECT clause (other than as an argument to an
aggregate function) must also appear in the GROUP BY clause. In forming the groups, null
values are treated as the same for grouping purposes. Grouping by an entity is permitted.
In this case, the entity must contain no serialized state fields or lob-valued state
fields..."
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.2.5
Environment: PostgreSQL 8.1.3, Hibernate 3.1.3
Reporter: Xavier Bugaud
Assignee: Anthony Patricio
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