Re: [Firebird-devel] Regression for SUM() operator?

[Dmitry Y. <fir...@ya...>]

Adriano dos Santos Fernandes wrote:
>
>> With Vulcan, I get:
>>
>>  SELECT SUM (USER_TYPED) * 100, SUM (cast (CASH_BALANCE as real)) FROM 
>> USER_INPUT;
>>
>>                                             SUM
>> ======================= =======================
>>      -95301.00000000000      -453.0199999809265
>
> Vulcan is wrong. CHAR + CHAR is error, so SUM(CHAR) is error too.

To be more precise, this is true for Dialect 3 only which tries to 
enforce type safety in arithmetics. The legacy Dialect 1 allows addition 
of numbers represented via strings, but AFAIK this is against the SQL 
specification.


Dmitry