[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4979) org.hibernate.test.hql.ASTParserLoadingTest failure running testCastInSelect with Ingres

org.hibernate.test.hql.ASTParserLoadingTest failure running testCastInSelect with Ingres ---------------------------------------------------------------------------------------- Key: HHH-4979 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4979 Project: Hibernate Core Issue Type: Bug Components: testsuite Affects Versions: 3.5.0-CR-2 Environment: Hibernate 3.5.0-CR, Ingres 9.3.1 (int.lnx/106), Ingres9Dialect mysql 51, posgresql 837 Reporter: Ray Fan Assignee: Steve Ebersole Priority: Minor Attachments: hql-astparserloadingtest.zip, IngresDialect.testCastInSelect.svn.diff Time Spent: 3 hours, 35 minutes Remaining Estimate: 0 minutes Assertion failure executing testCastInSelect from org.hibernate.test.hql.ASTParserLoadingTest with Ingres. {noformat} <failure message="expected:<12.399999618530273> but was:<12.39>" type="junit.framework.AssertionFailedError"> junit.framework.AssertionFailedError: expected:<12.399999618530273> but was:<12.39>; at junit.framework.Assert.fail(Assert.java:47) at junit.framework.Assert.failNotEquals(Assert.java:282) at junit.framework.Assert.assertEquals(Assert.java:64) at junit.framework.Assert.assertEquals(Assert.java:71) at org.hibernate.test.hql.ASTParserLoadingTest.testCastInSelect(ASTParserLoadingTest.java:1291) </failure>{noformat} The generated SQL from the HQL query taken from the output log is {noformat} 08:17:30,536 DEBUG QueryTranslatorImpl:241 - HQL: select cast(bodyWeight as big_decimal) from org.hibernate.test.hql.Animal 08:17:30,536 DEBUG QueryTranslatorImpl:242 - SQL: select cast(animal0_.body_weight as decimal(19, 2)) as col_0_0_ from Animal animal0_ Hibernate: select cast(animal0_.body_weight as decimal(19, 2)) as col_0_0_ from Animal animal0_ 08:17:30,701 INFO SessionFactoryImpl:908 - closing {noformat} The returned value from the query with a decimal(19,2) target data type is correct.