[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-873) referencing raw HQL FromElement alias outide the from clause of update and delete statements generates incorrect sql

referencing raw HQL FromElement alias outide the from clause of update and delete statements generates incorrect sql -------------------------------------------------------------------------------------------------------------------- Key: HHH-873 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-873 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.0.5 Environment: 2.6.11-gentoo-r4 sun-jdk-1.5.0.04 jboss-4.0.3RC1 (I guess 3.1alpha1) postgresql-8.0.3 jdbc3-postgresql-7.4.5 Reporter: Emmanuel Bernard Assignee: Steve Ebersole Fix For: 3.1 rc 1 Move from http://jira.jboss.com/jira/browse/EJBTHREE-259 Two very simple entities one owns the other with OneToOne Cascade=ALL relation. @Entity E1 @id AUTO long id @OneToOne(Cascade=ALL) E2 e2 @Entity E2 @id AUTO long id This HQL is intended to delete all orphan e2 entities. HQL : "delete from E2 e2 where e2 not in (select e1.e2 from E1 e1 where e1.e2 is not null)" it generates on postgresql "delete from E2 where e2x0_.id not in (select e2_id from E1 e1x1_ where e2x_id is not null)" which misses the E2 table alias and fails with "relation e2x0_ does not exist". If I use instead HQL : "delete from E2 e2 where e2.id not in (select e1.e2.id from E1 e1 where e1.e2 is not null)" then it generates: "delete from E2 where id not in (select e2_id from E1 e1x1_ where e2x_id is not null)" which does not access id by table alias and succeeds. I guess table aliases are not always correctly generated