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

[Olaf van der Spek]

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.