24.03.2017 16:03, Adriano dos Santos Fernandes wrote: > 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.
And make two more record formats - no, thanks >>> 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? You should know that default value for CURRENT_TIME (or any other allowed) expression will be value of that expression evaluated at the DDL statement run time. Regards, Vlad ------------------------------------------------------------------------------ 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