Debian Codegraph @

mysql-test/suite/innodb_fts/r/tablespace_location_error.result

raw
1 # Test with file_per_table
2 SET DEBUG = '+d,ib_fts_aux_table_error';
3 CREATE TABLE t1(a TEXT, b TEXT, c TEXT, d TEXT, FULLTEXT idx(a,b), FULLTEXT idx2(c,d)) ;
4 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
5 SET DEBUG = '-d,ib_fts_aux_table_error';
6 === information_schema.innodb_tables and innodb_tablespaces ===
7 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
8 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
9 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
10 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
11 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
12 # list files in datadir/test
13 SET DEBUG = '+d,ib_fts_index_table_error';
14 CREATE TABLE t1(a TEXT, b TEXT, c TEXT, d TEXT, FULLTEXT idx(a,b), FULLTEXT idx2(c,d)) ;
15 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
16 SET DEBUG = '-d,ib_fts_index_table_error';
17 === information_schema.innodb_tables and innodb_tablespaces ===
18 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
19 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
20 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
21 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
22 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
23 # list files in datadir/test
24 CREATE TABLE t1 (id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200)) ENGINE=InnoDB ;
25 === information_schema.innodb_tables and innodb_tablespaces ===
26 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
27 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
28 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
29 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
30 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
31 test/t1 test/t1 33 5 Dynamic 0 Single
32 # list files in datadir/test
33 t1.ibd
34 SET DEBUG = '+d,ib_fts_aux_table_error';
35 ALTER TABLE t1 ADD FULLTEXT INDEX (title);
36 ERROR HY000: Got error 11 - 'InnoDB error' from storage engine
37 SET DEBUG = '-d,ib_fts_aux_table_error';
38 === information_schema.innodb_tables and innodb_tablespaces ===
39 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
40 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
41 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
42 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
43 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
44 test/t1 test/t1 33 5 Dynamic 0 Single
45 # list files in datadir/test
46 t1.ibd
47 SET DEBUG = '+d,ib_fts_index_table_error';
48 ALTER TABLE t1 ADD FULLTEXT INDEX (title);
49 ERROR HY000: Got error 1000 - 'InnoDB error' from storage engine
50 SET DEBUG = '-d,ib_fts_index_table_error';
51 === information_schema.innodb_tables and innodb_tablespaces ===
52 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
53 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
54 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
55 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
56 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
57 test/t1 test/t1 33 5 Dynamic 0 Single
58 # list files in datadir/test
59 t1.ibd
60 DROP TABLE t1;
61 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT fts_idx(a,b), c INT PRIMARY KEY) ;
62 INSERT INTO t1 VALUES
63 ('MySQL Tutorial','DBMS stands for DataBase', 1) ,
64 ('How To Use MySQL Well','After you went through a', 2),
65 ('Optimizing MySQL','In this tutorial we will show', 3);
66 INSERT INTO t1 VALUES
67 ('1001 MySQL Tricks','1. Never run mysqld as root', 4),
68 ('MySQL vs. YourSQL','In the following database comparison', 5),
69 ('MySQL Security','When configured properly, MySQL', 6);
70 SELECT c FROM t1 WHERE MATCH (a,b)
71 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
72 c
73 1
74 3
75 === information_schema.innodb_tables and innodb_tablespaces ===
76 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
77 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
78 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
79 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
80 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
81 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
82 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
83 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
84 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
85 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
86 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
87 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
88 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
89 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
90 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
91 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
92 test/t1 test/t1 33 7 Dynamic 0 Single
93 # list files in datadir/test
94 fts_aux_index_1.ibd
95 fts_aux_index_2.ibd
96 fts_aux_index_3.ibd
97 fts_aux_index_4.ibd
98 fts_aux_index_5.ibd
99 fts_aux_index_6.ibd
100 fts_aux_being_deleted.ibd
101 fts_aux_being_deleted_cache.ibd
102 fts_aux_config.ibd
103 fts_aux_deleted.ibd
104 fts_aux_deleted_cache.ibd
105 t1.ibd
106 SET DEBUG = '+d,ib_fts_aux_table_error';
107 ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy;
108 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
109 SET DEBUG = '-d,ib_fts_aux_table_error';
110 === information_schema.innodb_tables and innodb_tablespaces ===
111 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
112 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
113 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
114 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
115 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
116 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
117 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
118 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
119 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
120 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
121 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
122 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
123 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
124 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
125 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
126 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
127 test/t1 test/t1 33 7 Dynamic 0 Single
128 # list files in datadir/test
129 fts_aux_index_1.ibd
130 fts_aux_index_2.ibd
131 fts_aux_index_3.ibd
132 fts_aux_index_4.ibd
133 fts_aux_index_5.ibd
134 fts_aux_index_6.ibd
135 fts_aux_being_deleted.ibd
136 fts_aux_being_deleted_cache.ibd
137 fts_aux_config.ibd
138 fts_aux_deleted.ibd
139 fts_aux_deleted_cache.ibd
140 t1.ibd
141 SET DEBUG = '+d,ib_fts_index_table_error';
142 ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy;
143 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
144 SET DEBUG = '-d,ib_fts_index_table_error';
145 === information_schema.innodb_tables and innodb_tablespaces ===
146 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
147 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
148 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
149 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
150 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
151 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
152 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
153 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
154 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
155 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
156 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
157 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
158 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
159 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
160 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
161 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
162 test/t1 test/t1 33 7 Dynamic 0 Single
163 # list files in datadir/test
164 fts_aux_index_1.ibd
165 fts_aux_index_2.ibd
166 fts_aux_index_3.ibd
167 fts_aux_index_4.ibd
168 fts_aux_index_5.ibd
169 fts_aux_index_6.ibd
170 fts_aux_being_deleted.ibd
171 fts_aux_being_deleted_cache.ibd
172 fts_aux_config.ibd
173 fts_aux_deleted.ibd
174 fts_aux_deleted_cache.ibd
175 t1.ibd
176 SET DEBUG = '+d,ib_fts_aux_table_error';
177 ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a,b);
178 SET DEBUG = '-d,ib_fts_aux_table_error';
179 === information_schema.innodb_tables and innodb_tablespaces ===
180 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
181 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
182 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
183 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
184 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
185 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
186 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
187 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
188 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
189 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
190 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
191 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
192 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
193 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
194 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
195 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
196 test/t1 test/t1 33 7 Dynamic 0 Single
197 # list files in datadir/test
198 fts_aux_index_1.ibd
199 fts_aux_index_2.ibd
200 fts_aux_index_3.ibd
201 fts_aux_index_4.ibd
202 fts_aux_index_5.ibd
203 fts_aux_index_6.ibd
204 fts_aux_being_deleted.ibd
205 fts_aux_being_deleted_cache.ibd
206 fts_aux_config.ibd
207 fts_aux_deleted.ibd
208 fts_aux_deleted_cache.ibd
209 t1.ibd
210 SET DEBUG = '+d,ib_fts_index_table_error';
211 ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a);
212 ERROR HY000: Got error 1000 - 'InnoDB error' from storage engine
213 SET DEBUG = '-d,ib_fts_index_table_error';
214 === information_schema.innodb_tables and innodb_tablespaces ===
215 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
216 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
217 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
218 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
219 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
220 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
221 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
222 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
223 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
224 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
225 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
226 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
227 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
228 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
229 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
230 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
231 test/t1 test/t1 33 7 Dynamic 0 Single
232 # list files in datadir/test
233 fts_aux_index_1.ibd
234 fts_aux_index_2.ibd
235 fts_aux_index_3.ibd
236 fts_aux_index_4.ibd
237 fts_aux_index_5.ibd
238 fts_aux_index_6.ibd
239 fts_aux_being_deleted.ibd
240 fts_aux_being_deleted_cache.ibd
241 fts_aux_config.ibd
242 fts_aux_deleted.ibd
243 fts_aux_deleted_cache.ibd
244 t1.ibd
245 DROP TABLE t1;
246 CREATE TABLESPACE s_def ADD DATAFILE 's_def.ibd';
247 === information_schema.innodb_tablespaces and innodb_datafiles ===
248 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
249 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
250 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
251 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
252 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
253 s_def General DEFAULT 0 1 1 Any s_def.ibd
254 === information_schema.files ===
255 Space_Name File_Type Engine Status Tablespace_Name Path
256 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
257 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
258 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
259 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
260 s_def TABLESPACE InnoDB NORMAL s_def MYSQLD_DATADIR/s_def.ibd
261 # Test with TABLESPACE
262 SET DEBUG = '+d,ib_fts_aux_table_error';
263 CREATE TABLE t1(a TEXT, b TEXT, c TEXT, d TEXT, FULLTEXT idx(a,b), FULLTEXT idx2(c,d)) TABLESPACE=s_def;
264 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
265 SET DEBUG = '-d,ib_fts_aux_table_error';
266 === information_schema.innodb_tables and innodb_tablespaces ===
267 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
268 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
269 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
270 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
271 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
272 # list files in datadir/test
273 SET DEBUG = '+d,ib_fts_index_table_error';
274 CREATE TABLE t1(a TEXT, b TEXT, c TEXT, d TEXT, FULLTEXT idx(a,b), FULLTEXT idx2(c,d)) TABLESPACE=s_def;
275 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
276 SET DEBUG = '-d,ib_fts_index_table_error';
277 === information_schema.innodb_tables and innodb_tablespaces ===
278 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
279 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
280 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
281 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
282 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
283 # list files in datadir/test
284 CREATE TABLE t1 (id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200)) ENGINE=InnoDB TABLESPACE=s_def;
285 === information_schema.innodb_tables and innodb_tablespaces ===
286 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
287 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
288 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
289 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
290 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
291 test/t1 s_def 161 5 Dynamic 0 General
292 # list files in datadir/test
293 SET DEBUG = '+d,ib_fts_aux_table_error';
294 ALTER TABLE t1 ADD FULLTEXT INDEX (title);
295 ERROR HY000: Got error 11 - 'InnoDB error' from storage engine
296 SET DEBUG = '-d,ib_fts_aux_table_error';
297 === information_schema.innodb_tables and innodb_tablespaces ===
298 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
299 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
300 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
301 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
302 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
303 test/t1 s_def 161 5 Dynamic 0 General
304 # list files in datadir/test
305 SET DEBUG = '+d,ib_fts_index_table_error';
306 ALTER TABLE t1 ADD FULLTEXT INDEX (title);
307 ERROR HY000: Got error 1000 - 'InnoDB error' from storage engine
308 SET DEBUG = '-d,ib_fts_index_table_error';
309 === information_schema.innodb_tables and innodb_tablespaces ===
310 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
311 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
312 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
313 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
314 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
315 test/t1 s_def 161 5 Dynamic 0 General
316 # list files in datadir/test
317 DROP TABLE t1;
318 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT fts_idx(a,b), c INT PRIMARY KEY) TABLESPACE=s_def;
319 INSERT INTO t1 VALUES
320 ('MySQL Tutorial','DBMS stands for DataBase', 1) ,
321 ('How To Use MySQL Well','After you went through a', 2),
322 ('Optimizing MySQL','In this tutorial we will show', 3);
323 INSERT INTO t1 VALUES
324 ('1001 MySQL Tricks','1. Never run mysqld as root', 4),
325 ('MySQL vs. YourSQL','In the following database comparison', 5),
326 ('MySQL Security','When configured properly, MySQL', 6);
327 SELECT c FROM t1 WHERE MATCH (a,b)
328 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
329 c
330 1
331 3
332 === information_schema.innodb_tables and innodb_tablespaces ===
333 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
334 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
335 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
336 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
337 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
338 test/fts_aux_index_1 s_def 161 8 Dynamic 0 General
339 test/fts_aux_index_2 s_def 161 8 Dynamic 0 General
340 test/fts_aux_index_3 s_def 161 8 Dynamic 0 General
341 test/fts_aux_index_4 s_def 161 8 Dynamic 0 General
342 test/fts_aux_index_5 s_def 161 8 Dynamic 0 General
343 test/fts_aux_index_6 s_def 161 8 Dynamic 0 General
344 test/fts_aux_being_deleted s_def 161 4 Dynamic 0 General
345 test/fts_aux_being_deleted_cache s_def 161 4 Dynamic 0 General
346 test/fts_aux_config s_def 161 5 Dynamic 0 General
347 test/fts_aux_deleted s_def 161 4 Dynamic 0 General
348 test/fts_aux_deleted_cache s_def 161 4 Dynamic 0 General
349 test/t1 s_def 161 7 Dynamic 0 General
350 # list files in datadir/test
351 SET DEBUG = '+d,ib_fts_aux_table_error';
352 ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy;
353 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
354 SET DEBUG = '-d,ib_fts_aux_table_error';
355 === information_schema.innodb_tables and innodb_tablespaces ===
356 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
357 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
358 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
359 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
360 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
361 test/fts_aux_index_1 s_def 161 8 Dynamic 0 General
362 test/fts_aux_index_2 s_def 161 8 Dynamic 0 General
363 test/fts_aux_index_3 s_def 161 8 Dynamic 0 General
364 test/fts_aux_index_4 s_def 161 8 Dynamic 0 General
365 test/fts_aux_index_5 s_def 161 8 Dynamic 0 General
366 test/fts_aux_index_6 s_def 161 8 Dynamic 0 General
367 test/fts_aux_being_deleted s_def 161 4 Dynamic 0 General
368 test/fts_aux_being_deleted_cache s_def 161 4 Dynamic 0 General
369 test/fts_aux_config s_def 161 5 Dynamic 0 General
370 test/fts_aux_deleted s_def 161 4 Dynamic 0 General
371 test/fts_aux_deleted_cache s_def 161 4 Dynamic 0 General
372 test/t1 s_def 161 7 Dynamic 0 General
373 # list files in datadir/test
374 SET DEBUG = '+d,ib_fts_index_table_error';
375 ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy;
376 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
377 SET DEBUG = '-d,ib_fts_index_table_error';
378 === information_schema.innodb_tables and innodb_tablespaces ===
379 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
380 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
381 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
382 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
383 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
384 test/fts_aux_index_1 s_def 161 8 Dynamic 0 General
385 test/fts_aux_index_2 s_def 161 8 Dynamic 0 General
386 test/fts_aux_index_3 s_def 161 8 Dynamic 0 General
387 test/fts_aux_index_4 s_def 161 8 Dynamic 0 General
388 test/fts_aux_index_5 s_def 161 8 Dynamic 0 General
389 test/fts_aux_index_6 s_def 161 8 Dynamic 0 General
390 test/fts_aux_being_deleted s_def 161 4 Dynamic 0 General
391 test/fts_aux_being_deleted_cache s_def 161 4 Dynamic 0 General
392 test/fts_aux_config s_def 161 5 Dynamic 0 General
393 test/fts_aux_deleted s_def 161 4 Dynamic 0 General
394 test/fts_aux_deleted_cache s_def 161 4 Dynamic 0 General
395 test/t1 s_def 161 7 Dynamic 0 General
396 # list files in datadir/test
397 SET DEBUG = '+d,ib_fts_aux_table_error';
398 ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a,b);
399 SET DEBUG = '-d,ib_fts_aux_table_error';
400 === information_schema.innodb_tables and innodb_tablespaces ===
401 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
402 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
403 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
404 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
405 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
406 test/fts_aux_index_1 s_def 161 8 Dynamic 0 General
407 test/fts_aux_index_2 s_def 161 8 Dynamic 0 General
408 test/fts_aux_index_3 s_def 161 8 Dynamic 0 General
409 test/fts_aux_index_4 s_def 161 8 Dynamic 0 General
410 test/fts_aux_index_5 s_def 161 8 Dynamic 0 General
411 test/fts_aux_index_6 s_def 161 8 Dynamic 0 General
412 test/fts_aux_being_deleted s_def 161 4 Dynamic 0 General
413 test/fts_aux_being_deleted_cache s_def 161 4 Dynamic 0 General
414 test/fts_aux_config s_def 161 5 Dynamic 0 General
415 test/fts_aux_deleted s_def 161 4 Dynamic 0 General
416 test/fts_aux_deleted_cache s_def 161 4 Dynamic 0 General
417 test/t1 s_def 161 7 Dynamic 0 General
418 # list files in datadir/test
419 SET DEBUG = '+d,ib_fts_index_table_error';
420 ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a);
421 ERROR HY000: Got error 1000 - 'InnoDB error' from storage engine
422 SET DEBUG = '-d,ib_fts_index_table_error';
423 === information_schema.innodb_tables and innodb_tablespaces ===
424 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
425 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
426 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
427 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
428 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
429 test/fts_aux_index_1 s_def 161 8 Dynamic 0 General
430 test/fts_aux_index_2 s_def 161 8 Dynamic 0 General
431 test/fts_aux_index_3 s_def 161 8 Dynamic 0 General
432 test/fts_aux_index_4 s_def 161 8 Dynamic 0 General
433 test/fts_aux_index_5 s_def 161 8 Dynamic 0 General
434 test/fts_aux_index_6 s_def 161 8 Dynamic 0 General
435 test/fts_aux_being_deleted s_def 161 4 Dynamic 0 General
436 test/fts_aux_being_deleted_cache s_def 161 4 Dynamic 0 General
437 test/fts_aux_config s_def 161 5 Dynamic 0 General
438 test/fts_aux_deleted s_def 161 4 Dynamic 0 General
439 test/fts_aux_deleted_cache s_def 161 4 Dynamic 0 General
440 test/t1 s_def 161 7 Dynamic 0 General
441 # list files in datadir/test
442 DROP TABLE t1;
443 DROP TABLESPACE s_def;