[hibernate-issues] [Hibernate-JIRA] Created: (HHH-5141) hql group by on multiple classes generates 1 query by class and can return a wrong number of results

[Eric Citaire (JIRA)]

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