[hibernate-issues] [Hibernate-JIRA] Created: (HHH-5045) org.hibernate.test.hql.HQLTest failure running testConcatenation with Ingres

[Ray Fan (JIRA)]

org.hibernate.test.hql.HQLTest failure running testConcatenation with Ingres
----------------------------------------------------------------------------

                 Key: HHH-5045
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5045
             Project: Hibernate Core
          Issue Type: Bug
          Components: core, testsuite
    Affects Versions: 3.5.0-CR-2
         Environment: Hibernate 3.5.0-CR-2, Ingres 9.3.1 (int.lnx/106), Ingres9Dialect
            Reporter: Ray Fan
            Priority: Minor


Assertion failure in testConcatenate:
{noformat}
<failure message="SQL is not the same as the old SQL (scalar=true) expected:<...(lower(upper('foo')||upper(?))like 'f%' )> but was:<...lower((upper('foo')+upper(?))) like 'f%'>" type="junit.framework.ComparisonFailure">junit.framework.ComparisonFailure: SQL is not the same as the old SQL (scalar=true) expected:<...(lower(upper('foo')||upper(?))like 'f%' )> but was:<...lower((upper('foo')+upper(?))) like 'f%'>
    at junit.framework.Assert.assertEquals(Assert.java:81)
    at org.hibernate.test.hql.QueryTranslatorTestCase.assertSQLEquals(QueryTranslatorTestCase.java:315)
    at org.hibernate.test.hql.QueryTranslatorTestCase.checkSql(QueryTranslatorTestCase.java:304)
    at org.hibernate.test.hql.QueryTranslatorTestCase.assertTranslation(QueryTranslatorTestCase.java:194)
    at org.hibernate.test.hql.QueryTranslatorTestCase.assertTranslation(QueryTranslatorTestCase.java:120)
    at org.hibernate.test.hql.QueryTranslatorTestCase.assertTranslation(QueryTranslatorTestCase.java:102)
    at org.hibernate.test.hql.HQLTest.testExpressionWithParamInFunction(HQLTest.java:241)
</failure>
{noformat}

The character used as the concatenation operator is specified as '+' in the IngresDialect although Ingres supports both '+' and "||".

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira