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
- blocks
-
MDEV-10459 Port Time Machine/Flashback Feature to MariaDB
- Open
- relates to
-
MDEV-14745 Documentation mentions that we will be able to flashback a TRUNCATE or DROP
- Closed