[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1930?page=c...
]
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira