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

Implement support to handle DDL Statements with Flashback

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      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

              Assignee:
              plinux Lixun Peng
              Reporter:
              ralf.gebhardt@mariadb.com Ralf Gebhardt
              Votes:
              4 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated: