Debian Codegraph @

mysql-test/suite/innodb/r/innodb-wl5980-alter.result

raw
1 #
2 # This is a copy of innodb-alter.test except using remote tablespaces
3 # and showing those files.
4 #
5 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
6 SET default_storage_engine=InnoDB;
7 SET NAMES utf8mb4;
8 CREATE TABLE t1 (
9 c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT,
10 INDEX(c2))
11 ENGINE=InnoDB DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
12 INSERT INTO t1 SET c1=1;
13 CREATE TABLE sys_tables SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES
14 WHERE NAME LIKE 'test/t%';
15 CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES i
16 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
17 CREATE TABLE t1p LIKE t1;
18 CREATE TABLE t1c (c1 INT PRIMARY KEY, c2 INT, c3 INT, INDEX(c2), INDEX(c3),
19 CONSTRAINT t1c2 FOREIGN KEY (c2) REFERENCES t1(c2),
20 CONSTRAINT t1c3 FOREIGN KEY (c3) REFERENCES t1p(c2))
21 ENGINE=InnoDB DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
22 CREATE TABLE sys_foreign SELECT i.*
23 FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN i
24 WHERE FOR_NAME LIKE 'test/t%';
25 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
26 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
27 ID FOR_COL_NAME REF_COL_NAME POS
28 test/t1c2 c2 c2 0
29 test/t1c3 c3 c2 0
30 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
31 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
32 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
33 NAME POS MTYPE PRTYPE LEN
34 c1 0 6 1283 4
35 c2 1 6 1027 4
36 ct 2 5 524540 10
37 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
38 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
39 NAME POS NAME
40 PRIMARY 0 c1
41 c2 0 c2
42 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
43 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
44 ID FOR_COL_NAME REF_COL_NAME POS
45 test/t1c2 c2 c2 0
46 test/t1c3 c3 c2 0
47 SHOW CREATE TABLE t1;
48 Table Create Table
49 t1 CREATE TABLE `t1` (
50 `c1` int(11) NOT NULL,
51 `c2` int(11) DEFAULT 1,
52 `ct` text DEFAULT NULL,
53 PRIMARY KEY (`c1`),
54 KEY `c2` (`c2`)
55 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
56 ALTER TABLE t1 ALTER c2 DROP DEFAULT;
57 SHOW CREATE TABLE t1;
58 Table Create Table
59 t1 CREATE TABLE `t1` (
60 `c1` int(11) NOT NULL,
61 `c2` int(11) DEFAULT NULL,
62 `ct` text DEFAULT NULL,
63 PRIMARY KEY (`c1`),
64 KEY `c2` (`c2`)
65 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
66 ### files in MYSQL_DATA_DIR/test
67 db.opt
68 sys_foreign.frm
69 sys_foreign.ibd
70 sys_indexes.frm
71 sys_indexes.ibd
72 sys_tables.frm
73 sys_tables.ibd
74 t1.frm
75 t1.isl
76 t1c.frm
77 t1c.isl
78 t1p.frm
79 t1p.ibd
80 ### files in MYSQL_TMP_DIR/alt_dir/test
81 t1.ibd
82 t1c.ibd
83 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
84 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
85 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
86 NAME POS MTYPE PRTYPE LEN
87 c1 0 6 1283 4
88 c2 1 6 1027 4
89 ct 2 5 524540 10
90 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
91 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
92 NAME POS NAME
93 PRIMARY 0 c1
94 c2 0 c2
95 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
96 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
97 ID FOR_COL_NAME REF_COL_NAME POS
98 test/t1c2 c2 c2 0
99 test/t1c3 c3 c2 0
100 ALTER TABLE t1 CHANGE c2 c2 INT AFTER c1;
101 ALTER TABLE t1 CHANGE c1 c1 INT FIRST;
102 ### files in MYSQL_DATA_DIR/test
103 db.opt
104 sys_foreign.frm
105 sys_foreign.ibd
106 sys_indexes.frm
107 sys_indexes.ibd
108 sys_tables.frm
109 sys_tables.ibd
110 t1.frm
111 t1.isl
112 t1c.frm
113 t1c.isl
114 t1p.frm
115 t1p.ibd
116 ### files in MYSQL_TMP_DIR/alt_dir/test
117 t1.ibd
118 t1c.ibd
119 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
120 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
121 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
122 NAME POS MTYPE PRTYPE LEN
123 c1 0 6 1283 4
124 c2 1 6 1027 4
125 ct 2 5 524540 10
126 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
127 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
128 NAME POS NAME
129 PRIMARY 0 c1
130 c2 0 c2
131 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
132 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
133 ID FOR_COL_NAME REF_COL_NAME POS
134 test/t1c2 c2 c2 0
135 test/t1c3 c3 c2 0
136 ALTER TABLE t1 CHANGE C2 c3 INT;
137 ### files in MYSQL_DATA_DIR/test
138 db.opt
139 sys_foreign.frm
140 sys_foreign.ibd
141 sys_indexes.frm
142 sys_indexes.ibd
143 sys_tables.frm
144 sys_tables.ibd
145 t1.frm
146 t1.isl
147 t1c.frm
148 t1c.isl
149 t1p.frm
150 t1p.ibd
151 ### files in MYSQL_TMP_DIR/alt_dir/test
152 t1.ibd
153 t1c.ibd
154 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
155 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
156 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
157 NAME POS MTYPE PRTYPE LEN
158 c1 0 6 1283 4
159 c3 1 6 1027 4
160 ct 2 5 524540 10
161 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
162 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
163 NAME POS NAME
164 PRIMARY 0 c1
165 c2 0 c3
166 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
167 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
168 ID FOR_COL_NAME REF_COL_NAME POS
169 test/t1c2 c2 c3 0
170 test/t1c3 c3 c2 0
171 ALTER TABLE t1 CHANGE c3 C INT;
172 ### files in MYSQL_DATA_DIR/test
173 db.opt
174 sys_foreign.frm
175 sys_foreign.ibd
176 sys_indexes.frm
177 sys_indexes.ibd
178 sys_tables.frm
179 sys_tables.ibd
180 t1.frm
181 t1.isl
182 t1c.frm
183 t1c.isl
184 t1p.frm
185 t1p.ibd
186 ### files in MYSQL_TMP_DIR/alt_dir/test
187 t1.ibd
188 t1c.ibd
189 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
190 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
191 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
192 NAME POS MTYPE PRTYPE LEN
193 c1 0 6 1283 4
194 C 1 6 1027 4
195 ct 2 5 524540 10
196 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
197 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
198 NAME POS NAME
199 PRIMARY 0 c1
200 c2 0 C
201 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
202 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
203 ID FOR_COL_NAME REF_COL_NAME POS
204 test/t1c2 c2 C 0
205 test/t1c3 c3 c2 0
206 ALTER TABLE t1 CHANGE C Cöŀumň_TWO INT;
207 ### files in MYSQL_DATA_DIR/test
208 db.opt
209 sys_foreign.frm
210 sys_foreign.ibd
211 sys_indexes.frm
212 sys_indexes.ibd
213 sys_tables.frm
214 sys_tables.ibd
215 t1.frm
216 t1.isl
217 t1c.frm
218 t1c.isl
219 t1p.frm
220 t1p.ibd
221 ### files in MYSQL_TMP_DIR/alt_dir/test
222 t1.ibd
223 t1c.ibd
224 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
225 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
226 ID FOR_COL_NAME REF_COL_NAME POS
227 test/t1c2 c2 Cöŀumň_TWO 0
228 test/t1c3 c3 c2 0
229 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
230 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
231 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
232 NAME POS MTYPE PRTYPE LEN
233 c1 0 6 1283 4
234 Cöŀumň_TWO 1 6 1027 4
235 ct 2 5 524540 10
236 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
237 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
238 NAME POS NAME
239 PRIMARY 0 c1
240 c2 0 Cöŀumň_TWO
241 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
242 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
243 ID FOR_COL_NAME REF_COL_NAME POS
244 test/t1c2 c2 Cöŀumň_TWO 0
245 test/t1c3 c3 c2 0
246 ALTER TABLE t1 CHANGE cöĿǖmň_two c3 INT;
247 ERROR 42S22: Unknown column 'cöĿǖmň_two' in 't1'
248 ALTER TABLE t1 CHANGE cÖĿUMŇ_two c3 INT, RENAME TO t3;
249 ### files in MYSQL_DATA_DIR/test
250 db.opt
251 sys_foreign.frm
252 sys_foreign.ibd
253 sys_indexes.frm
254 sys_indexes.ibd
255 sys_tables.frm
256 sys_tables.ibd
257 t1c.frm
258 t1c.isl
259 t1p.frm
260 t1p.ibd
261 t3.frm
262 t3.isl
263 ### files in MYSQL_TMP_DIR/alt_dir/test
264 t1c.ibd
265 t3.ibd
266 SELECT st.NAME, i.NAME
267 FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES i
268 ON i.TABLE_ID=st.TABLE_ID;
269 NAME NAME
270 test/t1 test/t3
271 SHOW CREATE TABLE t3;
272 Table Create Table
273 t3 CREATE TABLE `t3` (
274 `c1` int(11) NOT NULL,
275 `c3` int(11) DEFAULT NULL,
276 `ct` text DEFAULT NULL,
277 PRIMARY KEY (`c1`),
278 KEY `c2` (`c3`)
279 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
280 SHOW CREATE TABLE t1c;
281 Table Create Table
282 t1c CREATE TABLE `t1c` (
283 `c1` int(11) NOT NULL,
284 `c2` int(11) DEFAULT NULL,
285 `c3` int(11) DEFAULT NULL,
286 PRIMARY KEY (`c1`),
287 KEY `c2` (`c2`),
288 KEY `c3` (`c3`),
289 CONSTRAINT `t1c2` FOREIGN KEY (`c2`) REFERENCES `t3` (`c3`),
290 CONSTRAINT `t1c3` FOREIGN KEY (`c3`) REFERENCES `t1p` (`c2`)
291 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
292 ALTER TABLE t3 CHANGE c3
293 `12345678901234567890123456789012345678901234567890123456789012345` INT;
294 ERROR 42000: Identifier name '12345678901234567890123456789012345678901234567890123456789012345' is too long
295 ALTER TABLE t3 CHANGE c3
296 `1234567890123456789012345678901234567890123456789012345678901234` INT;
297 ### files in MYSQL_DATA_DIR/test
298 db.opt
299 sys_foreign.frm
300 sys_foreign.ibd
301 sys_indexes.frm
302 sys_indexes.ibd
303 sys_tables.frm
304 sys_tables.ibd
305 t1c.frm
306 t1c.isl
307 t1p.frm
308 t1p.ibd
309 t3.frm
310 t3.isl
311 ### files in MYSQL_TMP_DIR/alt_dir/test
312 t1c.ibd
313 t3.ibd
314 SHOW CREATE TABLE t3;
315 Table Create Table
316 t3 CREATE TABLE `t3` (
317 `c1` int(11) NOT NULL,
318 `1234567890123456789012345678901234567890123456789012345678901234` int(11) DEFAULT NULL,
319 `ct` text DEFAULT NULL,
320 PRIMARY KEY (`c1`),
321 KEY `c2` (`1234567890123456789012345678901234567890123456789012345678901234`)
322 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
323 ALTER TABLE t3 CHANGE
324 `1234567890123456789012345678901234567890123456789012345678901234`
325 `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾倿偀` INT;
326 ERROR 42000: Identifier name '倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借...' is too long
327 ALTER TABLE t3 CHANGE
328 `1234567890123456789012345678901234567890123456789012345678901234`
329 `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾倿ä` INT;
330 ERROR 42000: Identifier name '倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借...' is too long
331 ALTER TABLE t3 CHANGE
332 `1234567890123456789012345678901234567890123456789012345678901234`
333 `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾ä` INT;
334 ### files in MYSQL_DATA_DIR/test
335 db.opt
336 sys_foreign.frm
337 sys_foreign.ibd
338 sys_indexes.frm
339 sys_indexes.ibd
340 sys_tables.frm
341 sys_tables.ibd
342 t1c.frm
343 t1c.isl
344 t1p.frm
345 t1p.ibd
346 t3.frm
347 t3.isl
348 ### files in MYSQL_TMP_DIR/alt_dir/test
349 t1c.ibd
350 t3.ibd
351 ALTER TABLE t3 CHANGE
352 `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾Ä`
353 c3 INT;
354 ### files in MYSQL_DATA_DIR/test
355 db.opt
356 sys_foreign.frm
357 sys_foreign.ibd
358 sys_indexes.frm
359 sys_indexes.ibd
360 sys_tables.frm
361 sys_tables.ibd
362 t1c.frm
363 t1c.isl
364 t1p.frm
365 t1p.ibd
366 t3.frm
367 t3.isl
368 ### files in MYSQL_TMP_DIR/alt_dir/test
369 t1c.ibd
370 t3.ibd
371 ALTER TABLE t3 CHANGE c3 𐌀𐌁𐌂𐌃𐌄𐌅𐌆𐌇𐌈𐌉𐌊𐌋𐌌𐌍𐌎𐌏𐌐𐌑𐌒𐌓𐌔𐌕𐌖𐌗𐌘𐌙𐌚𐌛𐌜 INT;
372 ERROR HY000: Invalid utf8mb4 character string: '\xF0\x90\x8C\x80\xF0\x90\x8C\x81\xF0\x90\x8C\x82\xF0\x90\x8C\...'
373 ALTER TABLE t3 CHANGE c3 😲 INT;
374 ERROR HY000: Invalid utf8mb4 character string: '\xF0\x9F\x98\xB2'
375 ALTER TABLE t3 RENAME TO t2;
376 ### files in MYSQL_DATA_DIR/test
377 db.opt
378 sys_foreign.frm
379 sys_foreign.ibd
380 sys_indexes.frm
381 sys_indexes.ibd
382 sys_tables.frm
383 sys_tables.ibd
384 t1c.frm
385 t1c.isl
386 t1p.frm
387 t1p.ibd
388 t2.frm
389 t2.isl
390 ### files in MYSQL_TMP_DIR/alt_dir/test
391 t1c.ibd
392 t2.ibd
393 SELECT st.NAME, i.NAME
394 FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES i
395 ON i.TABLE_ID=st.TABLE_ID;
396 NAME NAME
397 test/t1 test/t2
398 SHOW CREATE TABLE t2;
399 Table Create Table
400 t2 CREATE TABLE `t2` (
401 `c1` int(11) NOT NULL,
402 `c3` int(11) DEFAULT NULL,
403 `ct` text DEFAULT NULL,
404 PRIMARY KEY (`c1`),
405 KEY `c2` (`c3`)
406 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
407 RENAME TABLE t2 TO t1;
408 SELECT st.NAME, i.NAME
409 FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES i
410 ON i.TABLE_ID=st.TABLE_ID;
411 NAME NAME
412 test/t1 test/t1
413 ### files in MYSQL_DATA_DIR/test
414 db.opt
415 sys_foreign.frm
416 sys_foreign.ibd
417 sys_indexes.frm
418 sys_indexes.ibd
419 sys_tables.frm
420 sys_tables.ibd
421 t1.frm
422 t1.isl
423 t1c.frm
424 t1c.isl
425 t1p.frm
426 t1p.ibd
427 ### files in MYSQL_TMP_DIR/alt_dir/test
428 t1.ibd
429 t1c.ibd
430 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
431 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
432 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
433 NAME POS MTYPE PRTYPE LEN
434 c1 0 6 1283 4
435 c3 1 6 1027 4
436 ct 2 5 524540 10
437 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
438 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
439 NAME POS NAME
440 PRIMARY 0 c1
441 c2 0 c3
442 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
443 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
444 ID FOR_COL_NAME REF_COL_NAME POS
445 test/t1c2 c2 c3 0
446 test/t1c3 c3 c2 0
447 ALTER TABLE t1 DROP INDEX c2;
448 ERROR HY000: Cannot drop index 'c2': needed in a foreign key constraint
449 ALTER TABLE t1 DROP INDEX c4;
450 ERROR 42000: Can't DROP INDEX `c4`; check that it exists
451 ALTER TABLE t1c DROP FOREIGN KEY c2;
452 ERROR 42000: Can't DROP FOREIGN KEY `c2`; check that it exists
453 ALTER TABLE t1c DROP FOREIGN KEY t1c2, DROP FOREIGN KEY c2;
454 ERROR 42000: Can't DROP FOREIGN KEY `c2`; check that it exists
455 ALTER TABLE t1c DROP FOREIGN KEY t1c2, DROP FOREIGN KEY c2, DROP INDEX c2;
456 ERROR 42000: Can't DROP FOREIGN KEY `c2`; check that it exists
457 ALTER TABLE t1c DROP INDEX c2;
458 ERROR HY000: Cannot drop index 'c2': needed in a foreign key constraint
459 ALTER TABLE t1c DROP FOREIGN KEY ẗ1C2;
460 ERROR 42000: Can't DROP FOREIGN KEY `ẗ1C2`; check that it exists
461 SHOW CREATE TABLE t1c;
462 Table Create Table
463 t1c CREATE TABLE `t1c` (
464 `c1` int(11) NOT NULL,
465 `c2` int(11) DEFAULT NULL,
466 `c3` int(11) DEFAULT NULL,
467 PRIMARY KEY (`c1`),
468 KEY `c2` (`c2`),
469 KEY `c3` (`c3`),
470 CONSTRAINT `t1c2` FOREIGN KEY (`c2`) REFERENCES `t1` (`c3`),
471 CONSTRAINT `t1c3` FOREIGN KEY (`c3`) REFERENCES `t1p` (`c2`)
472 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
473 SET foreign_key_checks=0;
474 DROP TABLE t1p;
475 SET foreign_key_checks=1;
476 SHOW CREATE TABLE t1c;
477 Table Create Table
478 t1c CREATE TABLE `t1c` (
479 `c1` int(11) NOT NULL,
480 `c2` int(11) DEFAULT NULL,
481 `c3` int(11) DEFAULT NULL,
482 PRIMARY KEY (`c1`),
483 KEY `c2` (`c2`),
484 KEY `c3` (`c3`),
485 CONSTRAINT `t1c2` FOREIGN KEY (`c2`) REFERENCES `t1` (`c3`),
486 CONSTRAINT `t1c3` FOREIGN KEY (`c3`) REFERENCES `t1p` (`c2`)
487 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
488 ### files in MYSQL_DATA_DIR/test
489 db.opt
490 sys_foreign.frm
491 sys_foreign.ibd
492 sys_indexes.frm
493 sys_indexes.ibd
494 sys_tables.frm
495 sys_tables.ibd
496 t1.frm
497 t1.isl
498 t1c.frm
499 t1c.isl
500 ### files in MYSQL_TMP_DIR/alt_dir/test
501 t1.ibd
502 t1c.ibd
503 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
504 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
505 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
506 NAME POS MTYPE PRTYPE LEN
507 c1 0 6 1283 4
508 c3 1 6 1027 4
509 ct 2 5 524540 10
510 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
511 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
512 NAME POS NAME
513 PRIMARY 0 c1
514 c2 0 c3
515 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
516 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
517 ID FOR_COL_NAME REF_COL_NAME POS
518 test/t1c2 c2 c3 0
519 test/t1c3 c3 c2 0
520 CREATE TABLE t1p (c1 INT PRIMARY KEY, c2 INT, INDEX(c2))
521 ENGINE=InnoDB DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
522 ALTER TABLE t1c DROP INDEX C2, DROP INDEX C3;
523 ERROR HY000: Cannot drop index 'c2': needed in a foreign key constraint
524 ALTER TABLE t1c DROP INDEX C3;
525 ERROR HY000: Cannot drop index 'c3': needed in a foreign key constraint
526 SET foreign_key_checks=0;
527 ALTER TABLE t1c DROP INDEX C3;
528 ### files in MYSQL_DATA_DIR/test
529 db.opt
530 sys_foreign.frm
531 sys_foreign.ibd
532 sys_indexes.frm
533 sys_indexes.ibd
534 sys_tables.frm
535 sys_tables.ibd
536 t1.frm
537 t1.isl
538 t1c.frm
539 t1c.isl
540 t1p.frm
541 t1p.isl
542 ### files in MYSQL_TMP_DIR/alt_dir/test
543 t1.ibd
544 t1c.ibd
545 t1p.ibd
546 SET foreign_key_checks=1;
547 SHOW CREATE TABLE t1c;
548 Table Create Table
549 t1c CREATE TABLE `t1c` (
550 `c1` int(11) NOT NULL,
551 `c2` int(11) DEFAULT NULL,
552 `c3` int(11) DEFAULT NULL,
553 PRIMARY KEY (`c1`),
554 KEY `c2` (`c2`),
555 CONSTRAINT `t1c2` FOREIGN KEY (`c2`) REFERENCES `t1` (`c3`),
556 CONSTRAINT `t1c3` FOREIGN KEY (`c3`) REFERENCES `t1p` (`c2`)
557 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
558 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
559 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
560 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
561 NAME POS MTYPE PRTYPE LEN
562 c1 0 6 1283 4
563 c3 1 6 1027 4
564 ct 2 5 524540 10
565 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
566 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
567 NAME POS NAME
568 PRIMARY 0 c1
569 c2 0 c3
570 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
571 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
572 ID FOR_COL_NAME REF_COL_NAME POS
573 test/t1c2 c2 c3 0
574 test/t1c3 c3 c2 0
575 ALTER TABLE t1c DROP FOREIGN KEY t1C3;
576 ### files in MYSQL_DATA_DIR/test
577 db.opt
578 sys_foreign.frm
579 sys_foreign.ibd
580 sys_indexes.frm
581 sys_indexes.ibd
582 sys_tables.frm
583 sys_tables.ibd
584 t1.frm
585 t1.isl
586 t1c.frm
587 t1c.isl
588 t1p.frm
589 t1p.isl
590 ### files in MYSQL_TMP_DIR/alt_dir/test
591 t1.ibd
592 t1c.ibd
593 t1p.ibd
594 SHOW CREATE TABLE t1c;
595 Table Create Table
596 t1c CREATE TABLE `t1c` (
597 `c1` int(11) NOT NULL,
598 `c2` int(11) DEFAULT NULL,
599 `c3` int(11) DEFAULT NULL,
600 PRIMARY KEY (`c1`),
601 KEY `c2` (`c2`),
602 CONSTRAINT `t1c2` FOREIGN KEY (`c2`) REFERENCES `t1` (`c3`)
603 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
604 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
605 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
606 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
607 NAME POS MTYPE PRTYPE LEN
608 c1 0 6 1283 4
609 c3 1 6 1027 4
610 ct 2 5 524540 10
611 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
612 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
613 NAME POS NAME
614 PRIMARY 0 c1
615 c2 0 c3
616 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
617 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
618 ID FOR_COL_NAME REF_COL_NAME POS
619 test/t1c2 c2 c3 0
620 ALTER TABLE t1c DROP INDEX c2, DROP FOREIGN KEY t1C2;
621 ### files in MYSQL_DATA_DIR/test
622 db.opt
623 sys_foreign.frm
624 sys_foreign.ibd
625 sys_indexes.frm
626 sys_indexes.ibd
627 sys_tables.frm
628 sys_tables.ibd
629 t1.frm
630 t1.isl
631 t1c.frm
632 t1c.isl
633 t1p.frm
634 t1p.isl
635 ### files in MYSQL_TMP_DIR/alt_dir/test
636 t1.ibd
637 t1c.ibd
638 t1p.ibd
639 SHOW CREATE TABLE t1c;
640 Table Create Table
641 t1c CREATE TABLE `t1c` (
642 `c1` int(11) NOT NULL,
643 `c2` int(11) DEFAULT NULL,
644 `c3` int(11) DEFAULT NULL,
645 PRIMARY KEY (`c1`)
646 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
647 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
648 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
649 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
650 NAME POS MTYPE PRTYPE LEN
651 c1 0 6 1283 4
652 c3 1 6 1027 4
653 ct 2 5 524540 10
654 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
655 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
656 NAME POS NAME
657 PRIMARY 0 c1
658 c2 0 c3
659 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
660 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
661 ID FOR_COL_NAME REF_COL_NAME POS
662 ALTER TABLE t1 DROP INDEX c2, CHANGE c3 c2 INT;
663 ### files in MYSQL_DATA_DIR/test
664 db.opt
665 sys_foreign.frm
666 sys_foreign.ibd
667 sys_indexes.frm
668 sys_indexes.ibd
669 sys_tables.frm
670 sys_tables.ibd
671 t1.frm
672 t1.isl
673 t1c.frm
674 t1c.isl
675 t1p.frm
676 t1p.isl
677 ### files in MYSQL_TMP_DIR/alt_dir/test
678 t1.ibd
679 t1c.ibd
680 t1p.ibd
681 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
682 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
683 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
684 NAME POS MTYPE PRTYPE LEN
685 c1 0 6 1283 4
686 c2 1 6 1027 4
687 ct 2 5 524540 10
688 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
689 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
690 NAME POS NAME
691 PRIMARY 0 c1
692 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
693 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
694 ID FOR_COL_NAME REF_COL_NAME POS
695 CREATE TABLE t1o LIKE t1;
696 ALTER TABLE t1 ADD FULLTEXT INDEX (ct),
697 CHANGE c1 pk INT, ALTER c2 SET DEFAULT 42, RENAME TO tt,
698 ALGORITHM=INPLACE, LOCK=NONE;
699 ERROR 0A000: LOCK=NONE is not supported. Reason: Fulltext index creation requires a lock. Try LOCK=SHARED
700 ALTER TABLE t1 ADD FULLTEXT INDEX (ct),
701 CHANGE c1 pk INT, ALTER c2 SET DEFAULT 42, RENAME TO tt,
702 ALGORITHM=INPLACE, LOCK=SHARED;
703 ### files in MYSQL_DATA_DIR/test
704 FTS_AUX_INDEX_1.isl
705 FTS_AUX_INDEX_2.isl
706 FTS_AUX_INDEX_3.isl
707 FTS_AUX_INDEX_4.isl
708 FTS_AUX_INDEX_5.isl
709 FTS_AUX_INDEX_6.isl
710 FTS_AUX_BEING_DELETED.isl
711 FTS_AUX_BEING_DELETED_CACHE.isl
712 FTS_AUX_CONFIG.isl
713 FTS_AUX_DELETED.isl
714 FTS_AUX_DELETED_CACHE.isl
715 db.opt
716 sys_foreign.frm
717 sys_foreign.ibd
718 sys_indexes.frm
719 sys_indexes.ibd
720 sys_tables.frm
721 sys_tables.ibd
722 t1c.frm
723 t1c.isl
724 t1o.frm
725 t1o.ibd
726 t1p.frm
727 t1p.isl
728 tt.frm
729 tt.isl
730 ### files in MYSQL_TMP_DIR/alt_dir/test
731 FTS_AUX_INDEX_1.ibd
732 FTS_AUX_INDEX_2.ibd
733 FTS_AUX_INDEX_3.ibd
734 FTS_AUX_INDEX_4.ibd
735 FTS_AUX_INDEX_5.ibd
736 FTS_AUX_INDEX_6.ibd
737 FTS_AUX_BEING_DELETED.ibd
738 FTS_AUX_BEING_DELETED_CACHE.ibd
739 FTS_AUX_CONFIG.ibd
740 FTS_AUX_DELETED.ibd
741 FTS_AUX_DELETED_CACHE.ibd
742 t1c.ibd
743 t1p.ibd
744 tt.ibd
745 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
746 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
747 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
748 NAME POS MTYPE PRTYPE LEN
749 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
750 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
751 NAME POS NAME
752 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
753 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
754 ID FOR_COL_NAME REF_COL_NAME POS
755 SHOW CREATE TABLE tt;
756 Table Create Table
757 tt CREATE TABLE `tt` (
758 `pk` int(11) NOT NULL,
759 `c2` int(11) DEFAULT 42,
760 `ct` text DEFAULT NULL,
761 PRIMARY KEY (`pk`),
762 FULLTEXT KEY `ct` (`ct`)
763 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
764 ALTER TABLE t1o CHANGE c1 dB_row_Id INT, ALGORITHM=COPY;
765 ERROR 42000: Incorrect column name 'dB_row_Id'
766 ALTER TABLE t1o CHANGE c1 dB_row_Id INT, ALGORITHM=INPLACE;
767 ERROR 42000: Incorrect column name 'DB_ROW_ID'
768 ALTER TABLE t1o CHANGE c1 DB_TRX_ID INT;
769 ERROR 42000: Incorrect column name 'DB_TRX_ID'
770 ALTER TABLE t1o CHANGE c1 db_roll_ptr INT;
771 ERROR 42000: Incorrect column name 'DB_ROLL_PTR'
772 ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_DOC_ID INT,
773 ALGORITHM=COPY;
774 ERROR 42000: Incorrect column name 'FTS_DOC_ID'
775 ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_DOC_ID INT,
776 ALGORITHM=INPLACE;
777 ERROR HY000: Column 'FTS_DOC_ID' is of wrong type for an InnoDB FULLTEXT index
778 ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_Doc_ID INT,
779 ALGORITHM=INPLACE;
780 ERROR 42000: Incorrect column name 'FTS_Doc_ID'
781 ALTER TABLE t1o ADD FULLTEXT INDEX(ct),
782 CHANGE c1 FTS_DOC_ID BIGINT UNSIGNED NOT NULL,
783 ALGORITHM=INPLACE;
784 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
785 CREATE TABLE t1n LIKE t1o;
786 ALTER TABLE t1n ADD FULLTEXT INDEX(ct);
787 ### files in MYSQL_DATA_DIR/test
788 FTS_AUX_INDEX_1.isl
789 FTS_AUX_INDEX_2.isl
790 FTS_AUX_INDEX_3.isl
791 FTS_AUX_INDEX_4.isl
792 FTS_AUX_INDEX_5.isl
793 FTS_AUX_INDEX_6.isl
794 FTS_AUX_BEING_DELETED.isl
795 FTS_AUX_BEING_DELETED_CACHE.isl
796 FTS_AUX_CONFIG.isl
797 FTS_AUX_DELETED.isl
798 FTS_AUX_DELETED_CACHE.isl
799 FTS_AUX_INDEX_1.ibd
800 FTS_AUX_INDEX_2.ibd
801 FTS_AUX_INDEX_3.ibd
802 FTS_AUX_INDEX_4.ibd
803 FTS_AUX_INDEX_5.ibd
804 FTS_AUX_INDEX_6.ibd
805 FTS_AUX_BEING_DELETED.ibd
806 FTS_AUX_BEING_DELETED_CACHE.ibd
807 FTS_AUX_CONFIG.ibd
808 FTS_AUX_DELETED.ibd
809 FTS_AUX_DELETED_CACHE.ibd
810 db.opt
811 sys_foreign.frm
812 sys_foreign.ibd
813 sys_indexes.frm
814 sys_indexes.ibd
815 sys_tables.frm
816 sys_tables.ibd
817 t1c.frm
818 t1c.isl
819 t1n.frm
820 t1n.ibd
821 t1o.frm
822 t1o.ibd
823 t1p.frm
824 t1p.isl
825 tt.frm
826 tt.isl
827 ### files in MYSQL_TMP_DIR/alt_dir/test
828 FTS_AUX_INDEX_1.ibd
829 FTS_AUX_INDEX_2.ibd
830 FTS_AUX_INDEX_3.ibd
831 FTS_AUX_INDEX_4.ibd
832 FTS_AUX_INDEX_5.ibd
833 FTS_AUX_INDEX_6.ibd
834 FTS_AUX_BEING_DELETED.ibd
835 FTS_AUX_BEING_DELETED_CACHE.ibd
836 FTS_AUX_CONFIG.ibd
837 FTS_AUX_DELETED.ibd
838 FTS_AUX_DELETED_CACHE.ibd
839 t1c.ibd
840 t1p.ibd
841 tt.ibd
842 ALTER TABLE t1n CHANGE c1 Fts_DOC_ID INT, ALGORITHM=INPLACE;
843 ERROR 42000: Incorrect column name 'FTS_DOC_ID'
844 ALTER TABLE t1n CHANGE c1 Fts_DOC_ID INT, ALGORITHM=COPY;
845 ERROR 42000: Incorrect column name 'Fts_DOC_ID'
846 ALTER TABLE t1n CHANGE FTS_DOC_ID c11 INT, ALGORITHM=INPLACE;
847 ERROR 42S22: Unknown column 'FTS_DOC_ID' in 't1n'
848 ALTER TABLE t1n CHANGE c1 FTS_DOC_ïD INT, ALGORITHM=INPLACE;
849 ### files in MYSQL_DATA_DIR/test
850 FTS_AUX_INDEX_1.isl
851 FTS_AUX_INDEX_2.isl
852 FTS_AUX_INDEX_3.isl
853 FTS_AUX_INDEX_4.isl
854 FTS_AUX_INDEX_5.isl
855 FTS_AUX_INDEX_6.isl
856 FTS_AUX_BEING_DELETED.isl
857 FTS_AUX_BEING_DELETED_CACHE.isl
858 FTS_AUX_CONFIG.isl
859 FTS_AUX_DELETED.isl
860 FTS_AUX_DELETED_CACHE.isl
861 FTS_AUX_INDEX_1.ibd
862 FTS_AUX_INDEX_2.ibd
863 FTS_AUX_INDEX_3.ibd
864 FTS_AUX_INDEX_4.ibd
865 FTS_AUX_INDEX_5.ibd
866 FTS_AUX_INDEX_6.ibd
867 FTS_AUX_BEING_DELETED.ibd
868 FTS_AUX_BEING_DELETED_CACHE.ibd
869 FTS_AUX_CONFIG.ibd
870 FTS_AUX_DELETED.ibd
871 FTS_AUX_DELETED_CACHE.ibd
872 db.opt
873 sys_foreign.frm
874 sys_foreign.ibd
875 sys_indexes.frm
876 sys_indexes.ibd
877 sys_tables.frm
878 sys_tables.ibd
879 t1c.frm
880 t1c.isl
881 t1n.frm
882 t1n.ibd
883 t1o.frm
884 t1o.ibd
885 t1p.frm
886 t1p.isl
887 tt.frm
888 tt.isl
889 ### files in MYSQL_TMP_DIR/alt_dir/test
890 FTS_AUX_INDEX_1.ibd
891 FTS_AUX_INDEX_2.ibd
892 FTS_AUX_INDEX_3.ibd
893 FTS_AUX_INDEX_4.ibd
894 FTS_AUX_INDEX_5.ibd
895 FTS_AUX_INDEX_6.ibd
896 FTS_AUX_BEING_DELETED.ibd
897 FTS_AUX_BEING_DELETED_CACHE.ibd
898 FTS_AUX_CONFIG.ibd
899 FTS_AUX_DELETED.ibd
900 FTS_AUX_DELETED_CACHE.ibd
901 t1c.ibd
902 t1p.ibd
903 tt.ibd
904 ALTER TABLE t1n CHANGE FTS_DOC_ÏD c1 INT, ALGORITHM=INPLACE;
905 ### files in MYSQL_DATA_DIR/test
906 FTS_AUX_INDEX_1.isl
907 FTS_AUX_INDEX_2.isl
908 FTS_AUX_INDEX_3.isl
909 FTS_AUX_INDEX_4.isl
910 FTS_AUX_INDEX_5.isl
911 FTS_AUX_INDEX_6.isl
912 FTS_AUX_BEING_DELETED.isl
913 FTS_AUX_BEING_DELETED_CACHE.isl
914 FTS_AUX_CONFIG.isl
915 FTS_AUX_DELETED.isl
916 FTS_AUX_DELETED_CACHE.isl
917 FTS_AUX_INDEX_1.ibd
918 FTS_AUX_INDEX_2.ibd
919 FTS_AUX_INDEX_3.ibd
920 FTS_AUX_INDEX_4.ibd
921 FTS_AUX_INDEX_5.ibd
922 FTS_AUX_INDEX_6.ibd
923 FTS_AUX_BEING_DELETED.ibd
924 FTS_AUX_BEING_DELETED_CACHE.ibd
925 FTS_AUX_CONFIG.ibd
926 FTS_AUX_DELETED.ibd
927 FTS_AUX_DELETED_CACHE.ibd
928 db.opt
929 sys_foreign.frm
930 sys_foreign.ibd
931 sys_indexes.frm
932 sys_indexes.ibd
933 sys_tables.frm
934 sys_tables.ibd
935 t1c.frm
936 t1c.isl
937 t1n.frm
938 t1n.ibd
939 t1o.frm
940 t1o.ibd
941 t1p.frm
942 t1p.isl
943 tt.frm
944 tt.isl
945 ### files in MYSQL_TMP_DIR/alt_dir/test
946 FTS_AUX_INDEX_1.ibd
947 FTS_AUX_INDEX_2.ibd
948 FTS_AUX_INDEX_3.ibd
949 FTS_AUX_INDEX_4.ibd
950 FTS_AUX_INDEX_5.ibd
951 FTS_AUX_INDEX_6.ibd
952 FTS_AUX_BEING_DELETED.ibd
953 FTS_AUX_BEING_DELETED_CACHE.ibd
954 FTS_AUX_CONFIG.ibd
955 FTS_AUX_DELETED.ibd
956 FTS_AUX_DELETED_CACHE.ibd
957 t1c.ibd
958 t1p.ibd
959 tt.ibd
960 ALTER TABLE t1n CHANGE c1 c2 INT, CHANGE c2 ct INT, CHANGE ct c1 TEXT,
961 ALGORITHM=INPLACE;
962 ### files in MYSQL_DATA_DIR/test
963 FTS_AUX_INDEX_1.isl
964 FTS_AUX_INDEX_2.isl
965 FTS_AUX_INDEX_3.isl
966 FTS_AUX_INDEX_4.isl
967 FTS_AUX_INDEX_5.isl
968 FTS_AUX_INDEX_6.isl
969 FTS_AUX_BEING_DELETED.isl
970 FTS_AUX_BEING_DELETED_CACHE.isl
971 FTS_AUX_CONFIG.isl
972 FTS_AUX_DELETED.isl
973 FTS_AUX_DELETED_CACHE.isl
974 FTS_AUX_INDEX_1.ibd
975 FTS_AUX_INDEX_2.ibd
976 FTS_AUX_INDEX_3.ibd
977 FTS_AUX_INDEX_4.ibd
978 FTS_AUX_INDEX_5.ibd
979 FTS_AUX_INDEX_6.ibd
980 FTS_AUX_BEING_DELETED.ibd
981 FTS_AUX_BEING_DELETED_CACHE.ibd
982 FTS_AUX_CONFIG.ibd
983 FTS_AUX_DELETED.ibd
984 FTS_AUX_DELETED_CACHE.ibd
985 db.opt
986 sys_foreign.frm
987 sys_foreign.ibd
988 sys_indexes.frm
989 sys_indexes.ibd
990 sys_tables.frm
991 sys_tables.ibd
992 t1c.frm
993 t1c.isl
994 t1n.frm
995 t1n.ibd
996 t1o.frm
997 t1o.ibd
998 t1p.frm
999 t1p.isl
1000 tt.frm
1001 tt.isl
1002 ### files in MYSQL_TMP_DIR/alt_dir/test
1003 FTS_AUX_INDEX_1.ibd
1004 FTS_AUX_INDEX_2.ibd
1005 FTS_AUX_INDEX_3.ibd
1006 FTS_AUX_INDEX_4.ibd
1007 FTS_AUX_INDEX_5.ibd
1008 FTS_AUX_INDEX_6.ibd
1009 FTS_AUX_BEING_DELETED.ibd
1010 FTS_AUX_BEING_DELETED_CACHE.ibd
1011 FTS_AUX_CONFIG.ibd
1012 FTS_AUX_DELETED.ibd
1013 FTS_AUX_DELETED_CACHE.ibd
1014 t1c.ibd
1015 t1p.ibd
1016 tt.ibd
1017 SHOW CREATE TABLE t1n;
1018 Table Create Table
1019 t1n CREATE TABLE `t1n` (
1020 `c2` int(11) NOT NULL,
1021 `ct` int(11) DEFAULT NULL,
1022 `c1` text DEFAULT NULL,
1023 PRIMARY KEY (`c2`),
1024 FULLTEXT KEY `ct` (`c1`)
1025 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1026 ALTER TABLE t1n CHANGE c2 c1 INT, CHANGE ct c2 INT, CHANGE c1 ct TEXT,
1027 ALGORITHM=COPY;
1028 ### files in MYSQL_DATA_DIR/test
1029 FTS_AUX_INDEX_1.isl
1030 FTS_AUX_INDEX_2.isl
1031 FTS_AUX_INDEX_3.isl
1032 FTS_AUX_INDEX_4.isl
1033 FTS_AUX_INDEX_5.isl
1034 FTS_AUX_INDEX_6.isl
1035 FTS_AUX_BEING_DELETED.isl
1036 FTS_AUX_BEING_DELETED_CACHE.isl
1037 FTS_AUX_CONFIG.isl
1038 FTS_AUX_DELETED.isl
1039 FTS_AUX_DELETED_CACHE.isl
1040 FTS_AUX_INDEX_1.ibd
1041 FTS_AUX_INDEX_2.ibd
1042 FTS_AUX_INDEX_3.ibd
1043 FTS_AUX_INDEX_4.ibd
1044 FTS_AUX_INDEX_5.ibd
1045 FTS_AUX_INDEX_6.ibd
1046 FTS_AUX_BEING_DELETED.ibd
1047 FTS_AUX_BEING_DELETED_CACHE.ibd
1048 FTS_AUX_CONFIG.ibd
1049 FTS_AUX_DELETED.ibd
1050 FTS_AUX_DELETED_CACHE.ibd
1051 db.opt
1052 sys_foreign.frm
1053 sys_foreign.ibd
1054 sys_indexes.frm
1055 sys_indexes.ibd
1056 sys_tables.frm
1057 sys_tables.ibd
1058 t1c.frm
1059 t1c.isl
1060 t1n.frm
1061 t1n.ibd
1062 t1o.frm
1063 t1o.ibd
1064 t1p.frm
1065 t1p.isl
1066 tt.frm
1067 tt.isl
1068 ### files in MYSQL_TMP_DIR/alt_dir/test
1069 FTS_AUX_INDEX_1.ibd
1070 FTS_AUX_INDEX_2.ibd
1071 FTS_AUX_INDEX_3.ibd
1072 FTS_AUX_INDEX_4.ibd
1073 FTS_AUX_INDEX_5.ibd
1074 FTS_AUX_INDEX_6.ibd
1075 FTS_AUX_BEING_DELETED.ibd
1076 FTS_AUX_BEING_DELETED_CACHE.ibd
1077 FTS_AUX_CONFIG.ibd
1078 FTS_AUX_DELETED.ibd
1079 FTS_AUX_DELETED_CACHE.ibd
1080 t1c.ibd
1081 t1p.ibd
1082 tt.ibd
1083 SHOW CREATE TABLE t1n;
1084 Table Create Table
1085 t1n CREATE TABLE `t1n` (
1086 `c1` int(11) NOT NULL,
1087 `c2` int(11) DEFAULT NULL,
1088 `ct` text DEFAULT NULL,
1089 PRIMARY KEY (`c1`),
1090 FULLTEXT KEY `ct` (`ct`)
1091 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1092 ALTER TABLE t1n ADD INDEX(c2), CHANGE c2 c4 INT, ALGORITHM=INPLACE;
1093 ERROR 42000: Key column 'c2' doesn't exist in table
1094 ALTER TABLE t1n ADD INDEX(c2), CHANGE c2 c4 INT, ALGORITHM=COPY;
1095 ERROR 42000: Key column 'c2' doesn't exist in table
1096 ALTER TABLE t1n ADD INDEX(c4), CHANGE c2 c4 INT, ALGORITHM=INPLACE;
1097 ### files in MYSQL_DATA_DIR/test
1098 FTS_AUX_INDEX_1.isl
1099 FTS_AUX_INDEX_2.isl
1100 FTS_AUX_INDEX_3.isl
1101 FTS_AUX_INDEX_4.isl
1102 FTS_AUX_INDEX_5.isl
1103 FTS_AUX_INDEX_6.isl
1104 FTS_AUX_BEING_DELETED.isl
1105 FTS_AUX_BEING_DELETED_CACHE.isl
1106 FTS_AUX_CONFIG.isl
1107 FTS_AUX_DELETED.isl
1108 FTS_AUX_DELETED_CACHE.isl
1109 FTS_AUX_INDEX_1.ibd
1110 FTS_AUX_INDEX_2.ibd
1111 FTS_AUX_INDEX_3.ibd
1112 FTS_AUX_INDEX_4.ibd
1113 FTS_AUX_INDEX_5.ibd
1114 FTS_AUX_INDEX_6.ibd
1115 FTS_AUX_BEING_DELETED.ibd
1116 FTS_AUX_BEING_DELETED_CACHE.ibd
1117 FTS_AUX_CONFIG.ibd
1118 FTS_AUX_DELETED.ibd
1119 FTS_AUX_DELETED_CACHE.ibd
1120 db.opt
1121 sys_foreign.frm
1122 sys_foreign.ibd
1123 sys_indexes.frm
1124 sys_indexes.ibd
1125 sys_tables.frm
1126 sys_tables.ibd
1127 t1c.frm
1128 t1c.isl
1129 t1n.frm
1130 t1n.ibd
1131 t1o.frm
1132 t1o.ibd
1133 t1p.frm
1134 t1p.isl
1135 tt.frm
1136 tt.isl
1137 ### files in MYSQL_TMP_DIR/alt_dir/test
1138 FTS_AUX_INDEX_1.ibd
1139 FTS_AUX_INDEX_2.ibd
1140 FTS_AUX_INDEX_3.ibd
1141 FTS_AUX_INDEX_4.ibd
1142 FTS_AUX_INDEX_5.ibd
1143 FTS_AUX_INDEX_6.ibd
1144 FTS_AUX_BEING_DELETED.ibd
1145 FTS_AUX_BEING_DELETED_CACHE.ibd
1146 FTS_AUX_CONFIG.ibd
1147 FTS_AUX_DELETED.ibd
1148 FTS_AUX_DELETED_CACHE.ibd
1149 t1c.ibd
1150 t1p.ibd
1151 tt.ibd
1152 SHOW CREATE TABLE t1n;
1153 Table Create Table
1154 t1n CREATE TABLE `t1n` (
1155 `c1` int(11) NOT NULL,
1156 `c4` int(11) DEFAULT NULL,
1157 `ct` text DEFAULT NULL,
1158 PRIMARY KEY (`c1`),
1159 KEY `c4` (`c4`),
1160 FULLTEXT KEY `ct` (`ct`)
1161 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1162 ALTER TABLE t1n DROP INDEX c4;
1163 ### files in MYSQL_DATA_DIR/test
1164 FTS_AUX_INDEX_1.isl
1165 FTS_AUX_INDEX_2.isl
1166 FTS_AUX_INDEX_3.isl
1167 FTS_AUX_INDEX_4.isl
1168 FTS_AUX_INDEX_5.isl
1169 FTS_AUX_INDEX_6.isl
1170 FTS_AUX_BEING_DELETED.isl
1171 FTS_AUX_BEING_DELETED_CACHE.isl
1172 FTS_AUX_CONFIG.isl
1173 FTS_AUX_DELETED.isl
1174 FTS_AUX_DELETED_CACHE.isl
1175 FTS_AUX_INDEX_1.ibd
1176 FTS_AUX_INDEX_2.ibd
1177 FTS_AUX_INDEX_3.ibd
1178 FTS_AUX_INDEX_4.ibd
1179 FTS_AUX_INDEX_5.ibd
1180 FTS_AUX_INDEX_6.ibd
1181 FTS_AUX_BEING_DELETED.ibd
1182 FTS_AUX_BEING_DELETED_CACHE.ibd
1183 FTS_AUX_CONFIG.ibd
1184 FTS_AUX_DELETED.ibd
1185 FTS_AUX_DELETED_CACHE.ibd
1186 db.opt
1187 sys_foreign.frm
1188 sys_foreign.ibd
1189 sys_indexes.frm
1190 sys_indexes.ibd
1191 sys_tables.frm
1192 sys_tables.ibd
1193 t1c.frm
1194 t1c.isl
1195 t1n.frm
1196 t1n.ibd
1197 t1o.frm
1198 t1o.ibd
1199 t1p.frm
1200 t1p.isl
1201 tt.frm
1202 tt.isl
1203 ### files in MYSQL_TMP_DIR/alt_dir/test
1204 FTS_AUX_INDEX_1.ibd
1205 FTS_AUX_INDEX_2.ibd
1206 FTS_AUX_INDEX_3.ibd
1207 FTS_AUX_INDEX_4.ibd
1208 FTS_AUX_INDEX_5.ibd
1209 FTS_AUX_INDEX_6.ibd
1210 FTS_AUX_BEING_DELETED.ibd
1211 FTS_AUX_BEING_DELETED_CACHE.ibd
1212 FTS_AUX_CONFIG.ibd
1213 FTS_AUX_DELETED.ibd
1214 FTS_AUX_DELETED_CACHE.ibd
1215 t1c.ibd
1216 t1p.ibd
1217 tt.ibd
1218 ALTER TABLE t1n CHANGE c4 c1 INT, ADD INDEX(c1), ALGORITHM=INPLACE;
1219 ERROR 42S21: Duplicate column name 'c1'
1220 ALTER TABLE t1n CHANGE c4 c11 INT, ADD INDEX(c11), ALGORITHM=INPLACE;
1221 ### files in MYSQL_DATA_DIR/test
1222 FTS_AUX_INDEX_1.isl
1223 FTS_AUX_INDEX_2.isl
1224 FTS_AUX_INDEX_3.isl
1225 FTS_AUX_INDEX_4.isl
1226 FTS_AUX_INDEX_5.isl
1227 FTS_AUX_INDEX_6.isl
1228 FTS_AUX_BEING_DELETED.isl
1229 FTS_AUX_BEING_DELETED_CACHE.isl
1230 FTS_AUX_CONFIG.isl
1231 FTS_AUX_DELETED.isl
1232 FTS_AUX_DELETED_CACHE.isl
1233 FTS_AUX_INDEX_1.ibd
1234 FTS_AUX_INDEX_2.ibd
1235 FTS_AUX_INDEX_3.ibd
1236 FTS_AUX_INDEX_4.ibd
1237 FTS_AUX_INDEX_5.ibd
1238 FTS_AUX_INDEX_6.ibd
1239 FTS_AUX_BEING_DELETED.ibd
1240 FTS_AUX_BEING_DELETED_CACHE.ibd
1241 FTS_AUX_CONFIG.ibd
1242 FTS_AUX_DELETED.ibd
1243 FTS_AUX_DELETED_CACHE.ibd
1244 db.opt
1245 sys_foreign.frm
1246 sys_foreign.ibd
1247 sys_indexes.frm
1248 sys_indexes.ibd
1249 sys_tables.frm
1250 sys_tables.ibd
1251 t1c.frm
1252 t1c.isl
1253 t1n.frm
1254 t1n.ibd
1255 t1o.frm
1256 t1o.ibd
1257 t1p.frm
1258 t1p.isl
1259 tt.frm
1260 tt.isl
1261 ### files in MYSQL_TMP_DIR/alt_dir/test
1262 FTS_AUX_INDEX_1.ibd
1263 FTS_AUX_INDEX_2.ibd
1264 FTS_AUX_INDEX_3.ibd
1265 FTS_AUX_INDEX_4.ibd
1266 FTS_AUX_INDEX_5.ibd
1267 FTS_AUX_INDEX_6.ibd
1268 FTS_AUX_BEING_DELETED.ibd
1269 FTS_AUX_BEING_DELETED_CACHE.ibd
1270 FTS_AUX_CONFIG.ibd
1271 FTS_AUX_DELETED.ibd
1272 FTS_AUX_DELETED_CACHE.ibd
1273 t1c.ibd
1274 t1p.ibd
1275 tt.ibd
1276 SHOW CREATE TABLE t1n;
1277 Table Create Table
1278 t1n CREATE TABLE `t1n` (
1279 `c1` int(11) NOT NULL,
1280 `c11` int(11) DEFAULT NULL,
1281 `ct` text DEFAULT NULL,
1282 PRIMARY KEY (`c1`),
1283 KEY `c11` (`c11`),
1284 FULLTEXT KEY `ct` (`ct`)
1285 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1286 DROP TABLE t1n;
1287 ALTER TABLE t1o MODIFY c1 BIGINT UNSIGNED NOT NULL;
1288 ### files in MYSQL_DATA_DIR/test
1289 FTS_AUX_INDEX_1.isl
1290 FTS_AUX_INDEX_2.isl
1291 FTS_AUX_INDEX_3.isl
1292 FTS_AUX_INDEX_4.isl
1293 FTS_AUX_INDEX_5.isl
1294 FTS_AUX_INDEX_6.isl
1295 FTS_AUX_BEING_DELETED.isl
1296 FTS_AUX_BEING_DELETED_CACHE.isl
1297 FTS_AUX_CONFIG.isl
1298 FTS_AUX_DELETED.isl
1299 FTS_AUX_DELETED_CACHE.isl
1300 db.opt
1301 sys_foreign.frm
1302 sys_foreign.ibd
1303 sys_indexes.frm
1304 sys_indexes.ibd
1305 sys_tables.frm
1306 sys_tables.ibd
1307 t1c.frm
1308 t1c.isl
1309 t1o.frm
1310 t1o.ibd
1311 t1p.frm
1312 t1p.isl
1313 tt.frm
1314 tt.isl
1315 ### files in MYSQL_TMP_DIR/alt_dir/test
1316 FTS_AUX_INDEX_1.ibd
1317 FTS_AUX_INDEX_2.ibd
1318 FTS_AUX_INDEX_3.ibd
1319 FTS_AUX_INDEX_4.ibd
1320 FTS_AUX_INDEX_5.ibd
1321 FTS_AUX_INDEX_6.ibd
1322 FTS_AUX_BEING_DELETED.ibd
1323 FTS_AUX_BEING_DELETED_CACHE.ibd
1324 FTS_AUX_CONFIG.ibd
1325 FTS_AUX_DELETED.ibd
1326 FTS_AUX_DELETED_CACHE.ibd
1327 t1c.ibd
1328 t1p.ibd
1329 tt.ibd
1330 ALTER TABLE t1o ADD FULLTEXT INDEX(ct),
1331 CHANGE c1 FTS_DOC_ID BIGINT UNSIGNED NOT NULL,
1332 ALGORITHM=INPLACE;
1333 ### files in MYSQL_DATA_DIR/test
1334 FTS_AUX_INDEX_1.isl
1335 FTS_AUX_INDEX_2.isl
1336 FTS_AUX_INDEX_3.isl
1337 FTS_AUX_INDEX_4.isl
1338 FTS_AUX_INDEX_5.isl
1339 FTS_AUX_INDEX_6.isl
1340 FTS_AUX_BEING_DELETED.isl
1341 FTS_AUX_BEING_DELETED_CACHE.isl
1342 FTS_AUX_CONFIG.isl
1343 FTS_AUX_DELETED.isl
1344 FTS_AUX_DELETED_CACHE.isl
1345 FTS_AUX_INDEX_1.ibd
1346 FTS_AUX_INDEX_2.ibd
1347 FTS_AUX_INDEX_3.ibd
1348 FTS_AUX_INDEX_4.ibd
1349 FTS_AUX_INDEX_5.ibd
1350 FTS_AUX_INDEX_6.ibd
1351 FTS_AUX_BEING_DELETED.ibd
1352 FTS_AUX_BEING_DELETED_CACHE.ibd
1353 FTS_AUX_CONFIG.ibd
1354 FTS_AUX_DELETED.ibd
1355 FTS_AUX_DELETED_CACHE.ibd
1356 db.opt
1357 sys_foreign.frm
1358 sys_foreign.ibd
1359 sys_indexes.frm
1360 sys_indexes.ibd
1361 sys_tables.frm
1362 sys_tables.ibd
1363 t1c.frm
1364 t1c.isl
1365 t1o.frm
1366 t1o.ibd
1367 t1p.frm
1368 t1p.isl
1369 tt.frm
1370 tt.isl
1371 ### files in MYSQL_TMP_DIR/alt_dir/test
1372 FTS_AUX_INDEX_1.ibd
1373 FTS_AUX_INDEX_2.ibd
1374 FTS_AUX_INDEX_3.ibd
1375 FTS_AUX_INDEX_4.ibd
1376 FTS_AUX_INDEX_5.ibd
1377 FTS_AUX_INDEX_6.ibd
1378 FTS_AUX_BEING_DELETED.ibd
1379 FTS_AUX_BEING_DELETED_CACHE.ibd
1380 FTS_AUX_CONFIG.ibd
1381 FTS_AUX_DELETED.ibd
1382 FTS_AUX_DELETED_CACHE.ibd
1383 t1c.ibd
1384 t1p.ibd
1385 tt.ibd
1386 ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL,
1387 ALGORITHM=INPLACE, LOCK=NONE;
1388 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Cannot drop or rename FTS_DOC_ID. Try ALGORITHM=COPY
1389 SELECT sc.pos FROM information_schema.innodb_sys_columns sc
1390 INNER JOIN information_schema.innodb_sys_tables st
1391 ON sc.TABLE_ID=st.TABLE_ID
1392 WHERE st.NAME='test/t1o' AND sc.NAME='FTS_DOC_ID';
1393 pos
1394 0
1395 SHOW CREATE TABLE t1o;
1396 Table Create Table
1397 t1o CREATE TABLE `t1o` (
1398 `FTS_DOC_ID` bigint(20) unsigned NOT NULL,
1399 `c2` int(11) DEFAULT NULL,
1400 `ct` text DEFAULT NULL,
1401 PRIMARY KEY (`FTS_DOC_ID`),
1402 FULLTEXT KEY `ct` (`ct`)
1403 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1404 ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL,
1405 DROP INDEX ct, LOCK=NONE;
1406 ### files in MYSQL_DATA_DIR/test
1407 FTS_AUX_INDEX_1.isl
1408 FTS_AUX_INDEX_2.isl
1409 FTS_AUX_INDEX_3.isl
1410 FTS_AUX_INDEX_4.isl
1411 FTS_AUX_INDEX_5.isl
1412 FTS_AUX_INDEX_6.isl
1413 FTS_AUX_BEING_DELETED.isl
1414 FTS_AUX_BEING_DELETED_CACHE.isl
1415 FTS_AUX_CONFIG.isl
1416 FTS_AUX_DELETED.isl
1417 FTS_AUX_DELETED_CACHE.isl
1418 db.opt
1419 sys_foreign.frm
1420 sys_foreign.ibd
1421 sys_indexes.frm
1422 sys_indexes.ibd
1423 sys_tables.frm
1424 sys_tables.ibd
1425 t1c.frm
1426 t1c.isl
1427 t1o.frm
1428 t1o.ibd
1429 t1p.frm
1430 t1p.isl
1431 tt.frm
1432 tt.isl
1433 ### files in MYSQL_TMP_DIR/alt_dir/test
1434 FTS_AUX_INDEX_1.ibd
1435 FTS_AUX_INDEX_2.ibd
1436 FTS_AUX_INDEX_3.ibd
1437 FTS_AUX_INDEX_4.ibd
1438 FTS_AUX_INDEX_5.ibd
1439 FTS_AUX_INDEX_6.ibd
1440 FTS_AUX_BEING_DELETED.ibd
1441 FTS_AUX_BEING_DELETED_CACHE.ibd
1442 FTS_AUX_CONFIG.ibd
1443 FTS_AUX_DELETED.ibd
1444 FTS_AUX_DELETED_CACHE.ibd
1445 t1c.ibd
1446 t1p.ibd
1447 tt.ibd
1448 SHOW CREATE TABLE t1o;
1449 Table Create Table
1450 t1o CREATE TABLE `t1o` (
1451 `foo_id` bigint(20) unsigned NOT NULL,
1452 `c2` int(11) DEFAULT NULL,
1453 `ct` text DEFAULT NULL,
1454 PRIMARY KEY (`foo_id`)
1455 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
1456 DROP TABLE t1c, t1p, sys_tables, sys_indexes, sys_foreign;
1457 CREATE TABLE sys_tables SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES
1458 WHERE NAME='test/t1o';
1459 CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES i
1460 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
1461 CREATE TABLE sys_foreign SELECT i.*
1462 FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN i WHERE FOR_NAME='test/t1o';
1463 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
1464 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
1465 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
1466 NAME POS MTYPE PRTYPE LEN
1467 foo_id 0 6 1800 8
1468 c2 1 6 1027 4
1469 ct 2 5 524540 10
1470 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
1471 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
1472 NAME POS NAME
1473 PRIMARY 0 foo_id
1474 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
1475 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
1476 ID FOR_COL_NAME REF_COL_NAME POS
1477 ALTER TABLE t1o ADD UNIQUE INDEX FTS_DOC_ID_INDEX(foo_id);
1478 ### files in MYSQL_DATA_DIR/test
1479 FTS_AUX_INDEX_1.isl
1480 FTS_AUX_INDEX_2.isl
1481 FTS_AUX_INDEX_3.isl
1482 FTS_AUX_INDEX_4.isl
1483 FTS_AUX_INDEX_5.isl
1484 FTS_AUX_INDEX_6.isl
1485 FTS_AUX_BEING_DELETED.isl
1486 FTS_AUX_BEING_DELETED_CACHE.isl
1487 FTS_AUX_CONFIG.isl
1488 FTS_AUX_DELETED.isl
1489 FTS_AUX_DELETED_CACHE.isl
1490 db.opt
1491 sys_foreign.frm
1492 sys_foreign.ibd
1493 sys_indexes.frm
1494 sys_indexes.ibd
1495 sys_tables.frm
1496 sys_tables.ibd
1497 t1o.frm
1498 t1o.ibd
1499 tt.frm
1500 tt.isl
1501 ### files in MYSQL_TMP_DIR/alt_dir/test
1502 FTS_AUX_INDEX_1.ibd
1503 FTS_AUX_INDEX_2.ibd
1504 FTS_AUX_INDEX_3.ibd
1505 FTS_AUX_INDEX_4.ibd
1506 FTS_AUX_INDEX_5.ibd
1507 FTS_AUX_INDEX_6.ibd
1508 FTS_AUX_BEING_DELETED.ibd
1509 FTS_AUX_BEING_DELETED_CACHE.ibd
1510 FTS_AUX_CONFIG.ibd
1511 FTS_AUX_DELETED.ibd
1512 FTS_AUX_DELETED_CACHE.ibd
1513 tt.ibd
1514 ALTER TABLE t1o CHANGE foo_id FTS_DOC_ID BIGINT UNSIGNED NOT NULL,
1515 ADD FULLTEXT INDEX(ct);
1516 ### files in MYSQL_DATA_DIR/test
1517 FTS_AUX_INDEX_1.isl
1518 FTS_AUX_INDEX_2.isl
1519 FTS_AUX_INDEX_3.isl
1520 FTS_AUX_INDEX_4.isl
1521 FTS_AUX_INDEX_5.isl
1522 FTS_AUX_INDEX_6.isl
1523 FTS_AUX_BEING_DELETED.isl
1524 FTS_AUX_BEING_DELETED_CACHE.isl
1525 FTS_AUX_CONFIG.isl
1526 FTS_AUX_DELETED.isl
1527 FTS_AUX_DELETED_CACHE.isl
1528 FTS_AUX_INDEX_1.ibd
1529 FTS_AUX_INDEX_2.ibd
1530 FTS_AUX_INDEX_3.ibd
1531 FTS_AUX_INDEX_4.ibd
1532 FTS_AUX_INDEX_5.ibd
1533 FTS_AUX_INDEX_6.ibd
1534 FTS_AUX_BEING_DELETED.ibd
1535 FTS_AUX_BEING_DELETED_CACHE.ibd
1536 FTS_AUX_CONFIG.ibd
1537 FTS_AUX_DELETED.ibd
1538 FTS_AUX_DELETED_CACHE.ibd
1539 db.opt
1540 sys_foreign.frm
1541 sys_foreign.ibd
1542 sys_indexes.frm
1543 sys_indexes.ibd
1544 sys_tables.frm
1545 sys_tables.ibd
1546 t1o.frm
1547 t1o.ibd
1548 tt.frm
1549 tt.isl
1550 ### files in MYSQL_TMP_DIR/alt_dir/test
1551 FTS_AUX_INDEX_1.ibd
1552 FTS_AUX_INDEX_2.ibd
1553 FTS_AUX_INDEX_3.ibd
1554 FTS_AUX_INDEX_4.ibd
1555 FTS_AUX_INDEX_5.ibd
1556 FTS_AUX_INDEX_6.ibd
1557 FTS_AUX_BEING_DELETED.ibd
1558 FTS_AUX_BEING_DELETED_CACHE.ibd
1559 FTS_AUX_CONFIG.ibd
1560 FTS_AUX_DELETED.ibd
1561 FTS_AUX_DELETED_CACHE.ibd
1562 tt.ibd
1563 ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL;
1564 ERROR HY000: Index 'FTS_DOC_ID_INDEX' is of wrong type for an InnoDB FULLTEXT index
1565 DROP TABLE sys_indexes;
1566 CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES i
1567 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
1568 SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN
1569 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i
1570 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
1571 NAME POS MTYPE PRTYPE LEN
1572 FTS_DOC_ID 0 6 1800 8
1573 c2 1 6 1027 4
1574 ct 2 5 524540 10
1575 SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i
1576 INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID;
1577 NAME POS NAME
1578 PRIMARY 0 FTS_DOC_ID
1579 FTS_DOC_ID_INDEX 0 FTS_DOC_ID
1580 ct 0 ct
1581 SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i
1582 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
1583 ID FOR_COL_NAME REF_COL_NAME POS
1584 #
1585 # Cleanup
1586 #
1587 DROP TABLE tt, t1o, sys_tables, sys_indexes, sys_foreign;
1588 ### files in MYSQL_DATA_DIR/test
1589 db.opt
1590 ### files in MYSQL_TMP_DIR/alt_dir/test
1591 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;