We're updating the issue view to help you get more done. 

hql parsed with exception (with clause)

Description

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.

Environment

None

Status

Assignee

Unassigned

Reporter

Tomasz Bech

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

3.5.3
3.1.3

Priority

Major