[MDEV-6238] Request: REMOVE PARTITIONING IF EXISTS Created: 2014-05-14 Updated: 2015-11-17 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Federico Razzoli | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
ADD/DROP PARTITION IF [NOT] EXISTS are supported, but ADD and DROP allow a limited set of operations. REORGANIZE and COALESCE allow some operations that are not allowed with ADD/DROP. But the only way to alter partitions in ANY possible way is removing partitioning and then re-create partitions. For this reason, IMO, the most flexible solution would be:
|