[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

[Gail Badner (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=36579#action_36579 ] 

Gail Badner commented on HHH-5141:
----------------------------------

Eric, 3.3.0.SP1 is a very old version. Please try 3.5.1 or 3.3.2.

Also, when you said:
   < It returns only : "Buddy" and "Smokey"
Did you mean "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