HQL "not in" generatad wrong SQL -------------------------------- Key: HHH-1106 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1106 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.0.5 Environment: 3.0.5, DB2 Reporter: Jarle Rudihagen Assignee: Gavin King Fix For: 3.1 rc3 HQL: select distinct soknadLinjeDO.soknadDO.soknId from SoknadLinjeDO as soknadLinjeDO where soknadLinjeDO.soknStatKode in (<list of code params>) and not (soknadLinjeDO.grKombKode in (<list of code params>) and soknadLinjeDO.soknadDO.soknGrKode = :PARAM) Generates SQL: select distinct soknadlinj0_.SOKN_ID as col_0_0_ from T_SOKNAD_LINJE soknadlinj0_, T_SOKNAD soknaddo1_ where soknadlinj0_.SOKN_ID=soknaddo1_.SOKN_ID and (soknadlinj0_.SOKN_STAT_KODE in (?,?,?.....)) and (soknadlinj0_.GR_KOMB_KODE in (?, ?.....) or soknaddo1_.SOKN_GR_KODE<>?) Here the problem is that it negates the "not in" clause and forgets to put in the "not in" in the following soknadlinj0_.GR_KOMB_KODE in (?, ?.....). There is one to many relationship between SoknadDO and SoknadLinjeDO.