CREATE TABLE t1 ( f1 INTEGER, f2 char(20))
PARTITION BY RANGE(f1) SUBPARTITION BY HASH(f1)
(PARTITION part1 VALUES LESS THAN (100));
SHOW CREATE TABLE t1;
--exec ls var/master-data/test/t1*
ALTER TABLE t1 ADD PARTITION
(PARTITION part2 VALUES LESS THAN (200) (SUBPARTITION subpart21));
SHOW CREATE TABLE t1;
--exec ls var/master-data/test/t1*
DROP TABLE t1;
CREATE TABLE t1 ( f1 INTEGER, f2 char(20))
PARTITION BY RANGE(f1) SUBPARTITION BY HASH(f1)
(PARTITION part1 VALUES LESS THAN (100) (SUBPARTITION subpart11));
SHOW CREATE TABLE t1;
--exec ls var/master-data/test/t1*