Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-268

LP #1223458: pt-table-sync deletes child table rows

    Details

      Description

      **Reported in Launchpad by Daniel Nichter last update 20-12-2013 03:54:32

      In the case of parent table <-- child table, and child table has ON DELETE CASCADE, when pt-table-sync does REPLACE on the parent table, since the REPLACE becomes DELETE + INSERT, the DELETE will cascade to the child and delete its rows.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: