Debian Codegraph @

mysql-test/suite/mariabackup/xb_partition.result

raw
1 CREATE TABLE t1(a INT) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES (1), (2), (3);
3 CREATE TABLE t2(a INT) ENGINE=InnoDB;
4 INSERT INTO t2 VALUES (4), (5), (6);
5 CREATE TABLE p (
6 a int
7 ) ENGINE=InnoDB
8 PARTITION BY RANGE (a)
9 (PARTITION p0 VALUES LESS THAN (100),
10 PARTITION p1 VALUES LESS THAN (200),
11 PARTITION p2 VALUES LESS THAN (300),
12 PARTITION p3 VALUES LESS THAN (400));
13 INSERT INTO p VALUES (1), (101), (201), (301);
14 CREATE TABLE isam_t1(a INT) ENGINE=MyISAM;
15 INSERT INTO isam_t1 VALUES (1), (2), (3);
16 CREATE TABLE isam_t2(a INT) ENGINE=MyISAM;
17 INSERT INTO isam_t2 VALUES (4), (5), (6);
18 CREATE TABLE isam_p (
19 a int
20 ) ENGINE=MyISAM
21 PARTITION BY RANGE (a)
22 (PARTITION p0 VALUES LESS THAN (100),
23 PARTITION p1 VALUES LESS THAN (200),
24 PARTITION p2 VALUES LESS THAN (300),
25 PARTITION p3 VALUES LESS THAN (400));
26 INSERT INTO isam_p VALUES (1), (101), (201), (301);
27 DROP TABLE t1;
28 DROP TABLE t2;
29 CREATE TABLE t2(a INT) ENGINE=InnoDB;
30 INSERT INTO t2 VALUES (40), (50), (60);
31 ALTER TABLE p DROP PARTITION p0;
32 ALTER TABLE p DROP PARTITION p1;
33 ALTER TABLE p ADD PARTITION (PARTITION p4 VALUES LESS THAN (500));
34 ALTER TABLE p ADD PARTITION (PARTITION p5 VALUES LESS THAN (600));
35 INSERT INTO p VALUES (401), (501);
36 DROP TABLE isam_t1;
37 DROP TABLE isam_t2;
38 CREATE TABLE isam_t2(a INT) ENGINE=MyISAM;
39 INSERT INTO isam_t2 VALUES (40), (50), (60);
40 ALTER TABLE isam_p DROP PARTITION p0;
41 ALTER TABLE isam_p DROP PARTITION p1;
42 ALTER TABLE isam_p ADD PARTITION (PARTITION p4 VALUES LESS THAN (500));
43 ALTER TABLE isam_p ADD PARTITION (PARTITION p5 VALUES LESS THAN (600));
44 INSERT INTO isam_p VALUES (401), (501);
45 # shutdown server
46 # remove datadir
47 # xtrabackup move back
48 # restart
49 SELECT * from p;
50 a
51 201
52 301
53 401
54 501
55 SELECT * from isam_p;
56 a
57 201
58 301
59 401
60 501
61 DROP TABLE isam_p;
62 DROP TABLE isam_t2;
63 DROP TABLE p;
64 DROP TABLE t2;