diff options
| author | f4rnham <f4rnham@users.noreply.github.com> | 2015-03-26 00:00:12 +0100 |
|---|---|---|
| committer | f4rnham <f4rnham@users.noreply.github.com> | 2015-03-26 00:01:14 +0100 |
| commit | 4feaa06c842b0ae1cc8ab2d6e7f0bbd00c000e87 (patch) | |
| tree | 8031a31c173faf0e1c21100e485f8e63313b2f19 /mysql-test/r/alter_table.result | |
| parent | bd2ae787ea273169dc88db62bc1e66d56cbe9a4c (diff) | |
| download | mariadb-git-4feaa06c842b0ae1cc8ab2d6e7f0bbd00c000e87.tar.gz | |
MDEV-7816 ALTER with DROP INDEX and ADD INDEX .. COMMENT='comment2' ignores the new comment
Consider two indexes different if their comments differ
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 544e64e6373..a7f8ffcc9ec 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -2007,3 +2007,13 @@ INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8); INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d, t1 e; ALTER TABLE t1 MODIFY i FLOAT; DROP TABLE t1; +CREATE TABLE t1(a INT); +CREATE INDEX i1 ON t1(a) COMMENT 'comment1'; +ALTER TABLE t1 DROP INDEX i1, ADD INDEX i1(a) COMMENT 'comment2'; +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL, + KEY `i1` (`a`) COMMENT 'comment2' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1; |