diff options
| author | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-02-12 15:41:36 +0400 |
|---|---|---|
| committer | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-02-12 15:41:36 +0400 |
| commit | 07f36668aecfd3d811c4ed5eb23b1bfdb8c86fdd (patch) | |
| tree | 7dd961ed670d0d28d50bea67201109c50e9296ff /mysql-test/t/default.test | |
| parent | a30830460794651c0e9fc5ec4779cf77680514ee (diff) | |
| download | mariadb-git-07f36668aecfd3d811c4ed5eb23b1bfdb8c86fdd.tar.gz | |
bug #20691 (INSERT (DEFAULT) may insert garbage with NO DEFAULT NOT NULL field)
Some fields (GEOMETRY first of all) can't be handled properly in this
case at all. So we return an error in this case
mysql-test/r/default.result:
result fixed
mysql-test/r/gis.result:
result fixed
mysql-test/t/default.test:
VIEW test added
mysql-test/t/gis.test:
testcase added
sql/item.cc:
set_defaults() changed with the 'reset()'
Diffstat (limited to 'mysql-test/t/default.test')
| -rw-r--r-- | mysql-test/t/default.test | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/mysql-test/t/default.test b/mysql-test/t/default.test index 225ddbc3ee2..14aa4b02cfe 100644 --- a/mysql-test/t/default.test +++ b/mysql-test/t/default.test @@ -137,6 +137,13 @@ insert into bug20691 values (DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAUL select * from bug20691 order by x asc; drop table bug20691; -### +create table t1 (id int not null); +insert into t1 values(default); + +create view v1 (c) as select id from t1; +insert into t1 values(default); +drop view v1; +drop table t1; + --echo End of 5.0 tests. |