Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22165

CONVERT TABLE: move in partition from existing table

    XMLWordPrintable

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration