expand_fast_index_creation is Broken For RENAME INDEX
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Hrvoje Matijakovic | ||
5.1 |
Fix Released
|
Medium
|
Hrvoje Matijakovic | ||
5.5 |
Fix Released
|
Medium
|
Hrvoje Matijakovic |
Bug Description
This page http://
This has been tested on 5.5.28-29.2, 5.1.66, 5.1.59 (wiki says expand_
How to repeat:
mysql [localhost] {msandbox} (test) > CREATE TABLE `t` (
-> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-> `c` char(1) DEFAULT NULL,
-> PRIMARY KEY (`id`),
-> KEY `cxc` (`c`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.11 sec)
mysql [localhost] {msandbox} (test) > show variables like '%fast_
+------
| Variable_name | Value |
+------
| expand_
| fast_index_creation | ON |
+------
2 rows in set (0.00 sec)
mysql [localhost] {msandbox} (test) > set expand_
Query OK, 0 rows affected (0.00 sec)
mysql [localhost] {msandbox} (test) > show variables like '%fast_
+------
| Variable_name | Value |
+------
| expand_
| fast_index_creation | ON |
+------
2 rows in set (0.00 sec)
mysql [localhost] {msandbox} (test) > alter table t rename index cxc to cxx;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index cxc to cxx' at line 1
This wiki entry http:// www.percona. com/doc/ percona- server/ 5.1/management/ innodb_ fast_index_ renaming. html says "5.1.49-12.0: Not yet released externally" - maybe this feature is not really generally available and if so, should be documented clearly on the page.