Subquery with multiple joins broken in 6.2.0. With 6.2.0.CR4 the SQL sub select with joins is correct.
But with 6.2.0.Final the left joins after the first left join becomes joins.
I tracked it down to https://hibernate.atlassian.net/browse/HHH-16396 . Removing commit https://github.com/hibernate/hibernate-orm/commit/fb174d19c7fd41e597af0664a6a10ed8d28b843b restores the functionality. |