[hibernate-issues] [Hibernate-JIRA] Created: (ANN-771) @Formula Subqueries as a table is not work

[solonote (JIRA)]

@Formula Subqueries as a table is not work
------------------------------------------

                 Key: ANN-771
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-771
             Project: Hibernate Annotations
          Issue Type: Bug
    Affects Versions: 3.4.0.GA
         Environment: oralce10g hibernate3 
            Reporter: solonote


......
public class xxx{
......
@Formula("(select boxL.box_count from (select rownum box_count,l.id lid from dp.letter l where l.box_id = box_id) boxL where boxL.lid=id)")
private Integer boxCountId;
.......
}

Hibernate: ....(select boxL.box_count from (select rownum this_.box_count,l.id this_.lid from dp.letter l where l.box_id = this_.box_id) this_.boxL where boxL.lid=this_.id) as formula0_6_....
this sql sentence is wrong

"select boxL.box_count from (select rownum box_count,l.id lid from dp.letter l where l.box_id = this_.box_id)) boxL where boxL.lid=this_.id"   <- this is correct.

please help me,thank you


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