Em 24/03/2017 11:53, Vlad Khorsun escreveu: > 24.03.2017 16:31, Adriano dos Santos Fernandes wrote: > >> Or better, increase the record format count, which seems as a stupid limit. > > It is really better. Are you have smart idea ? > >>>>>> 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. >>> >> >> You should known how bad this worked before the change that fixed it >> with the current behaviour. > > The change is good in this aspect and at least very questionable in > another one. > >> BTW, don't mix implementation details with expected results, please, >> this is wasting time. > > This "implementation details" is too important to ignore it. Or do you > prefer > to waste time updating table every time non-nullable column with default value > is added ? >
Looks like you do not understand how it works. Re-read thread "Adding NOT NULL fields with DEFAULT" from 2009. >> Correct result is priority, and current implementation detail does it >> very well > > So far we have no agreement on what is "correct result". And have no one agreeing with you so far. > Current implementation > changed well known old behaviour not claiming it as a bug. I'd say it looks > like > a bug itself. > Changed a bugged design/implementation since 2009. Looks a bit late to say this. Adriano PS: I'm stopping to lose time in this thread. ------------------------------------------------------------------------------ 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