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

[Ray Fan (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=35792#action_35792 ] 

Ray Fan commented on HHH-4979:
------------------------------

I've implemented an override for getCastTypeName using your suggestion and attaching the patch.
The test still fails but due to differences in the lower order decimal places, probably caused by floating point discrepancies.
{noformat}
<failure message="expected:<12.399999618530273> but was:<12.399999618530300>" type="junit.framework.AssertionFailedError">junit.framework.AssertionFailedError: expected:<12.399999618530273> but was:<12.399999618530300>
    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}



> 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
>
>
> 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.

-- 
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