Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzIxMjJjNDQ5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16269?atlOrigin=eyJpIjoiMzIxMj... ) HHH-16269 ( https://hibernate.atlassian.net/browse/HHH-16269?atlOrigin=eyJpIjoiMzIxMj... ) QueryTest.*null* fail on Sybase because WHERE c=null returns results ( https://hibernate.atlassian.net/browse/HHH-16269?atlOrigin=eyJpIjoiMzIxMj... ) Issue Type: Bug Affects Versions: 6.2.0.CR3 Assignee: Unassigned Components: testsuite Created: 08/Mar/2023 06:03 AM Environment: Hibernate ORM 6.2.0.CR3 + Sybase 16.0 + Sybase JDBC driver (jConnect (TM) for JDBC(TM)/16.0 SP04 PL03 (Build 27544) + extra connection parameters: `SQLINITSTRING=set quoted_identifier on&SQLINITSTRING=set ansinull on` Priority: Major Reporter: Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) QueryTest ( https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/t... ) fails on Sybase java.lang.AssertionError: expected:<0> but was:<1> at org.junit.Assert.fail(Assert.java:89) at org.junit.Assert.failNotEquals(Assert.java:835) at org.junit.Assert.assertEquals(Assert.java:647) at org.junit.Assert.assertEquals(Assert.java:633) at org.hibernate.orm.test.jpa.query.QueryTest.testNativeQueryNullNamedParameter(QueryTest.java:478) because, unlike other databases, on Sybase the query CREATE TABLE aa ( c varchar null ) INSERT INTO aa VALUES ( null ) SELECT * FROM aa WHERE c = null returns one row (it works the same as is null ). These tests were skipped before on Sybase ( https://hibernate.atlassian.net/browse/HHH-11332 ( https://hibernate.atlassian.net/browse/HHH-11332 ) ) . We could skip them again but they pass with jdts driver and only with Sybase driver. List of affected tests (there might be more): org.hibernate.orm.test.jpa.query.QueryTest.testNativeQueryNullNamedParameter org.hibernate.orm.test.jpa.query.QueryTest.testNativeQueryNullNamedParameterParameter org.hibernate.orm.test.jpa.query.QueryTest.testNativeQueryNullPositionalParameter org.hibernate.orm.test.jpa.query.QueryTest.testNativeQueryNullPositionalParameterParameter org.hibernate.orm.test.jpa.query.QueryTest.testNullNamedParameter org.hibernate.orm.test.jpa.query.QueryTest.testNullNamedParameterParameter org.hibernate.orm.test.jpa.query.QueryTest.testNullNamedParameterParameterIncompatible org.hibernate.orm.test.jpa.query.QueryTest.testNullPositionalParameter org.hibernate.orm.test.jpa.query.QueryTest.testNullPositionalParameterParameter org.hibernate.orm.test.jpa.query.QueryTest.testNullPositionalParameterParameterIncompatible ( https://hibernate.atlassian.net/browse/HHH-16269#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16269#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:c17c655 )