Debian Codegraph @

mysql-test/suite/parts/t/reorganize_partition_innodb.test

raw
1 --source include/have_innodb.inc
2 --source include/have_partition.inc
3 --source include/have_symlink.inc
4
5 --echo #
6 --echo # MDEV-15953 Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
7 --echo #
8
9 mkdir $MYSQLTEST_VARDIR/tmp/partitions_here;
10
11 evalp CREATE TABLE t (
12 a INT NOT NULL, KEY(a)
13 ) ENGINE=INNODB
14 PARTITION BY HASH (a) (
15 PARTITION p1 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/' ENGINE = INNODB,
16 PARTITION p2 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/' ENGINE = INNODB
17 );
18 INSERT INTO t VALUES (1);
19
20 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
21 SHOW CREATE TABLE t;
22 ALTER TABLE t ADD PRIMARY KEY pk(a), ALGORITHM=INPLACE;
23 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
24 SHOW CREATE TABLE t;
25 ALTER TABLE t DROP PRIMARY KEY, ALGORITHM=COPY;
26 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
27 SHOW CREATE TABLE t;
28 SET @TMP = @@GLOBAL.INNODB_FILE_PER_TABLE;
29 SET GLOBAL INNODB_FILE_PER_TABLE=OFF;
30 ALTER TABLE t ADD PRIMARY KEY pk(a), ALGORITHM=INPLACE;
31 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
32 SHOW CREATE TABLE t;
33 SET GLOBAL INNODB_FILE_PER_TABLE=@TMP;
34
35 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
36 eval ALTER TABLE t REORGANIZE PARTITION p1,p2 INTO (
37 PARTITION p1 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB,
38 PARTITION p2 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB
39 );
40 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
41 SHOW CREATE TABLE t;
42
43 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
44 eval ALTER TABLE t REORGANIZE PARTITION p1,p2 INTO (
45 PARTITION p1 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/',
46 PARTITION p2 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
47 );
48 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
49 SHOW CREATE TABLE t;
50
51 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
52 eval ALTER TABLE t REORGANIZE PARTITION p1,p2 INTO (
53 PARTITION p1 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB,
54 PARTITION p2 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB
55 );
56 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
57 SHOW CREATE TABLE t;
58
59 DROP TABLE t;
60
61 SET @strict = @@innodb_strict_mode;
62 SET innodb_strict_mode=OFF;
63 evalp CREATE TABLE t (
64 a INT NOT NULL, KEY(a)
65 ) ENGINE=INNODB
66 PARTITION BY RANGE (a)
67 SUBPARTITION BY HASH (a)
68 SUBPARTITIONS 2
69 (
70 PARTITION p1 VALUES LESS THAN (7)
71 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/'
72 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
73 ENGINE = INNODB,
74 PARTITION p2 VALUES LESS THAN MAXVALUE
75 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/'
76 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
77 ENGINE = INNODB
78 );
79 SET innodb_strict_mode=@strict;
80
81 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
82 eval ALTER TABLE t
83 REORGANIZE PARTITION p1,p2 INTO
84 (
85 PARTITION p1 VALUES LESS THAN (7)
86 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
87 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/'
88 ENGINE = INNODB,
89 PARTITION p2 VALUES LESS THAN MAXVALUE
90 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
91 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/'
92 ENGINE = INNODB
93 );
94
95 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
96 SHOW CREATE TABLE t;
97
98 DROP TABLE t;
99
100 rmdir $MYSQLTEST_VARDIR/tmp/partitions_here/test;
101 rmdir $MYSQLTEST_VARDIR/tmp/partitions_here;
102