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

Setup default partitions for system versioning

    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

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                midenok Aleksey Midenkov
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: