Subject Re: [firebird-support] firebird 2.1
Author Helen Borrie
At 05:09 PM 25/04/2008, you wrote:
>Now the link
>works for me.
>I do not understand what am I supposed to do.

Just don't try to raise the scale of the column - it is illegal now. ;-) Fb 2.0.x and also Fb 1.5.x allowed it, and it would (potentially) permit an overflow of the implemented precision limit and corrupt the database. That was a bug.

>this is the exact description of my problem :
>SQL> create table tab ( a numeric(4,2) );
>SQL> insert into tab values (99.99);
>SQL> alter table tab alter a type numeric(4,3);
>Statement failed, SQLCODE = -607
>unsuccessful metadata update
>-New scale specified for column A must be at most 2.

Your "history" ("I could do this in v.2.0.x") shows how the bug exhibited itself and your "problem" demonstrates that the bug is fixed.