Excellent explanation Ann, as always. Just one doubt: After a cycle backup/restore: the restored database will have all the rows with the new domain?
All columns with domain D_CURRENCY that were created with DECIMAL(9, 2) now will be DECIMAL(18, 2) ? Greetings. Walter. On Tue, Jun 16, 2015 at 2:58 PM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > Ann, > > thank you very much for your clear explanation. > > Aldo > > El 16/06/15 a las 12:44, Ann Harrison aharri...@ibphoenix.com > [firebird-support] escibiĆ³: > > > On Tue, Jun 16, 2015 at 11:15 AM, Aldo Caruso aldo.car...@argencasas.com > [firebird-support] <firebird-support@yahoogroups.com> wrote: > >> >> >> I have defined the following domain : >> >> CREATE DOMAIN CURRENCY AS decimal(9,2) >> >> I would like to alter it as the following : >> >> ALTER DOMAIN CURRENCY AS decimal(18,2) >> >> I have many fields in tables that depend on this domain and they >> are filled with values. >> >> Will they be restructured in their internal representation ( from >> INTEGER to BIGINT in dialect 3 ) with no harm for the stored data ? >> >> >> > Initially, only the domain and column definitions will change, creating > new > format versions for the tables affected. When you insert new records into > those tables, the new records will have the new format. Old records will > be changed in memory when you read them, so they appear to be in the > new format. The stored format of existing records change when the > records are modified. > > Good luck, > > Ann > > > > >