|Subject||Re: [firebird-support] Altering a domain|
|Author||Walter R. Ojeda Valiente|
On Sat, Jun 20, 2015 at 9:04 AM, Ann Harrison aharrison@... [firebird-support] <firstname.lastname@example.org> wrote:
> On Jun 19, 2015, at 3:32 PM, 'Walter R. Ojeda Valiente' sistemas2000profesional@... [firebird-support] <email@example.com> wrote:
> 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) ?
Yes. Gbak is really an unload/recreate/reload. A newly restored database will have all records at the same format version. The format version number is a single byte, so it's possible to exhaust the format version numbers by altering a table repeatedly (that's a hedge because I don't remember if the byte is treated as signed). A gbak backup/restore resets the format version numbers. (Again, a hedge because it may be necessary for gbak to alter tables when there are cross references, so the restore may not create exclusively format version 1 records).