On 2017-01-19 13:14, Ann Harrison wrote: >> On Jan 19, 2017, at 1:46 AM, Dmitry Yemanov <firebi...@yandex.ru> >> wrote: >> >> 19.01.2017 00:51, Ann Harrison wrote: >>> >>> In what universe does that make sense? The field is NOT NULL. >>> You're storing NULL in it. That's an error. >> >> I'd say it depends. What about a BEFORE trigger converting input NULL >> to >> something valid before storing? > > Sure, a before trigger can fix up bad values and avoid an error. I > haven't followed the development of the SQL standard for the past > decade. If it now says that assigning NULL to a column that > disallows NULLs means that you should apply some other value in some > cases, then I guess I know in what universe that makes sense.
Luckily it doesn't, it has DEFAULT for that. Mark ------------------------------------------------------------------------------ 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