Subject Re: [firebird-support] FB 2.1 and ALTER DOMAIN
Author Dmitry Yemanov
Luis Madaleno | magnisoft® wrote:
> Well it was a very nice bug! :)
> Because it worked and in fact my domain got changed to numeric(10,4).

And your existing rows possibly violated the new definition (if they
contained values larger than 999999.9999). This is why it's prohibited
now, as the ALTER statement is not allowed to truncate the existing data
or make it invalid.