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

Setup default partitions for system versioning

    XMLWordPrintable

Details

    Description

      Currently such syntax fails:

      create table t1 (i int) with system versioning partition by system_time;

      with error message:

      ERROR 1492 (HY000): For LIST partitions each partition must be defined

      which is by itself incorrect.

      Auto-create 1 history partition and 1 working partition for the above syntax. Specify the number of history partitions by the partitions keyword:

      create table t1 (i int) with system versioning partition by system_time partitions 2;

      This should create 1 history and 1 working partition. The working partition is mandatory, so partitions 1 should fail with error.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27328 Change of SYSTEM_TIME partitioning options is not possible without data copy

          • Major - Major loss of function.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22153 ALTER add default history partitions makes table inaccessible

          • Critical - Crashes, loss of data, severe memory leak.
          • 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

          Task - A task that needs to be done. MDEV-19938 Reorganize multiple history partitions

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22112 Assertion `tab_part_info->part_type == RANGE_PARTITION || tab_part_info->part_type == LIST_PARTITION' failed in prep_alter_part_table

          • Major - Major loss of function.
          • Closed

          Activity

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.