Adding a new table to a partitioned table is now quite cumbersome:
('archive' is here a partitioned table and p1 is a normal table)
ALTER TABLE archive ADD PARTITION (PARTITION p1 VALUES LESS THAN (200));
ALTER TABLE archive EXCHANGE PARTITION p1 WITH TABLE p1;
DROP TABLE p1;
It would be nice to be able to do this in one step:
ALTER TABLE archive CONVERT TABLE tp1 TO PARTITION p1 VALUES LESS THAN (200);
The operation crash safety must be protected by DDL logging.