@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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira