CREATE TABLE t (a INT, KEY(a)) ENGINE=Aria PARTITION BY KEY(a) PARTITIONS 2; SELECT * FROM t PARTITION (p1); a DROP TABLE t;