1--source include/have_rocksdb.inc 2 3# 4# TRUNCATE PARTITION 5# 6 7 8# Hidden Key table 9--echo # 10--echo # table(hidden key) 11--echo # 12CREATE TABLE t1 ( 13 a INT, 14 b INT 15) ENGINE=ROCKSDB 16PARTITION BY RANGE (b) ( 17 PARTITION p0 VALUES LESS THAN (3), 18 PARTITION p1 VALUES LESS THAN (6), 19 PARTITION p2 VALUES LESS THAN MAXVALUE 20); 21 22--source ../include/truncate_partition.inc 23 24 25--echo # 26--echo # table(secondary key) 27--echo # 28CREATE TABLE t1( 29 a INT, 30 b INT, 31 KEY (b) 32) ENGINE=ROCKSDB 33PARTITION BY HASH(a) PARTITIONS 3; 34 35--source ../include/truncate_partition.inc 36 37 38--echo # 39--echo # table(primary key, auto increment) 40--echo # 41CREATE TABLE t1( 42 a INT NOT NULL AUTO_INCREMENT, 43 b INT, 44 PRIMARY KEY(a) 45) ENGINE=ROCKSDB 46PARTITION BY KEY() PARTITIONS 3; 47 48--source ../include/truncate_partition.inc 49 50 51--echo # 52--echo # table(cf) 53--echo # 54CREATE TABLE t1 ( 55 a INT, 56 b INT, 57 PRIMARY KEY (`a`, `b`) COMMENT 'testcomment' 58) ENGINE=ROCKSDB 59 PARTITION BY LIST(a) ( 60 PARTITION p0 VALUES IN (1, 4, 7), 61 PARTITION p1 VALUES IN (2, 5, 8), 62 PARTITION p2 VALUES IN (3, 6, 9) 63); 64 65--source ../include/truncate_partition.inc 66 67 68--echo # 69--echo # table(reverse cf) 70--echo # 71CREATE TABLE t1 ( 72 a INT, 73 b INT, 74 PRIMARY KEY (`a`, `b`) COMMENT 'p0_cfname=rev:foo;p1_cfname=bar;p2_cfname=baz' 75) ENGINE=ROCKSDB 76PARTITION BY LIST(a) ( 77 PARTITION p0 VALUES IN (1, 4, 7), 78 PARTITION p1 VALUES IN (2, 5, 8), 79 PARTITION p2 VALUES IN (3, 6, 9) 80); 81 82--source ../include/truncate_partition.inc 83