Martin Simka (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) *updated* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTc1ZjM5ZGQ4...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-16269?atlOrigin=eyJpIjoiNTc1Zj...
) HHH-16269 (
https://hibernate.atlassian.net/browse/HHH-16269?atlOrigin=eyJpIjoiNTc1Zj...
) QueryTest.*null* fail on Sybase because WHERE c=null returns results (
https://hibernate.atlassian.net/browse/HHH-16269?atlOrigin=eyJpIjoiNTc1Zj...
)
Change By: Martin Simka (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
)
[
QueryTest|https://github.com/hibernate/hibernate-orm/blob/main/hibernate-...]
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.atlass...])
. 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}
(
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 )