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

          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.