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

Add catchall to all table partitioning for list partitions

    XMLWordPrintable

Details

    Description

      Not all table partitioning has the ability to add a so called "catch all". The catch all is present in range partitioning:
      partition last values less than(MAXVALUE)

      The proposal is to add similar statements to list partitioning: Proposed syntax:
      partition last values not in other

      Benefits: No more insert exceptions, giving the DBA more choices in applying this partitioning with less effort.

      Oracle uses the following syntax for this:

      CREATE TABLE h2 (c1 NUMBER,c2 NUMBER)
      PARTITION BY LIST(c1) (
      PARTITION p0 VALUES (1, 4, 7),
      PARTITION p1 VALUES (2, 5, 8),
      PARTITION p3 VALUES(DEFAULT)

      We should probably use the DEFAULT syntax for this.

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              Norbert van Nobelen Norbert van Nobelen
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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