[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615?page=c...
]
Tim Lüecke commented on HHH-1615:
---------------------------------
I only examined the first query, thinking the second query should be faster anyway.
However, as it turns out the second query is even slower than the first in my example. The
fastest way in this simple example seems to be to perform a subselect in the select clause
instead.
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