[Hibernate-JIRA] Created: (HHH-2423) Restrictions.isEmpty ignores where clause defined in the one-to-many collection mapping
3:50 a.m.
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
3:29 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2423) Restrictions.isEmpty ignores where clause defined in the one-to-many collection mapping
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2423?page=c...
]
Vladimir Strugatsky commented on HHH-2423:
------------------------------------------
We want to come up with a fix for this problem. Can someone from the Hibernate team point
us to the right place in the Hibernate code?
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
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:20 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2423) Restrictions.isEmpty ignores where clause defined in the one-to-many collection mapping
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2423?page=c...
]
Tsuyoshi Goto updated HHH-2423:
-------------------------------
Attachment: OneToManyPersister.java.patch
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!
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:20 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2423) Restrictions.isEmpty ignores where clause defined in the one-to-many collection mapping
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2423?page=c...
]
Tsuyoshi Goto updated HHH-2423:
-------------------------------
Attachment: AbstractEmptinessExpression.java.patch
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!
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:20 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2423) Restrictions.isEmpty ignores where clause defined in the one-to-many collection mapping
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2423?page=c...
]
Tsuyoshi Goto commented on HHH-2423:
------------------------------------
Dear Hiernate developers,
I am a developer working for Vladimir above and tried to fix this bug a few days ago.
I will attach patch files created by WinMerge.
As you see I made an additional access method on OneToManyPersister.java that can be a
'hack' and a propery way should may exists through existing methods but I did not
look into details... So if you could check this point then it would become safer although
I can not see any situations that may give a wrong String for this case.
Best Regards,
Tsuyoshi
7.19.2007.
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!
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6192
days inactive
6349
days old
hibernate-issues@lists.jboss.org
4 comments
2 participants
participants (2)
-
Tsuyoshi Goto (JIRA) -
Vladimir Strugatsky (JIRA)