-
Committer:
Alexey Kopytov
-
Date:
2011-09-06 11:50:30 UTC
-
Revision ID:
akopytov@gmail.com-20110906115030-b00igs95gg58wuql
Bug #812179: AUTO_INCREMENT columns must be skipped by the
--innodb-optimize-keys optimization in mysqldump
The problem was that when a table contained an AUTO_INCREMENT column in
a secondary key rather than a primary one, mysqldump would still skip
the key definition from CREATE TABLE and added it with the following
ALTER TABLE. Such dumps could not be imported, because the resulting
CREATE TABLE contained an unindexed AUTO_INCREMENT column.
Fixed by skipping keys on AUTO_INCREMENT columns from the
--innodb-optimize-keys optimization.