Percona Server with XtraDB

AUTO_INCREMENT columns must be skipped by the --innodb-optimize-keys optimization in mysqldump

Reported by Alexey Kopytov on 2011-07-18
16
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server
High
Alexey Kopytov
5.1
High
Alexey Kopytov
5.5
High
Alexey Kopytov
Rnt-5.1
High
Alexey Kopytov

Bug Description

Since AUTO_INCREMENT columns must be defined as keys, omitting key specifications and then adding them back in ALTER TABLE doesn't work for them.

mysqldump --innodb-optimize-keys must be fixed to take that into account.

tags: added: cr i14678
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers