Debian Codegraph @

mysql-test/suite/innodb/t/subpartition.test

raw
1 SET @file_per_table=@@global.innodb_file_per_table;
2
3 CREATE TABLESPACE table_level ADD DATAFILE 'table.ibd';
4 CREATE TABLESPACE partition_level ADD DATAFILE 'partition.ibd';
5 CREATE TABLESPACE subpartition_level ADD DATAFILE 'subpartition.ibd';
6
7 --mkdir $MYSQL_TMP_DIR/table
8 --mkdir $MYSQL_TMP_DIR/partition
9 --mkdir $MYSQL_TMP_DIR/subpartition
10
11 CREATE TABLE subpartitioned(a int auto_increment primary key)
12 TABLESPACE table_level
13 PARTITION BY RANGE (a)
14 SUBPARTITION BY HASH (a) SUBPARTITIONS 2
15 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE partition_level
16 (SUBPARTITION sp0 TABLESPACE subpartition_level,
17 SUBPARTITION sp1),
18 PARTITION p1 VALUES LESS THAN (16)
19 (SUBPARTITION sp2,
20 SUBPARTITION sp3 TABLESPACE innodb_file_per_table),
21 PARTITION p2 VALUES LESS THAN (256) TABLESPACE innodb_file_per_table
22 (SUBPARTITION sp4 TABLESPACE subpartition_level,
23 SUBPARTITION sp5));
24
25 --echo # Subpartitions show the inherited TABLESPACE.
26 --echo # Bug#23219564 FIXME: the TABLESPACE of PARTITION should be shown!
27 SHOW CREATE TABLE subpartitioned;
28
29 --echo # The TABLESPACE of PARTITION/TABLE should be inherited for subpartitions
30
31 ALTER TABLE subpartitioned ADD PARTITION (PARTITION p3 VALUES LESS THAN (65536) (SUBPARTITION sp6 TABLESPACE innodb_file_per_table, SUBPARTITION sp7 TABLESPACE innodb_system));
32
33 SHOW CREATE TABLE subpartitioned;
34
35 ALTER TABLE subpartitioned REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN(65536) (SUBPARTITION sp6, SUBPARTITION sp7 TABLESPACE subpartition_level));
36
37 SHOW CREATE TABLE subpartitioned;
38
39 ALTER TABLE subpartitioned DROP PARTITION p3;
40
41 SHOW CREATE TABLE subpartitioned;
42
43 DROP TABLE subpartitioned;
44
45 CREATE TABLE partitioned(a int auto_increment primary key)
46 TABLESPACE table_level
47 PARTITION BY RANGE (a)
48 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE partition_level,
49 PARTITION p1 VALUES LESS THAN (16),
50 PARTITION p2 VALUES LESS THAN (256) TABLESPACE innodb_file_per_table);
51
52 --echo # Bug#23219685 FIXME: PARTITION should show inherited TABLESPACE!
53 SHOW CREATE TABLE partitioned;
54
55 DROP TABLE partitioned;
56
57 SET GLOBAL innodb_file_per_table=ON;
58 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
59 eval CREATE TABLE subpartitioned(a int auto_increment primary key)
60 DATA DIRECTORY '$MYSQL_TMP_DIR/table'
61 PARTITION BY RANGE (a)
62 SUBPARTITION BY HASH (a) SUBPARTITIONS 2
63 (PARTITION p0 VALUES LESS THAN (0) DATA DIRECTORY '$MYSQL_TMP_DIR/partition'
64 (SUBPARTITION sp0 DATA DIRECTORY '$MYSQL_TMP_DIR/subpartition',
65 SUBPARTITION sp1),
66 PARTITION p1 VALUES LESS THAN (16)
67 TABLESPACE innodb_file_per_table DATA DIRECTORY '$MYSQL_TMP_DIR/partition'
68 (SUBPARTITION sp2,
69 SUBPARTITION sp3 DATA DIRECTORY '$MYSQL_TMP_DIR/subpartition'),
70 PARTITION p2 VALUES LESS THAN (256)
71 (SUBPARTITION sp4 DATA DIRECTORY '$MYSQL_TMP_DIR/subpartition',
72 SUBPARTITION sp5));
73
74 --echo # Subpartitions show the inherited DATA DIRECTORY.
75 --echo # Bug#23219564 FIXME: the DATA DIRECTORY of PARTITION should be shown!
76 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
77 SHOW CREATE TABLE subpartitioned;
78
79 DROP TABLE subpartitioned;
80
81 SET GLOBAL innodb_file_per_table=OFF;
82 SET innodb_strict_mode=OFF;
83 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
84 eval CREATE TABLE subpartitioned(a int auto_increment primary key)
85 DATA DIRECTORY '$MYSQL_TMP_DIR/table'
86 PARTITION BY RANGE (a)
87 SUBPARTITION BY HASH (a) SUBPARTITIONS 2
88 (PARTITION p0 VALUES LESS THAN (0) DATA DIRECTORY '$MYSQL_TMP_DIR/partition'
89 (SUBPARTITION sp0 DATA DIRECTORY '$MYSQL_TMP_DIR/subpartition',
90 SUBPARTITION sp1),
91 PARTITION p1 VALUES LESS THAN (16)
92 TABLESPACE innodb_file_per_table DATA DIRECTORY '$MYSQL_TMP_DIR/partition'
93 (SUBPARTITION sp2,
94 SUBPARTITION sp3 DATA DIRECTORY '$MYSQL_TMP_DIR/subpartition'),
95 PARTITION p2 VALUES LESS THAN (256)
96 (SUBPARTITION sp4 DATA DIRECTORY '$MYSQL_TMP_DIR/subpartition',
97 SUBPARTITION sp5));
98 SET innodb_strict_mode=ON;
99
100 --echo # Subpartitions show the inherited DATA DIRECTORY.
101 --echo # Bug#23219564 FIXME: the DATA DIRECTORY of PARTITION should be shown!
102 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
103 SHOW CREATE TABLE subpartitioned;
104
105 --echo # The DATA DIRECTORY of PARTITION/TABLE should be inherited for subpartitions
106 SET GLOBAL innodb_file_per_table=ON;
107
108 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
109 eval ALTER TABLE subpartitioned ADD PARTITION (PARTITION p3 VALUES LESS THAN (65536) TABLESPACE innodb_file_per_table DATA DIRECTORY '$MYSQL_TMP_DIR/partition' (SUBPARTITION sp6, SUBPARTITION sp7));
110
111 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
112 SHOW CREATE TABLE subpartitioned;
113
114 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
115 eval ALTER TABLE subpartitioned REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN(65536) (SUBPARTITION sp6, SUBPARTITION sp7 DATA DIRECTORY '$MYSQL_TMP_DIR/subpartition'));
116
117 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
118 SHOW CREATE TABLE subpartitioned;
119
120 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
121 ALTER TABLE subpartitioned DROP PARTITION p3;
122
123 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
124 SHOW CREATE TABLE subpartitioned;
125
126 DROP TABLE subpartitioned;
127
128 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
129 eval CREATE TABLE partitioned(a int auto_increment primary key)
130 DATA DIRECTORY '$MYSQL_TMP_DIR/table'
131 PARTITION BY RANGE (a)
132 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE innodb_file_per_table,
133 PARTITION p1 VALUES LESS THAN (16)
134 TABLESPACE innodb_file_per_table DATA DIRECTORY '$MYSQL_TMP_DIR/partition',
135 PARTITION p2 VALUES LESS THAN (256));
136
137 --echo # Bug#23219685 FIXME: PARTITION should show inherited DATA DIRECTORY!
138 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
139 SHOW CREATE TABLE partitioned;
140
141 DROP TABLE partitioned;
142
143 SET GLOBAL innodb_file_per_table=OFF;
144 SET innodb_strict_mode=OFF;
145 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
146 eval CREATE TABLE partitioned(a int auto_increment primary key)
147 DATA DIRECTORY '$MYSQL_TMP_DIR/table'
148 PARTITION BY RANGE (a)
149 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE innodb_file_per_table,
150 PARTITION p1 VALUES LESS THAN (16)
151 TABLESPACE innodb_file_per_table DATA DIRECTORY '$MYSQL_TMP_DIR/partition',
152 PARTITION p2 VALUES LESS THAN (256));
153 SET innodb_strict_mode=ON;
154
155 --echo # Bug#23219685 FIXME: PARTITION should show inherited DATA DIRECTORY!
156 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
157 SHOW CREATE TABLE partitioned;
158
159 DROP TABLE partitioned;
160
161 --rmdir $MYSQL_TMP_DIR/table/test
162 --rmdir $MYSQL_TMP_DIR/table
163 --rmdir $MYSQL_TMP_DIR/partition/test
164 --rmdir $MYSQL_TMP_DIR/partition
165 --rmdir $MYSQL_TMP_DIR/subpartition/test
166 --rmdir $MYSQL_TMP_DIR/subpartition
167
168 DROP TABLESPACE table_level;
169 DROP TABLESPACE partition_level;
170 DROP TABLESPACE subpartition_level;
171
172 SET GLOBAL innodb_file_per_table=@file_per_table;