[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5141) hql group by on multiple classes generates 1 query by class and can return a wrong number of results
Eric Citaire (JIRA)
noreply at atlassian.com
Wed Apr 21 17:53:33 EDT 2010
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=36590#action_36590 ]
Eric Citaire commented on HHH-5141:
-----------------------------------
Oh, sorry about that. Yes, i meant "Buddy" and "Tiger".
> hql group by on multiple classes generates 1 query by class and can return a wrong number of results
> ----------------------------------------------------------------------------------------------------
>
> Key: HHH-5141
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5141
> Project: Hibernate Core
> Issue Type: Bug
> Components: query-hql
> Affects Versions: 3.3.0.SP1
> Environment: Hibernate Annotations 3.4.0.GA, HSQLDB 1.8.0.10
> Reporter: Eric Citaire
> Priority: Critical
>
> The classes DomesticDog and DomesticCat extend / implement Pet.
> Here is the data of the 2 tables :
> {{DomesticDog}}
> {{+----+----------------------+}}
> {{| 1 | Max |}}
> {{| 2 | Buddy |}}
> {{| 3 | Jake |}}
> {{| 4 | Buddy |}}
> {{+----+----------------------+}}
> {{DomesticCat}}
> {{+----+----------------------+}}
> {{| 1 | Tiger |}}
> {{| 2 | Smokey |}}
> {{| 3 | Tiger |}}
> {{| 4 | Max |}}
> {{+----+----------------------+}}
> Given the HQL query :
> {{select pet.name from Pet pet group by pet.name having count(pet) > 1}}
> Two SQL queries are generated and executed separately :
> {{select domesticdog0_.name as col_0_0_ from DomesticDog domesticdog0_ group by domesticdog0_.name having count(domesticdog0_.id)>1}}
> {{select domesticcat0_.name as col_0_0_ from DomesticCat domesticcat0_ group by domesticcat0_.name having count(domesticcat0_.id)>1}}
> It returns only : "Buddy" and "Smokey". But it does not return "Max" wich is the name of a cat and a dog.
--
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list