It appears that if I try to insert an illegal value into an INT field, the
value is set to 0 instead of NULL, even though the field has NULL as a
default.
Is this documented behavior, and if so, what's the rationale?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stephen Fromm wrote:
It appears that if I try to insert an illegal value into an INT field, the
value is set to 0 instead of NULL, even though the field has NULL as a
default.
Is this documented behavior, and if so, what's the rationale?
Yes.