innodb_fast_alter_column doesn't work with indexed columns

Bug #848703 reported by Alexey Kopytov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Undecided
Unassigned
Rnt-5.1
Fix Released
Undecided
Alexey Kopytov

Bug Description

mysql> create table t1 (a varchar(20)) engine=innodb;
Query OK, 0 rows affected (0.02 sec)

mysql> alter table t1 modify a varchar(80);
Query OK, 0 rows affected (3.29 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> alter table t1 add key (a);
Query OK, 0 rows affected (1.55 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> alter table t1 modify a varchar(81);
ERROR 1280 (42000): Incorrect index name 'a'

Additionally, that error occurs regardless of whether innodb_fast_alter_column is on or off.

Tags: cr i18486

Related branches

Changed in percona-server:
status: New → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2678

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.