Debian Codegraph @

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

raw
1 #
2 # WL#6205 - A series of tests to show the correct behavior for
3 # CREATE TABLESPACE and associated SQL statements for 4k page size.
4 #
5
6 --echo #
7 --echo # CREATE TABLESPACE related tests for 4k page sizes.
8 --echo #
9
10 SET DEFAULT_STORAGE_ENGINE=InnoDB;
11 LET $MYSQLD_DATADIR = `select @@datadir`;
12 LET $INNODB_PAGE_SIZE = `select @@innodb_page_size`;
13
14 --echo # Strict-mode has no effect on CREATE TABLESPACE. But it does affect
15 --echo # whether an invalid KEY_BLOCK_SIZE is rejected or adjusted.
16 SHOW VARIABLES LIKE 'innodb_strict_mode';
17 SHOW VARIABLES LIKE 'innodb_file_per_table';
18
19 --echo #
20 --echo # Create a tablespace with compressed page sizes that can match
21 --echo # innodb-page-size.
22 --echo #
23 CREATE TABLESPACE s_1k ADD DATAFILE 's_1k.ibd' FILE_BLOCK_SIZE=1k;
24 CREATE TABLESPACE s_2k ADD DATAFILE 's_2k.ibd' FILE_BLOCK_SIZE=2k;
25 CREATE TABLESPACE s_4k ADD DATAFILE 's_4k.ibd' FILE_BLOCK_SIZE=4k;
26 --error ER_ILLEGAL_HA_CREATE_OPTION
27 CREATE TABLESPACE s_8k ADD DATAFILE 's_8k.ibd' FILE_BLOCK_SIZE=8k;
28 SHOW WARNINGS;
29 --error ER_ILLEGAL_HA_CREATE_OPTION
30 CREATE TABLESPACE s_16k ADD DATAFILE 's_16k.ibd' FILE_BLOCK_SIZE=16k;
31 SHOW WARNINGS;
32 --error ER_ILLEGAL_HA_CREATE_OPTION
33 CREATE TABLESPACE s_32k ADD DATAFILE 's_32k.ibd' FILE_BLOCK_SIZE=32k;
34 SHOW WARNINGS;
35 --error ER_ILLEGAL_HA_CREATE_OPTION
36 CREATE TABLESPACE s_64k ADD DATAFILE 's_64k.ibd' FILE_BLOCK_SIZE=64k;
37 SHOW WARNINGS;
38 --source suite/innodb/include/show_i_s_tablespaces.inc
39
40 --echo #
41 --echo # Try to put a temporary table into a non-temporary compressed tablespace
42 --echo #
43 --error ER_ILLEGAL_HA_CREATE_OPTION
44 CREATE TEMPORARY TABLE t_temp_zip (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_1k;
45 SHOW WARNINGS;
46
47 --echo #
48 --echo # Add tables to the 1K tablespace.
49 --echo #
50 CREATE TABLE t_zip1k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_1k;
51 --error ER_ILLEGAL_HA_CREATE_OPTION
52 CREATE TABLE t_zip2k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_1k;
53 SHOW WARNINGS;
54 --error ER_ILLEGAL_HA_CREATE_OPTION
55 CREATE TABLE t_zip4k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_1k;
56 SHOW WARNINGS;
57 --error ER_ILLEGAL_HA_CREATE_OPTION
58 CREATE TABLE t_zip8k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_1k;
59 SHOW WARNINGS;
60 --error ER_ILLEGAL_HA_CREATE_OPTION
61 CREATE TABLE t_zip16k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_1k;
62 SHOW WARNINGS;
63 --error ER_ILLEGAL_HA_CREATE_OPTION
64 CREATE TABLE t_zip32k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_1k;
65 SHOW WARNINGS;
66 --error ER_ILLEGAL_HA_CREATE_OPTION
67 CREATE TABLE t_red_in_1k (a int, b text) ROW_FORMAT=Redundant TABLESPACE s_1k;
68 SHOW WARNINGS;
69 --error ER_ILLEGAL_HA_CREATE_OPTION
70 CREATE TABLE t_cmp_in_1k (a int, b text) ROW_FORMAT=Compact TABLESPACE s_1k;
71 SHOW WARNINGS;
72 --error ER_ILLEGAL_HA_CREATE_OPTION
73 CREATE TABLE t_dyn_in_1k (a int, b text) ROW_FORMAT=Dynamic TABLESPACE s_1k;
74 SHOW WARNINGS;
75
76 --echo #
77 --echo # Add tables to the 2K tablespace.
78 --echo #
79 --error ER_ILLEGAL_HA_CREATE_OPTION
80 CREATE TABLE t_zip1k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_2k;
81 SHOW WARNINGS;
82 CREATE TABLE t_zip2k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_2k;
83 --error ER_ILLEGAL_HA_CREATE_OPTION
84 CREATE TABLE t_zip4k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_2k;
85 SHOW WARNINGS;
86 --error ER_ILLEGAL_HA_CREATE_OPTION
87 CREATE TABLE t_zip8k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_2k;
88 SHOW WARNINGS;
89 --error ER_ILLEGAL_HA_CREATE_OPTION
90 CREATE TABLE t_zip16k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_2k;
91 SHOW WARNINGS;
92 --error ER_ILLEGAL_HA_CREATE_OPTION
93 CREATE TABLE t_zip32k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_2k;
94 SHOW WARNINGS;
95 --error ER_ILLEGAL_HA_CREATE_OPTION
96 CREATE TABLE t_red_in_2k (a int, b text) ROW_FORMAT=Redundant TABLESPACE s_2k;
97 SHOW WARNINGS;
98 --error ER_ILLEGAL_HA_CREATE_OPTION
99 CREATE TABLE t_cmp_in_2k (a int, b text) ROW_FORMAT=Compact TABLESPACE s_2k;
100 SHOW WARNINGS;
101 --error ER_ILLEGAL_HA_CREATE_OPTION
102 CREATE TABLE t_dyn_in_2k (a int, b text) ROW_FORMAT=Dynamic TABLESPACE s_2k;
103 SHOW WARNINGS;
104
105 --echo #
106 --echo # Add tables to the 4K tablespace.
107 --echo #
108 --error ER_ILLEGAL_HA_CREATE_OPTION
109 CREATE TABLE t_zip1k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_4k;
110 SHOW WARNINGS;
111 --error ER_ILLEGAL_HA_CREATE_OPTION
112 CREATE TABLE t_zip2k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_4k;
113 SHOW WARNINGS;
114 --error ER_ILLEGAL_HA_CREATE_OPTION
115 CREATE TABLE t_zip4k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_4k;
116 SHOW WARNINGS;
117 --error ER_ILLEGAL_HA_CREATE_OPTION
118 CREATE TABLE t_zip8k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_4k;
119 SHOW WARNINGS;
120 --error ER_ILLEGAL_HA_CREATE_OPTION
121 CREATE TABLE t_zip16k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_4k;
122 SHOW WARNINGS;
123 --error ER_ILLEGAL_HA_CREATE_OPTION
124 CREATE TABLE t_zip32k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_4k;
125 SHOW WARNINGS;
126
127 CREATE TABLE t_red_in_4k (a int, b text) ROW_FORMAT=redundant TABLESPACE s_4k;
128 CREATE TABLE t_com_in_4k (a int, b text) ROW_FORMAT=compact TABLESPACE s_4k;
129 CREATE TABLE t_dyn_in_4k (a int, b text) ROW_FORMAT=dynamic TABLESPACE s_4k;
130
131 --echo # Add data to the existing Tables
132 INSERT INTO t_zip1k_in_1k VALUES (1,'a'),(2,'b'),(3,'c');
133 INSERT INTO t_zip2k_in_2k VALUES (1,'a'),(2,'b'),(3,'c');
134 INSERT INTO t_red_in_4k VALUES (1,'a'),(2,'b'),(3,'c');
135 INSERT INTO t_com_in_4k VALUES (1,'a'),(2,'b'),(3,'c');
136 INSERT INTO t_dyn_in_4k VALUES (1,'a'),(2,'b'),(3,'c');
137
138 --echo # Restart mysqld
139 --source include/restart_mysqld.inc
140
141 --echo #
142 --echo # Try to drop a tablespace which is not empty
143 --echo #
144 --error ER_TABLESPACE_IS_NOT_EMPTY
145 DROP TABLESPACE s_4k;
146
147 --echo #
148 --echo # Add more data to the existing Tables
149 --echo #
150 INSERT INTO t_zip1k_in_1k VALUES (4,'d');
151 INSERT INTO t_zip2k_in_2k VALUES (4,'d');
152 INSERT INTO t_red_in_4k VALUES (4,'d');
153 INSERT INTO t_com_in_4k VALUES (4,'d');
154 INSERT INTO t_dyn_in_4k VALUES (4,'d');
155
156 --echo #
157 --echo # Create an empty copy of each table using LIKE
158 --echo #
159 CREATE TABLE t_zip1k_in_1k_like LIKE t_zip1k_in_1k;
160 CREATE TABLE t_zip2k_in_2k_like LIKE t_zip2k_in_2k;
161 CREATE TABLE t_red_in_4k_like LIKE t_red_in_4k;
162 CREATE TABLE t_com_in_4k_like LIKE t_com_in_4k;
163 CREATE TABLE t_dyn_in_4k_like LIKE t_dyn_in_4k;
164
165 --echo #
166 --echo # Create a full copy of each table using AS
167 --echo #
168 CREATE TABLE t_zip1k_in_1k_as TABLESPACE=s_1k KEY_BLOCK_SIZE=1 AS (SELECT * FROM t_zip1k_in_1k);
169 CREATE TABLE t_zip2k_in_2k_as TABLESPACE=s_2k KEY_BLOCK_SIZE=2 AS (SELECT * FROM t_zip2k_in_2k);
170 CREATE TABLE t_red_in_4k_as TABLESPACE=s_4k ROW_FORMAT=redundant AS (SELECT * FROM t_red_in_4k);
171 CREATE TABLE t_com_in_4k_as TABLESPACE=s_4k ROW_FORMAT=compact AS (SELECT * FROM t_com_in_4k);
172 CREATE TABLE t_dyn_in_4k_as TABLESPACE=s_4k ROW_FORMAT=dynamic AS (SELECT * FROM t_dyn_in_4k);
173
174 --echo #
175 --echo # Create a copy of the 1k table, moving it to another tablespace with a different
176 --echo # FILE_BLOCK_SIZE, while changing the KEY_BLOCK_SIZE.
177 --echo #
178 CREATE TABLE t_zip2k_in_2k_from_1k TABLESPACE s_2k KEY_BLOCK_SIZE=2 AS (SELECT * FROM t_zip1k_in_1k);
179 CREATE TABLE t_red_in_4k_from_1k TABLESPACE s_4k ROW_FORMAT=redundant AS (SELECT * FROM t_zip1k_in_1k);
180 CREATE TABLE t_com_in_4k_from_1k TABLESPACE s_4k ROW_FORMAT=compact AS (SELECT * FROM t_zip1k_in_1k);
181 CREATE TABLE t_dyn_in_4k_from_1k TABLESPACE s_4k ROW_FORMAT=dynamic AS (SELECT * FROM t_zip1k_in_1k);
182
183 --source suite/innodb/include/show_i_s_tablespaces.inc
184 --source suite/innodb/include/show_i_s_tables.inc
185 --echo # Directory of MYSQLD_DATADIR/
186 --list_files $MYSQLD_DATADIR/ *.ibd
187 --echo # Directory of MYSQLD_DATADIR/test/
188 --list_files $MYSQLD_DATADIR/test/ *.ibd
189
190 --echo #
191 --echo # Restart the server and make sure that everything is OK.
192 --echo #
193 --source include/restart_mysqld.inc
194
195 --source suite/innodb/include/show_i_s_tablespaces.inc
196 --source suite/innodb/include/show_i_s_tables.inc
197 --echo # Directory of MYSQLD_DATADIR/
198 --list_files $MYSQLD_DATADIR/ *.ibd
199 --echo # Directory of MYSQLD_DATADIR/test/
200 --list_files $MYSQLD_DATADIR/test/ *.ibd
201
202 --echo #
203 --echo # Clean-up tables we no longer need
204 --echo #
205
206 DROP TABLE t_zip1k_in_1k_like;
207 DROP TABLE t_zip2k_in_2k_like;
208 DROP TABLE t_red_in_4k_like;
209 DROP TABLE t_com_in_4k_like;
210 DROP TABLE t_dyn_in_4k_like;
211 DROP TABLE t_zip1k_in_1k_as;
212 DROP TABLE t_zip2k_in_2k_as;
213 DROP TABLE t_red_in_4k_as;
214 DROP TABLE t_com_in_4k_as;
215 DROP TABLE t_dyn_in_4k_as;
216 DROP TABLE t_zip2k_in_2k_from_1k;
217 DROP TABLE t_red_in_4k_from_1k;
218 DROP TABLE t_com_in_4k_from_1k;
219 DROP TABLE t_dyn_in_4k_from_1k;
220
221 CHECK TABLE t_zip1k_in_1k;
222 CHECK TABLE t_zip2k_in_2k;
223 CHECK TABLE t_red_in_4k;
224 CHECK TABLE t_com_in_4k;
225 CHECK TABLE t_dyn_in_4k;
226
227 DROP TABLE t_zip1k_in_1k;
228 DROP TABLE t_zip2k_in_2k;
229 DROP TABLE t_red_in_4k;
230 DROP TABLE t_com_in_4k;
231 DROP TABLE t_dyn_in_4k;
232
233 --echo #
234 --echo # Create compressed tables explicitly as file_per_table tablespaces.
235 --echo #
236 CREATE TABLE t_zip1k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=1;
237 CREATE TABLE t_zip2k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=2;
238 CREATE TABLE t_zip4k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=4;
239
240 --echo #
241 --echo # Create compressed tables in remote locations using file-per-table.
242 --echo #
243 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
244 eval CREATE TABLE t_zip1k_as_remote (a int, b text) KEY_BLOCK_SIZE=1 TABLESPACE=innodb_file_per_table DATA DIRECTORY='$MYSQL_TMP_DIR';
245 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
246 eval CREATE TABLE t_zip2k_as_remote (a int, b text) KEY_BLOCK_SIZE=2 TABLESPACE=innodb_file_per_table DATA DIRECTORY='$MYSQL_TMP_DIR';
247 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
248 eval CREATE TABLE t_zip4k_as_remote (a int, b text) KEY_BLOCK_SIZE=4 TABLESPACE=innodb_file_per_table DATA DIRECTORY='$MYSQL_TMP_DIR';
249
250 --source suite/innodb/include/show_i_s_tablespaces.inc
251 --source suite/innodb/include/show_i_s_tables.inc
252 --echo # MYSQLD_DATADIR/
253 --list_files $MYSQLD_DATADIR/ *.ibd
254 --echo # MYSQLD_DATADIR/test/
255 --list_files $MYSQLD_DATADIR/test/ *.ibd
256
257 --echo #
258 --echo # These file_per_table tables cannot be moved to a general tablespace if the
259 --echo # FILE_BLOCK_SIZE does not match the KEY_BLOCK_SIZE or if the tablespace is
260 --echo # not compressed.
261 --echo #
262 --error ER_ILLEGAL_HA_CREATE_OPTION
263 ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_1k`;
264 SHOW WARNINGS;
265 --error ER_ILLEGAL_HA_CREATE_OPTION
266 ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_1k`;
267 SHOW WARNINGS;
268 --error ER_ILLEGAL_HA_CREATE_OPTION
269 ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_1k`;
270 SHOW WARNINGS;
271 --error ER_ILLEGAL_HA_CREATE_OPTION
272 ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_1k`;
273 SHOW WARNINGS;
274
275 --error ER_ILLEGAL_HA_CREATE_OPTION
276 ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_2k`;
277 SHOW WARNINGS;
278 --error ER_ILLEGAL_HA_CREATE_OPTION
279 ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_2k`;
280 SHOW WARNINGS;
281 --error ER_ILLEGAL_HA_CREATE_OPTION
282 ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_2k`;
283 SHOW WARNINGS;
284 --error ER_ILLEGAL_HA_CREATE_OPTION
285 ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_2k`;
286 SHOW WARNINGS;
287
288 --error ER_ILLEGAL_HA_CREATE_OPTION
289 ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_4k`;
290 SHOW WARNINGS;
291 --error ER_ILLEGAL_HA_CREATE_OPTION
292 ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_4k`;
293 SHOW WARNINGS;
294 --error ER_ILLEGAL_HA_CREATE_OPTION
295 ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_4k`;
296 SHOW WARNINGS;
297 --error ER_ILLEGAL_HA_CREATE_OPTION
298 ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_4k`;
299 SHOW WARNINGS;
300
301 DROP TABLE `t_zip4k_as_remote`;
302
303 --echo #
304 --echo # These explicit file_per_table tables can be moved to a general tablespace
305 --echo # if FILE_BLOCK_SIZE matches KEY_BLOCK_SIZE and the tablespace is compressed.
306 --echo #
307 ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_1k`, RENAME TO `t_zip1k_in_s_1k`;
308 ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_2k`, RENAME TO `t_zip2k_in_s_2k`;
309 ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_1k`, RENAME TO `t_zip1k_remote_in_s_1k`;
310 ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_2k`, RENAME TO `t_zip2k_remote_in_s_2k`;
311
312 --source suite/innodb/include/show_i_s_tablespaces.inc
313 --source suite/innodb/include/show_i_s_tables.inc
314 --echo # MYSQLD_DATADIR/
315 --list_files $MYSQLD_DATADIR/ *.ibd
316 --echo # MYSQLD_DATADIR/test/
317 --list_files $MYSQLD_DATADIR/test/ *.ibd
318
319 CHECK TABLE `t_zip1k_in_s_1k`;
320 CHECK TABLE `t_zip2k_in_s_2k`;
321 CHECK TABLE `t_zip1k_remote_in_s_1k`;
322 CHECK TABLE `t_zip2k_remote_in_s_2k`;
323
324 --echo #
325 --echo # Tables in general tablespaces cannot be moved to another general tablespace if the
326 --echo # FILE_BLOCK_SIZE does not match the KEY_BLOCK_SIZE or if the tablespace is
327 --echo # not compressed.
328 --echo #
329 --error ER_ILLEGAL_HA_CREATE_OPTION
330 ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_1k`;
331 SHOW WARNINGS;
332
333 --error ER_ILLEGAL_HA_CREATE_OPTION
334 ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_2k`;
335 SHOW WARNINGS;
336
337 --error ER_ILLEGAL_HA_CREATE_OPTION
338 ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_4k`;
339 SHOW WARNINGS;
340 --error ER_ILLEGAL_HA_CREATE_OPTION
341 ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_4k`;
342 SHOW WARNINGS;
343
344
345 --echo #
346 --echo # Tables in a general tablespace can be moved to file_per_table locations.
347 --echo #
348 ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip1k_to_file_per_table`;
349 ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip2k_to_file_per_table`;
350 --source suite/innodb/include/show_i_s_tablespaces.inc
351 --source suite/innodb/include/show_i_s_tables.inc
352
353 CHECK TABLE `t_zip1k_to_file_per_table`;
354 CHECK TABLE `t_zip2k_to_file_per_table`;
355 CHECK TABLE `t_zip4k_as_file_per_table`;
356
357 DROP TABLE `t_zip1k_to_file_per_table`;
358 DROP TABLE `t_zip2k_to_file_per_table`;
359 DROP TABLE `t_zip4k_as_file_per_table`;
360
361 --echo #
362 --echo # Tables in a general tablespace cannot be moved to remote file_per_table locations
363 --echo # because MySQL ignores DATA DIRECTORY in ALTER TABLE.
364 --echo #
365 ALTER TABLE `t_zip1k_remote_in_s_1k` TABLESPACE=`innodb_file_per_table`, DATA DIRECTORY='$MYSQL_TMP_DIR', RENAME TO `t_zip1k_to_file_per_table`;
366 ALTER TABLE `t_zip2k_remote_in_s_2k` TABLESPACE=`innodb_file_per_table`, DATA DIRECTORY='$MYSQL_TMP_DIR', RENAME TO `t_zip2k_to_file_per_table`;
367 --source suite/innodb/include/show_i_s_tablespaces.inc
368 --source suite/innodb/include/show_i_s_tables.inc
369
370 DROP TABLE `t_zip1k_to_file_per_table`;
371 DROP TABLE `t_zip2k_to_file_per_table`;
372
373 --echo #
374 --echo # Clean-up.
375 --echo #
376
377 DROP TABLESPACE s_1k;
378 DROP TABLESPACE s_2k;
379 DROP TABLESPACE s_4k;
380 --rmdir $MYSQL_TMP_DIR/test