Hibernate version: 3.0.5

My HQL query:

from com.reservit.plannit.data.bo.inventory.EngCatInventoryBO as EngCatInventory where NOT ( ( EngCatInventory.fromdate > ? ) OR ( EngCatInventory.todate < ? ) ) AND ( ( EngCatInventory.roomcategory = ? ) )

is translated into SQL code:

select engcatinve0_.id as id, engcatinve0_.partid as partid21_, engcatinve0_.fromdate as fromdate21_, engcatinve0_.todate as todate21_, engcatinve0_.roomcategory as roomcate5_21_, engcatinve0_.engallotment as engallot6_21_ from engcatinventory engcatinve0_ where engcatinve0_.fromdate<=? and engcatinve0_.todate>=? and engcatinve0_.roomcategory=?

as you can see:
the NOT was dropped
the date compare are not correct (< substitute to <= and > to >=)

objets returns when this query is executed are of course not correct

What happens? is it a bug?

Umm...what I can see from your HQL and the generated SQL output seems to be 100 per cent correct.



corresponds to



Best regards
Sven

Why do you think that result are incorrect? Hibernate just simplified your condition to equivalent one.

Your condition:

not (x>? or y<?) and z=?


Hibernate:

x<=? and y>=? and z=?


On which data they are evaluated differently?

well i understand where is the problem
in fact this is not a OR but a XOR.
because begin date is always before end date
on my db, if i execute the SQL request, good results are returns
hibernate change my request using pure boolean algebric rules.

So, you try to emulate XOR? Can you show example of your data and what select returns in both cases? This should be good test case for Hibernate team.

I seem to recall from high school that !(a&b) <=> !a|!b

;-)

Sorry, I still don't understand what should be wrong.
You wrote:


That's not true. Look at what you've written.

If you still think it's incorrect post your SQL statement which works on your database and the corresponding query in HQL you're using.

Best regards
Sven