Subject strange behaviour on query
Author martinknappe
hello

i'm experiencing some very (to my mind) odd behaviour with firebird
1.5 with the following query:

select first 1 dic.id
from dicentries dic
inner join dskrptlink_dicentries dl on dic.id = dl.id_dicentry
inner join dskrpts d on dl.id_dskrpt = d.id
where d.asdskrpt = :asdskrptinput
and dic.id >= :idin
order by dic.id ascending

now, i KNOW that with :asdskrptinput set to '^' and :idin to 1, the
requested record id should be 1; however when i launch this query,
ibexpert starts to work and seems like it won't ever stop so that i
have to kill it
what's even odder is that when i change the last but one line to

"and dic.id = :idin" ('=' as opposed to '>=')

I get the desired result (which is 1 as i knew before) immediately.
The same when I comment out the whole line (the last but one i mean)

is that a bug? or am I not seeing the wood for trees?

thanx,

martin