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

[Nivedan (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=43957#comment-43957 ] 

Nivedan commented on HHH-1673:
------------------------------

Hi Team,
Is this resolved as yet?

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

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira