diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2003-12-12 21:26:44 -0400 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2003-12-12 21:26:44 -0400 |
| commit | 51c54cd7744103b4876c61dca3662ed91d3a8dea (patch) | |
| tree | 5d3eb4c08cbcee1b1e4e6e7c4706374777c07a0d /mysql-test | |
| parent | 22c12eaeb296b55d6121531bea44a97fb5297f04 (diff) | |
| download | mariadb-git-51c54cd7744103b4876c61dca3662ed91d3a8dea.tar.gz | |
added checking for old cuted value in Field_enum::store
(bug #2023)
mysql-test/r/type_enum.result:
added tests for wrong enum values (bug #2023)
mysql-test/t/type_enum.test:
added tests for wrong enum values (bug #2023)
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/type_enum.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/type_enum.test | 11 |
2 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/type_enum.result b/mysql-test/r/type_enum.result index ee3bd077798..03cfdc3c286 100644 --- a/mysql-test/r/type_enum.result +++ b/mysql-test/r/type_enum.result @@ -1636,3 +1636,13 @@ t1 CREATE TABLE `t1` ( `a` enum('','a','b') NOT NULL default 'b' ) TYPE=MyISAM drop table t1; +create table t1 (a enum ('0','1')); +insert into t1 set a='foobar'; +select * from t1; +a + +update t1 set a = replace(a,'x','y'); +select * from t1; +a + +drop table t1; diff --git a/mysql-test/t/type_enum.test b/mysql-test/t/type_enum.test index 8f399e4364e..78b850b6ea6 100644 --- a/mysql-test/t/type_enum.test +++ b/mysql-test/t/type_enum.test @@ -21,3 +21,14 @@ drop table t1; create table t1 (a enum (' ','a','b ') not null default 'b '); show create table t1; drop table t1; + +# +# Tests of wrong enum values (bug #2023) +# + +create table t1 (a enum ('0','1')); +insert into t1 set a='foobar'; +select * from t1; +update t1 set a = replace(a,'x','y'); +select * from t1; +drop table t1;
\ No newline at end of file |