Message Title

Martin Simka created an issue

Issue Type:	Bug
Assignee:	Unassigned
Components:	hibernate-core, testsuite
Created:	14/Mar/2023 08:26 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`
Fix Versions:	6.2.0
Priority:	Major
Reporter:	Martin Simka

CountExpressionTest.testCountDistinctTuple fails on Sybase

                                  java.lang.AssertionError: expected:<4> but was:<2>
        at org.junit.Assert.fail(Assert.java:89)
        at org.junit.Assert.failNotEquals(Assert.java:835)
        at org.junit.Assert.assertEquals(Assert.java:120)
        at org.junit.Assert.assertEquals(Assert.java:146)
        at org.hibernate.orm.test.query.hql.CountExpressionTest.lambda$testCountDistinctTuple$2(CountExpressionTest.java:107)
        at org.hibernate.testing.transaction.TransactionUtil.doInHibernate(TransactionUtil.java:371)
        at org.hibernate.orm.test.query.hql.CountExpressionTest.testCountDistinctTuple(CountExpressionTest.java:93)
                              

Executed SQL query is

                              select
    d1_0.id,
    count_big(distinct coalesce(nullif(coalesce(cast(l1_0.localized_KEY as varchar(16384)),char(0)),''),char(0)+'1')+char(0)+coalesce(nullif(coalesce(l1_0.localized,char(0)),''),char(0)+'2')) 
from
    Document d1_0 
left join
    (Document_Person c1_0 
join
    Person c1_1 
        on c1_1.id=c1_0.contacts_id) 
            on d1_0.id=c1_0.Document_id 
    left join
        Person_localized l1_0 
            on c1_1.id=l1_0.Person_id 
    group by
        d1_0.id
                              

Add Comment

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

This message was sent by Atlassian Jira