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

Documentation mentions that we will be able to flashback a TRUNCATE or DROP

Details

    Description

      Hi,

      The Flashback documentation:
      https://mariadb.com/kb/en/library/flashback/
      claims we can flashback a DROP TABLE or TRUNCATE TABLE in a future version. I would be really surprised if this is possible, unless we would not actually drop the table or write the entire table into the binary log.

      Can you please elaborate on this?

      Thanks,
      Michaël

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-10571 Implement support to handle DDL Statements with Flashback

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            michaeldg Michaël de groot created issue -
            greenman Ian Gilfillan added a comment -

            plinux can you comment on this?

            greenman Ian Gilfillan added a comment - plinux can you comment on this?
            plinux Lixun Peng added a comment -

            If enable Flashback DDL support, then when we do the DDL, we will copy or move current table to a reserved & hidden database, when we need to flashback DDL, then just copy or move the old table from this hidden database

            plinux Lixun Peng added a comment - If enable Flashback DDL support, then when we do the DDL, we will copy or move current table to a reserved & hidden database, when we need to flashback DDL, then just copy or move the old table from this hidden database
            greenman Ian Gilfillan added a comment -

            Added how this could work to the docs at https://mariadb.com/kb/en/library/flashback/

            greenman Ian Gilfillan added a comment - Added how this could work to the docs at https://mariadb.com/kb/en/library/flashback/
            greenman Ian Gilfillan made changes -
            Field Original Value New Value
            Fix Version/s N/A [ 14700 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            michaeldg Michaël de groot made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 84579 ] MariaDB v4 [ 133425 ]

            People

              greenman Ian Gilfillan
              michaeldg Michaël de groot
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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