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