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

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole updated HHH-5045:
--------------------------------

    Description: 
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 "||".

  was:
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 "||".


> 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
>         Attachments: IngresDialect.testConcatenation.svn.diff
>
>
> 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