diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2013-11-11 18:23:53 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2013-11-11 18:23:53 +0400 |
| commit | 3cf7e283a6004385b6f2e116b933299d9701fac7 (patch) | |
| tree | b55e5c2639e5134296d5d2873203478eadf9727d /mysql-test/r/alter_table.result | |
| parent | 07d3fc52208b6c680aaec3db65a756824d535719 (diff) | |
| download | mariadb-git-3cf7e283a6004385b6f2e116b933299d9701fac7.tar.gz | |
MDEV-4435 Server crashes in my_strcasecmp_utf8 on ADD KEY IF NOT EXISTS with implicit name when the key exists.
Use field name as a key name if the key name wasn't specified.
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index d1df0aced63..5a2b48219af 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -1893,3 +1893,9 @@ DROP TABLE ti3; CREATE TABLE tm1(i INT DEFAULT 1) engine=MyISAM; ALTER TABLE tm1 ADD INDEX ii1(i), ALTER COLUMN i DROP DEFAULT; DROP TABLE tm1; +create table if not exists t1 (i int); +alter table t1 add key (i); +alter table t1 add key if not exists (i); +Warnings: +Note 1061 Duplicate key name 'i' +DROP TABLE t1; |