[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3335?page=c...
]
Gail Badner commented on HHH-3335:
----------------------------------
This issue duplicates HHH-1657. Please consider contributing the test cases requested in
HHH-1657 to help get this issue resolved.
Details for the test cases I am requesting are at
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1657#action... .
I know that there is a lot of interest in getting this issue resolved. Is anyone willing
to contribute one or more of the test cases? If so, please add a comment to HHH-1657 to
indicate which you will work on.
Thanks,
Gail
HQL DELETE with sub-select creates invalid SQL
----------------------------------------------
Key: HHH-3335
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3335
Project: Hibernate3
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.6
Environment: Oracle 10, Java 1.5
Reporter: John Baker
Assignee: Gail Badner
Hello,
Consider two objects, ISSO and Event, where ISSO extends Event and the id is called
eventId (maps to variable id). Event also has an attribute time. Now consider this HQL:
delete from ISSO e where e.id in (select ev.id from Event ev where ev.time < 123)
I appreciate this could be written without the subselect but I've simplified a more
complex subselect in order to demonstrate the problem. This generates SQL that results in
the following Oracle error:
ORA-00918: column ambiguously defined
The SQL generated is as follows:
insert into HT_ISSO select isso0_.eventId as eventId from ISSO isso0_ inner join Event
isso0_1_ on isso0_.eventId=isso0_1_.eventId
where eventId in (select event1_.eventId from Event event1_ where event1_.time<23)
And the problem is the eventId following where. This should be using the alias, i.e. the
SQL should be:
insert into HT_ISSO select isso0_.eventId as eventId from ISSO isso0_ inner join Event
isso0_1_ on isso0_.eventId=isso0_1_.eventId
where isso0_.eventId in (select event1_.eventId from Event event1_ where
event1_.time<23)
That's it! Can this be fixed?
Thanks.
--
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