hql converts to wrong sql: brackets trouble ------------------------------------------- Key: HHH-7229 URL: https://hibernate.onjira.com/browse/HHH-7229 Project: Hibernate ORM Issue Type: Bug Components: query-hql Affects Versions: 4.1.0 Environment: Mac 10.7.3 Java(TM) SE Runtime Environment (build 1.6.0_29-b11-402-11D50b) Java HotSpot(TM) 64-Bit Server VM (build 20.4-b02-402, mixed mode) hibernate+jpa+spring org.hibernate.javax.persistence:hibernate-jpa-2.0-api:1.0.1.Final postgresql 8.4-701.jdbc4 Reporter: Anton P. Original: /* select count(*) from PrivateMessage model where ( ( model.senderDelete=:w3 and model.owner=:w4 ) or ( model.recipientDelete=:w6 and model.to=:w7 ) ) and ( lower(model.message) like :w9 or ( lower(model.owner.name) like :w11 or lower(model.to.name) like :w12 ) ) */ select count(*) as col_0_0_ from PRIVATE_MESSAGES privatemes0_ inner join MESSAGES privatemes0_1_ on privatemes0_.id=privatemes0_1_.id cross join USERS user1_ cross join USERS user2_ where privatemes0_1_.OWNER=user1_.id and privatemes0_.TO_USER_ID=user2_.id and ( privatemes0_.SENDER_DELETE=? and privatemes0_1_.OWNER=? or privatemes0_.RECIPIENT_DELETE=? and privatemes0_.TO_USER_ID=? ) and ( lower(privatemes0_1_.MSG) like ? or lower(user1_.NAME) like ? or lower(user2_.NAME) like ? ) limit ? But SHOULD be: select count(*) as col_0_0_ from PRIVATE_MESSAGES privatemes0_ inner join MESSAGES privatemes0_1_ on privatemes0_.id=privatemes0_1_.id cross join USERS user1_ cross join USERS user2_ where privatemes0_1_.OWNER=user1_.id and privatemes0_.TO_USER_ID=user2_.id and ( (privatemes0_.SENDER_DELETE=? and privatemes0_1_.OWNER=?) (or privatemes0_.RECIPIENT_DELETE=? and privatemes0_.TO_USER_ID=?) ) and ( lower(privatemes0_1_.MSG) like ? or lower(user1_.NAME) like ? or lower(user2_.NAME) like ? ) limit ? -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira