Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-1125

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

    XMLWordPrintable

    Details

      Description

      **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.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  przemyslaw.skibinski Przemyslaw Skibinski
                  Reporter:
                  lpjirasync lpjirasync (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 58 minutes
                    58m