When mapping a domain on getter methods, if a @Formula is not in order with the other get methods, Hibernate generates an AND statement for the formula ------------------------------------------------------------------------------------------------------------------------------------------------------- Key: HCANN-13 URL: http://opensource.atlassian.com/projects/hibernate/browse/HCANN-13 Project: Hibernate Commons Annotations Issue Type: Bug Environment: Oracle 10g, Hibernate 3 Reporter: Fabio Schmitz Tani When mapping a domain on getter methods, if a @Formula is not in order with the other get methods, Hibernate generates an AND statement for the formula. For example, a domain with 2 fields and a formula field: <code> private Integer id; private String text; private Integer countField; @Id @Column(name = "id") public Integer getId()... @Column(name = "text") public String getText()... public void setId(Integer id)... public void setText(String txt)... @Formula("(select count(*) from other table)") public Integer getCount()... public void setCount(Integer count).... </code> When searching with Criteria, Hibernate adds the Formula in the query as a requirement: select this_.id, this_.txt, (select count(*) from other table) as count from table this_ where id = ? and ((select count(*) from other table)=?) -- 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