Inequality operator (<>) on component/composite-id uses AND instead of OR between atomic fields comparison ---------------------------------------------------------------------------------------------------------- Key: HHH-5886 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5886 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.2.7 Environment: 3.2.7GA, jetty, H2/oracle 11g/DB2 v9 Reporter: Paizo As described here: [https://forum.hibernate.org/viewtopic.php?f=1&t=1009229&start=0] given this mapping snippet: {quote} <class name="d.p.entityIDMUnit.lim.bl.pom.impl.PPKone" table="PPKone"> <composite-id> <key-property name="i" type="IntegerType"> <column name="c_i_5b145" precision="19" scale="0"/> </key-property> <key-property name="j" type="IntegerType"> <column name="c_j_4534d" precision="19" scale="0"/> </key-property> </composite-id> ... {quote} and the following HQL: from d.p.entityIDMUnit.lim.bl.pom.impl.PPKone p where (( ( p <> p ) and ( p.i = 1 ) )) The SQL where statement looks: where *ppkone0_.c_i_5b145<>ppkone0_.c_i_5b145 {color:red} and {color} ppkone0_.c_j_4534d<>ppkone0_.c_j_4534d* and ppkone0_.c_i_5b145=1 when it should be: *{color:red}({color}ppkone0_.c_i_5b145<>ppkone0_.c_i_5b145 {color:red} OR {color} ppkone0_.c_j_4534d<>ppkone0_.c_j_4534d{color:red}){color}* or ppkone0_.c_i_5b145=1 A component/composite-id is different from another one if at least ONE of its fields is different, not only when all the fields are different -- 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