Message Title

HHH-9329

In contrast to what happened in 4.2.7.SP1 and below, this solution would also allow something like

 
                                                    SELECT 
	d.id 
FROM 
	Document d 
LEFT JOIN 
	d.contacts c 
		WITH KEY(c) = c.id
 
                                                

as the generated SQL would look like

 
                                                    select
	document0_.id as col_0_0_ 
from
	Document document0_ 
left outer join
	Document_Person contacts1_ 
		on document0_.id=contacts1_.Document_id 
left outer join
	Person person2_ 
		on contacts1_.contacts_id=person2_.id 
		and (
			contacts1_.position=person2_.id
		)
where
	person2_.id IS NOT NULL
 
                                                

Add Comment

This message was sent by Atlassian JIRA