Debian Codegraph @

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

raw
1 #
2 # Bug #29793800 ASSERT AFTER DISCARD TABLESPACE, RENAME TABLE AND
3 # CREATE TABLE USING SAME NAME.
4 #
5 # Test Case 1:
6 CREATE TABLE t1(b INT)ENGINE=innodb;
7 === information_schema.innodb_tables and innodb_tablespaces ===
8 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
9 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
10 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
11 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
12 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
13 test/t1 test/t1 33 4 Dynamic 0 Single
14 === information_schema.innodb_tablespaces and innodb_datafiles ===
15 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
16 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
17 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
18 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
19 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
20 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t1.ibd
21 === information_schema.files ===
22 Space_Name File_Type Engine Status Tablespace_Name Path
23 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
24 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
25 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
26 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
27 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
28 ALTER TABLE t1 DISCARD TABLESPACE;
29 === information_schema.innodb_tables and innodb_tablespaces ===
30 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
31 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
32 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
33 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
34 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
35 test/t1 test/t1 33 4 Dynamic 0 Single
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 test/t1 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/test/t1.ibd
43 === information_schema.files ===
44 Space_Name File_Type Engine Status Tablespace_Name Path
45 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
46 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
47 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
48 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
49 ALTER TABLE t1 RENAME t2;
50 === information_schema.innodb_tables and innodb_tablespaces ===
51 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
52 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
53 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
54 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
55 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
56 test/t2 test/t2 33 4 Dynamic 0 Single
57 === information_schema.innodb_tablespaces and innodb_datafiles ===
58 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
59 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
60 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
61 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
62 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
63 test/t2 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/test/t2.ibd
64 === information_schema.files ===
65 Space_Name File_Type Engine Status Tablespace_Name Path
66 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
67 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
68 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
69 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
70 CREATE TABLE t1(c INT)ENGINE=myisam;
71 === information_schema.innodb_tables and innodb_tablespaces ===
72 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
73 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
74 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
75 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
76 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
77 test/t2 test/t2 33 4 Dynamic 0 Single
78 === information_schema.innodb_tablespaces and innodb_datafiles ===
79 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
80 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
81 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
82 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
83 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
84 test/t2 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/test/t2.ibd
85 === information_schema.files ===
86 Space_Name File_Type Engine Status Tablespace_Name Path
87 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
88 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
89 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
90 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
91 alter table t1 engine=innodb;
92 === information_schema.innodb_tables and innodb_tablespaces ===
93 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
94 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
95 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
96 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
97 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
98 test/t1 test/t1 33 4 Dynamic 0 Single
99 test/t2 test/t2 33 4 Dynamic 0 Single
100 === information_schema.innodb_tablespaces and innodb_datafiles ===
101 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
102 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
103 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
104 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
105 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
106 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t1.ibd
107 test/t2 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/test/t2.ibd
108 === information_schema.files ===
109 Space_Name File_Type Engine Status Tablespace_Name Path
110 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
111 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
112 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
113 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
114 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
115 drop table t1;
116 drop table t2;
117 # Test Case 2:
118 CREATE TABLE t1(b INT)ENGINE=innodb;
119 === information_schema.innodb_tables and innodb_tablespaces ===
120 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
121 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
122 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
123 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
124 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
125 test/t1 test/t1 33 4 Dynamic 0 Single
126 === information_schema.innodb_tablespaces and innodb_datafiles ===
127 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
128 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
129 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
130 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
131 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
132 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t1.ibd
133 === information_schema.files ===
134 Space_Name File_Type Engine Status Tablespace_Name Path
135 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
136 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
137 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
138 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
139 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
140 ALTER TABLE t1 DISCARD TABLESPACE;
141 === information_schema.innodb_tables and innodb_tablespaces ===
142 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
143 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
144 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
145 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
146 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
147 test/t1 test/t1 33 4 Dynamic 0 Single
148 === information_schema.innodb_tablespaces and innodb_datafiles ===
149 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
150 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
151 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
152 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
153 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
154 test/t1 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/test/t1.ibd
155 === information_schema.files ===
156 Space_Name File_Type Engine Status Tablespace_Name Path
157 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
158 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
159 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
160 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
161 ALTER TABLE t1 RENAME t2;
162 === information_schema.innodb_tables and innodb_tablespaces ===
163 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
164 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
165 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
166 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
167 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
168 test/t2 test/t2 33 4 Dynamic 0 Single
169 === information_schema.innodb_tablespaces and innodb_datafiles ===
170 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
171 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
172 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
173 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
174 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
175 test/t2 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/test/t2.ibd
176 === information_schema.files ===
177 Space_Name File_Type Engine Status Tablespace_Name Path
178 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
179 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
180 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
181 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
182 CREATE TABLE t1(c INT)ENGINE=innodb;
183 === information_schema.innodb_tables and innodb_tablespaces ===
184 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
185 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
186 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
187 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
188 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
189 test/t1 test/t1 33 4 Dynamic 0 Single
190 test/t2 test/t2 33 4 Dynamic 0 Single
191 === information_schema.innodb_tablespaces and innodb_datafiles ===
192 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
193 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
194 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
195 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
196 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
197 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t1.ibd
198 test/t2 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/test/t2.ibd
199 === information_schema.files ===
200 Space_Name File_Type Engine Status Tablespace_Name Path
201 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
202 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
203 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
204 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
205 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
206 drop table t1;
207 drop table t2;
208 # Test Case 3:
209 CREATE TABLE `t1/t2` (b INT, c text) ENGINE=innodb;
210 === information_schema.innodb_tables and innodb_tablespaces ===
211 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
212 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
213 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
214 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
215 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
216 test/t1@002ft2 test/t1/t2 33 5 Dynamic 0 Single
217 === information_schema.innodb_tablespaces and innodb_datafiles ===
218 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
219 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
220 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
221 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
222 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
223 test/t1/t2 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/[email protected]
224 === information_schema.files ===
225 Space_Name File_Type Engine Status Tablespace_Name Path
226 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
227 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
228 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
229 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
230 test/t1/t2 TABLESPACE InnoDB NORMAL test/t1/t2 MYSQLD_DATADIR/test/[email protected]
231 ALTER TABLE `t1/t2` DISCARD TABLESPACE;
232 === information_schema.innodb_tables and innodb_tablespaces ===
233 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
234 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
235 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
236 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
237 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
238 test/t1@002ft2 test/t1/t2 33 5 Dynamic 0 Single
239 === information_schema.innodb_tablespaces and innodb_datafiles ===
240 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
241 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
242 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
243 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
244 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
245 test/t1/t2 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/test/[email protected]
246 === information_schema.files ===
247 Space_Name File_Type Engine Status Tablespace_Name Path
248 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
249 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
250 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
251 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
252 ALTER TABLE `t1/t2` RENAME `t3\t4\t5`;
253 === information_schema.innodb_tables and innodb_tablespaces ===
254 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
255 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
256 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
257 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
258 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
259 test/t3@005ct4@005ct5 test/t3\t4\t5 33 5 Dynamic 0 Single
260 === information_schema.innodb_tablespaces and innodb_datafiles ===
261 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
262 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
263 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
264 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
265 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
266 test/t3\t4\t5 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/test/t3@[email protected]
267 === information_schema.files ===
268 Space_Name File_Type Engine Status Tablespace_Name Path
269 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
270 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
271 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
272 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
273 drop table `t3\t4\t5`;
274 # Test Case 4:
275 create database `d1/d2\d3`;
276 use `d1/d2\d3`;
277 CREATE TABLE `t1/t2\t3` (b INT, c text) ENGINE=innodb;
278 === information_schema.innodb_tables and innodb_tablespaces ===
279 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
280 d1@002fd2@005cd3/t1@002ft2@005ct3 d1/d2\d3/t1/t2\t3 33 5 Dynamic 0 Single
281 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
282 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
283 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
284 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
285 === information_schema.innodb_tablespaces and innodb_datafiles ===
286 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
287 d1/d2\d3/t1/t2\t3 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/d1@002fd2@005cd3/t1@[email protected]
288 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
289 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
290 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
291 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
292 === information_schema.files ===
293 Space_Name File_Type Engine Status Tablespace_Name Path
294 d1/d2\d3/t1/t2\t3 TABLESPACE InnoDB NORMAL d1/d2\d3/t1/t2\t3 MYSQLD_DATADIR/d1@002fd2@005cd3/t1@[email protected]
295 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
296 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
297 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
298 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
299 ALTER TABLE `t1/t2\t3` DISCARD TABLESPACE;
300 === information_schema.innodb_tables and innodb_tablespaces ===
301 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
302 d1@002fd2@005cd3/t1@002ft2@005ct3 d1/d2\d3/t1/t2\t3 33 5 Dynamic 0 Single
303 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
304 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
305 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
306 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
307 === information_schema.innodb_tablespaces and innodb_datafiles ===
308 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
309 d1/d2\d3/t1/t2\t3 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/d1@002fd2@005cd3/t1@[email protected]
310 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
311 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
312 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
313 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
314 === information_schema.files ===
315 Space_Name File_Type Engine Status Tablespace_Name Path
316 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
317 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
318 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
319 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
320 ALTER TABLE `t1/t2\t3` RENAME `t3\t4/t5`;
321 === information_schema.innodb_tables and innodb_tablespaces ===
322 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
323 d1@002fd2@005cd3/t3@005ct4@002ft5 d1/d2\d3/t3\t4/t5 33 5 Dynamic 0 Single
324 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
325 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
326 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
327 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
328 === information_schema.innodb_tablespaces and innodb_datafiles ===
329 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
330 d1/d2\d3/t3\t4/t5 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/d1@002fd2@005cd3/t3@[email protected]
331 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
332 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
333 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
334 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
335 === information_schema.files ===
336 Space_Name File_Type Engine Status Tablespace_Name Path
337 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
338 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
339 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
340 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
341 drop table `t3\t4/t5`;
342 drop database `d1/d2\d3`;
343 # Test Case 5:
344 create database `d1/d2\d3`;
345 create database `d4/d5\d6`;
346 CREATE TABLE `d1/d2\d3`.`t1/t2\t3` (b INT, c text) ENGINE=innodb;
347 === information_schema.innodb_tables and innodb_tablespaces ===
348 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
349 d1@002fd2@005cd3/t1@002ft2@005ct3 d1/d2\d3/t1/t2\t3 33 5 Dynamic 0 Single
350 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
351 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
352 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
353 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
354 === information_schema.innodb_tablespaces and innodb_datafiles ===
355 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
356 d1/d2\d3/t1/t2\t3 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/d1@002fd2@005cd3/t1@[email protected]
357 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
358 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
359 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
360 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
361 === information_schema.files ===
362 Space_Name File_Type Engine Status Tablespace_Name Path
363 d1/d2\d3/t1/t2\t3 TABLESPACE InnoDB NORMAL d1/d2\d3/t1/t2\t3 MYSQLD_DATADIR/d1@002fd2@005cd3/t1@[email protected]
364 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
365 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
366 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
367 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
368 ALTER TABLE `d1/d2\d3`.`t1/t2\t3` DISCARD TABLESPACE;
369 === information_schema.innodb_tables and innodb_tablespaces ===
370 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
371 d1@002fd2@005cd3/t1@002ft2@005ct3 d1/d2\d3/t1/t2\t3 33 5 Dynamic 0 Single
372 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
373 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
374 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
375 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
376 === information_schema.innodb_tablespaces and innodb_datafiles ===
377 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
378 d1/d2\d3/t1/t2\t3 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/d1@002fd2@005cd3/t1@[email protected]
379 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
380 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
381 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
382 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
383 === information_schema.files ===
384 Space_Name File_Type Engine Status Tablespace_Name Path
385 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
386 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
387 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
388 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
389 ALTER TABLE `d1/d2\d3`.`t1/t2\t3` RENAME `d4/d5\d6`.`t3\t4/t5`;
390 === information_schema.innodb_tables and innodb_tablespaces ===
391 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
392 d4@002fd5@005cd6/t3@005ct4@002ft5 d4/d5\d6/t3\t4/t5 33 5 Dynamic 0 Single
393 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
394 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
395 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
396 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
397 === information_schema.innodb_tablespaces and innodb_datafiles ===
398 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
399 d4/d5\d6/t3\t4/t5 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/d4@002fd5@005cd6/t3@[email protected]
400 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
401 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
402 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
403 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
404 === information_schema.files ===
405 Space_Name File_Type Engine Status Tablespace_Name Path
406 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
407 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
408 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
409 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
410 drop table `d4/d5\d6`.`t3\t4/t5`;
411 drop database `d1/d2\d3`;
412 drop database `d4/d5\d6`;
413 # Test Case 6:
414 create database `d1/d2`;
415 create database `d1`;
416 CREATE TABLE `d1/d2`.`t1/t2` (b INT, c text) ENGINE=innodb;
417 === information_schema.innodb_tables and innodb_tablespaces ===
418 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
419 d1@002fd2/t1@002ft2 d1/d2/t1/t2 33 5 Dynamic 0 Single
420 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
421 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
422 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
423 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
424 === information_schema.innodb_tablespaces and innodb_datafiles ===
425 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
426 d1/d2/t1/t2 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/d1@002fd2/[email protected]
427 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
428 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
429 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
430 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
431 === information_schema.files ===
432 Space_Name File_Type Engine Status Tablespace_Name Path
433 d1/d2/t1/t2 TABLESPACE InnoDB NORMAL d1/d2/t1/t2 MYSQLD_DATADIR/d1@002fd2/[email protected]
434 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
435 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
436 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
437 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
438 ALTER TABLE `d1/d2`.`t1/t2` DISCARD TABLESPACE;
439 === information_schema.innodb_tables and innodb_tablespaces ===
440 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
441 d1@002fd2/t1@002ft2 d1/d2/t1/t2 33 5 Dynamic 0 Single
442 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
443 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
444 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
445 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
446 === information_schema.innodb_tablespaces and innodb_datafiles ===
447 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
448 d1/d2/t1/t2 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/d1@002fd2/[email protected]
449 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
450 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
451 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
452 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
453 === information_schema.files ===
454 Space_Name File_Type Engine Status Tablespace_Name Path
455 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
456 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
457 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
458 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
459 ALTER TABLE `d1/d2`.`t1/t2` RENAME `d1`.`d2/t1/t2`;
460 === information_schema.innodb_tables and innodb_tablespaces ===
461 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
462 d1/d2@002ft1@002ft2 d1/d2/t1/t2 33 5 Dynamic 0 Single
463 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
464 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
465 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
466 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
467 === information_schema.innodb_tablespaces and innodb_datafiles ===
468 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
469 d1/d2/t1/t2 Single DEFAULT 0 0 0 Dynamic MYSQLD_DATADIR/d1/d2@[email protected]
470 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
471 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
472 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
473 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
474 === information_schema.files ===
475 Space_Name File_Type Engine Status Tablespace_Name Path
476 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
477 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
478 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
479 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
480 drop table `d1`.`d2/t1/t2`;
481 drop database `d1/d2`;
482 drop database `d1`;