Em 24/03/2017 03:33, Vlad Khorsun escreveu: > > Another example - i add not null column with wrong default value and > going to correct this wrong default value. Should i update whole table > to do it ? >
Drop the column and recreate it, fixing your error. >> From another side, storing the default value inside the format is a >> smart hack that allows to avoid updating the table. It was designed to >> act like an implicit update but without the overhead. And considering >> the update semantics, the new behaviour may look correct. > > Also true > >> The big question is what expectations are better suitable to our users. > > The one that already works for years and well known ? ;) > You mean, that behaviour that a default uses CURRENT_TIME and every time you select it you see a different value? Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel