Debian Codegraph @

mysql-test/suite/parts/r/alter_data_directory_innodb.result

raw
1 #
2 # MDEV-15953 Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
3 #
4 CREATE TABLE t (
5 a INT NOT NULL
6 ) ENGINE=INNODB
7 PARTITION BY HASH (a) (
8 PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here/' ENGINE = INNODB,
9 PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here/' ENGINE = INNODB
10 );
11 INSERT INTO t VALUES (1);
12 SHOW CREATE TABLE t;
13 Table Create Table
14 t CREATE TABLE `t` (
15 `a` int(11) NOT NULL
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
17 PARTITION BY HASH (`a`)
18 (PARTITION `p1` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB,
19 PARTITION `p2` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB)
20 ALTER TABLE t ADD PRIMARY KEY pk(a), ALGORITHM=INPLACE;
21 Warnings:
22 Warning 1280 Name 'pk' ignored for PRIMARY key.
23 SHOW CREATE TABLE t;
24 Table Create Table
25 t CREATE TABLE `t` (
26 `a` int(11) NOT NULL,
27 PRIMARY KEY (`a`)
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
29 PARTITION BY HASH (`a`)
30 (PARTITION `p1` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB,
31 PARTITION `p2` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB)
32 ALTER TABLE t DROP PRIMARY KEY, ALGORITHM=COPY;
33 SHOW CREATE TABLE t;
34 Table Create Table
35 t CREATE TABLE `t` (
36 `a` int(11) NOT NULL
37 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
38 PARTITION BY HASH (`a`)
39 (PARTITION `p1` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB,
40 PARTITION `p2` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB)
41 SET @TMP = @@GLOBAL.INNODB_FILE_PER_TABLE;
42 SET GLOBAL INNODB_FILE_PER_TABLE=OFF;
43 Warnings:
44 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
45 ALTER TABLE t ADD PRIMARY KEY pk(a), ALGORITHM=INPLACE;
46 Warnings:
47 Warning 1280 Name 'pk' ignored for PRIMARY key.
48 SHOW CREATE TABLE t;
49 Table Create Table
50 t CREATE TABLE `t` (
51 `a` int(11) NOT NULL,
52 PRIMARY KEY (`a`)
53 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
54 PARTITION BY HASH (`a`)
55 (PARTITION `p1` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB,
56 PARTITION `p2` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB)
57 SET GLOBAL INNODB_FILE_PER_TABLE=@TMP;
58 Warnings:
59 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
60 ALTER TABLE t REORGANIZE PARTITION p1,p2 INTO (
61 PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB,
62 PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB
63 );
64 Warnings:
65 Warning 1982 DATA DIRECTORY option ignored for InnoDB partition
66 Warning 1982 DATA DIRECTORY option ignored for InnoDB partition
67 SHOW CREATE TABLE t;
68 Table Create Table
69 t CREATE TABLE `t` (
70 `a` int(11) NOT NULL,
71 PRIMARY KEY (`a`)
72 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
73 PARTITION BY HASH (`a`)
74 (PARTITION `p1` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB,
75 PARTITION `p2` DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/partitions_here' ENGINE = InnoDB)
76 DROP TABLE t;