Hi all
I have 2 date ranges startDate and endDate
I need to write an HQL that covers 4 conditions:
1. The range between startDate and endDate.
2. A range that can start before the startDate and can finish after the endDate.
3. A range that can start before the startDate and finishes in range (between) the startDate and endDate
4. A range that can start after the startDate and earlier than (between) the endDate and finishes after the endDate

The problem that HQL drops the parentheses after the 'or' and 'and'
See query:

from Entity
where myVal in (:myVal)
and
// The range between startDate and endDate.
//equivalent to between
(
startDate>= to_date(:startDate, 'dd/mm/yyyy')
and
endDate <= to_date(:endDate , 'dd/mm/yyyy')
)
Or
// A range that can start before the startDate and can finish after the endDate
(
startDate < to_date(:startDate, 'dd/mm/yyyy')
and
endDate > to_date(:endDate , 'dd/mm/yyyy')

)
Or
// A range that can start before the startDate and finishes in range (between) //the startDate and endDate

(
startDate < to_date(:startDate, 'dd/mm/yyyy')
and

(
endDate > to_date(:startDate , 'dd/mm/yyyy')
and
endDate< to_date(:startDate , 'dd/mm/yyyy')
)
)



Or
// A range that can start after the startDate and earlier than
//(between)the
//endDate //and finishes after the endDate
(
startDate> to_date(:startDate , 'dd/mm/yyyy')
and
startDate< to_date(:endDate , 'dd/mm/yyyy')

)
and
endDate>:endDate
)
)

How can I write the HQL without 'losing ' parentheses?

See HHH-550.


AND has a higher precendence than OR according to the SQL standard and all major databases.