[Hibernate-issues] [Hibernate-JIRA] Closed: (HB-502) group by clause in subselect

[<leg...@at...>]

Message:

   The following issue has been closed.

   Resolver: Gavin King
       Date: Wed, 26 Nov 2003 10:16 AM

This should be working in latest releases afaik. Try Hibernate 2.1.
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-502


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-502
    Summary: group by clause in subselect
       Type: Bug

     Status: Closed
   Priority: Major
 Resolution: DUPLICATE

    Project: Hibernate2
   Versions:
             2.0.2

   Assignee: 
   Reporter: Jo Droogmans

    Created: Wed, 26 Nov 2003 9:56 AM
    Updated: Wed, 26 Nov 2003 10:16 AM
Environment: Hibernate 2.0.2
Database Informix (any database that supports correlated subselects)

Description:
HQL does not support a group by clause in a correlated subselect
e.g.

select o1.objid
from object o1
where
o1.property1 in
(select o2.property1
from object o2
where o1 = 02
group by 02.property1)



---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira