[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-520) Add Distinct to Criteria API

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

The following comment has been added to this issue:

     Author: Michael Greer
    Created: Sat, 13 Dec 2003 9:14 AM
       Body:
<p>I believe this is similar to <a href="http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-123">Apply distinctness to HQL fetch of collection</a>, but I voted for this anyway.</p>
<p>The return of duplicates in an entity list if you eagerly fetch their children is unexpected behavior which, while easily remedied in the app, perhaps does not belong in this layer. I understand that adding "DISTINCT" to the query would be a major performance hit, so why not handle it programatically after returning the results? We have to handle it in any case, since it is an unwieldy and unexpected result, so we might as well hide it in the proper layer.</p>
---------------------------------------------------------------------
View the issue:

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


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-520
    Summary: Add Distinct to Criteria API
       Type: New Feature

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.1 rc1

   Assignee: 
   Reporter: Stephen Owens

    Created: Thu, 4 Dec 2003 7:08 AM
    Updated: Sat, 13 Dec 2003 9:14 AM
Environment: Hibernate 2.1+, (Any DB)

Description:
Need the ability to specify that results of a Criteria query should be 'DISTINCT', especially when joining to a collection. So the Criteria equivalent of the HQL statement 

"select distinct parent from Parent as parent join Parent.children as child where child.age>5"


---------------------------------------------------------------------
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