diff options
| author | Davi Arnaut <Davi.Arnaut@Sun.COM> | 2008-10-24 11:58:48 -0200 |
|---|---|---|
| committer | Davi Arnaut <Davi.Arnaut@Sun.COM> | 2008-10-24 11:58:48 -0200 |
| commit | d4438c99ff0b2a5e9541b1b259b612fb34c46fe7 (patch) | |
| tree | 93d7ac1e0b63dd10f9a9a294cce8145816509837 /mysql-test/t/alter_table.test | |
| parent | 463c837c3aaa5c85e8024463bf247a926932de5d (diff) | |
| parent | 256f41edfe87bf92807d9c9500ae627a0045ef5e (diff) | |
| download | mariadb-git-d4438c99ff0b2a5e9541b1b259b612fb34c46fe7.tar.gz | |
Merge from mysql-5.1-5.1.29-rc into mysql-5.1-bugteam
Diffstat (limited to 'mysql-test/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 8502ba3f3d3..76d57e76491 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -977,4 +977,14 @@ select (@orig_max_data_length > @changed_max_data_length); drop table t1; +# +# Bug #23113: Different behavior on altering ENUM fields between 5.0 and 5.1 +# +CREATE TABLE t1(a INT AUTO_INCREMENT PRIMARY KEY, + b ENUM('a', 'b', 'c') NOT NULL); +INSERT INTO t1 (b) VALUES ('a'), ('c'), ('b'), ('b'), ('a'); +ALTER TABLE t1 MODIFY b ENUM('a', 'z', 'b', 'c') NOT NULL; +SELECT * FROM t1; +DROP TABLE t1; + --echo End of 5.1 tests |