Debian Codegraph @

mysql-test/suite/mariabackup/xb_partition.test

raw
1 #--source include/innodb_page_size.inc
2 --source include/have_partition.inc
3 --source include/innodb_undo_tablespaces.inc
4
5 CREATE TABLE t1(a INT) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES (1), (2), (3);
7
8 CREATE TABLE t2(a INT) ENGINE=InnoDB;
9 INSERT INTO t2 VALUES (4), (5), (6);
10
11 CREATE TABLE p (
12 a int
13 ) ENGINE=InnoDB
14 PARTITION BY RANGE (a)
15 (PARTITION p0 VALUES LESS THAN (100),
16 PARTITION p1 VALUES LESS THAN (200),
17 PARTITION p2 VALUES LESS THAN (300),
18 PARTITION p3 VALUES LESS THAN (400));
19
20 INSERT INTO p VALUES (1), (101), (201), (301);
21
22 CREATE TABLE isam_t1(a INT) ENGINE=MyISAM;
23 INSERT INTO isam_t1 VALUES (1), (2), (3);
24
25 CREATE TABLE isam_t2(a INT) ENGINE=MyISAM;
26 INSERT INTO isam_t2 VALUES (4), (5), (6);
27
28 CREATE TABLE isam_p (
29 a int
30 ) ENGINE=MyISAM
31 PARTITION BY RANGE (a)
32 (PARTITION p0 VALUES LESS THAN (100),
33 PARTITION p1 VALUES LESS THAN (200),
34 PARTITION p2 VALUES LESS THAN (300),
35 PARTITION p3 VALUES LESS THAN (400));
36
37 INSERT INTO isam_p VALUES (1), (101), (201), (301);
38
39 let $targetdir=$MYSQLTEST_VARDIR/tmp;
40
41 --disable_result_log
42 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$targetdir/full;
43 --enable_result_log
44
45 DROP TABLE t1;
46 DROP TABLE t2;
47 CREATE TABLE t2(a INT) ENGINE=InnoDB;
48 INSERT INTO t2 VALUES (40), (50), (60);
49
50 ALTER TABLE p DROP PARTITION p0;
51 ALTER TABLE p DROP PARTITION p1;
52 ALTER TABLE p ADD PARTITION (PARTITION p4 VALUES LESS THAN (500));
53 ALTER TABLE p ADD PARTITION (PARTITION p5 VALUES LESS THAN (600));
54
55 INSERT INTO p VALUES (401), (501);
56
57
58 DROP TABLE isam_t1;
59 DROP TABLE isam_t2;
60 CREATE TABLE isam_t2(a INT) ENGINE=MyISAM;
61
62 INSERT INTO isam_t2 VALUES (40), (50), (60);
63
64 ALTER TABLE isam_p DROP PARTITION p0;
65 ALTER TABLE isam_p DROP PARTITION p1;
66 ALTER TABLE isam_p ADD PARTITION (PARTITION p4 VALUES LESS THAN (500));
67 ALTER TABLE isam_p ADD PARTITION (PARTITION p5 VALUES LESS THAN (600));
68
69 INSERT INTO isam_p VALUES (401), (501);
70
71 --disable_result_log
72 exec $INNOBACKUPEX --defaults-file=$MYSQLTEST_VARDIR/my.cnf --incremental --no-timestamp --incremental-basedir=$targetdir/full $targetdir/inc;
73 exec $INNOBACKUPEX --defaults-file=$MYSQLTEST_VARDIR/my.cnf --apply-log $targetdir/full;
74 exec $INNOBACKUPEX --defaults-file=$MYSQLTEST_VARDIR/my.cnf --apply-log --incremental-dir=$targetdir/inc $targetdir/full;
75
76 let $targetdir=$targetdir/full;
77 -- source include/restart_and_restore.inc
78 --enable_result_log
79
80 SELECT * from p;
81 SELECT * from isam_p;
82
83 DROP TABLE isam_p;
84 DROP TABLE isam_t2;
85 DROP TABLE p;
86 DROP TABLE t2;
87 rmdir $MYSQLTEST_VARDIR/tmp/full;
88 rmdir $MYSQLTEST_VARDIR/tmp/inc;