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

Implement interval partitioning similar to Oracle

    XMLWordPrintable

Details

    Description

      Some users would like MariaDB to support interval partitioning similar to Oracle's feature:

      Interval Partitioning

      Interval partitioning is an extension of range partitioning which instructs the database to automatically create partitions of a specified interval when data inserted into the table exceeds all of the existing range partitions. You must specify at least one range partition. The range partitioning key value determines the high value of the range partitions, which is called the transition point, and the database creates interval partitions for data with values that are beyond that transition point. The lower boundary of every interval partition is the non-inclusive upper boundary of the previous range or interval partition.

      For example, if you create an interval partitioned table with monthly intervals and you set the transition point at January 1, 2007, then the lower boundary for the January 2007 interval is January 1, 2007. The lower boundary for the July 2007 interval is July 1, 2007, regardless of whether the June 2007 partition was created.

      You can create single-level interval partitioned tables and the following composite partitioned tables:

      • Interval-range
      • Interval-hash
      • Interval-list
      • Only one partitioning key column can be specified, and it must be of NUMBER or DATE type.
      • Interval partitioning is not supported for index-organized tables.
      • NULL values cannot be stored in the partitioning key column when using interval partitioning.

      Interval partitioning supports a subset of the capabilities of range partitioning. For information about restrictions when using interval partitioning, refer to Oracle Database SQL Language Reference.

      https://docs.oracle.com/database/121/VLDBG/GUID-C121EA1B-2725-4464-B2C9-EEDE0C3C95AB.htm

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39807 MDEV-15621: Assertion `0' failed upon INSERT

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39808 MDEV-15621: ROW-binlog + INSERT: auto-creates an interval partition & logs the row, but not the implicit ADD PARTITION

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40048 MDEV-15621: Prelocking with range interval auto partitioning

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40088 MDEV-15621: Assertion `fixed()' failed with INTERVAL (SELECT 1) DAY

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40467 Auto-partition fails when using maximum timestamp

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40631 main.partition_range_interval timeout in view protocol

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40650 main.partition_range_interval fails 32bit builders

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40978 PREPARE with INTERVAL ? in Partition DDL Crashes the Server (DoS)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41579 INSERT DELAYED into a table with INTERVAL partitioning hangs

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41582 Assertion `!m_prebuilt->table || table->versioned() == m_prebuilt->table->versioned()' failed in ha_innobase::open on INSERT w/ INTERVAL partitioning

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41596 Galera node leaves the cluster after an INSERT that adds INTERVAL partitions on another node

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41600 INSERT fails with ERROR 1493 when INTERVAL partitions on a TIMESTAMP column cross a change to daylight saving time

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41628 INSERT fails with ERROR 1517 when a new INTERVAL partition gets the name of an existing partition or subpartition

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41629 INTERVAL partitioning on a TIMESTAMP column changes the query result: a session with another time zone does not find the row

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41710 Replica stops with error 1526 on a row event for an INTERVAL partitioned table when the master session has another time zone

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41711 Concurrent INSERTs each add the missing INTERVAL partitions, so the table gets several times the partitions it needs

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41712 Aria or MyISAM table can no longer be opened after SYSTEM_TIME AUTO or INTERVAL partitioning adds partitions without its ROW_FORMAT

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41733 A consistent snapshot transaction, and so mariadb-dump --single-transaction, fails with ERROR 1412 after DML in another session adds SYSTEM_TIME AUTO or INTERVAL partitions

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41853 INTERVAL 1 MONTH partition bounds drift to the 28th when the first bound is at the end of a month

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41858 Warning for a failed INTERVAL partition creation shows %s.%s instead of the table name

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32057 Auto adding of partitions

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-17554 Auto-create history partitions for system-versioned tables

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

          Task - A task that needs to be done. MDEV-39666 Test MDEV-15621 Implement interval partitioning similar to Oracle

          • Critical - Crashes, loss of data, severe memory leak.
          • In Testing
          has action item

          DOCS-6233 Loading...

          Activity

            People

              ycp Yuchen Pei
              GeoffMontee Geoff Montee (Inactive)
              Yuchen Pei Yuchen Pei
              Sergei Petrunia Sergei Petrunia
              Pavithra Pandith Pavithra Pandith
              Votes:
              1 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 20d
                  20d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 19d 37m Time Not Required
                  19d 37m

                  Git Integration

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