diff options
author | unknown <cmiller@zippy.cornsilk.net> | 2006-11-09 18:33:58 -0500 |
---|---|---|
committer | unknown <cmiller@zippy.cornsilk.net> | 2006-11-09 18:33:58 -0500 |
commit | 19d61b1b81fdcfed3986f37e7677f6bcc7e7c6aa (patch) | |
tree | 489166e5267286ba6c0dd121f5990c32a90f72cd /mysql-test/t/gcc296.test | |
parent | e3f0e67b8fbe5c6b020dec8daf0f3622202e8911 (diff) | |
download | mariadb-git-19d61b1b81fdcfed3986f37e7677f6bcc7e7c6aa.tar.gz |
Bug#20691: DATETIME col (NOT NULL, NO DEFAULT) may insert garbage when \
specifying DEFAULT
This was not specific to datetime. When there is no default value
for a column, and the user inserted DEFAULT, we would write
uninitialized memory to the table.
Now, insist on writing a default value, a zero-ish value, the same
one that comes from inserting NULL into a not-NULL field.
(This is, at best, really strange behavior that comes from allowing
sloppy usage, and serves as a good reason always to run one's server
in a strict SQL mode.)
mysql-test/r/default.result:
Verify that all kinds of types work, even others other than datetime.
mysql-test/t/default.test:
Verify that all kinds of types work, even others other than datetime.
sql/item.cc:
Even if we warn that there is no default value in the table definition,
we have to insert /something/.
Diffstat (limited to 'mysql-test/t/gcc296.test')
0 files changed, 0 insertions, 0 deletions