[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2423) Restrictions.isEmpty ignores where clause defined in the one-to-many collection mapping

Restrictions.isEmpty ignores where clause defined in the one-to-many collection mapping --------------------------------------------------------------------------------------- Key: HHH-2423 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2423 Project: Hibernate3 Issue Type: Bug Components: query-criteria Affects Versions: 3.1.2 Environment: 3.1.2 against MySQL 5.0 and Oracle 9i Reporter: Vladimir Strugatsky Attachments: AbstractEmptinessExpression.java.patch, OneToManyPersister.java.patch In hbm.xml file: <bag name="issueContextRelationships" lazy="true" inverse="true" cascade="all-delete-orphan" where="SOURCE_SCREEN_NAME='Issue'" > <key column="ID_XXX" > </key> <one-to-many class="com.complianceandrisks.c2p.model.compliancehierarchy.IssueContextRelationship" /> </bag> Using the criteria: criteria.add(Restrictions.isEmpty("issueContextRelationships")); Generates the query: where not exists (select 1 from CONTEXT_REFERENCE_RELS where this_.ID_XXX=ID_XXX) but the SOURCE_SCREEN_NAME='Issue' is not generated!