HQL: NOT IN does not properly handle null ----------------------------------------- Key: HHH-3329 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3329 Project: Hibernate3 Issue Type: Bug Components: query-hql Affects Versions: 3.2.6 Environment: Hypersonic SQL Reporter: Thom Hehl Priority: Minor I have a nullable integer column in my DB represented by a property with a type of Integer. I want to write a query against this column such as WHERE part.pendingIndicator NOT IN ('1', '2', '3', '4') But this does not return rows in which pendingIndicator is null. I have to include null separately such as: WHERE part.pendingIndicator IS NULL OR part.pendingIndicator NOT IN ('1', '2', '3', '4') -- 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