[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1076) FETCH JOIN with DISTINCT returns duplicate values

FETCH JOIN with DISTINCT returns duplicate values ------------------------------------------------- Key: HHH-1076 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1076 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.1 rc2 Environment: Windows XPSP2, Hibernate 3.1rc2, JDK 5.0_05, MySQL 5.0.13 / PostgreSQL 8.1beta3 Reporter: Juergen Zimmermann Attachments: fetch.zip When I make a fetch join (left outer join with FETCH clause) I get duplicated return values even when I specify DISTINCT. Without the FETCH keyword no duplicates are returned. Examples (see attached test case): * SELECT DISTINCT c.id FROM CustomerData c LEFT JOIN FETCH c.orders o WHERE c.name = 'Alpha' AND o.id > 0 * SELECT DISTINCT c.id FROM CustomerData c LEFT JOIN c.orders o WHERE c.name = 'Alpha' AND o.id > 0 JAR files are not uploaded due to upload restrictions of my proxy server: commons logging, db driver, hibernate jars