[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5041) @ManyToOne not working with @Formula

[Sharath Reddy (JIRA)]

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

Sharath Reddy commented on HHH-5041:
------------------------------------

Sorry, the generated SQL is:

select
        product0_.id as id9_1_,
        product0_.description as descript2_9_1_,
        product0_.product_idnf as product3_9_1_,
        SUBSTR(product0_.product_idnf,
        1,
        3) as formula13_1_,
        product1_.id as id9_0_,
        product1_.description as descript2_9_0_,
        product1_.product_idnf as product3_9_0_,
        SUBSTR(product1_.product_idnf,
        1,
        3) as formula13_0_ 
    from
        product product0_ 
    left outer join
        product product1_ 
            on SUBSTR(product0_.product_idnf,
        1,
        3)=product1_.product_idnf 
    where
        product0_.id=?

> @ManyToOne not working with @Formula
> ------------------------------------
>
>                 Key: HHH-5041
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5041
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: annotations
>    Affects Versions: 3.5.0-CR-2
>            Reporter: Chris Wilson
>         Attachments: HibernateAnnotationJoinOnFormulaTest.java
>
>
> HHH-4382 was marked as resolved fixed in 3.5. However, I cannot find the fix, and it appears still to be broken for me.
> The attached test case fails with 3.5.0-CR-2 just as it did with 3.3.2. It seems to ignore the @Formula annotation and simply create a productFamily column, which is of course empty.
> If I am doing something wrong, please could you tell me what it is, so that I can fix my code?

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