Message Title

HHH-9329

Well the KEY-part is probably more appropriate in the collection table join, but usages of non-id attributes like c.name must obviously come after the target table join.
When using attributes like c.name I think the only possible solution would be to join like this

 
                                                    select
	document0_.id as col_0_0_ 
from
	Document document0_ 
left outer join
(
	select 
		*
	from
		Document_Person contacts1_ 
	left outer join
		Person person2_ 
			on contacts1_.contacts_id=person2_.id 
			and (
				/* The condition of the with clause */
				contacts1_.position=person2_.id
			)
	) contacts2_
		on document0_.id=contacts2_.Document_id 
where
	person2_.id IS NOT NULL
 
                                                

Add Comment

This message was sent by Atlassian JIRA