Subject | strange behaviour on query |
---|---|
Author | martinknappe |
Post date | 2006-05-26T21:55:01Z |
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
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