[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4906) Collection incorrectly populated after LEFT_JOIN query with restriction on child

Collection incorrectly populated after LEFT_JOIN query with restriction on child -------------------------------------------------------------------------------- Key: HHH-4906 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4906 Project: Hibernate Core Issue Type: Bug Components: caching (L2) Affects Versions: 3.3.1 Environment: Hibernate 3.3.1, but first encountered this but over a year ago. Database is Oracle 10g, but think it is DB-independent. Reporter: Viliam Ďurina Attachments: testcase.zip If you have two classes in one to many relationship (call them parent and child) and query the parent class with left-joined child with a restriction on a field of the child class, then the parent class's children collection is incorrectly initialized with a children list filtered by that restriction. Seems as incorrect optimization: Hibernate thinks the children collection is complete and initializes it from the query and caches it. If you replace LEFT_JOIN with INNER_JOIN, it works: the children collection is initialized in the moment it is first accessed by a separate query. But actually, in this case it has nothing to do with LEFT or INNER join, but with restrictions on the children association. See attached test case: run the Test class and see, that the children collection has only one item instead of three. Replace left join with inner and see that 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira