[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-3329) HQL: NOT IN does not properly handle null

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 Assignee: Gail Badner 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')