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/t/alter_table.test | |
| 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/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index ab1fb4e4c54..0c0672de3e2 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -1697,3 +1697,11 @@ 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; +# +# MDEV-7816 ALTER with DROP INDEX and ADD INDEX .. COMMENT='comment2' ignores the new comment +# +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; +DROP TABLE t1; |