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

            Assignee:
            midenok Aleksey Midenkov
            Reporter:
            midenok Aleksey Midenkov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration