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

Request: REMOVE PARTITIONING IF EXISTS

        Details

        • Type: Task
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Fix Version/s: 10.2
        • Component/s: None
        • 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;

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    f_razzoli Federico Razzoli
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated: