[MDEV-32869] SELECT EXTENDED for the recovery of corrupted data Created: 2023-11-24 Updated: 2023-11-24 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Server, Storage Engine - InnoDB |
| Fix Version/s: | 11.5 |
| Type: | New Feature | Priority: | Major |
| Reporter: | Marko Mäkelä | Assignee: | Michael Widenius |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
monty has requested that REPAIR TABLE be implemented for InnoDB tables. I believe that there are some fundamental problems with REPAIR TABLE:
For these reasons, I think that a better option to resurrect data from a corrupted database instance would be to implement a special form of SELECT * statement that would include some additional columns in the result set that would be defined by the storage engine. For InnoDB, these could include the following:
I think that implementing this would require a new virtual member function in class handler. |
| Comments |
| Comment by Sergei Golubchik [ 2023-11-24 ] |
|
SELECT is supposed to select, and if one wants to repair a table, one uses REPAIR. Nothing prevents InnoDB from implementing it internally as a select or from creating a backup, but the command name should correspond to what the command does. |