[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2049) LEFT OUTER JOIN subcriteria filters children

[Douglas Ferguson (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=37128#action_37128 ] 

Douglas Ferguson commented on HHH-2049:
---------------------------------------

We have a library that uses the criteria api to build up a pretty complicated filter. We had a change in our data model recently that requires us to use a "left join on id1 = id2 AND id1 = ?" 

Is there a way to accomplish this with the criteria api? 

If not, if we were going to create a patch or some how create an workaround, can anybody point us in the right direction?

> LEFT OUTER JOIN subcriteria filters children
> --------------------------------------------
>
>                 Key: HHH-2049
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2049
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: query-criteria
>    Affects Versions: 3.1.3, 3.2.0.cr4
>         Environment: Hibernate 3.1.3/3.2.0rc4, hsqldb 1.8
>            Reporter: Mattias Jiderhamn
>         Attachments: SubCriteriaTestCase.zip
>
>
> When using the Criteria API with LEFT OUTER JOIN to add criterias to the children, i.e.
>   criteria.createCriteria("children", JoinFragment.LEFT_OUTER_JOIN)
> the child collections will only contain those children matching the criteria. (Even when *not* using any Filters).
> The attached testcase (also found here: http://forum.hibernate.org/viewtopic.php?p=2320786) will explain it in more detail.

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