Debian Codegraph @

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

raw
1 #
2 # CREATE TABLESPACE related tests for 16k page sizes.
3 #
4 SET DEFAULT_STORAGE_ENGINE=InnoDB;
5 # Strict-mode has no effect on CREATE TABLESPACE. But it does affect
6 # whether an invalid KEY_BLOCK_SIZE is rejected or adjusted.
7 SHOW VARIABLES LIKE 'innodb_strict_mode';
8 Variable_name Value
9 innodb_strict_mode ON
10 SHOW VARIABLES LIKE 'innodb_file_per_table';
11 Variable_name Value
12 innodb_file_per_table ON
13 #
14 # Create a tablespace with compressed page sizes that can match
15 # innodb-page-size.
16 #
17 CREATE TABLESPACE s_1k ADD DATAFILE 's_1k.ibd' FILE_BLOCK_SIZE=1k;
18 CREATE TABLESPACE s_2k ADD DATAFILE 's_2k.ibd' FILE_BLOCK_SIZE=2k;
19 CREATE TABLESPACE s_4k ADD DATAFILE 's_4k.ibd' FILE_BLOCK_SIZE=4k;
20 CREATE TABLESPACE s_8k ADD DATAFILE 's_8k.ibd' FILE_BLOCK_SIZE=8k;
21 CREATE TABLESPACE s_16k ADD DATAFILE 's_16k.ibd' FILE_BLOCK_SIZE=16k;
22 CREATE TABLESPACE s_32k ADD DATAFILE 's_32k.ibd' FILE_BLOCK_SIZE=32k;
23 ERROR HY000: InnoDB: Cannot create a tablespace with FILE_BLOCK_SIZE=32768 because INNODB_PAGE_SIZE=16384.
24 SHOW WARNINGS;
25 Level Code Message
26 Error 1478 InnoDB: Cannot create a tablespace with FILE_BLOCK_SIZE=32768 because INNODB_PAGE_SIZE=16384.
27 Error 1528 Failed to create TABLESPACE s_32k
28 Error 1031 Table storage engine for 's_32k' doesn't have this option
29 CREATE TABLESPACE s_64k ADD DATAFILE 's_64k.ibd' FILE_BLOCK_SIZE=64k;
30 ERROR HY000: InnoDB: Cannot create a tablespace with FILE_BLOCK_SIZE=65536 because INNODB_PAGE_SIZE=16384.
31 SHOW WARNINGS;
32 Level Code Message
33 Error 1478 InnoDB: Cannot create a tablespace with FILE_BLOCK_SIZE=65536 because INNODB_PAGE_SIZE=16384.
34 Error 1528 Failed to create TABLESPACE s_64k
35 Error 1031 Table storage engine for 's_64k' doesn't have this option
36 === information_schema.innodb_tablespaces and innodb_datafiles ===
37 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
38 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
39 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
40 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
41 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
42 s_16k General DEFAULT 0 1 1 Any s_16k.ibd
43 s_1k General DEFAULT 1024 1 1 Compressed s_1k.ibd
44 s_2k General DEFAULT 2048 1 1 Compressed s_2k.ibd
45 s_4k General DEFAULT 4096 1 1 Compressed s_4k.ibd
46 s_8k General DEFAULT 8192 1 1 Compressed s_8k.ibd
47 === information_schema.files ===
48 Space_Name File_Type Engine Status Tablespace_Name Path
49 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
50 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
51 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
52 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
53 s_16k TABLESPACE InnoDB NORMAL s_16k MYSQLD_DATADIR/s_16k.ibd
54 s_1k TABLESPACE InnoDB NORMAL s_1k MYSQLD_DATADIR/s_1k.ibd
55 s_2k TABLESPACE InnoDB NORMAL s_2k MYSQLD_DATADIR/s_2k.ibd
56 s_4k TABLESPACE InnoDB NORMAL s_4k MYSQLD_DATADIR/s_4k.ibd
57 s_8k TABLESPACE InnoDB NORMAL s_8k MYSQLD_DATADIR/s_8k.ibd
58 #
59 # Try to put a temporary table into a non-temporary compressed tablespace
60 #
61 CREATE TEMPORARY TABLE t_temp_zip (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_1k;
62 ERROR HY000: InnoDB: Tablespace `s_1k` cannot contain TEMPORARY tables.
63 SHOW WARNINGS;
64 Level Code Message
65 Error 1478 InnoDB: Tablespace `s_1k` cannot contain TEMPORARY tables.
66 Error 1031 Table storage engine for 't_temp_zip' doesn't have this option
67 #
68 # Add tables to the 1K tablespace.
69 #
70 CREATE TABLE t_zip1k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_1k;
71 CREATE TABLE t_zip2k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_1k;
72 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 2048
73 SHOW WARNINGS;
74 Level Code Message
75 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 2048
76 Error 1031 Table storage engine for 't_zip2k_in_1k' doesn't have this option
77 CREATE TABLE t_zip4k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_1k;
78 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 4096
79 SHOW WARNINGS;
80 Level Code Message
81 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 4096
82 Error 1031 Table storage engine for 't_zip4k_in_1k' doesn't have this option
83 CREATE TABLE t_zip8k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_1k;
84 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 8192
85 SHOW WARNINGS;
86 Level Code Message
87 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 8192
88 Error 1031 Table storage engine for 't_zip8k_in_1k' doesn't have this option
89 CREATE TABLE t_zip16k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_1k;
90 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
91 SHOW WARNINGS;
92 Level Code Message
93 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
94 Error 1031 Table storage engine for 't_zip16k_in_1k' doesn't have this option
95 CREATE TABLE t_zip32k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_1k;
96 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 32768
97 SHOW WARNINGS;
98 Level Code Message
99 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 32768
100 Error 1031 Table storage engine for 't_zip32k_in_1k' doesn't have this option
101 CREATE TABLE t_red_in_1k (a int, b text) ROW_FORMAT=Redundant TABLESPACE s_1k;
102 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
103 SHOW WARNINGS;
104 Level Code Message
105 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
106 Error 1031 Table storage engine for 't_red_in_1k' doesn't have this option
107 CREATE TABLE t_cmp_in_1k (a int, b text) ROW_FORMAT=Compact TABLESPACE s_1k;
108 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
109 SHOW WARNINGS;
110 Level Code Message
111 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
112 Error 1031 Table storage engine for 't_cmp_in_1k' doesn't have this option
113 CREATE TABLE t_dyn_in_1k (a int, b text) ROW_FORMAT=Dynamic TABLESPACE s_1k;
114 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
115 SHOW WARNINGS;
116 Level Code Message
117 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
118 Error 1031 Table storage engine for 't_dyn_in_1k' doesn't have this option
119 #
120 # Add tables to the 2K tablespace.
121 #
122 CREATE TABLE t_zip1k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_2k;
123 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 1024
124 SHOW WARNINGS;
125 Level Code Message
126 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 1024
127 Error 1031 Table storage engine for 't_zip1k_in_2k' doesn't have this option
128 CREATE TABLE t_zip2k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_2k;
129 CREATE TABLE t_zip4k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_2k;
130 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 4096
131 SHOW WARNINGS;
132 Level Code Message
133 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 4096
134 Error 1031 Table storage engine for 't_zip4k_in_2k' doesn't have this option
135 CREATE TABLE t_zip8k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_2k;
136 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 8192
137 SHOW WARNINGS;
138 Level Code Message
139 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 8192
140 Error 1031 Table storage engine for 't_zip8k_in_2k' doesn't have this option
141 CREATE TABLE t_zip16k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_2k;
142 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
143 SHOW WARNINGS;
144 Level Code Message
145 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
146 Error 1031 Table storage engine for 't_zip16k_in_2k' doesn't have this option
147 CREATE TABLE t_zip32k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_2k;
148 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 32768
149 SHOW WARNINGS;
150 Level Code Message
151 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 32768
152 Error 1031 Table storage engine for 't_zip32k_in_2k' doesn't have this option
153 CREATE TABLE t_red_in_2k (a int, b text) ROW_FORMAT=Redundant TABLESPACE s_2k;
154 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
155 SHOW WARNINGS;
156 Level Code Message
157 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
158 Error 1031 Table storage engine for 't_red_in_2k' doesn't have this option
159 CREATE TABLE t_cmp_in_2k (a int, b text) ROW_FORMAT=Compact TABLESPACE s_2k;
160 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
161 SHOW WARNINGS;
162 Level Code Message
163 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
164 Error 1031 Table storage engine for 't_cmp_in_2k' doesn't have this option
165 CREATE TABLE t_dyn_in_2k (a int, b text) ROW_FORMAT=Dynamic TABLESPACE s_2k;
166 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
167 SHOW WARNINGS;
168 Level Code Message
169 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
170 Error 1031 Table storage engine for 't_dyn_in_2k' doesn't have this option
171 #
172 # Add tables to the 4K tablespace.
173 #
174 CREATE TABLE t_zip1k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_4k;
175 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 1024
176 SHOW WARNINGS;
177 Level Code Message
178 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 1024
179 Error 1031 Table storage engine for 't_zip1k_in_4k' doesn't have this option
180 CREATE TABLE t_zip2k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_4k;
181 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 2048
182 SHOW WARNINGS;
183 Level Code Message
184 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 2048
185 Error 1031 Table storage engine for 't_zip2k_in_4k' doesn't have this option
186 CREATE TABLE t_zip4k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_4k;
187 CREATE TABLE t_zip8k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_4k;
188 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 8192
189 SHOW WARNINGS;
190 Level Code Message
191 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 8192
192 Error 1031 Table storage engine for 't_zip8k_in_4k' doesn't have this option
193 CREATE TABLE t_zip16k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_4k;
194 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
195 SHOW WARNINGS;
196 Level Code Message
197 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
198 Error 1031 Table storage engine for 't_zip16k_in_4k' doesn't have this option
199 CREATE TABLE t_zip32k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_4k;
200 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 32768
201 SHOW WARNINGS;
202 Level Code Message
203 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 32768
204 Error 1031 Table storage engine for 't_zip32k_in_4k' doesn't have this option
205 CREATE TABLE t_red_in_4k (a int, b text) ROW_FORMAT=Redundant TABLESPACE s_4k;
206 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
207 SHOW WARNINGS;
208 Level Code Message
209 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
210 Error 1031 Table storage engine for 't_red_in_4k' doesn't have this option
211 CREATE TABLE t_cmp_in_4k (a int, b text) ROW_FORMAT=Compact TABLESPACE s_4k;
212 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
213 SHOW WARNINGS;
214 Level Code Message
215 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
216 Error 1031 Table storage engine for 't_cmp_in_4k' doesn't have this option
217 CREATE TABLE t_dyn_in_4k (a int, b text) ROW_FORMAT=Dynamic TABLESPACE s_4k;
218 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
219 SHOW WARNINGS;
220 Level Code Message
221 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
222 Error 1031 Table storage engine for 't_dyn_in_4k' doesn't have this option
223 #
224 # Add tables to the 8K tablespace.
225 #
226 CREATE TABLE t_zip1k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_8k;
227 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 1024
228 SHOW WARNINGS;
229 Level Code Message
230 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 1024
231 Error 1031 Table storage engine for 't_zip1k_in_8k' doesn't have this option
232 CREATE TABLE t_zip2k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_8k;
233 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 2048
234 SHOW WARNINGS;
235 Level Code Message
236 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 2048
237 Error 1031 Table storage engine for 't_zip2k_in_8k' doesn't have this option
238 CREATE TABLE t_zip4k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_8k;
239 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 4096
240 SHOW WARNINGS;
241 Level Code Message
242 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 4096
243 Error 1031 Table storage engine for 't_zip4k_in_8k' doesn't have this option
244 CREATE TABLE t_zip8k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_8k;
245 CREATE TABLE t_zip16k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_8k;
246 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
247 SHOW WARNINGS;
248 Level Code Message
249 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
250 Error 1031 Table storage engine for 't_zip16k_in_8k' doesn't have this option
251 CREATE TABLE t_zip32k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_8k;
252 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 32768
253 SHOW WARNINGS;
254 Level Code Message
255 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 32768
256 Error 1031 Table storage engine for 't_zip32k_in_8k' doesn't have this option
257 CREATE TABLE t_red_in_8k (a int, b text) ROW_FORMAT=redundant TABLESPACE s_8k;
258 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
259 SHOW WARNINGS;
260 Level Code Message
261 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
262 Error 1031 Table storage engine for 't_red_in_8k' doesn't have this option
263 CREATE TABLE t_com_in_8k (a int, b text) ROW_FORMAT=compact TABLESPACE s_8k;
264 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
265 SHOW WARNINGS;
266 Level Code Message
267 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
268 Error 1031 Table storage engine for 't_com_in_8k' doesn't have this option
269 CREATE TABLE t_dyn_in_8k (a int, b text) ROW_FORMAT=dynamic TABLESPACE s_8k;
270 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
271 SHOW WARNINGS;
272 Level Code Message
273 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
274 Error 1031 Table storage engine for 't_dyn_in_8k' doesn't have this option
275 #
276 # Add tables to the 16K tablespace.
277 #
278 CREATE TABLE t_zip1k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_16k;
279 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
280 SHOW WARNINGS;
281 Level Code Message
282 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
283 Error 1031 Table storage engine for 't_zip1k_in_16k' doesn't have this option
284 CREATE TABLE t_zip2k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_16k;
285 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
286 SHOW WARNINGS;
287 Level Code Message
288 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
289 Error 1031 Table storage engine for 't_zip2k_in_16k' doesn't have this option
290 CREATE TABLE t_zip4k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_16k;
291 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
292 SHOW WARNINGS;
293 Level Code Message
294 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
295 Error 1031 Table storage engine for 't_zip4k_in_16k' doesn't have this option
296 CREATE TABLE t_zip8k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_16k;
297 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
298 SHOW WARNINGS;
299 Level Code Message
300 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
301 Error 1031 Table storage engine for 't_zip8k_in_16k' doesn't have this option
302 CREATE TABLE t_zip16k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_16k;
303 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
304 SHOW WARNINGS;
305 Level Code Message
306 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
307 Error 1031 Table storage engine for 't_zip16k_in_16k' doesn't have this option
308 CREATE TABLE t_zip32k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_16k;
309 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
310 SHOW WARNINGS;
311 Level Code Message
312 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
313 Error 1031 Table storage engine for 't_zip32k_in_16k' doesn't have this option
314 CREATE TABLE t_red_in_16k (a int, b text) ROW_FORMAT=redundant TABLESPACE s_16k;
315 CREATE TABLE t_com_in_16k (a int, b text) ROW_FORMAT=compact TABLESPACE s_16k;
316 CREATE TABLE t_dyn_in_16k (a int, b text) ROW_FORMAT=dynamic TABLESPACE s_16k;
317 # Add data to the existing Tables
318 INSERT INTO t_zip1k_in_1k VALUES (1,'a'),(2,'b'),(3,'c');
319 INSERT INTO t_zip2k_in_2k VALUES (1,'a'),(2,'b'),(3,'c');
320 INSERT INTO t_zip4k_in_4k VALUES (1,'a'),(2,'b'),(3,'c');
321 INSERT INTO t_zip8k_in_8k VALUES (1,'a'),(2,'b'),(3,'c');
322 INSERT INTO t_red_in_16k VALUES (1,'a'),(2,'b'),(3,'c');
323 INSERT INTO t_com_in_16k VALUES (1,'a'),(2,'b'),(3,'c');
324 INSERT INTO t_dyn_in_16k VALUES (1,'a'),(2,'b'),(3,'c');
325 # Restart mysqld
326 # restart
327 #
328 # Try to drop these tablespaces which are not empty
329 #
330 DROP TABLESPACE s_1k;
331 ERROR HY000: Tablespace `s_1k` is not empty.
332 DROP TABLESPACE s_2k;
333 ERROR HY000: Tablespace `s_2k` is not empty.
334 DROP TABLESPACE s_4k;
335 ERROR HY000: Tablespace `s_4k` is not empty.
336 DROP TABLESPACE s_8k;
337 ERROR HY000: Tablespace `s_8k` is not empty.
338 DROP TABLESPACE s_16k;
339 ERROR HY000: Tablespace `s_16k` is not empty.
340 #
341 # Add more data to the existing Tables
342 #
343 INSERT INTO t_zip1k_in_1k VALUES (4,'d');
344 INSERT INTO t_zip2k_in_2k VALUES (4,'d');
345 INSERT INTO t_zip4k_in_4k VALUES (4,'d');
346 INSERT INTO t_zip8k_in_8k VALUES (4,'d');
347 INSERT INTO t_red_in_16k VALUES (4,'d');
348 INSERT INTO t_com_in_16k VALUES (4,'d');
349 INSERT INTO t_dyn_in_16k VALUES (4,'d');
350 #
351 # Create an empty copy of each table using LIKE
352 #
353 CREATE TABLE t_zip1k_in_1k_like LIKE t_zip1k_in_1k;
354 CREATE TABLE t_zip2k_in_2k_like LIKE t_zip2k_in_2k;
355 CREATE TABLE t_zip4k_in_4k_like LIKE t_zip4k_in_4k;
356 CREATE TABLE t_zip8k_in_8k_like LIKE t_zip8k_in_8k;
357 CREATE TABLE t_red_in_16k_like LIKE t_red_in_16k;
358 CREATE TABLE t_com_in_16k_like LIKE t_com_in_16k;
359 CREATE TABLE t_dyn_in_16k_like LIKE t_dyn_in_16k;
360 #
361 # Create a full copy of each table using AS
362 #
363 CREATE TABLE t_zip1k_in_1k_as TABLESPACE=s_1k KEY_BLOCK_SIZE=1 AS (SELECT * FROM t_zip1k_in_1k);
364 CREATE TABLE t_zip2k_in_2k_as TABLESPACE=s_2k KEY_BLOCK_SIZE=2 AS (SELECT * FROM t_zip2k_in_2k);
365 CREATE TABLE t_zip4k_in_4k_as TABLESPACE=s_4k KEY_BLOCK_SIZE=4 AS (SELECT * FROM t_zip4k_in_4k);
366 CREATE TABLE t_zip8k_in_8k_as TABLESPACE=s_8k KEY_BLOCK_SIZE=8 AS (SELECT * FROM t_zip8k_in_8k);
367 CREATE TABLE t_red_in_16k_as TABLESPACE=s_16k ROW_FORMAT=redundant AS (SELECT * FROM t_red_in_16k);
368 CREATE TABLE t_com_in_16k_as TABLESPACE=s_16k ROW_FORMAT=compact AS (SELECT * FROM t_com_in_16k);
369 CREATE TABLE t_dyn_in_16k_as TABLESPACE=s_16k ROW_FORMAT=dynamic AS (SELECT * FROM t_dyn_in_16k);
370 #
371 # Create a copy of the 1k table, moving it to another tablespace with a different
372 # FILE_BLOCK_SIZE, while changing the KEY_BLOCK_SIZE.
373 #
374 CREATE TABLE t_zip2k_in_2k_from_1k TABLESPACE s_2k KEY_BLOCK_SIZE=2 AS (SELECT * FROM t_zip1k_in_1k);
375 CREATE TABLE t_zip4k_in_4k_from_1k TABLESPACE s_4k KEY_BLOCK_SIZE=4 AS (SELECT * FROM t_zip1k_in_1k);
376 CREATE TABLE t_zip8k_in_8k_from_1k TABLESPACE s_8k KEY_BLOCK_SIZE=8 AS (SELECT * FROM t_zip1k_in_1k);
377 CREATE TABLE t_red_in_16k_from_1k TABLESPACE s_16k ROW_FORMAT=redundant AS (SELECT * FROM t_zip1k_in_1k);
378 CREATE TABLE t_com_in_16k_from_1k TABLESPACE s_16k ROW_FORMAT=compact AS (SELECT * FROM t_zip1k_in_1k);
379 CREATE TABLE t_dyn_in_16k_from_1k TABLESPACE s_16k ROW_FORMAT=dynamic AS (SELECT * FROM t_zip1k_in_1k);
380 #
381 # Create a tablespace that will be deleted while the engine is not
382 # running to show that it can still be dropped.
383 #
384 CREATE TABLESPACE s_missing ADD DATAFILE 'delete_me.ibd';
385 CREATE TABLE t_missing (a int) TABLESPACE=s_missing;
386 === information_schema.innodb_tablespaces and innodb_datafiles ===
387 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
388 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
389 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
390 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
391 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
392 s_16k General DEFAULT 0 1 1 Any s_16k.ibd
393 s_1k General DEFAULT 1024 1 1 Compressed s_1k.ibd
394 s_2k General DEFAULT 2048 1 1 Compressed s_2k.ibd
395 s_4k General DEFAULT 4096 1 1 Compressed s_4k.ibd
396 s_8k General DEFAULT 8192 1 1 Compressed s_8k.ibd
397 s_missing General DEFAULT 0 1 1 Any delete_me.ibd
398 === information_schema.files ===
399 Space_Name File_Type Engine Status Tablespace_Name Path
400 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
401 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
402 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
403 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
404 s_16k TABLESPACE InnoDB NORMAL s_16k MYSQLD_DATADIR/s_16k.ibd
405 s_1k TABLESPACE InnoDB NORMAL s_1k MYSQLD_DATADIR/s_1k.ibd
406 s_2k TABLESPACE InnoDB NORMAL s_2k MYSQLD_DATADIR/s_2k.ibd
407 s_4k TABLESPACE InnoDB NORMAL s_4k MYSQLD_DATADIR/s_4k.ibd
408 s_8k TABLESPACE InnoDB NORMAL s_8k MYSQLD_DATADIR/s_8k.ibd
409 s_missing TABLESPACE InnoDB NORMAL s_missing MYSQLD_DATADIR/delete_me.ibd
410 === information_schema.innodb_tables and innodb_tablespaces ===
411 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
412 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
413 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
414 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
415 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
416 test/t_com_in_16k s_16k 129 5 Compact 0 General
417 test/t_com_in_16k_as s_16k 129 5 Compact 0 General
418 test/t_com_in_16k_from_1k s_16k 129 5 Compact 0 General
419 test/t_com_in_16k_like s_16k 129 5 Compact 0 General
420 test/t_dyn_in_16k s_16k 161 5 Dynamic 0 General
421 test/t_dyn_in_16k_as s_16k 161 5 Dynamic 0 General
422 test/t_dyn_in_16k_from_1k s_16k 161 5 Dynamic 0 General
423 test/t_dyn_in_16k_like s_16k 161 5 Dynamic 0 General
424 test/t_missing s_missing 161 4 Dynamic 0 General
425 test/t_red_in_16k s_16k 128 5 Redundant 0 General
426 test/t_red_in_16k_as s_16k 128 5 Redundant 0 General
427 test/t_red_in_16k_from_1k s_16k 128 5 Redundant 0 General
428 test/t_red_in_16k_like s_16k 128 5 Redundant 0 General
429 test/t_zip1k_in_1k s_1k 163 5 Compressed 1024 General
430 test/t_zip1k_in_1k_as s_1k 163 5 Compressed 1024 General
431 test/t_zip1k_in_1k_like s_1k 163 5 Compressed 1024 General
432 test/t_zip2k_in_2k s_2k 165 5 Compressed 2048 General
433 test/t_zip2k_in_2k_as s_2k 165 5 Compressed 2048 General
434 test/t_zip2k_in_2k_from_1k s_2k 165 5 Compressed 2048 General
435 test/t_zip2k_in_2k_like s_2k 165 5 Compressed 2048 General
436 test/t_zip4k_in_4k s_4k 167 5 Compressed 4096 General
437 test/t_zip4k_in_4k_as s_4k 167 5 Compressed 4096 General
438 test/t_zip4k_in_4k_from_1k s_4k 167 5 Compressed 4096 General
439 test/t_zip4k_in_4k_like s_4k 167 5 Compressed 4096 General
440 test/t_zip8k_in_8k s_8k 169 5 Compressed 8192 General
441 test/t_zip8k_in_8k_as s_8k 169 5 Compressed 8192 General
442 test/t_zip8k_in_8k_from_1k s_8k 169 5 Compressed 8192 General
443 test/t_zip8k_in_8k_like s_8k 169 5 Compressed 8192 General
444 # Directory of MYSQLD_DATADIR/
445 delete_me.ibd
446 mysql.ibd
447 s_16k.ibd
448 s_1k.ibd
449 s_2k.ibd
450 s_4k.ibd
451 s_8k.ibd
452 # Directory of MYSQLD_DATADIR/test/
453 #
454 # Stop the server.
455 # Delete a general tablespace datafile.
456 # restart
457 # Make sure that the missing tablespace can be dropped and
458 # everything else is OK.
459 #
460 === information_schema.innodb_tablespaces and innodb_datafiles ===
461 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
462 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
463 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
464 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
465 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
466 s_16k General DEFAULT 0 1 1 Any s_16k.ibd
467 s_1k General DEFAULT 1024 1 1 Compressed s_1k.ibd
468 s_2k General DEFAULT 2048 1 1 Compressed s_2k.ibd
469 s_4k General DEFAULT 4096 1 1 Compressed s_4k.ibd
470 s_8k General DEFAULT 8192 1 1 Compressed s_8k.ibd
471 s_missing General DEFAULT 0 0 0 Any delete_me.ibd
472 === information_schema.files ===
473 Space_Name File_Type Engine Status Tablespace_Name Path
474 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
475 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
476 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
477 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
478 s_16k TABLESPACE InnoDB NORMAL s_16k MYSQLD_DATADIR/s_16k.ibd
479 s_1k TABLESPACE InnoDB NORMAL s_1k MYSQLD_DATADIR/s_1k.ibd
480 s_2k TABLESPACE InnoDB NORMAL s_2k MYSQLD_DATADIR/s_2k.ibd
481 s_4k TABLESPACE InnoDB NORMAL s_4k MYSQLD_DATADIR/s_4k.ibd
482 s_8k TABLESPACE InnoDB NORMAL s_8k MYSQLD_DATADIR/s_8k.ibd
483 === information_schema.innodb_tables and innodb_tablespaces ===
484 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
485 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
486 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
487 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
488 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
489 test/t_com_in_16k s_16k 129 5 Compact 0 General
490 test/t_com_in_16k_as s_16k 129 5 Compact 0 General
491 test/t_com_in_16k_from_1k s_16k 129 5 Compact 0 General
492 test/t_com_in_16k_like s_16k 129 5 Compact 0 General
493 test/t_dyn_in_16k s_16k 161 5 Dynamic 0 General
494 test/t_dyn_in_16k_as s_16k 161 5 Dynamic 0 General
495 test/t_dyn_in_16k_from_1k s_16k 161 5 Dynamic 0 General
496 test/t_dyn_in_16k_like s_16k 161 5 Dynamic 0 General
497 test/t_missing s_missing 161 4 Dynamic 0 General
498 test/t_red_in_16k s_16k 128 5 Redundant 0 General
499 test/t_red_in_16k_as s_16k 128 5 Redundant 0 General
500 test/t_red_in_16k_from_1k s_16k 128 5 Redundant 0 General
501 test/t_red_in_16k_like s_16k 128 5 Redundant 0 General
502 test/t_zip1k_in_1k s_1k 163 5 Compressed 1024 General
503 test/t_zip1k_in_1k_as s_1k 163 5 Compressed 1024 General
504 test/t_zip1k_in_1k_like s_1k 163 5 Compressed 1024 General
505 test/t_zip2k_in_2k s_2k 165 5 Compressed 2048 General
506 test/t_zip2k_in_2k_as s_2k 165 5 Compressed 2048 General
507 test/t_zip2k_in_2k_from_1k s_2k 165 5 Compressed 2048 General
508 test/t_zip2k_in_2k_like s_2k 165 5 Compressed 2048 General
509 test/t_zip4k_in_4k s_4k 167 5 Compressed 4096 General
510 test/t_zip4k_in_4k_as s_4k 167 5 Compressed 4096 General
511 test/t_zip4k_in_4k_from_1k s_4k 167 5 Compressed 4096 General
512 test/t_zip4k_in_4k_like s_4k 167 5 Compressed 4096 General
513 test/t_zip8k_in_8k s_8k 169 5 Compressed 8192 General
514 test/t_zip8k_in_8k_as s_8k 169 5 Compressed 8192 General
515 test/t_zip8k_in_8k_from_1k s_8k 169 5 Compressed 8192 General
516 test/t_zip8k_in_8k_like s_8k 169 5 Compressed 8192 General
517 # Directory of MYSQLD_DATADIR/
518 mysql.ibd
519 s_16k.ibd
520 s_1k.ibd
521 s_2k.ibd
522 s_4k.ibd
523 s_8k.ibd
524 # Directory of MYSQLD_DATADIR/test/
525 #
526 # Clean-up tables we no longer need
527 #
528 DROP TABLESPACE s_missing;
529 ERROR HY000: Tablespace `s_missing` is not empty.
530 DROP TABLE t_missing;
531 DROP TABLESPACE s_missing;
532 DROP TABLE t_zip1k_in_1k_like;
533 DROP TABLE t_zip2k_in_2k_like;
534 DROP TABLE t_zip4k_in_4k_like;
535 DROP TABLE t_zip8k_in_8k_like;
536 DROP TABLE t_red_in_16k_like;
537 DROP TABLE t_com_in_16k_like;
538 DROP TABLE t_dyn_in_16k_like;
539 DROP TABLE t_zip1k_in_1k_as;
540 DROP TABLE t_zip2k_in_2k_as;
541 DROP TABLE t_zip4k_in_4k_as;
542 DROP TABLE t_zip8k_in_8k_as;
543 DROP TABLE t_red_in_16k_as;
544 DROP TABLE t_com_in_16k_as;
545 DROP TABLE t_dyn_in_16k_as;
546 DROP TABLE t_zip2k_in_2k_from_1k;
547 DROP TABLE t_zip4k_in_4k_from_1k;
548 DROP TABLE t_zip8k_in_8k_from_1k;
549 DROP TABLE t_red_in_16k_from_1k;
550 DROP TABLE t_com_in_16k_from_1k;
551 DROP TABLE t_dyn_in_16k_from_1k;
552 CHECK TABLE t_zip1k_in_1k;
553 Table Op Msg_type Msg_text
554 test.t_zip1k_in_1k check status OK
555 CHECK TABLE t_zip2k_in_2k;
556 Table Op Msg_type Msg_text
557 test.t_zip2k_in_2k check status OK
558 CHECK TABLE t_zip4k_in_4k;
559 Table Op Msg_type Msg_text
560 test.t_zip4k_in_4k check status OK
561 CHECK TABLE t_zip8k_in_8k;
562 Table Op Msg_type Msg_text
563 test.t_zip8k_in_8k check status OK
564 CHECK TABLE t_red_in_16k;
565 Table Op Msg_type Msg_text
566 test.t_red_in_16k check status OK
567 CHECK TABLE t_com_in_16k;
568 Table Op Msg_type Msg_text
569 test.t_com_in_16k check status OK
570 CHECK TABLE t_dyn_in_16k;
571 Table Op Msg_type Msg_text
572 test.t_dyn_in_16k check status OK
573 DROP TABLE t_zip1k_in_1k;
574 DROP TABLE t_zip2k_in_2k;
575 DROP TABLE t_zip4k_in_4k;
576 DROP TABLE t_zip8k_in_8k;
577 DROP TABLE t_red_in_16k;
578 DROP TABLE t_com_in_16k;
579 DROP TABLE t_dyn_in_16k;
580 #
581 # Create compressed tables explicitly as file_per_table tablespaces.
582 #
583 CREATE TABLE t_zip1k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=1;
584 CREATE TABLE t_zip2k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=2;
585 CREATE TABLE t_zip4k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=4;
586 CREATE TABLE t_zip8k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=8;
587 CREATE TABLE t_zip16k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=16;
588 #
589 # Create compressed tables in remote locations using file-per-table.
590 #
591 CREATE TABLE t_zip1k_as_remote (a int, b text) KEY_BLOCK_SIZE=1 TABLESPACE=innodb_file_per_table DATA DIRECTORY='MYSQL_TMP_DIR';
592 CREATE TABLE t_zip2k_as_remote (a int, b text) KEY_BLOCK_SIZE=2 TABLESPACE=innodb_file_per_table DATA DIRECTORY='MYSQL_TMP_DIR';
593 CREATE TABLE t_zip4k_as_remote (a int, b text) KEY_BLOCK_SIZE=4 TABLESPACE=innodb_file_per_table DATA DIRECTORY='MYSQL_TMP_DIR';
594 CREATE TABLE t_zip8k_as_remote (a int, b text) KEY_BLOCK_SIZE=8 TABLESPACE=innodb_file_per_table DATA DIRECTORY='MYSQL_TMP_DIR';
595 CREATE TABLE t_zip16k_as_remote (a int, b text) KEY_BLOCK_SIZE=16 TABLESPACE=innodb_file_per_table DATA DIRECTORY='MYSQL_TMP_DIR';
596 === information_schema.innodb_tablespaces and innodb_datafiles ===
597 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
598 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
599 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
600 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
601 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
602 s_16k General DEFAULT 0 1 1 Any s_16k.ibd
603 s_1k General DEFAULT 1024 1 1 Compressed s_1k.ibd
604 s_2k General DEFAULT 2048 1 1 Compressed s_2k.ibd
605 s_4k General DEFAULT 4096 1 1 Compressed s_4k.ibd
606 s_8k General DEFAULT 8192 1 1 Compressed s_8k.ibd
607 test/t_zip16k_as_file_per_table Single DEFAULT DEFAULT 1 1 Compressed MYSQLD_DATADIR/test/t_zip16k_as_file_per_table.ibd
608 test/t_zip16k_as_remote Single DEFAULT DEFAULT 1 1 Compressed MYSQL_TMP_DIR/test/t_zip16k_as_remote.ibd
609 test/t_zip1k_as_file_per_table Single DEFAULT 1024 1 1 Compressed MYSQLD_DATADIR/test/t_zip1k_as_file_per_table.ibd
610 test/t_zip1k_as_remote Single DEFAULT 1024 1 1 Compressed MYSQL_TMP_DIR/test/t_zip1k_as_remote.ibd
611 test/t_zip2k_as_file_per_table Single DEFAULT 2048 1 1 Compressed MYSQLD_DATADIR/test/t_zip2k_as_file_per_table.ibd
612 test/t_zip2k_as_remote Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/test/t_zip2k_as_remote.ibd
613 test/t_zip4k_as_file_per_table Single DEFAULT 4096 1 1 Compressed MYSQLD_DATADIR/test/t_zip4k_as_file_per_table.ibd
614 test/t_zip4k_as_remote Single DEFAULT 4096 1 1 Compressed MYSQL_TMP_DIR/test/t_zip4k_as_remote.ibd
615 test/t_zip8k_as_file_per_table Single DEFAULT 8192 1 1 Compressed MYSQLD_DATADIR/test/t_zip8k_as_file_per_table.ibd
616 test/t_zip8k_as_remote Single DEFAULT 8192 1 1 Compressed MYSQL_TMP_DIR/test/t_zip8k_as_remote.ibd
617 === information_schema.files ===
618 Space_Name File_Type Engine Status Tablespace_Name Path
619 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
620 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
621 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
622 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
623 s_16k TABLESPACE InnoDB NORMAL s_16k MYSQLD_DATADIR/s_16k.ibd
624 s_1k TABLESPACE InnoDB NORMAL s_1k MYSQLD_DATADIR/s_1k.ibd
625 s_2k TABLESPACE InnoDB NORMAL s_2k MYSQLD_DATADIR/s_2k.ibd
626 s_4k TABLESPACE InnoDB NORMAL s_4k MYSQLD_DATADIR/s_4k.ibd
627 s_8k TABLESPACE InnoDB NORMAL s_8k MYSQLD_DATADIR/s_8k.ibd
628 test/t_zip16k_as_file_per_table TABLESPACE InnoDB NORMAL test/t_zip16k_as_file_per_table MYSQLD_DATADIR/test/t_zip16k_as_file_per_table.ibd
629 test/t_zip16k_as_remote TABLESPACE InnoDB NORMAL test/t_zip16k_as_remote MYSQL_TMP_DIR/test/t_zip16k_as_remote.ibd
630 test/t_zip1k_as_file_per_table TABLESPACE InnoDB NORMAL test/t_zip1k_as_file_per_table MYSQLD_DATADIR/test/t_zip1k_as_file_per_table.ibd
631 test/t_zip1k_as_remote TABLESPACE InnoDB NORMAL test/t_zip1k_as_remote MYSQL_TMP_DIR/test/t_zip1k_as_remote.ibd
632 test/t_zip2k_as_file_per_table TABLESPACE InnoDB NORMAL test/t_zip2k_as_file_per_table MYSQLD_DATADIR/test/t_zip2k_as_file_per_table.ibd
633 test/t_zip2k_as_remote TABLESPACE InnoDB NORMAL test/t_zip2k_as_remote MYSQL_TMP_DIR/test/t_zip2k_as_remote.ibd
634 test/t_zip4k_as_file_per_table TABLESPACE InnoDB NORMAL test/t_zip4k_as_file_per_table MYSQLD_DATADIR/test/t_zip4k_as_file_per_table.ibd
635 test/t_zip4k_as_remote TABLESPACE InnoDB NORMAL test/t_zip4k_as_remote MYSQL_TMP_DIR/test/t_zip4k_as_remote.ibd
636 test/t_zip8k_as_file_per_table TABLESPACE InnoDB NORMAL test/t_zip8k_as_file_per_table MYSQLD_DATADIR/test/t_zip8k_as_file_per_table.ibd
637 test/t_zip8k_as_remote TABLESPACE InnoDB NORMAL test/t_zip8k_as_remote MYSQL_TMP_DIR/test/t_zip8k_as_remote.ibd
638 === information_schema.innodb_tables and innodb_tablespaces ===
639 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
640 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
641 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
642 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
643 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
644 test/t_zip16k_as_file_per_table test/t_zip16k_as_file_per_table 43 5 Compressed 16384 Single
645 test/t_zip16k_as_remote test/t_zip16k_as_remote 107 5 Compressed 16384 Single
646 test/t_zip1k_as_file_per_table test/t_zip1k_as_file_per_table 35 5 Compressed 1024 Single
647 test/t_zip1k_as_remote test/t_zip1k_as_remote 99 5 Compressed 1024 Single
648 test/t_zip2k_as_file_per_table test/t_zip2k_as_file_per_table 37 5 Compressed 2048 Single
649 test/t_zip2k_as_remote test/t_zip2k_as_remote 101 5 Compressed 2048 Single
650 test/t_zip4k_as_file_per_table test/t_zip4k_as_file_per_table 39 5 Compressed 4096 Single
651 test/t_zip4k_as_remote test/t_zip4k_as_remote 103 5 Compressed 4096 Single
652 test/t_zip8k_as_file_per_table test/t_zip8k_as_file_per_table 41 5 Compressed 8192 Single
653 test/t_zip8k_as_remote test/t_zip8k_as_remote 105 5 Compressed 8192 Single
654 # MYSQLD_DATADIR/
655 mysql.ibd
656 s_16k.ibd
657 s_1k.ibd
658 s_2k.ibd
659 s_4k.ibd
660 s_8k.ibd
661 # MYSQLD_DATADIR/test/
662 t_zip16k_as_file_per_table.ibd
663 t_zip1k_as_file_per_table.ibd
664 t_zip2k_as_file_per_table.ibd
665 t_zip4k_as_file_per_table.ibd
666 t_zip8k_as_file_per_table.ibd
667 #
668 # These file_per_table tables cannot be moved to a general tablespace if the
669 # FILE_BLOCK_SIZE does not match the KEY_BLOCK_SIZE or if the tablespace is
670 # not compressed.
671 #
672 ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_1k`;
673 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 2048
674 SHOW WARNINGS;
675 Level Code Message
676 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 2048
677 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
678 ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_1k`;
679 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 4096
680 SHOW WARNINGS;
681 Level Code Message
682 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 4096
683 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
684 ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_1k`;
685 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 8192
686 SHOW WARNINGS;
687 Level Code Message
688 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 8192
689 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
690 ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_1k`;
691 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
692 SHOW WARNINGS;
693 Level Code Message
694 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
695 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
696 ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_1k`;
697 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 2048
698 SHOW WARNINGS;
699 Level Code Message
700 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 2048
701 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
702 ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_1k`;
703 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 4096
704 SHOW WARNINGS;
705 Level Code Message
706 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 4096
707 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
708 ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_1k`;
709 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 8192
710 SHOW WARNINGS;
711 Level Code Message
712 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 8192
713 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
714 ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_1k`;
715 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
716 SHOW WARNINGS;
717 Level Code Message
718 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 16384
719 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
720 ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_2k`;
721 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 1024
722 SHOW WARNINGS;
723 Level Code Message
724 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 1024
725 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
726 ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_2k`;
727 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 4096
728 SHOW WARNINGS;
729 Level Code Message
730 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 4096
731 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
732 ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_2k`;
733 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 8192
734 SHOW WARNINGS;
735 Level Code Message
736 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 8192
737 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
738 ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_2k`;
739 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
740 SHOW WARNINGS;
741 Level Code Message
742 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
743 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
744 ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_2k`;
745 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 1024
746 SHOW WARNINGS;
747 Level Code Message
748 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 1024
749 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
750 ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_2k`;
751 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 4096
752 SHOW WARNINGS;
753 Level Code Message
754 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 4096
755 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
756 ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_2k`;
757 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 8192
758 SHOW WARNINGS;
759 Level Code Message
760 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 8192
761 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
762 ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_2k`;
763 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
764 SHOW WARNINGS;
765 Level Code Message
766 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 16384
767 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
768 ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_4k`;
769 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 1024
770 SHOW WARNINGS;
771 Level Code Message
772 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 1024
773 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
774 ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_4k`;
775 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 2048
776 SHOW WARNINGS;
777 Level Code Message
778 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 2048
779 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
780 ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_4k`;
781 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 8192
782 SHOW WARNINGS;
783 Level Code Message
784 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 8192
785 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
786 ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_4k`;
787 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
788 SHOW WARNINGS;
789 Level Code Message
790 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
791 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
792 ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_4k`;
793 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 1024
794 SHOW WARNINGS;
795 Level Code Message
796 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 1024
797 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
798 ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_4k`;
799 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 2048
800 SHOW WARNINGS;
801 Level Code Message
802 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 2048
803 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
804 ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_4k`;
805 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 8192
806 SHOW WARNINGS;
807 Level Code Message
808 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 8192
809 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
810 ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_4k`;
811 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
812 SHOW WARNINGS;
813 Level Code Message
814 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 16384
815 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
816 ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_8k`;
817 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 1024
818 SHOW WARNINGS;
819 Level Code Message
820 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 1024
821 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
822 ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_8k`;
823 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 2048
824 SHOW WARNINGS;
825 Level Code Message
826 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 2048
827 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
828 ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_8k`;
829 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 4096
830 SHOW WARNINGS;
831 Level Code Message
832 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 4096
833 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
834 ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_8k`;
835 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
836 SHOW WARNINGS;
837 Level Code Message
838 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
839 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
840 ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_8k`;
841 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 1024
842 SHOW WARNINGS;
843 Level Code Message
844 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 1024
845 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
846 ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_8k`;
847 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 2048
848 SHOW WARNINGS;
849 Level Code Message
850 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 2048
851 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
852 ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_8k`;
853 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 4096
854 SHOW WARNINGS;
855 Level Code Message
856 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 4096
857 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
858 ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_8k`;
859 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
860 SHOW WARNINGS;
861 Level Code Message
862 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 16384
863 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
864 ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_16k`;
865 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
866 SHOW WARNINGS;
867 Level Code Message
868 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
869 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
870 ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_16k`;
871 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
872 SHOW WARNINGS;
873 Level Code Message
874 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
875 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
876 ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_16k`;
877 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
878 SHOW WARNINGS;
879 Level Code Message
880 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
881 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
882 ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_16k`;
883 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
884 SHOW WARNINGS;
885 Level Code Message
886 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
887 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
888 ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_16k`;
889 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
890 SHOW WARNINGS;
891 Level Code Message
892 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
893 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
894 ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_16k`;
895 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
896 SHOW WARNINGS;
897 Level Code Message
898 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
899 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
900 ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_16k`;
901 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
902 SHOW WARNINGS;
903 Level Code Message
904 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
905 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
906 ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_16k`;
907 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
908 SHOW WARNINGS;
909 Level Code Message
910 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
911 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
912 ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_16k`;
913 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
914 SHOW WARNINGS;
915 Level Code Message
916 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
917 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
918 ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_16k`;
919 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
920 SHOW WARNINGS;
921 Level Code Message
922 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
923 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
924 DROP TABLE `t_zip16k_as_remote`;
925 #
926 # These explicit file_per_table tables can be moved to a general tablespace
927 # if FILE_BLOCK_SIZE matches KEY_BLOCK_SIZE and the tablespace is compressed.
928 #
929 ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_1k`, RENAME TO `t_zip1k_in_s_1k`;
930 ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_2k`, RENAME TO `t_zip2k_in_s_2k`;
931 ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_4k`, RENAME TO `t_zip4k_in_s_4k`;
932 ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_8k`, RENAME TO `t_zip8k_in_s_8k`;
933 ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_1k`, RENAME TO `t_zip1k_remote_in_s_1k`;
934 ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_2k`, RENAME TO `t_zip2k_remote_in_s_2k`;
935 ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_4k`, RENAME TO `t_zip4k_remote_in_s_4k`;
936 ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_8k`, RENAME TO `t_zip8k_remote_in_s_8k`;
937 === information_schema.innodb_tablespaces and innodb_datafiles ===
938 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
939 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
940 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
941 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
942 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
943 s_16k General DEFAULT 0 1 1 Any s_16k.ibd
944 s_1k General DEFAULT 1024 1 1 Compressed s_1k.ibd
945 s_2k General DEFAULT 2048 1 1 Compressed s_2k.ibd
946 s_4k General DEFAULT 4096 1 1 Compressed s_4k.ibd
947 s_8k General DEFAULT 8192 1 1 Compressed s_8k.ibd
948 test/t_zip16k_as_file_per_table Single DEFAULT DEFAULT 1 1 Compressed MYSQLD_DATADIR/test/t_zip16k_as_file_per_table.ibd
949 === information_schema.files ===
950 Space_Name File_Type Engine Status Tablespace_Name Path
951 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
952 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
953 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
954 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
955 s_16k TABLESPACE InnoDB NORMAL s_16k MYSQLD_DATADIR/s_16k.ibd
956 s_1k TABLESPACE InnoDB NORMAL s_1k MYSQLD_DATADIR/s_1k.ibd
957 s_2k TABLESPACE InnoDB NORMAL s_2k MYSQLD_DATADIR/s_2k.ibd
958 s_4k TABLESPACE InnoDB NORMAL s_4k MYSQLD_DATADIR/s_4k.ibd
959 s_8k TABLESPACE InnoDB NORMAL s_8k MYSQLD_DATADIR/s_8k.ibd
960 test/t_zip16k_as_file_per_table TABLESPACE InnoDB NORMAL test/t_zip16k_as_file_per_table MYSQLD_DATADIR/test/t_zip16k_as_file_per_table.ibd
961 === information_schema.innodb_tables and innodb_tablespaces ===
962 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
963 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
964 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
965 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
966 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
967 test/t_zip16k_as_file_per_table test/t_zip16k_as_file_per_table 43 5 Compressed 16384 Single
968 test/t_zip1k_in_s_1k s_1k 163 5 Compressed 1024 General
969 test/t_zip1k_remote_in_s_1k s_1k 163 5 Compressed 1024 General
970 test/t_zip2k_in_s_2k s_2k 165 5 Compressed 2048 General
971 test/t_zip2k_remote_in_s_2k s_2k 165 5 Compressed 2048 General
972 test/t_zip4k_in_s_4k s_4k 167 5 Compressed 4096 General
973 test/t_zip4k_remote_in_s_4k s_4k 167 5 Compressed 4096 General
974 test/t_zip8k_in_s_8k s_8k 169 5 Compressed 8192 General
975 test/t_zip8k_remote_in_s_8k s_8k 169 5 Compressed 8192 General
976 # MYSQLD_DATADIR/
977 mysql.ibd
978 s_16k.ibd
979 s_1k.ibd
980 s_2k.ibd
981 s_4k.ibd
982 s_8k.ibd
983 # MYSQLD_DATADIR/test/
984 t_zip16k_as_file_per_table.ibd
985 CHECK TABLE `t_zip1k_in_s_1k`;
986 Table Op Msg_type Msg_text
987 test.t_zip1k_in_s_1k check status OK
988 CHECK TABLE `t_zip2k_in_s_2k`;
989 Table Op Msg_type Msg_text
990 test.t_zip2k_in_s_2k check status OK
991 CHECK TABLE `t_zip4k_in_s_4k`;
992 Table Op Msg_type Msg_text
993 test.t_zip4k_in_s_4k check status OK
994 CHECK TABLE `t_zip8k_in_s_8k`;
995 Table Op Msg_type Msg_text
996 test.t_zip8k_in_s_8k check status OK
997 CHECK TABLE `t_zip1k_remote_in_s_1k`;
998 Table Op Msg_type Msg_text
999 test.t_zip1k_remote_in_s_1k check status OK
1000 CHECK TABLE `t_zip2k_remote_in_s_2k`;
1001 Table Op Msg_type Msg_text
1002 test.t_zip2k_remote_in_s_2k check status OK
1003 CHECK TABLE `t_zip4k_remote_in_s_4k`;
1004 Table Op Msg_type Msg_text
1005 test.t_zip4k_remote_in_s_4k check status OK
1006 CHECK TABLE `t_zip8k_remote_in_s_8k`;
1007 Table Op Msg_type Msg_text
1008 test.t_zip8k_remote_in_s_8k check status OK
1009 #
1010 # Tables in general tablespaces cannot be moved to another general tablespace if the
1011 # FILE_BLOCK_SIZE does not match the KEY_BLOCK_SIZE or if the tablespace is
1012 # not compressed.
1013 #
1014 ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_1k`;
1015 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 2048
1016 SHOW WARNINGS;
1017 Level Code Message
1018 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 2048
1019 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1020 ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`s_1k`;
1021 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 4096
1022 SHOW WARNINGS;
1023 Level Code Message
1024 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 4096
1025 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1026 ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`s_1k`;
1027 ERROR HY000: InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 8192
1028 SHOW WARNINGS;
1029 Level Code Message
1030 Error 1478 InnoDB: Tablespace `s_1k` uses block size 1024 and cannot contain a table with physical page size 8192
1031 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1032 ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_2k`;
1033 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 1024
1034 SHOW WARNINGS;
1035 Level Code Message
1036 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 1024
1037 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1038 ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`s_2k`;
1039 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 4096
1040 SHOW WARNINGS;
1041 Level Code Message
1042 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 4096
1043 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1044 ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`s_2k`;
1045 ERROR HY000: InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 8192
1046 SHOW WARNINGS;
1047 Level Code Message
1048 Error 1478 InnoDB: Tablespace `s_2k` uses block size 2048 and cannot contain a table with physical page size 8192
1049 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1050 ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_4k`;
1051 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 1024
1052 SHOW WARNINGS;
1053 Level Code Message
1054 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 1024
1055 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1056 ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_4k`;
1057 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 2048
1058 SHOW WARNINGS;
1059 Level Code Message
1060 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 2048
1061 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1062 ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`s_4k`;
1063 ERROR HY000: InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 8192
1064 SHOW WARNINGS;
1065 Level Code Message
1066 Error 1478 InnoDB: Tablespace `s_4k` uses block size 4096 and cannot contain a table with physical page size 8192
1067 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1068 ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_8k`;
1069 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 1024
1070 SHOW WARNINGS;
1071 Level Code Message
1072 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 1024
1073 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1074 ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_8k`;
1075 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 2048
1076 SHOW WARNINGS;
1077 Level Code Message
1078 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 2048
1079 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1080 ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`s_8k`;
1081 ERROR HY000: InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 4096
1082 SHOW WARNINGS;
1083 Level Code Message
1084 Error 1478 InnoDB: Tablespace `s_8k` uses block size 8192 and cannot contain a table with physical page size 4096
1085 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1086 ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_16k`;
1087 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
1088 SHOW WARNINGS;
1089 Level Code Message
1090 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
1091 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1092 ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_16k`;
1093 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
1094 SHOW WARNINGS;
1095 Level Code Message
1096 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
1097 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1098 ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`s_16k`;
1099 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
1100 SHOW WARNINGS;
1101 Level Code Message
1102 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
1103 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1104 ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`s_16k`;
1105 ERROR HY000: InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
1106 SHOW WARNINGS;
1107 Level Code Message
1108 Error 1478 InnoDB: Tablespace `s_16k` cannot contain a COMPRESSED table
1109 Error 1478 Table storage engine 'InnoDB' does not support the create option 'TABLESPACE'
1110 #
1111 # Tables in a general tablespace can be moved to file_per_table locations.
1112 #
1113 ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip1k_to_file_per_table`;
1114 ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip2k_to_file_per_table`;
1115 ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip4k_to_file_per_table`;
1116 ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip8k_to_file_per_table`;
1117 === information_schema.innodb_tablespaces and innodb_datafiles ===
1118 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
1119 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
1120 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
1121 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
1122 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
1123 s_16k General DEFAULT 0 1 1 Any s_16k.ibd
1124 s_1k General DEFAULT 1024 1 1 Compressed s_1k.ibd
1125 s_2k General DEFAULT 2048 1 1 Compressed s_2k.ibd
1126 s_4k General DEFAULT 4096 1 1 Compressed s_4k.ibd
1127 s_8k General DEFAULT 8192 1 1 Compressed s_8k.ibd
1128 test/t_zip16k_as_file_per_table Single DEFAULT DEFAULT 1 1 Compressed MYSQLD_DATADIR/test/t_zip16k_as_file_per_table.ibd
1129 test/t_zip1k_to_file_per_table Single DEFAULT 1024 1 1 Compressed MYSQLD_DATADIR/test/t_zip1k_to_file_per_table.ibd
1130 test/t_zip2k_to_file_per_table Single DEFAULT 2048 1 1 Compressed MYSQLD_DATADIR/test/t_zip2k_to_file_per_table.ibd
1131 test/t_zip4k_to_file_per_table Single DEFAULT 4096 1 1 Compressed MYSQLD_DATADIR/test/t_zip4k_to_file_per_table.ibd
1132 test/t_zip8k_to_file_per_table Single DEFAULT 8192 1 1 Compressed MYSQLD_DATADIR/test/t_zip8k_to_file_per_table.ibd
1133 === information_schema.files ===
1134 Space_Name File_Type Engine Status Tablespace_Name Path
1135 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
1136 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
1137 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
1138 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
1139 s_16k TABLESPACE InnoDB NORMAL s_16k MYSQLD_DATADIR/s_16k.ibd
1140 s_1k TABLESPACE InnoDB NORMAL s_1k MYSQLD_DATADIR/s_1k.ibd
1141 s_2k TABLESPACE InnoDB NORMAL s_2k MYSQLD_DATADIR/s_2k.ibd
1142 s_4k TABLESPACE InnoDB NORMAL s_4k MYSQLD_DATADIR/s_4k.ibd
1143 s_8k TABLESPACE InnoDB NORMAL s_8k MYSQLD_DATADIR/s_8k.ibd
1144 test/t_zip16k_as_file_per_table TABLESPACE InnoDB NORMAL test/t_zip16k_as_file_per_table MYSQLD_DATADIR/test/t_zip16k_as_file_per_table.ibd
1145 test/t_zip1k_to_file_per_table TABLESPACE InnoDB NORMAL test/t_zip1k_to_file_per_table MYSQLD_DATADIR/test/t_zip1k_to_file_per_table.ibd
1146 test/t_zip2k_to_file_per_table TABLESPACE InnoDB NORMAL test/t_zip2k_to_file_per_table MYSQLD_DATADIR/test/t_zip2k_to_file_per_table.ibd
1147 test/t_zip4k_to_file_per_table TABLESPACE InnoDB NORMAL test/t_zip4k_to_file_per_table MYSQLD_DATADIR/test/t_zip4k_to_file_per_table.ibd
1148 test/t_zip8k_to_file_per_table TABLESPACE InnoDB NORMAL test/t_zip8k_to_file_per_table MYSQLD_DATADIR/test/t_zip8k_to_file_per_table.ibd
1149 === information_schema.innodb_tables and innodb_tablespaces ===
1150 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
1151 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
1152 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
1153 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
1154 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
1155 test/t_zip16k_as_file_per_table test/t_zip16k_as_file_per_table 43 5 Compressed 16384 Single
1156 test/t_zip1k_remote_in_s_1k s_1k 163 5 Compressed 1024 General
1157 test/t_zip1k_to_file_per_table test/t_zip1k_to_file_per_table 35 5 Compressed 1024 Single
1158 test/t_zip2k_remote_in_s_2k s_2k 165 5 Compressed 2048 General
1159 test/t_zip2k_to_file_per_table test/t_zip2k_to_file_per_table 37 5 Compressed 2048 Single
1160 test/t_zip4k_remote_in_s_4k s_4k 167 5 Compressed 4096 General
1161 test/t_zip4k_to_file_per_table test/t_zip4k_to_file_per_table 39 5 Compressed 4096 Single
1162 test/t_zip8k_remote_in_s_8k s_8k 169 5 Compressed 8192 General
1163 test/t_zip8k_to_file_per_table test/t_zip8k_to_file_per_table 41 5 Compressed 8192 Single
1164 CHECK TABLE `t_zip1k_to_file_per_table`;
1165 Table Op Msg_type Msg_text
1166 test.t_zip1k_to_file_per_table check status OK
1167 CHECK TABLE `t_zip2k_to_file_per_table`;
1168 Table Op Msg_type Msg_text
1169 test.t_zip2k_to_file_per_table check status OK
1170 CHECK TABLE `t_zip4k_to_file_per_table`;
1171 Table Op Msg_type Msg_text
1172 test.t_zip4k_to_file_per_table check status OK
1173 CHECK TABLE `t_zip8k_to_file_per_table`;
1174 Table Op Msg_type Msg_text
1175 test.t_zip8k_to_file_per_table check status OK
1176 CHECK TABLE `t_zip16k_as_file_per_table`;
1177 Table Op Msg_type Msg_text
1178 test.t_zip16k_as_file_per_table check status OK
1179 DROP TABLE `t_zip1k_to_file_per_table`;
1180 DROP TABLE `t_zip2k_to_file_per_table`;
1181 DROP TABLE `t_zip4k_to_file_per_table`;
1182 DROP TABLE `t_zip8k_to_file_per_table`;
1183 DROP TABLE `t_zip16k_as_file_per_table`;
1184 #
1185 # Tables in a general tablespace cannot be moved to remote file_per_table locations
1186 # because MySQL ignores DATA DIRECTORY in ALTER TABLE.
1187 #
1188 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`;
1189 Warnings:
1190 Warning 1618 <DATA DIRECTORY> option ignored
1191 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`;
1192 Warnings:
1193 Warning 1618 <DATA DIRECTORY> option ignored
1194 ALTER TABLE `t_zip4k_remote_in_s_4k` TABLESPACE=`innodb_file_per_table`, DATA DIRECTORY='$MYSQL_TMP_DIR', RENAME TO `t_zip4k_to_file_per_table`;
1195 Warnings:
1196 Warning 1618 <DATA DIRECTORY> option ignored
1197 ALTER TABLE `t_zip8k_remote_in_s_8k` TABLESPACE=`innodb_file_per_table`, DATA DIRECTORY='$MYSQL_TMP_DIR', RENAME TO `t_zip8k_to_file_per_table`;
1198 Warnings:
1199 Warning 1618 <DATA DIRECTORY> option ignored
1200 === information_schema.innodb_tablespaces and innodb_datafiles ===
1201 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
1202 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
1203 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
1204 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
1205 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
1206 s_16k General DEFAULT 0 1 1 Any s_16k.ibd
1207 s_1k General DEFAULT 1024 1 1 Compressed s_1k.ibd
1208 s_2k General DEFAULT 2048 1 1 Compressed s_2k.ibd
1209 s_4k General DEFAULT 4096 1 1 Compressed s_4k.ibd
1210 s_8k General DEFAULT 8192 1 1 Compressed s_8k.ibd
1211 test/t_zip1k_to_file_per_table Single DEFAULT 1024 1 1 Compressed MYSQLD_DATADIR/test/t_zip1k_to_file_per_table.ibd
1212 test/t_zip2k_to_file_per_table Single DEFAULT 2048 1 1 Compressed MYSQLD_DATADIR/test/t_zip2k_to_file_per_table.ibd
1213 test/t_zip4k_to_file_per_table Single DEFAULT 4096 1 1 Compressed MYSQLD_DATADIR/test/t_zip4k_to_file_per_table.ibd
1214 test/t_zip8k_to_file_per_table Single DEFAULT 8192 1 1 Compressed MYSQLD_DATADIR/test/t_zip8k_to_file_per_table.ibd
1215 === information_schema.files ===
1216 Space_Name File_Type Engine Status Tablespace_Name Path
1217 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
1218 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
1219 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
1220 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
1221 s_16k TABLESPACE InnoDB NORMAL s_16k MYSQLD_DATADIR/s_16k.ibd
1222 s_1k TABLESPACE InnoDB NORMAL s_1k MYSQLD_DATADIR/s_1k.ibd
1223 s_2k TABLESPACE InnoDB NORMAL s_2k MYSQLD_DATADIR/s_2k.ibd
1224 s_4k TABLESPACE InnoDB NORMAL s_4k MYSQLD_DATADIR/s_4k.ibd
1225 s_8k TABLESPACE InnoDB NORMAL s_8k MYSQLD_DATADIR/s_8k.ibd
1226 test/t_zip1k_to_file_per_table TABLESPACE InnoDB NORMAL test/t_zip1k_to_file_per_table MYSQLD_DATADIR/test/t_zip1k_to_file_per_table.ibd
1227 test/t_zip2k_to_file_per_table TABLESPACE InnoDB NORMAL test/t_zip2k_to_file_per_table MYSQLD_DATADIR/test/t_zip2k_to_file_per_table.ibd
1228 test/t_zip4k_to_file_per_table TABLESPACE InnoDB NORMAL test/t_zip4k_to_file_per_table MYSQLD_DATADIR/test/t_zip4k_to_file_per_table.ibd
1229 test/t_zip8k_to_file_per_table TABLESPACE InnoDB NORMAL test/t_zip8k_to_file_per_table MYSQLD_DATADIR/test/t_zip8k_to_file_per_table.ibd
1230 === information_schema.innodb_tables and innodb_tablespaces ===
1231 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
1232 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
1233 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
1234 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
1235 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
1236 test/t_zip1k_to_file_per_table test/t_zip1k_to_file_per_table 35 5 Compressed 1024 Single
1237 test/t_zip2k_to_file_per_table test/t_zip2k_to_file_per_table 37 5 Compressed 2048 Single
1238 test/t_zip4k_to_file_per_table test/t_zip4k_to_file_per_table 39 5 Compressed 4096 Single
1239 test/t_zip8k_to_file_per_table test/t_zip8k_to_file_per_table 41 5 Compressed 8192 Single
1240 DROP TABLE `t_zip1k_to_file_per_table`;
1241 DROP TABLE `t_zip2k_to_file_per_table`;
1242 DROP TABLE `t_zip4k_to_file_per_table`;
1243 DROP TABLE `t_zip8k_to_file_per_table`;
1244 #
1245 # Clean-up.
1246 #
1247 DROP TABLESPACE s_1k;
1248 DROP TABLESPACE s_2k;
1249 DROP TABLESPACE s_4k;
1250 DROP TABLESPACE s_8k;
1251 DROP TABLESPACE s_16k;