Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16216 ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiYjUxOD... ) Re: @Query creates additional not null checks for SybaseASEDialect ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiYjUxOD... ) Since you mentioned H5.6, just wanted to add that previously, in Hibernate 5 the "ansinull" setting was not considered, so the semantics of the = operator were dependent on the database settings. With Hibernate 6, the setting is read on startup to determine how to render predicates, so that the semantics of HQL are adhered. The thing you want is the so called "distinct from" predicate, which treats null = null as true. ( https://hibernate.atlassian.net/browse/HHH-16216#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16216#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100217- sha1:58f696e )