Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
Hibernate 3.0.5

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi,
I'm just curious with this HQL statement

select (20 + 10) - (10 + 10) from BdpInTransitBlncItems A

In normal sql statement, this will result in 30 - 20 == 10, but the result from hql is 30. It is as if the parantheses dont work.

Please guide mee...

Here is the output after setting show_sql to true

Hibernate: select 100+10-10*10 as col_0_0_ from BDP_IN_TRANSIT_BLNC_ITEMS bdpintrans0_

I wonder why the parentheses supplied in hql are removed ? Is this the normal behaviour ? I tried out both OracleDialect and Orache9Dialect, and the results are the same. Is there a configuration stating that the parentheses' removal behaviour ?

Please, it's very urgent ... T-T

Bad Hibernate!

I'll fix it ;)

Fixed in CVS:

http://opensource.atlassian.com/project ... se/HHH-868

Hi,

That was quick !

Thanks alot !

^-^

Hi Guys,

I am using hibernate 3.1 beta 2. I found a similar parentheses related problem. My HQL looks something like:

select pb.person
from PersonBenefit pb
where
pb.person.app.id = :appKeyId and
( (pb.ben.code = :healthBenCd1 and pb.flag1 = :flagval1) or
(pb.ben.code = :healthBenCd2 and pb.flag1 = :flagval2 and pb.person.prsnFlag = :flagVal3) )

when Hibernate translates in HQL into SQL it strips off the inner parentheses. The where clause looks something like -

where..........
.........
pb.person.app.id = :appKeyId and
(pb.ben.code = :healthBenCd1 and pb.flag1 = :flagval1 or
pb.ben.code = :healthBenCd2 and pb.flag1 = :flagval2 and pb.person.prsnFlag = :flagVal3 )

Has anybody faced a similar problem? Thanks for your help

Hi... I have the same problem in a HQL query, Hibernate is eliminating the internal parenthesis... I see you could fix it, and I want to know how can I get that fix from CVS repository, or if I have to download the beta 2 to get the fix.

Thanks in advance