select max(m.d_kinhshs)
from kinas m
where m.am_asqenh = :p_am_asqenh
and m.c_eid_kin != 'DNSN'
and (
(m.d_kinhshs < :p_d_syntagh)
or
(m.d_kinhshs <= :l_d_ews and
m.c_eid_kin != 'EXAG' )
)
the part that gives me a hard time is the part between the
parentheses
(
(m.d_kinhshs < :p_d_syntagh)
or
(m.d_kinhshs <= :l_d_ews and
m.c_eid_kin != 'EXAG' )
)
If I take the two outer parentheses off, then the query runs to
completion but I really do not want to do that since it will change
the precedence of the operators and will get wrong results back.
It probably has to do something with the nesting depth of the WHERE
clause ??
The query runs successfully AS-IS in II 9.2.0 (int.lnx/118)NPTL but it
gives me that error when run under II 9.2.0 (i64.hpu/143) which has
also patch 13830 applied.
Is there an issue after patch 13830 related to this case?