[Pkg-nagios-devel] Bug#287792: D.1.2 Changes in release 5.0.2 (01 Dec 2004)

Olaf van der Spek Olaf van der Spek <OvdSpek@LIACS.NL>, 287792@bugs.debian.org
Tue, 04 Jan 2005 21:08:33 +0100


The changelog for 5.0.2 says this:
MySQL now remembers which columns were declared to have default values. 
In STRICT_TRANS_TABLES/STRICT_ALL_TABLES mode, you now get an error if 
you do an INSERT without specifying all columns that don't have a 
default value. A side effect of this is that when you do SHOW CREATE for 
a new table, you will no longer see a DEFAULT value for a column for 
which you didn't specify a default value.

This looks like the behaviour you see in this bug, but I don't know how 
it ended up in your 4.0.