Re: [Firebird-devel] Number rounding/truncation

[Ivan P. <iva...@se...>]

> Should this be considered a bug?
> 
> ------------------
> SQL> select cast(5.6 as integer) from rdb$database;
> 
>        CAST
> ============
>           6

This is conversion from NUMERIC(x, 1) to NUMERIC(x, 0). Seems o.k.


> SQL> select cast('5.6' as integer) from rdb$database;
> 
>        CAST
> ============
>           5

This is direct conversion of string to integer. What the rules should be
is the question, but there are worse cases. In some countries it is common
to use comma as decimal separator, but if you use it by mistake,
you will not get error but this (also see handling of spaces)

SELECT 5.6,
  cast(5.6 as integer),
  cast('5.6' as integer),
  cast('5,6' as integer),
  cast('5,6,7 8 9' as integer)
FROM RDB$DATABASE;

CAST CAST CAST CAST

===================== =========== =========== =========== ===========
5.6     6       5       56      56789

Ivan