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

[John Ip (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_30876 ] 

John Ip commented on HHH-3394:
------------------------------

I experience the same problem

> 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: Hibernate3
>          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.

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