On 24/03/17 17:57, Vlad Khorsun wrote: >> What must be done is specified exactly. And we should suppose that in >> all other aspects data stored in database should not be changed - > What data is *stored* ?
For any field, the data that is loaded initially or later modified. And I REPEAT ... if the field was originally NULL it should remain NULL until a specific record update modifies it. It should not be returning some DEFAULT value that was added later UNLESS the constraints are changed to require the NULL value to be populated, but that should not be populated 'magically' and the SQL spec does not override that basic function of a value in an existing record? The DEFAULT value should only be used to replace a NULL value when a record is added ... full stop. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk ------------------------------------------------------------------------------ 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