[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7229) hql converts to wrong sql: brackets trouble
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