Debian Codegraph @

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

raw
1 --echo #
2 --echo # Test support for the COMPRESSION syntax on any system by
3 --echo # making InnoDB ignore the actual Punch Hole and setting the
4 --echo # file system punch hole size (block_size or compression unit)
5 --echo # to half the UNIV_PAGE_SIZE so that punch hole seems to work
6 --echo # even though no space on the FS is being released.
7 --echo #
8
9 --source include/have_innodb_max_16k.inc
10 --source include/have_punch_hole.inc
11
12 SET DEFAULT_STORAGE_ENGINE=InnoDB;
13
14 LET MYSQLD_DATADIR = `SELECT @@datadir`;
15
16 LET $prev_innodb_file_per_table = `SELECT @@innodb_file_per_table`;
17 SET GLOBAL innodb_file_per_table = ON;
18 SELECT @@innodb_file_per_table;
19
20 LET $prev_innodb_strict_mode = `SELECT @@innodb_strict_mode`;
21
22 CREATE TABLESPACE s1 ADD DATAFILE 's1.ibd';
23
24 --echo #
25 --echo # Try to create a table with ZLib compression with strict mode OFF.
26 --echo # If there is an error about Punch Hole not supported, make InnoDB
27 --echo # think that Punch Hole is working but actually ignore the calls.
28 --echo #
29 SET SESSION innodb_strict_mode = OFF;
30 SELECT @@innodb_strict_mode;
31
32 --disable_warnings
33 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB";
34 let COMPR_ZIP_WARN= `SHOW WARNINGS`;
35 --enable_warnings
36
37 perl;
38 use strict;
39 my $no_holes = ($ENV{COMPR_ZIP_WARN} =~ /Punch hole not supported/)? 1 : 0;
40 ### we do not expect any other warning
41 printf("Unexpected warning: %s\n",$ENV{COMPR_ZIP_WARN})
42 if (not $no_holes and $ENV{COMPR_ZIP_WARN} ne '');
43 open(DHF,">$ENV{'MYSQLD_DATADIR'}/compr.inc");
44 printf DHF "let \$no_holes= %s;\n",$no_holes;
45 close(DHF);
46 EOF
47
48 --source $MYSQLD_DATADIR/compr.inc
49 --remove_file $MYSQLD_DATADIR/compr.inc
50 LET IGNORE_PUNCH_HOLE=1;
51 if ($no_holes)
52 {
53 --source include/have_debug.inc
54 --disable_query_log
55 LET IGNORE_PUNCH_HOLE=1;
56 SET DEBUG='+d,ignore_punch_hole';
57 --enable_query_log
58 }
59 DROP TABLE t1;
60
61 --echo #
62 --echo # Test acceptable DDL with innodb_strict_mode=ON.
63 --echo #
64 SET SESSION innodb_strict_mode = ON;
65 SELECT @@innodb_strict_mode;
66
67 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB";
68 SHOW CREATE TABLE t1;
69 INSERT INTO t1 VALUES(1),(2),(3),(4);
70 FLUSH TABLES t1 WITH READ LOCK;
71 UNLOCK TABLES;
72 SELECT * FROM t1;
73
74 CREATE TABLE t2(c1 INT PRIMARY KEY) COMPRESSION="LZ4";
75 SHOW CREATE TABLE t2;
76 INSERT INTO t2 VALUES(1),(2),(3),(4);
77 FLUSH TABLES t2 WITH READ LOCK;
78 UNLOCK TABLES;
79 SELECT * FROM t2;
80
81 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1' OR TABLE_NAME = 't2' ORDER BY TABLE_NAME;
82 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE 'test/t%' ORDER BY NAME;
83
84 --echo #
85 --echo # Bug#21687636 COMPRESSION COLUMN IN INNODB_TABLESPACES IS NOT CORRECT
86 --echo #
87 --source include/restart_mysqld.inc
88 IF ($IGNORE_PUNCH_HOLE)
89 {
90 --disable_query_log
91 SET DEBUG='+d,ignore_punch_hole';
92 --enable_query_log
93 }
94 SET GLOBAL innodb_file_per_table = ON;
95 SET SESSION innodb_strict_mode = ON;
96 SHOW CREATE TABLE t1;
97 SHOW CREATE TABLE t2;
98
99 --echo #
100 --echo # Bug#21557723 Create table from the SHOW CREATE TABLE output
101 --echo #
102 let $create1 = query_get_value(SHOW CREATE TABLE t1, Create Table, 1);
103 let $create2 = query_get_value(SHOW CREATE TABLE t2, Create Table, 1);
104 DROP TABLE t1, t2;
105 eval $create1;
106 eval $create2;
107 SHOW CREATE TABLE t1;
108 SHOW CREATE TABLE t2;
109 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1' OR TABLE_NAME = 't2' ORDER BY TABLE_NAME;
110 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE 'test/t%' ORDER BY NAME;
111 INSERT INTO t1 VALUES(1),(2),(3),(4);
112 FLUSH TABLES t1 WITH READ LOCK;
113 UNLOCK TABLES;
114 SELECT * FROM t1;
115 INSERT INTO t2 VALUES(1),(2),(3),(4);
116 FLUSH TABLES t2 WITH READ LOCK;
117 UNLOCK TABLES;
118 SELECT * FROM t2;
119 DROP TABLE t2;
120
121 --echo #
122 --echo # Create a second table using CREATE TABLE LIKE and CREATE TABLE AS SELECT *
123 --echo # starting with a table that really has Page Compression
124 --echo #
125 CREATE TABLE t2 LIKE t1;
126 INSERT INTO t2 SELECT * FROM t1;
127 CREATE TABLE t3 AS SELECT * FROM t1;
128 CREATE DATABASE test2;
129 CREATE TABLE test2.t2 LIKE t1;
130 INSERT INTO test2.t2 SELECT * FROM t1;
131 CREATE TABLE test2.t3 AS SELECT * FROM t1;
132
133 SELECT TABLE_SCHEMA, TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
134 WHERE TABLE_NAME = 't2' OR TABLE_NAME = 't3' ORDER BY TABLE_SCHEMA, TABLE_NAME;
135 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
136 WHERE NAME LIKE 'test%/t%' ORDER BY NAME;
137 SHOW CREATE TABLE t2;
138 SHOW CREATE TABLE t3;
139 SHOW CREATE TABLE test2.t2;
140 SHOW CREATE TABLE test2.t3;
141
142 DROP TABLE t2;
143 DROP TABLE t3;
144 DROP TABLE test2.t2;
145 DROP TABLE test2.t3;
146 DROP DATABASE test2;
147
148 --echo #
149 --echo # Change compression with ALTER TABLE
150 --echo #
151 ALTER TABLE t1 COMPRESSION='';
152 INSERT INTO t1 VALUES(5);
153 FLUSH TABLES t1 WITH READ LOCK;
154 UNLOCK TABLES;
155 SHOW CREATE TABLE t1;
156 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
157 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
158
159 ALTER TABLE t1 COMPRESSION='LZ4';
160 INSERT INTO t1 VALUES(6);
161 FLUSH TABLES t1 WITH READ LOCK;
162 UNLOCK TABLES;
163 SHOW CREATE TABLE t1;
164 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
165 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
166
167 ALTER TABLE t1 COMPRESSION='NONE';
168 INSERT INTO t1 VALUES(7);
169 FLUSH TABLES t1 WITH READ LOCK;
170 UNLOCK TABLES;
171 SHOW CREATE TABLE t1;
172 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
173 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
174
175 OPTIMIZE TABLE t1;
176 SHOW CREATE TABLE t1;
177 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
178 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
179
180 DROP TABLE t1;
181
182 --echo #
183 --echo # Test various BAD DDL with innodb_strict_mode=ON.
184 --echo #
185
186 --error ER_ILLEGAL_HA
187 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="zlibX";
188 SHOW WARNINGS;
189 --error ER_NO_SUCH_TABLE
190 SHOW CREATE TABLE t1;
191
192 --echo #
193 --echo # Check for too long string
194 --echo #
195 SET @long_str = REPEAT('ZLIB', 32768);
196 SET @s = CONCAT('CREATE TABLE t1(c1 INT) ENGINE=InnoDB, COMPRESSION="', @long_str, '"');
197 PREPARE stmt from @s;
198 --error ER_WRONG_STRING_LENGTH
199 EXECUTE stmt;
200 SHOW WARNINGS;
201 DEALLOCATE PREPARE stmt;
202 --error ER_NO_SUCH_TABLE
203 SHOW CREATE TABLE t1;
204
205 --echo #
206 --echo # Compression cannot be used with ROW_FORMAT=COMPRESSED, TEMPORARY
207 --echo # or Shared tablespaces, either general or system.
208 --echo #
209
210 --echo # CREATE TABLE: COMPRESSION + TEMPORARY
211 --error ER_ILLEGAL_HA
212 CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB";
213 SHOW WARNINGS;
214
215 --echo # CREATE TABLE: COMPRESSION + TABLESPACE
216 --error ER_ILLEGAL_HA
217 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=s1;
218 SHOW WARNINGS;
219
220 --echo # CREATE TABLE: COMPRESSION + TABLESPACE=innodb_system
221 --error ER_ILLEGAL_HA
222 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_system;
223 SHOW WARNINGS;
224
225 --echo # CREATE TABLE: COMPRESSION + TABLESPACE=innodb_temporary
226 --error ER_ILLEGAL_HA_CREATE_OPTION
227 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_temporary;
228 SHOW WARNINGS;
229
230 --echo # CREATE TABLE: COMPRESSION + TEMPORARY + TABLESPACE=innodb_temporary
231 --error ER_ILLEGAL_HA
232 CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_temporary;
233 SHOW WARNINGS;
234
235 --echo # CREATE TABLE: COMPRESSION + implicit System Tablespace
236 SET GLOBAL INNODB_FILE_PER_TABLE = OFF;
237 --error ER_ILLEGAL_HA
238 CREATE TABLE t1(C1 INT) ENGINE=InnoDB COMPRESSION="zlib";
239 SHOW WARNINGS;
240 --error ER_ILLEGAL_HA
241 CREATE TABLE t1(C1 INT) ENGINE=InnoDB COMPRESSION="blah";
242 SHOW WARNINGS;
243 SET GLOBAL INNODB_FILE_PER_TABLE = ON;
244
245 --echo # CREATE TABLE: COMPRESSION + ROW_FORMAT=COMPRESSED
246 --error ER_ILLEGAL_HA
247 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" ROW_FORMAT=COMPRESSED;
248 SHOW WARNINGS;
249
250 --echo # CREATE TABLE: COMPRESSION + KEY_BLOCK_SIZE
251 --error ER_ILLEGAL_HA
252 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" KEY_BLOCK_SIZE=2;
253 SHOW WARNINGS;
254
255 --echo # ALTER TABLE: implicit COMPRESSION + TABLESPACE
256 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB";
257 --error ER_ILLEGAL_HA_CREATE_OPTION
258 ALTER TABLE t1 TABLESPACE=s1;
259 SHOW WARNINGS;
260
261 --echo # ALTER TABLE: COMPRESSION + TABLESPACE
262 --error ER_ILLEGAL_HA_CREATE_OPTION
263 ALTER TABLE t1 COMPRESSION="LZ4" TABLESPACE=s1;
264 SHOW WARNINGS;
265
266 --echo # ALTER TABLE: implicit COMPRESSION + ROW_FORMAT=COMPRESSED
267 --error ER_ILLEGAL_HA_CREATE_OPTION
268 ALTER TABLE t1 ROW_FORMAT=COMPRESSED;
269 SHOW WARNINGS;
270
271 --echo # ALTER TABLE: COMPRESSION + ROW_FORMAT=COMPRESSED
272 --error ER_ILLEGAL_HA_CREATE_OPTION
273 ALTER TABLE t1 COMPRESSION="ZLIB" ROW_FORMAT=COMPRESSED;
274 SHOW WARNINGS;
275
276 --echo # ALTER TABLE: COMPRESSION + KEY_BLOCK_SIZE
277 --error ER_ILLEGAL_HA_CREATE_OPTION
278 ALTER TABLE t1 COMPRESSION="ZLIB" KEY_BLOCK_SIZE=2;
279 SHOW WARNINGS;
280
281 --echo # ALTER TABLE: COMPRESSION='abcdefghijklmnopqrstuvwxyz'
282 --error ER_ILLEGAL_HA_CREATE_OPTION
283 ALTER TABLE t1 COMPRESSION='abcdefghijklmnopqrstuvwxyz';
284 SHOW WARNINGS;
285 DROP TABLE t1;
286
287 --echo #
288 --echo # Test the bad combinations above with innodb_strict_mode=OFF.
289 --echo #
290 SET SESSION innodb_strict_mode = OFF;
291 SELECT @@innodb_strict_mode;
292
293 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="zlibX";
294 SHOW WARNINGS;
295 SHOW CREATE TABLE t1;
296 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
297 SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
298 DROP TABLE t1;
299
300 --echo #
301 --echo # Check for too long string
302 --echo #
303 SET @long_str = REPEAT('ZLIB', 32768);
304 SET @s = CONCAT('CREATE TABLE t1(c1 INT) ENGINE=InnoDB, COMPRESSION="', @long_str, '"');
305 PREPARE stmt from @s;
306 --error ER_WRONG_STRING_LENGTH
307 EXECUTE stmt;
308 SHOW WARNINGS;
309 DEALLOCATE PREPARE stmt;
310 --error ER_NO_SUCH_TABLE
311 SHOW CREATE TABLE t1;
312
313 --echo #
314 --echo # Compression cannot be used with ROW_FORMAT=COMPRESSED, TEMPORARY
315 --echo # or Shared tablespaces, either general or system.
316 --echo #
317
318 --echo # CREATE TABLE: COMPRESSION + TEMPORARY
319 --error ER_UNSUPPORTED_EXTENSION
320 CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB";
321 SHOW WARNINGS;
322
323 --echo # CREATE TABLE: COMPRESSION + TABLESPACE
324 --error ER_ILLEGAL_HA
325 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=s1;
326 SHOW WARNINGS;
327
328 --echo # CREATE TABLE: COMPRESSION + TABLESPACE=innodb_system
329 --error ER_ILLEGAL_HA
330 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_system;
331 SHOW WARNINGS;
332
333 --echo # CREATE TABLE: COMPRESSION + TABLESPACE=innodb_temporary
334 --error ER_ILLEGAL_HA_CREATE_OPTION
335 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_temporary;
336 SHOW WARNINGS;
337
338 --echo # CREATE TABLE: COMPRESSION + TEMPORARY + TABLESPACE=innodb_temporary
339 --error ER_ILLEGAL_HA
340 CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_temporary;
341 SHOW WARNINGS;
342
343 --echo # CREATE TABLE: COMPRESSION + implicit System Tablespace
344 SET GLOBAL INNODB_FILE_PER_TABLE = OFF;
345 --error ER_UNSUPPORTED_EXTENSION
346 CREATE TABLE t1(C1 INT) ENGINE=InnoDB COMPRESSION="zlib";
347 SHOW WARNINGS;
348 --error ER_UNSUPPORTED_EXTENSION
349 CREATE TABLE t1(C1 INT) ENGINE=InnoDB COMPRESSION="blah";
350 SHOW WARNINGS;
351 SET GLOBAL INNODB_FILE_PER_TABLE = ON;
352
353 --echo # CREATE TABLE: COMPRESSION + ROW_FORMAT=COMPRESSED
354 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" ROW_FORMAT=COMPRESSED;
355 SHOW WARNINGS;
356 SHOW CREATE TABLE t1;
357 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
358 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
359 INSERT INTO t1 VALUES(1),(2),(3),(4);
360 FLUSH TABLES t1 WITH READ LOCK;
361 UNLOCK TABLES;
362 SELECT * FROM t1;
363 DROP TABLE t1;
364
365 --echo # CREATE TABLE: COMPRESSION + KEY_BLOCK_SIZE
366 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" KEY_BLOCK_SIZE=2;
367 SHOW WARNINGS;
368 SHOW CREATE TABLE t1;
369 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
370 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
371 INSERT INTO t1 VALUES(1),(2),(3),(4);
372 FLUSH TABLES t1 WITH READ LOCK;
373 UNLOCK TABLES;
374 SELECT * FROM t1;
375 DROP TABLE t1;
376
377 --echo # ALTER TABLE: implicit COMPRESSION + TABLESPACE
378 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB";
379 --error ER_ILLEGAL_HA_CREATE_OPTION
380 ALTER TABLE t1 TABLESPACE=s1;
381 SHOW WARNINGS;
382
383 --echo # ALTER TABLE: COMPRESSION + TABLESPACE
384 --error ER_ILLEGAL_HA_CREATE_OPTION
385 ALTER TABLE t1 COMPRESSION="LZ4" TABLESPACE=s1;
386 SHOW WARNINGS;
387
388 --echo # ALTER TABLE: implicit COMPRESSION + ROW_FORMAT=COMPRESSED
389 ALTER TABLE t1 ROW_FORMAT=COMPRESSED;
390 SHOW WARNINGS;
391 SHOW CREATE TABLE t1;
392 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
393 SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
394
395 --echo # ALTER TABLE: COMPRESSION + ROW_FORMAT=COMPRESSED
396 ALTER TABLE t1 COMPRESSION="ZLIB" ROW_FORMAT=COMPRESSED;
397 SHOW WARNINGS;
398 SHOW CREATE TABLE t1;
399 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
400 SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
401
402 --echo # ALTER TABLE: COMPRESSION + KEY_BLOCK_SIZE
403 ALTER TABLE t1 COMPRESSION="ZLIB" KEY_BLOCK_SIZE=2;
404 SHOW WARNINGS;
405 SHOW CREATE TABLE t1;
406 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
407 SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
408
409 --echo # ALTER TABLE: COMPRESSION='abcdefghijklmnopqrstuvwxyz'
410 ALTER TABLE t1 COMPRESSION='abcdefghijklmnopqrstuvwxyz';
411 SHOW WARNINGS;
412 SHOW CREATE TABLE t1;
413 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
414 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
415 DROP TABLE t1;
416
417 --echo #
418 --echo # BUG#22916982 - ASSERT 0 IN FSP_SDI_GET_ROOT_PAGE_NUM(), FLUSH TABLES FOR EXPORT
419 --echo #
420
421 CREATE TABLE t1 (a INT) ENGINE=INNODB ROW_FORMAT=DYNAMIC COMPRESSION='ZLIB';
422 FLUSH TABLE t1 FOR EXPORT;
423 --source include/restart_mysqld.inc
424 FLUSH TABLE t1 FOR EXPORT;
425 UNLOCK TABLES;
426 DROP TABLE t1;
427
428 --echo #
429 --echo # Cleanup
430 --echo #
431 DROP TABLESPACE s1;
432 eval SET GLOBAL INNODB_FILE_PER_TABLE=$prev_innodb_file_per_table;
433 eval SET GLOBAL INNODB_FILE_PER_TABLE=$prev_innodb_strict_mode;
434 SET DEBUG='-d,ignore_punch_hole';
435 SET DEBUG='-d,ignore_punch_hole_size';