Restrictions.ne("field", value) creates incorrect SQL if value has a composite
key
----------------------------------------------------------------------------------
Key: HHH-3926
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3926
Project: Hibernate Core
Issue Type: Bug
Components: query-criteria
Affects Versions: 3.3.1
Environment: Hibernate 3.3.1.GA, Hibernate Annotations 3.4.0, J2EE SDK 5_05,
example is in HSQL, problem was originally found on oracle with hibernate 3.2.6.GA
Reporter: Thomas Dietmaier
Priority: Minor
Attachments: CompositeNotEqual.zip
When applying Restrictions.ne for a value object where the entity has a composite ID
Criteria ca = session.createCriteria(Container.class);
ca.add(Restrictions.ne("thing", a));
Hibernate generates the following SQL:
Hibernate: select this_.id as id1_1_, this_.thing_item as thing2_1_1_, this_.thing_tenant
as thing3_1_1_, thing2_.item as item0_0_, thing2_.tenant as tenant0_0_ from Container
this_ left outer join Thing thing2_ on this_.thing_item=thing2_.item and
this_.thing_tenant=thing2_.tenant where (this_.thing_item<>? and
this_.thing_tenant<>?)
... which should probably be
[...] where (this_.thing_item<>? OR this_.thing_tenant<>?)
sources attached
--
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