-
Type:
Bug
-
Status: Done
-
Priority:
High
-
Resolution: Fixed
-
Affects Version/s: 5.5.x, 5.6.x, 5.7.x
-
Fix Version/s: 5.7.21-21, 5.5.60-38.12, 5.6.40-84.0
-
Component/s: None
-
Launchpad URL:
**Reported in Launchpad by Paulus last update 11-12-2017 14:42:24
The percona build introduces --innodb-optimize-keys into the mysqldump utility. However it incorrectly works with foreign keys on the same table. For example this snippet produces an error on restore:
mysql -e 'create table test (a int, b int, index(a), index(b), foreign key (a) references test(b));' test
mysqldump test test > test.sql
mysql test < test.sql
The expected behaviour is to restore the table and not stop on the create table statement.