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/r/alter_table.result | |
| 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/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index e01f4fa047b..f0edfc9bb59 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -1240,4 +1240,16 @@ select (@orig_max_data_length > @changed_max_data_length); (@orig_max_data_length > @changed_max_data_length) 1 drop table t1; +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; +a b +1 a +2 c +3 b +4 b +5 a +DROP TABLE t1; End of 5.1 tests |