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

[Vladimir Strugatsky (JIRA)]

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
        Type: Bug

  Components: query-criteria  
    Versions: 3.1.2    
 Environment: 3.1.2 against MySQL 5.0 and Oracle 9i
    Reporter: Vladimir Strugatsky


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!

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira