many-to-many faulty delete optimization when filter in use ---------------------------------------------------------- Key: HHH-548 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-548 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.0.3 Environment: Hibernate 3.0.3 (standalone from a JUnit test) Reporter: Vincent Giguère Assignee: Gavin King Fix For: 3.1 beta 1 Read post on forum: http://forum.hibernate.org/viewtopic.php?t=943013 There is a faulty optimization for many-to-many delete statements when filters are in use. If a xxx-to-many association is loaded with filters turned on, that we remove every object from the association and then persist the parent object (with cascade on childs), the child delete SQL statement issued is: delete from association_table where parent_id=? This is not accurate since other associated childs might not have been loaded at first (and hence not deleted) because a filter was up. The filter should probably be applied to the child table on the delete as well. Regards, Vincent Giguère