""Roger Pullen"" <pullen.roger@...> wrote in message
news:EPEIJNIEIODGFFJBMDPPGEEKCGAA.pullen.roger@......

> Just testing an original IB6 db on RC2
>
> Has there been a change in integer datatypes?
>
> An SP which multiplied a numeric(9,2) by 10000
> and cast it as an integer now fails with an
> overflow. If I reduce the 10000 to 100 it is OK

Is this your case? If there was a glitch in RC2, then it doesn't exist
anymore. I don't remember when I did a change to the scale:

SQL> set sql dialect 1;
WARNING: Client SQL dialect has been set to 1 when connecting to Database
SQL dialect 3 database.
SQL> select cast(1 as numeric(9,2)) * 10000 from rdb$database;

============
10000.00

SQL> select cast(cast(1 as numeric(9,2)) * 10000 as int) from rdb$database;
CAST
============
10000

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