[QueryTest|https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/test/java/org/hibernate/orm/test/jpa/query/QueryTest.java] fails on Sybase
{noformat}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){noformat}
because, unlike other databases, on Sybase the query
{code:sql}CREATE TABLE aa (c varchar null)
INSERT INTO aa VALUES (null)
SELECT * FROM aa WHERE c = null{code}
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|smart-link]) . We could skip them again but they pass with jdts driver and fail only with Sybase driver.
List of affected tests (there might be more):
{noformat}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{noformat} |
|
