[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1615?page=c...
]
Patrick Burleson commented on HHH-1615:
---------------------------------------
Thank you for updating the documention, as the example outlined by :
select cat
from Cat cat
join cat.kittens kitten
group by cat
having avg(kitten.weight) > 100
order by count(kitten) asc, sum(kitten.weight) desc
is very misleading. If this wasn't an intended feature, than sure, this issue is minor
and an improvment as you could work around it.
And _ANY_ wrong example in the documentation will create a bug report like this.
Doesn't matter that there was just one wrong one. A wrong example in any manual will
have users trying to do something that can't be done.
If I can find some time in the next little bit, I'd be happy to find a way to add this
and submit a patch.
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