[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:

ALTER TABLE t REMOVE PARTITIONING IF EXISTS;


Generated at Thu Feb 08 07:10:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.