hi,

I have had weird problem creating a query with HQL.


DEBUG - HQL: select myThing from MyClass where .. <clauses that work> AND ( ( foo1 <> (:value1) AND foo1 < (:value2) ) OR ( foo1 = (:value1) AND foo2 < (:value3) ) )

maps to:

DEBUG - SQL: select myThing as col_0_0_ from myclass_table where .. <clauses that work> and (foo1<>? and foo1<? or foo1=? and foo2<?)

So there is couple () missing and whole query loses it's meaning.

Same kind of thing works corretly with Criteria if I create two 'AND' clauses as Criterion and put them to criteria with Restrictions.or(criterionA, criterionB).

So my question is: Is this really a bug or am I doing something wrong? Do I have to add something to query so it maps HQL to SQL way I want it to map with those () marks on right place.

The translation seems correct. Comparisons are evaluated before AND:s that are evaluated before OR:s so the parenthesis should not be needed.

Yes, comparsions are evaluated before. But OR is for those two different AND:s. Without parenthesis OR is only for foo1<(:value2) and foo1=(:value1) clauses which I do not intent. It gives whole different output with or without parenthesis.

If I get query from using criteria I get this:

DEBUG - select myThing as col_0_0_ from myclass_table where .. <clauses that work> and ((foo1<>? and foo1<?) or (foo1=? and foo2<?))

So parenthesis are on their place.

If it is so, then your database is different from all other databases and programming languages I know of.



is equivalent to



not