Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10571

Implement support to handle DDL Statements with Flashback

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      The first implementation of the flashback feature only reverts DML based statements up to a point where a DDL statement was executed.

      For the support of DDL changes in the server are needed.

      • For ADD INDEX/COLUMN, or CREATE TABLE query, just drop the index, column, table when running Flashback.
      • For DROP INDEX/COLUMN, or DROP TABLE query, will copy or rename the old table to a reserved database. When Flashback is running, I can drop new table, and rename the saved old table to original database.
      • For TRUNCATE table, I just rename old table to reserved database and create a new empty table.

      Attachments

        Issue Links

          Activity

            People

              plinux Lixun Peng
              ralf.gebhardt Ralf Gebhardt
              Votes:
              7 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.