Bug Report: PARTITION BY KEY() is not parsed correctly.

[dbussink]

Overview of the Issue

The PARTITION BY KEY syntax allows for passing in an empty column list which signifies that the primary key is used for partitioning.

See also https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html, specifically:

KEY takes only a list of zero or more column names. Any columns used as the partitioning key must
comprise part or all of the table's primary key, if the table has one. Where no column name is
specified as the partitioning key, the table's primary key is used, if there is one.

Reproduction Steps

create table t (id int, primary key(id)) partition by key () partitions 2

Binary Version

All version

Operating System and Environment details

Not applicable

Log Fragments

Not applicable

[dbussink]

#10958 fixes this