[PS-3863] mysqldump --innodb-optimize-keys may produce invalid SQL with implicitly named FK constraints - Percona JIRA

XML

Word

Printable

CREATE TABLE t2 (id int, a int, primary key(id), FOREIGN KEY (a) REFERENCES t2(id)) ENGINE=InnoDB;

implicitly creates

KEY `a` (`a`)

which is taken away to `ALTER TABLE` by optimizer.
Then optimized statement also implicitly creates

KEY `a` (`a`)

what causes that `ALTER TABLE` returns an error.

relates to

PS-605 LP #1081016: mysqldump --innodb-optimize-keys may produce invalid SQL with explicitly named FK constraints

PS-1125 LP #1732625: mysqldump produces incorrect dumps with self-referenced foreign keys

PS-1125 LP #1732625: mysqldump produces incorrect dumps with self-referenced foreign keys

Estimated:

Not Specified

Remaining:

Logged:

1h 30m