[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1419) Update + Exists doesn't seem to work

Update + Exists doesn't seem to work ------------------------------------ Key: HHH-1419 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1419 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.1.1 Reporter: Bill Burke Assignee: Steve Ebersole Fix For: 3.2.0.alpha1, 3.1.3 Attachments: ex09_1.zip Don't know if this is me or not but this query doesn't seem to work with the many to many relationship between reservation and customer: Query query; query = manager.createQuery("UPDATE Reservation res " + "SET res.amountPaid = (res.amountPaid + 10) " + "WHERE EXISTS (" + "SELECT c FROM res.customers c " + "where c.firstName = 'Bill' and " + "c.lastName='Burke')"); query.executeUpdate();