| Bug #76910 | Keep original table after ALTER TABLE with ALGORITHM=COPY | ||
|---|---|---|---|
| Submitted: | 1 May 2015 12:07 | ||
| Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
| Status: | Open | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S4 (Feature request) |
| Version: | 5.7 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.020 sec. using MySQL 8.0.36-u4-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
© 2024, Oracle Corporation and/or its affiliates
Description: It would be nice to be able to run an alter table which copies the table and then keep the old table with ${tablename}_copy or somthing similar. This makes it easy to rollback with RENAME TABLE This doesn't include new changes, but for those binlogs might be used. This is especially handy for DROP COLUMN actions. How to repeat: See description