[#MDEV-26471] Syntax extension: do not require PARTITION keyword in partition definition

[MDEV-26471] Syntax extension: do not require PARTITION keyword in partition definition Created: 2021-08-24 Updated: 2023-11-23 Resolved: 2021-10-26
Status:	Closed
Project:	MariaDB Server
Component/s:	Partitioning
Fix Version/s:	10.7.1

Type:

Task

Priority:

Major

Reporter:

Aleksey Midenkov

Assignee:

Aleksey Midenkov

Resolution:

Fixed

Votes:

Labels:

None

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.

Comments

Comment by Aleksey Midenkov [ 2021-08-24 ]

Comment by Sergei Golubchik [ 2021-09-10 ]

bb4b95975f is ok

Generated at Thu Feb 08 09:45:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.