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

Syntax extension: do not require PARTITION keyword in partition definition

    XMLWordPrintable

Details

    Description

      Instead of

        create or replace table t1 (x int)
        partition by range(x) (
          partition p1 values less than (10),
          partition p2 values less than (20),
          partition p3 values less than (30),
          partition p4 values less than (40),
          partition p5 values less than (50),
          partition pn values less than maxvalue);
      

      it should be possible to type in shorter form:

        create or replace table t1 (x int)
        partition by range(x) (
          p1 values less than (10),
          p2 values less than (20),
          p3 values less than (30),
          p4 values less than (40),
          p5 values less than (50),
          pn values less than maxvalue);
      

      As above examples demonstrate, make PARTITION keyword in partition definition optional.

      Attachments

        Activity

          People

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