Error when create statement contains the option of "algorithm"

[zhunina]

Steps:
1

mysql> create table tbl_name(id int,c_id int,name varchar(8)) partition by linear key algorithm=2 (id,c_id) partitions 4 (partition p0,partition p1,partition p2,partition p3);
ERROR 1064 (HY000): syntax error, error in :' key algorithm=2 (id,c_id) partitio',expect LPAREN, actual IDENTIFIER algorithm

2

mysql> create table tbl_name(id int,c_id int,name varchar(8)) partition by key  algorithm=1(id) partitions 4 (partition p0,partition p1,partition p2,partition p3);
ERROR 1064 (HY000): syntax error, error in :'key  algorithm=1(id) partitions 4 (',expect LPAREN, actual IDENTIFIER algorithm

[sunsun314]

This issue is create by Druid Parser did not support the sql
the range of Druid Parser support partition is like:
partition_options:
{[LINEAR] HASH(expr)
| PARTITION BY [linear] KEY (column_list)
| RANGE{(expr) | COLUMNS(column_list)}
| LIST{(expr) | COLUMNS(column_list)}
}
[(partition_definition [, partition_definition] ...)]

[ditdb]

这个已经pull到alibaba/druid上， 并被其commit到master上，见 #2131

[FlyingMao]

verified version：
5.6.29-dble-9.9.9.9-359645c-20181029082136

[FlyingMao]

for tester:
suggest autotest position: sqls/bugs/bug.sql (reference line 209~213)