[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1673) hql parsed with exception (with clause)

hql parsed with exception (with clause) --------------------------------------- Key: HHH-1673 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1673 Project: Hibernate3 Issue Type: Deprecation Components: query-hql Affects Versions: 3.1.3 Reporter: Tomasz Bech Attachments: HHH-1673.patch, HHH-1673.patch 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.