Debian Codegraph @

mysql-test/suite/maria/partition.result

raw
1 CREATE TABLE t (a INT, KEY(a)) ENGINE=Aria PARTITION BY KEY(a) PARTITIONS 2;
2 SELECT * FROM t PARTITION (p1);
3 a
4 DROP TABLE t;
5 CREATE TABLE t (a INT KEY) ENGINE=Aria PARTITION BY LIST (a) (
6 PARTITION p0 VALUES IN (1,2),
7 PARTITION p1 VALUES IN (3,4)
8 );
9 CREATE TABLE t1 (a INT KEY) ENGINE=Aria;
10 INSERT INTO t1 VALUES (1);
11 INSERT INTO t1 VALUES (3);
12 Swap table t1 and partition p0 of table t.
13 FLUSH TABLES;
14 REPAIR TABLE t;
15 Table Op Msg_type Msg_text
16 test.t repair warning Moved 1 misplaced rows
17 test.t repair status OK
18 DROP TABLE t;
19 DROP TABLE t1;