The 'improvement' bug fix: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1520
has broken working functionality:
I found that after switching to 3.1.3 following construction is not working any longer:
(FootnoteTypeBO has collection 'descriptions' and reference to languageBO)
from FootnoteTypeBO as o
left outer join o.descriptions as t1
with (t1.language in (select loid from LanguageBO where name = 'aa'))
--> exception: 'with-clause referenced two different from-clause elements'.
There is no implicit join as dewscribed in main anomaly, so it shouldn't cause the problem. So now there is no way to write correct hql/sql, and I don't see any workaround.