Message Title

Martin Simka created an issue

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

QueryTest 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) . 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
                              

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira