Subject Re: [firebird-support] Re: expression evaluation not supported (FIREBIRD 2.0 RC3)
Author Dmitry Yemanov
"skander_sp" <skander_sp@...> wrote:
>
> one of the fields was defined as "char(10)" (mistake with similars
> name of domains), but due the "live cast" don't fail in FB 1.5.
> May be FB 2.0 is stronger and can't permit do it.

Starting with IB6/FB1 and Dialect 3, arithmetical operations on strings are
not permitted and an explicit cast is required instead. However, this rule
has been enforced for addition/subtraction only, other operations weren't
checked. FB2 establishes the same rule for multiplication/division as well,
just to be fully consistent with the "as designed" semantics of Dialect 3.


Dmitry