[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-879) Enable joining the same association twice with Criteria

[Simon Neilson (JIRA)]

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

Simon Neilson commented on HHH-879:
-----------------------------------

To help illustrate my previous comment, here is some example SQL generated from a criteria using sub-selects (on T_METER_PROPS) instead of multiple joins.

{code}
    select
        this_.*
    from
        T_METER this_ 
    where          
	    exists (
		select
		    p_.F_MP_FK_M_ID as y0_ 
		from
		    T_METER_PROPS p_ 
		where
		    p_.F_MP_FK_M_ID=this_.F_M_ID 
		    and p_.F_MP_FK_AP_ID=? 
		    and p_.F_MP_VALUE=?
	    ) 
	    or exists (
		select
		    p_.F_MP_FK_M_ID as y0_ 
		from
		    T_METER_PROPS p_ 
		where
		    p_.F_MP_FK_M_ID=this_.F_M_ID 
		    and p_.F_MP_FK_AP_ID=? 
		    and p_.F_MP_VALUE=?
	    )
{code}

> Enable joining the same association twice with Criteria
> -------------------------------------------------------
>
>                 Key: HHH-879
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-879
>             Project: Hibernate Core
>          Issue Type: Improvement
>          Components: core
>            Reporter: Vladimir Bayanov
>
> Make double joining the same association with Criteria.createCriteria possible. See: http://forum.hibernate.org/viewtopic.php?t=931249

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