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 | be7629e370d34a98618b0f97144eaaf426499177 (patch) | |
| tree | 93d7ac1e0b63dd10f9a9a294cce8145816509837 /mysql-test/r/alter_table.result | |
| parent | 1585368047027e66e6823f9c20d0d8610ae42487 (diff) | |
| parent | adf630dcee997fea38d231f652e44496ca566ca6 (diff) | |
| download | mariadb-git-be7629e370d34a98618b0f97144eaaf426499177.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 |