[feature] support partition list

[andyli029]

Summary

support partition list:
In syntax, it is similar to MySQL partitioning-list
but PARTITION b0 has its meaning: b0 is one variable which represents one backend.

MySQL

CREATE TABLE list (
 c1 INT NOT NULL,
 c2 INT NOT NULL
) PARTITION BY LIST(c1) (
PARTITION p0 VALUES IN (1,4,7),
PARTITION p1 VALUES IN (2,5,8));
	
mysql> insert list values(3,3);
ERROR 1526 (HY000): Table has no partition for value 3

mysql> insert list values(1,1);
Query OK, 1 row affected (0.02 sec)

RadonDB

CREATE TABLE l(
 c1 INT NOT NULL,
 c2 INT NOT NULL
) PARTITION BY LIST(c1) (
PARTITION b0 VALUES IN (1,4,7),
PARTITION b1 VALUES IN (2,5,8));

b0: one backend
b1: another backend

mysql> insert l values(3,3);
ERROR 1526 (HY000): Table has no partition for value 3

mysql> insert l values(1,1);
Query OK, 1 row affected (0.02 sec)

[BohuTANG]

ACK