[MDEV-14745] Documentation mentions that we will be able to flashback a TRUNCATE or DROP Created: 2017-12-22  Updated: 2019-07-24  Resolved: 2018-05-10

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Fix Version/s: N/A

Type: Task Priority: Minor
Reporter: Michaël de groot Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-10571 Implement support to handle DDL State... Open

 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

 Comments   
Comment by Ian Gilfillan [ 2017-12-28 ]

plinux can you comment on this?

Comment by Lixun Peng [ 2018-05-09 ]

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

Comment by Ian Gilfillan [ 2018-05-10 ]

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

Generated at Thu Feb 08 08:15:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.