[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3394) ScrollableResults delivers sometime wrong collections when used with a LEFT JOIN FETCH clause

ScrollableResults delivers sometime wrong collections when used with a LEFT JOIN FETCH clause --------------------------------------------------------------------------------------------- Key: HHH-3394 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3394 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.2.6 Environment: Windows, Java SE 6.06, Oracle 9 / 10, Hibernate 3.2.6 Reporter: Thomas Scherm Following stament is used to create a ScrollableResult from a Query. SELECT DISTINCT f FROM Fall f LEFT JOIN FETCH f.leistungen l WHERE (f.status = '2' OR f.status = '3') AND f.quartalJahr = ? It schould deliver a Faelle with prefeched sets of Leistungen. The first row is ok. All subsequent rows return exactly one leistungen. Th SQL Statement is ok, the session cache works fine and has the missing Leistungen, but they are not attached. As Workaround we removed the FETC clause and let it work with lazy loading. It works.