[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5045?page=c... ] Ray Fan updated HHH-5045: ------------------------- Attachment: IngresDialect.testConcatenation.svn.diff Updated org.hibernate.test.hql.HQLTest.testConcatenation to skip IngresDialect, but should pass with subsequent Ingres dialects. Modify concatenation operator in the Ingres9Dialect. -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5045?page=c... ] 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 "||". -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5045?page=c... ] Strong Liu resolved HHH-5045. ----------------------------- Assignee: Strong Liu Resolution: Fixed Fix Version/s: 3.5.x patch applied, thanks Ray :) -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira