Debian Codegraph @

mysql-test/suite/innodb/r/subpartition.result

raw
1 SET @file_per_table=@@global.innodb_file_per_table;
2 CREATE TABLESPACE table_level ADD DATAFILE 'table.ibd';
3 CREATE TABLESPACE partition_level ADD DATAFILE 'partition.ibd';
4 CREATE TABLESPACE subpartition_level ADD DATAFILE 'subpartition.ibd';
5 CREATE TABLE subpartitioned(a int auto_increment primary key)
6 TABLESPACE table_level
7 PARTITION BY RANGE (a)
8 SUBPARTITION BY HASH (a) SUBPARTITIONS 2
9 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE partition_level
10 (SUBPARTITION sp0 TABLESPACE subpartition_level,
11 SUBPARTITION sp1),
12 PARTITION p1 VALUES LESS THAN (16)
13 (SUBPARTITION sp2,
14 SUBPARTITION sp3 TABLESPACE innodb_file_per_table),
15 PARTITION p2 VALUES LESS THAN (256) TABLESPACE innodb_file_per_table
16 (SUBPARTITION sp4 TABLESPACE subpartition_level,
17 SUBPARTITION sp5));
18 # Subpartitions show the inherited TABLESPACE.
19 # Bug#23219564 FIXME: the TABLESPACE of PARTITION should be shown!
20 SHOW CREATE TABLE subpartitioned;
21 Table Create Table
22 subpartitioned CREATE TABLE `subpartitioned` (
23 `a` int(11) NOT NULL AUTO_INCREMENT,
24 PRIMARY KEY (`a`)
25 ) /*!50100 TABLESPACE `table_level` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
26 /*!50100 PARTITION BY RANGE (`a`)
27 SUBPARTITION BY HASH (`a`)
28 (PARTITION p0 VALUES LESS THAN (0)
29 (SUBPARTITION sp0 TABLESPACE = `subpartition_level` ENGINE = InnoDB,
30 SUBPARTITION sp1 TABLESPACE = `partition_level` ENGINE = InnoDB),
31 PARTITION p1 VALUES LESS THAN (16)
32 (SUBPARTITION sp2 TABLESPACE = `table_level` ENGINE = InnoDB,
33 SUBPARTITION sp3 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB),
34 PARTITION p2 VALUES LESS THAN (256)
35 (SUBPARTITION sp4 TABLESPACE = `subpartition_level` ENGINE = InnoDB,
36 SUBPARTITION sp5 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB)) */
37 # The TABLESPACE of PARTITION/TABLE should be inherited for subpartitions
38 ALTER TABLE subpartitioned ADD PARTITION (PARTITION p3 VALUES LESS THAN (65536) (SUBPARTITION sp6 TABLESPACE innodb_file_per_table, SUBPARTITION sp7 TABLESPACE innodb_system));
39 SHOW CREATE TABLE subpartitioned;
40 Table Create Table
41 subpartitioned CREATE TABLE `subpartitioned` (
42 `a` int(11) NOT NULL AUTO_INCREMENT,
43 PRIMARY KEY (`a`)
44 ) /*!50100 TABLESPACE `table_level` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
45 /*!50100 PARTITION BY RANGE (`a`)
46 SUBPARTITION BY HASH (`a`)
47 (PARTITION p0 VALUES LESS THAN (0)
48 (SUBPARTITION sp0 TABLESPACE = `subpartition_level` ENGINE = InnoDB,
49 SUBPARTITION sp1 TABLESPACE = `partition_level` ENGINE = InnoDB),
50 PARTITION p1 VALUES LESS THAN (16)
51 (SUBPARTITION sp2 TABLESPACE = `table_level` ENGINE = InnoDB,
52 SUBPARTITION sp3 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB),
53 PARTITION p2 VALUES LESS THAN (256)
54 (SUBPARTITION sp4 TABLESPACE = `subpartition_level` ENGINE = InnoDB,
55 SUBPARTITION sp5 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB),
56 PARTITION p3 VALUES LESS THAN (65536)
57 (SUBPARTITION sp6 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB,
58 SUBPARTITION sp7 TABLESPACE = `innodb_system` ENGINE = InnoDB)) */
59 ALTER TABLE subpartitioned REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN(65536) (SUBPARTITION sp6, SUBPARTITION sp7 TABLESPACE subpartition_level));
60 SHOW CREATE TABLE subpartitioned;
61 Table Create Table
62 subpartitioned CREATE TABLE `subpartitioned` (
63 `a` int(11) NOT NULL AUTO_INCREMENT,
64 PRIMARY KEY (`a`)
65 ) /*!50100 TABLESPACE `table_level` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
66 /*!50100 PARTITION BY RANGE (`a`)
67 SUBPARTITION BY HASH (`a`)
68 (PARTITION p0 VALUES LESS THAN (0)
69 (SUBPARTITION sp0 TABLESPACE = `subpartition_level` ENGINE = InnoDB,
70 SUBPARTITION sp1 TABLESPACE = `partition_level` ENGINE = InnoDB),
71 PARTITION p1 VALUES LESS THAN (16)
72 (SUBPARTITION sp2 TABLESPACE = `table_level` ENGINE = InnoDB,
73 SUBPARTITION sp3 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB),
74 PARTITION p2 VALUES LESS THAN (256)
75 (SUBPARTITION sp4 TABLESPACE = `subpartition_level` ENGINE = InnoDB,
76 SUBPARTITION sp5 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB),
77 PARTITION p3 VALUES LESS THAN (65536)
78 (SUBPARTITION sp6 TABLESPACE = `table_level` ENGINE = InnoDB,
79 SUBPARTITION sp7 TABLESPACE = `subpartition_level` ENGINE = InnoDB)) */
80 ALTER TABLE subpartitioned DROP PARTITION p3;
81 SHOW CREATE TABLE subpartitioned;
82 Table Create Table
83 subpartitioned CREATE TABLE `subpartitioned` (
84 `a` int(11) NOT NULL AUTO_INCREMENT,
85 PRIMARY KEY (`a`)
86 ) /*!50100 TABLESPACE `table_level` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 /*!50100 PARTITION BY RANGE (`a`)
88 SUBPARTITION BY HASH (`a`)
89 (PARTITION p0 VALUES LESS THAN (0)
90 (SUBPARTITION sp0 TABLESPACE = `subpartition_level` ENGINE = InnoDB,
91 SUBPARTITION sp1 TABLESPACE = `partition_level` ENGINE = InnoDB),
92 PARTITION p1 VALUES LESS THAN (16)
93 (SUBPARTITION sp2 TABLESPACE = `table_level` ENGINE = InnoDB,
94 SUBPARTITION sp3 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB),
95 PARTITION p2 VALUES LESS THAN (256)
96 (SUBPARTITION sp4 TABLESPACE = `subpartition_level` ENGINE = InnoDB,
97 SUBPARTITION sp5 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB)) */
98 DROP TABLE subpartitioned;
99 CREATE TABLE partitioned(a int auto_increment primary key)
100 TABLESPACE table_level
101 PARTITION BY RANGE (a)
102 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE partition_level,
103 PARTITION p1 VALUES LESS THAN (16),
104 PARTITION p2 VALUES LESS THAN (256) TABLESPACE innodb_file_per_table);
105 # Bug#23219685 FIXME: PARTITION should show inherited TABLESPACE!
106 SHOW CREATE TABLE partitioned;
107 Table Create Table
108 partitioned CREATE TABLE `partitioned` (
109 `a` int(11) NOT NULL AUTO_INCREMENT,
110 PRIMARY KEY (`a`)
111 ) /*!50100 TABLESPACE `table_level` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
112 /*!50100 PARTITION BY RANGE (`a`)
113 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE = `partition_level` ENGINE = InnoDB,
114 PARTITION p1 VALUES LESS THAN (16) TABLESPACE = `table_level` ENGINE = InnoDB,
115 PARTITION p2 VALUES LESS THAN (256) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB) */
116 DROP TABLE partitioned;
117 SET GLOBAL innodb_file_per_table=ON;
118 CREATE TABLE subpartitioned(a int auto_increment primary key)
119 DATA DIRECTORY 'MYSQL_TMP_DIR/table'
120 PARTITION BY RANGE (a)
121 SUBPARTITION BY HASH (a) SUBPARTITIONS 2
122 (PARTITION p0 VALUES LESS THAN (0) DATA DIRECTORY 'MYSQL_TMP_DIR/partition'
123 (SUBPARTITION sp0 DATA DIRECTORY 'MYSQL_TMP_DIR/subpartition',
124 SUBPARTITION sp1),
125 PARTITION p1 VALUES LESS THAN (16)
126 TABLESPACE innodb_file_per_table DATA DIRECTORY 'MYSQL_TMP_DIR/partition'
127 (SUBPARTITION sp2,
128 SUBPARTITION sp3 DATA DIRECTORY 'MYSQL_TMP_DIR/subpartition'),
129 PARTITION p2 VALUES LESS THAN (256)
130 (SUBPARTITION sp4 DATA DIRECTORY 'MYSQL_TMP_DIR/subpartition',
131 SUBPARTITION sp5));
132 # Subpartitions show the inherited DATA DIRECTORY.
133 # Bug#23219564 FIXME: the DATA DIRECTORY of PARTITION should be shown!
134 SHOW CREATE TABLE subpartitioned;
135 Table Create Table
136 subpartitioned CREATE TABLE `subpartitioned` (
137 `a` int(11) NOT NULL AUTO_INCREMENT,
138 PRIMARY KEY (`a`)
139 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
140 /*!50100 PARTITION BY RANGE (`a`)
141 SUBPARTITION BY HASH (`a`)
142 (PARTITION p0 VALUES LESS THAN (0)
143 (SUBPARTITION sp0 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/subpartition/' ENGINE = InnoDB,
144 SUBPARTITION sp1 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition/' ENGINE = InnoDB),
145 PARTITION p1 VALUES LESS THAN (16)
146 (SUBPARTITION sp2 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition/' ENGINE = InnoDB,
147 SUBPARTITION sp3 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/subpartition/' ENGINE = InnoDB),
148 PARTITION p2 VALUES LESS THAN (256)
149 (SUBPARTITION sp4 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/subpartition/' ENGINE = InnoDB,
150 SUBPARTITION sp5 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/table/' ENGINE = InnoDB)) */
151 DROP TABLE subpartitioned;
152 SET GLOBAL innodb_file_per_table=OFF;
153 SET innodb_strict_mode=OFF;
154 CREATE TABLE subpartitioned(a int auto_increment primary key)
155 DATA DIRECTORY 'MYSQL_TMP_DIR/table'
156 PARTITION BY RANGE (a)
157 SUBPARTITION BY HASH (a) SUBPARTITIONS 2
158 (PARTITION p0 VALUES LESS THAN (0) DATA DIRECTORY 'MYSQL_TMP_DIR/partition'
159 (SUBPARTITION sp0 DATA DIRECTORY 'MYSQL_TMP_DIR/subpartition',
160 SUBPARTITION sp1),
161 PARTITION p1 VALUES LESS THAN (16)
162 TABLESPACE innodb_file_per_table DATA DIRECTORY 'MYSQL_TMP_DIR/partition'
163 (SUBPARTITION sp2,
164 SUBPARTITION sp3 DATA DIRECTORY 'MYSQL_TMP_DIR/subpartition'),
165 PARTITION p2 VALUES LESS THAN (256)
166 (SUBPARTITION sp4 DATA DIRECTORY 'MYSQL_TMP_DIR/subpartition',
167 SUBPARTITION sp5));
168 Warnings:
169 Warning 1478 InnoDB: DATA DIRECTORY requires innodb_file_per_table.
170 Warning 1618 <DATA DIRECTORY> option ignored
171 Warning 1478 InnoDB: DATA DIRECTORY requires innodb_file_per_table.
172 Warning 1618 <DATA DIRECTORY> option ignored
173 Warning 1478 InnoDB: DATA DIRECTORY requires innodb_file_per_table.
174 Warning 1618 <DATA DIRECTORY> option ignored
175 Warning 1478 InnoDB: DATA DIRECTORY requires innodb_file_per_table.
176 Warning 1618 <DATA DIRECTORY> option ignored
177 Warning 1478 InnoDB: DATA DIRECTORY requires innodb_file_per_table.
178 Warning 1618 <DATA DIRECTORY> option ignored
179 SET innodb_strict_mode=ON;
180 # Subpartitions show the inherited DATA DIRECTORY.
181 # Bug#23219564 FIXME: the DATA DIRECTORY of PARTITION should be shown!
182 SHOW CREATE TABLE subpartitioned;
183 Table Create Table
184 subpartitioned CREATE TABLE `subpartitioned` (
185 `a` int(11) NOT NULL AUTO_INCREMENT,
186 PRIMARY KEY (`a`)
187 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
188 /*!50100 PARTITION BY RANGE (`a`)
189 SUBPARTITION BY HASH (`a`)
190 (PARTITION p0 VALUES LESS THAN (0)
191 (SUBPARTITION sp0 TABLESPACE = `innodb_system` ENGINE = InnoDB,
192 SUBPARTITION sp1 TABLESPACE = `innodb_system` ENGINE = InnoDB),
193 PARTITION p1 VALUES LESS THAN (16)
194 (SUBPARTITION sp2 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition/' ENGINE = InnoDB,
195 SUBPARTITION sp3 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/subpartition/' ENGINE = InnoDB),
196 PARTITION p2 VALUES LESS THAN (256)
197 (SUBPARTITION sp4 TABLESPACE = `innodb_system` ENGINE = InnoDB,
198 SUBPARTITION sp5 TABLESPACE = `innodb_system` ENGINE = InnoDB)) */
199 # The DATA DIRECTORY of PARTITION/TABLE should be inherited for subpartitions
200 SET GLOBAL innodb_file_per_table=ON;
201 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));
202 SHOW CREATE TABLE subpartitioned;
203 Table Create Table
204 subpartitioned CREATE TABLE `subpartitioned` (
205 `a` int(11) NOT NULL AUTO_INCREMENT,
206 PRIMARY KEY (`a`)
207 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
208 /*!50100 PARTITION BY RANGE (`a`)
209 SUBPARTITION BY HASH (`a`)
210 (PARTITION p0 VALUES LESS THAN (0)
211 (SUBPARTITION sp0 TABLESPACE = `innodb_system` ENGINE = InnoDB,
212 SUBPARTITION sp1 TABLESPACE = `innodb_system` ENGINE = InnoDB),
213 PARTITION p1 VALUES LESS THAN (16)
214 (SUBPARTITION sp2 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition' ENGINE = InnoDB,
215 SUBPARTITION sp3 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/subpartition' ENGINE = InnoDB),
216 PARTITION p2 VALUES LESS THAN (256)
217 (SUBPARTITION sp4 TABLESPACE = `innodb_system` ENGINE = InnoDB,
218 SUBPARTITION sp5 TABLESPACE = `innodb_system` ENGINE = InnoDB),
219 PARTITION p3 VALUES LESS THAN (65536)
220 (SUBPARTITION sp6 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition' ENGINE = InnoDB,
221 SUBPARTITION sp7 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition' ENGINE = InnoDB)) */
222 ALTER TABLE subpartitioned REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN(65536) (SUBPARTITION sp6, SUBPARTITION sp7 DATA DIRECTORY 'MYSQL_TMP_DIR/subpartition'));
223 SHOW CREATE TABLE subpartitioned;
224 Table Create Table
225 subpartitioned CREATE TABLE `subpartitioned` (
226 `a` int(11) NOT NULL AUTO_INCREMENT,
227 PRIMARY KEY (`a`)
228 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
229 /*!50100 PARTITION BY RANGE (`a`)
230 SUBPARTITION BY HASH (`a`)
231 (PARTITION p0 VALUES LESS THAN (0)
232 (SUBPARTITION sp0 TABLESPACE = `innodb_system` ENGINE = InnoDB,
233 SUBPARTITION sp1 TABLESPACE = `innodb_system` ENGINE = InnoDB),
234 PARTITION p1 VALUES LESS THAN (16)
235 (SUBPARTITION sp2 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition' ENGINE = InnoDB,
236 SUBPARTITION sp3 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/subpartition' ENGINE = InnoDB),
237 PARTITION p2 VALUES LESS THAN (256)
238 (SUBPARTITION sp4 TABLESPACE = `innodb_system` ENGINE = InnoDB,
239 SUBPARTITION sp5 TABLESPACE = `innodb_system` ENGINE = InnoDB),
240 PARTITION p3 VALUES LESS THAN (65536)
241 (SUBPARTITION sp6 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB,
242 SUBPARTITION sp7 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/subpartition' ENGINE = InnoDB)) */
243 ALTER TABLE subpartitioned DROP PARTITION p3;
244 SHOW CREATE TABLE subpartitioned;
245 Table Create Table
246 subpartitioned CREATE TABLE `subpartitioned` (
247 `a` int(11) NOT NULL AUTO_INCREMENT,
248 PRIMARY KEY (`a`)
249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
250 /*!50100 PARTITION BY RANGE (`a`)
251 SUBPARTITION BY HASH (`a`)
252 (PARTITION p0 VALUES LESS THAN (0)
253 (SUBPARTITION sp0 TABLESPACE = `innodb_system` ENGINE = InnoDB,
254 SUBPARTITION sp1 TABLESPACE = `innodb_system` ENGINE = InnoDB),
255 PARTITION p1 VALUES LESS THAN (16)
256 (SUBPARTITION sp2 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition' ENGINE = InnoDB,
257 SUBPARTITION sp3 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/subpartition' ENGINE = InnoDB),
258 PARTITION p2 VALUES LESS THAN (256)
259 (SUBPARTITION sp4 TABLESPACE = `innodb_system` ENGINE = InnoDB,
260 SUBPARTITION sp5 TABLESPACE = `innodb_system` ENGINE = InnoDB)) */
261 DROP TABLE subpartitioned;
262 CREATE TABLE partitioned(a int auto_increment primary key)
263 DATA DIRECTORY 'MYSQL_TMP_DIR/table'
264 PARTITION BY RANGE (a)
265 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE innodb_file_per_table,
266 PARTITION p1 VALUES LESS THAN (16)
267 TABLESPACE innodb_file_per_table DATA DIRECTORY 'MYSQL_TMP_DIR/partition',
268 PARTITION p2 VALUES LESS THAN (256));
269 # Bug#23219685 FIXME: PARTITION should show inherited DATA DIRECTORY!
270 SHOW CREATE TABLE partitioned;
271 Table Create Table
272 partitioned CREATE TABLE `partitioned` (
273 `a` int(11) NOT NULL AUTO_INCREMENT,
274 PRIMARY KEY (`a`)
275 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
276 /*!50100 PARTITION BY RANGE (`a`)
277 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/table/' ENGINE = InnoDB,
278 PARTITION p1 VALUES LESS THAN (16) TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition/' ENGINE = InnoDB,
279 PARTITION p2 VALUES LESS THAN (256) TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/table/' ENGINE = InnoDB) */
280 DROP TABLE partitioned;
281 SET GLOBAL innodb_file_per_table=OFF;
282 SET innodb_strict_mode=OFF;
283 CREATE TABLE partitioned(a int auto_increment primary key)
284 DATA DIRECTORY 'MYSQL_TMP_DIR/table'
285 PARTITION BY RANGE (a)
286 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE innodb_file_per_table,
287 PARTITION p1 VALUES LESS THAN (16)
288 TABLESPACE innodb_file_per_table DATA DIRECTORY 'MYSQL_TMP_DIR/partition',
289 PARTITION p2 VALUES LESS THAN (256));
290 Warnings:
291 Warning 1478 InnoDB: DATA DIRECTORY requires innodb_file_per_table.
292 Warning 1618 <DATA DIRECTORY> option ignored
293 Warning 1478 InnoDB: DATA DIRECTORY requires innodb_file_per_table.
294 Warning 1618 <DATA DIRECTORY> option ignored
295 SET innodb_strict_mode=ON;
296 # Bug#23219685 FIXME: PARTITION should show inherited DATA DIRECTORY!
297 SHOW CREATE TABLE partitioned;
298 Table Create Table
299 partitioned CREATE TABLE `partitioned` (
300 `a` int(11) NOT NULL AUTO_INCREMENT,
301 PRIMARY KEY (`a`)
302 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
303 /*!50100 PARTITION BY RANGE (`a`)
304 (PARTITION p0 VALUES LESS THAN (0) TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/table/' ENGINE = InnoDB,
305 PARTITION p1 VALUES LESS THAN (16) TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/partition/' ENGINE = InnoDB,
306 PARTITION p2 VALUES LESS THAN (256) TABLESPACE = `innodb_system` ENGINE = InnoDB) */
307 DROP TABLE partitioned;
308 DROP TABLESPACE table_level;
309 DROP TABLESPACE partition_level;
310 DROP TABLESPACE subpartition_level;
311 SET GLOBAL innodb_file_per_table=@file_per_table;