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

Implement support for ALTER TABLE ... {DISCARD|IMPORT} PARTITION

Details

    Description

      MySQL 5.7 supports ALTER TABLE ... {DISCARD|IMPORT} PARTITION. The documentation explains how to use it here:

      https://dev.mysql.com/doc/refman/5.7/en/innodb-transportable-tablespace-examples.html
      UPDATE: The above page does not exist anymore, page
      https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html explains it, too

      Should MariaDB also support that?

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-13626 Merge InnoDB test cases from MySQL 5.7

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-17690 Document InnoDB's transportable tablespaces

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-26137 ALTER TABLE IMPORT enhancement

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17132 Feature request: mariabackup doesn't support Backup & Restore of specific partition of table

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-17689 Document how to do partial backups and restores with Mariabackup

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33722 discard tablespace doesn't work for partitioned tables

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Fix Version/s 10.3 [ 22126 ]
            serg Sergei Golubchik made changes -
            Description MySQL 5.7 supports ALTER TABLE ... {DISCARD|IMPORT} PARTITION. The documentation explains how to use it here:

            https://dev.mysql.com/doc/refman/5.7/en/innodb-transportable-tablespace-examples.html

            Should MariaDB also support that?             		MySQL 5.7 supports {{ALTER TABLE ... \{DISCARD|IMPORT} PARTITION}}. The documentation explains how to use it here:

            https://dev.mysql.com/doc/refman/5.7/en/innodb-transportable-tablespace-examples.html

            Should MariaDB also support that?
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic/Theme Improvements_Partitioning
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 76670 ] MariaDB v4 [ 130515 ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Description MySQL 5.7 supports {{ALTER TABLE ... \{DISCARD|IMPORT} PARTITION}}. The documentation explains how to use it here:

            https://dev.mysql.com/doc/refman/5.7/en/innodb-transportable-tablespace-examples.html

            Should MariaDB also support that?             		MySQL 5.7 supports {{ALTER TABLE ... \{DISCARD|IMPORT} PARTITION}}. The documentation explains how to use it here:

            https://dev.mysql.com/doc/refman/5.7/en/innodb-transportable-tablespace-examples.html
            UPDATE: The above page does not exist anymore, page
            https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html explains it, too

            Should MariaDB also support that?
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] Marko Mäkelä [ marko ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            julien.fritsch Julien Fritsch made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]
            alice Alice Sherepa made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 201599 198878 115300
            Zendesk active tickets 201599

            People

              marko Marko Mäkelä
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              12 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.