Debian Codegraph @

mysql-test/suite/parts/t/alter_data_directory_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 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
12 eval CREATE TABLE t (
13 a INT NOT NULL
14 ) ENGINE=INNODB
15 PARTITION BY HASH (a) (
16 PARTITION p1 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/' ENGINE = INNODB,
17 PARTITION p2 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/' ENGINE = INNODB
18 );
19 INSERT INTO t VALUES (1);
20
21 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
22 SHOW CREATE TABLE t;
23 ALTER TABLE t ADD PRIMARY KEY pk(a), ALGORITHM=INPLACE;
24 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
25 SHOW CREATE TABLE t;
26 ALTER TABLE t DROP PRIMARY KEY, ALGORITHM=COPY;
27 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
28 SHOW CREATE TABLE t;
29 SET @TMP = @@GLOBAL.INNODB_FILE_PER_TABLE;
30 SET GLOBAL INNODB_FILE_PER_TABLE=OFF;
31 ALTER TABLE t ADD PRIMARY KEY pk(a), ALGORITHM=INPLACE;
32 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
33 SHOW CREATE TABLE t;
34 SET GLOBAL INNODB_FILE_PER_TABLE=@TMP;
35
36 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
37 eval ALTER TABLE t REORGANIZE PARTITION p1,p2 INTO (
38 PARTITION p1 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB,
39 PARTITION p2 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB
40 );
41 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
42 SHOW CREATE TABLE t;
43
44 DROP TABLE t;
45
46 rmdir $MYSQLTEST_VARDIR/tmp/partitions_here/test;
47 rmdir $MYSQLTEST_VARDIR/tmp/partitions_here;