[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-1657) hql update generate wrong sql with joined subclass hierarcy

hql update generate wrong sql with joined subclass hierarcy ----------------------------------------------------------- Key: HHH-1657 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1657 Project: Hibernate Core Issue Type: Bug Components: query-hql Environment: Hibernate 3.2.0cr1, Hibernate 3.1.3 Reporter: Alexey Romanchuk Assignee: Gail Badner Let suppose that we have two joined subclass entities: Parent (id PK) and Child (id PK) that mapped with joined subclass method. When I try to update Child by id with hql: update Child c set c.field = 'value' where c.id = 1234 hibernate generates joined tables like insert into HT_parent select child0_.id as id from child child0_ inner join parent child0_1_ on child0_.id=child0_1_.id wher id in = 1234 look at last condition. hibernate use id WITH OUT tables alias that cause sql exception: column reference "id" is ambiguous