[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.