Debian Codegraph @

mysql-test/suite/mariabackup/partition_datadir.result

raw
1 CREATE TABLE t(i int)
2 ENGINE=InnoDB
3 PARTITION BY RANGE (i)
4 (PARTITION p0 VALUES LESS THAN (100),
5 PARTITION P1 VALUES LESS THAN (200),
6 PARTITION p2 VALUES LESS THAN (300) DATA DIRECTORY = 'MYSQLTEST_VARDIR/partitdata',
7 PARTITION p3 VALUES LESS THAN (400) DATA DIRECTORY = 'MYSQLTEST_VARDIR/partitdata',
8 PARTITION p4 VALUES LESS THAN MAXVALUE);
9 INSERT INTO t VALUES (1), (101), (201), (301), (401);
10 DROP TABLE t;
11 # shutdown server
12 # remove datadir
13 # xtrabackup move back
14 # restart
15 SELECT * FROM t;
16 i
17 1
18 101
19 201
20 301
21 401
22 DROP TABLE t;