[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1930) QuerySyntaxException "with-clause expressions did not reference from-clause element to which the with-clause was associated"

[Sandeep Tamhankar (JIRA)]

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

Sandeep Tamhankar commented on HHH-1930:
----------------------------------------

I have a different flavor of this bug:

select foo.id
from Foo foo left join foo.bar.baz b1 with b1.name = 'jack'

Assume 'bar' is of type 'Bar' and 'baz' is of type 'Baz'.  Hibernate knows how to traverse the relationships, but the code in HqlSqlWalker.handleWIthFragment yells because it thinks the 'from' node is a Bar, not a Baz.  The workaround is to do something like this:

select foo.id
from Foo foo inner join foo.bar as mybar left join mybar.baz b1 with b1.name = 'jack'


> QuerySyntaxException "with-clause expressions did not reference from-clause element to which the with-clause was associated"
> ----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HHH-1930
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1930
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: query-hql
>    Affects Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3
>            Reporter: Manfred Geiler
>
> In Version 3.1.2 the following "EventManager" HQL query worked fine:
>    select p from Person p join p.emailAddresses as email with email = 'xyz'
> and produced an SQL query like this:
>   select person0_.PERSON_ID as PERSON1_2_, person0_.age as age2_, person0_.firstname as firstname2_, person0_.lastname as lastname2_ 
>    from PERSON person0_ 
>    inner join PERSON_EMAIL_ADDR emailaddre1_ 
>     on person0_.PERSON_ID=emailaddre1_.PERSON_ID and (emailaddre1_.EMAIL_ADDR='xyz')
> From Version 3.1.3 on this HQL throws the following QuerySyntaxException:
> "with-clause expressions did not reference from-clause element to which the with-clause was associated"

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira