org.hibernate.test.hql.ASTParserLoadingTest failure running testStr with Ingres -------------------------------------------------------------------------------- Key: HHH-4998 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4998 Project: Hibernate Core Issue Type: Bug Components: query-hql, testsuite Affects Versions: 3.5.0-CR-2 Environment: Hibernate 3.5.0-CR-2, Ingres 9.3.1 (int.lnx/106), IngresDialect Reporter: Ray Fan Priority: Minor Attachments: hql-astparserloadingtest.zip Assertion failure during testStr in hql ASTParserLoadingTest {noformat} <failure message="expected:<...> but was:<... >" type="junit.framework.ComparisonFailure">junit.framework.ComparisonFailure: expected:<...> but was:<... > at junit.framework.Assert.assertEquals(Assert.java:81) at junit.framework.Assert.assertEquals(Assert.java:87) at org.hibernate.test.hql.ASTParserLoadingTest.testStr(ASTParserLoadingTest.java:1593) </failure> {noformat} The generated SQL query {noformat} select (cast(year(current_date) as char)+'-'+cast(month(current_date) as char)+'-'+cast(day(current_date) as char)) as col_0_0_ from Animal animal0_ {noformat} The cast to char produces space padded values causing the failure. -- 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