diff options
| author | unknown <hf@deer.(none)> | 2003-06-24 10:53:21 +0500 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2003-06-24 10:53:21 +0500 |
| commit | 3148d6f2a55211d02f63e4dc3a45f1d19ba536cd (patch) | |
| tree | 31d4acfcfe7089167f37ea80cf5d57bc207f9240 /mysql-test/r/insert.result | |
| parent | 83dc6b10db135f2448e5fa6218bb9b780f734c17 (diff) | |
| download | mariadb-git-3148d6f2a55211d02f63e4dc3a45f1d19ba536cd.tar.gz | |
Another bugfix for #615
Looks a bit nicer than previous one
mysql-test/r/insert.result:
Test results added
mysql-test/t/insert.test:
testcase for the bug added
sql/field.h:
Field::set_default fixed
sql/field_conv.cc:
Now we can just replace field->reset() with field->set_default() here
Diffstat (limited to 'mysql-test/r/insert.result')
| -rw-r--r-- | mysql-test/r/insert.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/insert.result b/mysql-test/r/insert.result index 69b790ff35b..d019cfcbfa9 100644 --- a/mysql-test/r/insert.result +++ b/mysql-test/r/insert.result @@ -58,6 +58,16 @@ skr 2 test 1 test 2 drop table t1; +create table t1 (id int NOT NULL DEFAULT 8); +insert into t1 values(NULL); +Column 'id' cannot be null +insert into t1 values (1), (NULL), (2); +select * from t1; +id +1 +8 +2 +drop table t1; drop database if exists foo; create database foo; use foo; |