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

Bug #812179 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.

Related branches

lp:~akopytov/percona-server/bug812179-5.5
Merged into lp:percona-server/5.5 at revision 159
Laurynas Biveinis: Approve on 2011-09-13
lp:~akopytov/percona-server/bug812179-5.1
Merged into lp:percona-server/5.1 at revision 281
Laurynas Biveinis: Approve on 2011-09-13
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