Subject Re: Strange query results, based on where clause
Author alex_vnru
--- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:
> 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.

Ann, imHo implicit type convertion is nasty invention. It provided
me some gray hairs in times of PL/1. I think the best is to detect
syntax error when incompatible types, such as Char and any digit type,
are used in one expression or are compared without explicit Cast. If
so, this situation would be evident for Bob himself - he would be
forced to add leading '0's by simply logic. But backward
compatibility... In any case, personally I think it's not a reason to
delay FB1 release, accurate programmer can avoid such a troubles just
knowing about it.

Best regards, Alexander V.Nevsky.