Subject Re: [ib-support] Strange query results, based on where clause
Author Claudio Valderrama C.
""Ann W. Harrison"" <aharrison@...> wrote in message
news:5.1.0.14.2.20020301142510.02b97aa0@......
> Fred,
>
> Thanks. Now we just have to decide whether this is
> an old familiar neighborhood bug that we can ignore for
> Firebird1, or whether it needs to be fixed. At least
> we didn't put it in.

It's so old that there's even one or two entries on our tracker. Comparisons
are flexible when they aren't indexed. When the index is used, comparison is
rigorous. Nothing new since IB4.0.

Futhermore, dialect 3 was supposed to stop some implicit conversions from
string to number but I don't see how they apply. I don't see any difference
when compared to the old behavior.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing