Hibernate version: 3.2.4SP1 with 3.3.1GA EntityManager and 3.3.0GA Annotations

Name and version of the database you are using: Postgresql 8.2

The generated SQL (show_sql=true):
update PERSON set NAME=? where (ID in (select company1_.ID from COMPANY company1_ )) and person0_.NAME<>?


I think I've found a bug in the SQL generation for update queries in EJBQL.

My query is:
update Person set name = ?1 where id in (select c.id from Customer c)
and name <> ?2

The generated SQL refers to an unknown table alias "person0_".

If I change around the conditions in the where clause, then the problem goes away. That is:

update Person set name = ?1 where name <> ?2 and id in (select c.id from Customer c)

does not generate bad code.

Also, if I add a where clause to the inner select, then the problem also goes away.

Finally, correct SQL is generated in the matching select.

Is this a known bug? Or should I add it to JIRA?

Please add it to JIRA in the Hibernate3 project.
A test case would be apreciated.

I added this issue to JIRA:

http://opensource.atlassian.com/projects/hibernate/browse/HHH-2724

The test classes are about as small as I could make them. Best of luck solving the problem.