Debian Codegraph @

mysql-test/suite/innodb/t/choose_tbsp_location-alter.test

raw
1 --echo #
2 --echo # This is a copy of innodb-alter.test except using remote tablespaces
3 --echo # and showing those files.
4 --echo #
5
6 --disable_query_log
7 # This can change during the test
8 LET $innodb_file_per_table_orig=`select @@innodb_file_per_table`;
9
10 # Use this coversion to make the result file consistent. This string gets printed
11 # in the result file in numerous places. Since ".ibd" is one of the patterns that
12 # makes a whitespace delimited word recognized as a path, the '\' characters will
13 # get converted to '/' in the result file on Windows, but not on Unix.
14 # So just look for ".i".
15 LET $regexp=/fts_([0-9a-f_]+)([A-Z0-9_]+)/fts_aux\2/;
16
17 # Set up some variables
18 LET $MYSQL_DATA_DIR = `select @@datadir`;
19 LET $data_directory_clause = DATA DIRECTORY='$MYSQL_TMP_DIR/alt_dir';
20 --enable_query_log
21
22 SET default_storage_engine=InnoDB;
23 SET GLOBAL innodb_file_per_table=ON;
24
25 SET NAMES utf8;
26
27 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
28 eval CREATE TABLE t1 (
29 c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT,
30 INDEX(c2))
31 ENGINE=InnoDB $data_directory_clause;
32
33 INSERT INTO t1 SET c1=1;
34
35 CREATE TABLE sys_tables SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES
36 WHERE NAME LIKE 'test/t%';
37 CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_INDEXES i
38 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
39
40 CREATE TABLE t1p LIKE t1;
41
42 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
43 eval CREATE TABLE t1c (c1 INT PRIMARY KEY, c2 INT, c3 INT, INDEX(c2), INDEX(c3),
44 CONSTRAINT t1c2 FOREIGN KEY (c2) REFERENCES t1(c2),
45 CONSTRAINT t1c3 FOREIGN KEY (c3) REFERENCES t1p(c2))
46 ENGINE=InnoDB $data_directory_clause;
47
48 CREATE TABLE sys_foreign SELECT i.*
49 FROM INFORMATION_SCHEMA.INNODB_FOREIGN i
50 WHERE FOR_NAME LIKE 'test/t%';
51
52 --sorted_result
53 SELECT i.FOR_COL_NAME, i.REF_COL_NAME, i.POS FROM INFORMATION_SCHEMA.INNODB_FOREIGN_COLS i
54 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
55
56 -- source suite/innodb/include/innodb_dict.inc
57
58 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
59 SHOW CREATE TABLE t1;
60 ALTER TABLE t1 ALTER c2 DROP DEFAULT;
61 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
62 SHOW CREATE TABLE t1;
63
64 --echo ### files in MYSQL_DATA_DIR/test
65 --replace_regex $regexp
66 --list_files $MYSQL_DATA_DIR/test
67 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
68 --replace_regex $regexp
69 --list_files $MYSQL_TMP_DIR/alt_dir/test
70
71 -- source suite/innodb/include/innodb_dict.inc
72
73 # These should be no-op.
74 ALTER TABLE t1 CHANGE c2 c2 INT AFTER c1;
75 ALTER TABLE t1 CHANGE c1 c1 INT FIRST;
76
77 --echo ### files in MYSQL_DATA_DIR/test
78 --replace_regex $regexp
79 --list_files $MYSQL_DATA_DIR/test
80 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
81 --replace_regex $regexp
82 --list_files $MYSQL_TMP_DIR/alt_dir/test
83
84 -- source suite/innodb/include/innodb_dict.inc
85
86 ALTER TABLE t1 CHANGE C2 c3 INT;
87
88 --echo ### files in MYSQL_DATA_DIR/test
89 --replace_regex $regexp
90 --list_files $MYSQL_DATA_DIR/test
91 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
92 --replace_regex $regexp
93 --list_files $MYSQL_TMP_DIR/alt_dir/test
94
95 -- source suite/innodb/include/innodb_dict.inc
96
97 ALTER TABLE t1 CHANGE c3 C INT;
98
99 --echo ### files in MYSQL_DATA_DIR/test
100 --replace_regex $regexp
101 --list_files $MYSQL_DATA_DIR/test
102 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
103 --replace_regex $regexp
104 --list_files $MYSQL_TMP_DIR/alt_dir/test
105
106 -- source suite/innodb/include/innodb_dict.inc
107
108 ALTER TABLE t1 CHANGE C Cöŀumň_TWO INT;
109
110 --echo ### files in MYSQL_DATA_DIR/test
111 --replace_regex $regexp
112 --list_files $MYSQL_DATA_DIR/test
113 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
114 --replace_regex $regexp
115 --list_files $MYSQL_TMP_DIR/alt_dir/test
116
117 --sorted_result
118 SELECT i.FOR_COL_NAME, i.REF_COL_NAME, i.POS FROM INFORMATION_SCHEMA.INNODB_FOREIGN_COLS i
119 INNER JOIN sys_foreign sf ON i.ID = sf.ID;
120
121 -- source suite/innodb/include/innodb_dict.inc
122
123 -- error ER_BAD_FIELD_ERROR
124 ALTER TABLE t1 CHANGE cöĿǖmň_two c3 INT;
125
126 ALTER TABLE t1 CHANGE cÖĿUMŇ_two c3 INT, RENAME TO t3;
127
128 --echo ### files in MYSQL_DATA_DIR/test
129 --replace_regex $regexp
130 --list_files $MYSQL_DATA_DIR/test
131 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
132 --replace_regex $regexp
133 --list_files $MYSQL_TMP_DIR/alt_dir/test
134
135 SELECT st.NAME, i.NAME
136 FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_TABLES i
137 ON i.TABLE_ID=st.TABLE_ID;
138
139 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
140 SHOW CREATE TABLE t3;
141 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
142 SHOW CREATE TABLE t1c;
143
144 # The maximum column name length should be 64 characters.
145 --error ER_TOO_LONG_IDENT
146 ALTER TABLE t3 CHANGE c3
147 `12345678901234567890123456789012345678901234567890123456789012345` INT;
148 ALTER TABLE t3 CHANGE c3
149 `1234567890123456789012345678901234567890123456789012345678901234` INT;
150
151 --echo ### files in MYSQL_DATA_DIR/test
152 --replace_regex $regexp
153 --list_files $MYSQL_DATA_DIR/test
154 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
155 --replace_regex $regexp
156 --list_files $MYSQL_TMP_DIR/alt_dir/test
157
158 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
159 SHOW CREATE TABLE t3;
160
161 # Test the length limit with non-ASCII utf-8 characters.
162 --error ER_TOO_LONG_IDENT
163 ALTER TABLE t3 CHANGE
164 `1234567890123456789012345678901234567890123456789012345678901234`
165 `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾倿偀` INT;
166
167 --error ER_TOO_LONG_IDENT
168 ALTER TABLE t3 CHANGE
169 `1234567890123456789012345678901234567890123456789012345678901234`
170 `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾倿ä` INT;
171
172 ALTER TABLE t3 CHANGE
173 `1234567890123456789012345678901234567890123456789012345678901234`
174 `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾ä` INT;
175
176 --echo ### files in MYSQL_DATA_DIR/test
177 --replace_regex $regexp
178 --list_files $MYSQL_DATA_DIR/test
179 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
180 --replace_regex $regexp
181 --list_files $MYSQL_TMP_DIR/alt_dir/test
182
183 # check that the rename is case-insensitive (note the upper-case ä at end)
184 ALTER TABLE t3 CHANGE
185 `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾Ä`
186 c3 INT;
187
188 --echo ### files in MYSQL_DATA_DIR/test
189 --replace_regex $regexp
190 --list_files $MYSQL_DATA_DIR/test
191 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
192 --replace_regex $regexp
193 --list_files $MYSQL_TMP_DIR/alt_dir/test
194
195 # test with 4-byte UTF-8 (should be disallowed)
196 --error ER_INVALID_CHARACTER_STRING
197 ALTER TABLE t3 CHANGE c3 𐌀𐌁𐌂𐌃𐌄𐌅𐌆𐌇𐌈𐌉𐌊𐌋𐌌𐌍𐌎𐌏𐌐𐌑𐌒𐌓𐌔𐌕𐌖𐌗𐌘𐌙𐌚𐌛𐌜 INT;
198
199 --error ER_INVALID_CHARACTER_STRING
200 ALTER TABLE t3 CHANGE c3 😲 INT;
201
202 ALTER TABLE t3 RENAME TO t2;
203
204 --echo ### files in MYSQL_DATA_DIR/test
205 --replace_regex $regexp
206 --list_files $MYSQL_DATA_DIR/test
207 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
208 --replace_regex $regexp
209 --list_files $MYSQL_TMP_DIR/alt_dir/test
210
211 SELECT st.NAME, i.NAME
212 FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_TABLES i
213 ON i.TABLE_ID=st.TABLE_ID;
214
215 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
216 SHOW CREATE TABLE t2;
217
218 RENAME TABLE t2 TO t1;
219
220 SELECT st.NAME, i.NAME
221 FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_TABLES i
222 ON i.TABLE_ID=st.TABLE_ID;
223
224 --echo ### files in MYSQL_DATA_DIR/test
225 --replace_regex $regexp
226 --list_files $MYSQL_DATA_DIR/test
227 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
228 --replace_regex $regexp
229 --list_files $MYSQL_TMP_DIR/alt_dir/test
230
231 -- source suite/innodb/include/innodb_dict.inc
232
233 --error ER_DROP_INDEX_FK
234 ALTER TABLE t1 DROP INDEX c2;
235
236 --error ER_CANT_DROP_FIELD_OR_KEY
237 ALTER TABLE t1 DROP INDEX c4;
238
239 --error ER_CANT_DROP_FIELD_OR_KEY
240 ALTER TABLE t1c DROP FOREIGN KEY c2;
241
242 --error ER_CANT_DROP_FIELD_OR_KEY
243 ALTER TABLE t1c DROP FOREIGN KEY t1c2, DROP FOREIGN KEY c2;
244
245 --error ER_CANT_DROP_FIELD_OR_KEY
246 ALTER TABLE t1c DROP FOREIGN KEY t1c2, DROP FOREIGN KEY c2, DROP INDEX c2;
247
248 --error ER_DROP_INDEX_FK
249 ALTER TABLE t1c DROP INDEX c2;
250
251 --error ER_CANT_DROP_FIELD_OR_KEY
252 ALTER TABLE t1c DROP FOREIGN KEY ẗ1C2;
253
254 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
255 SHOW CREATE TABLE t1c;
256
257 SET foreign_key_checks=0;
258 DROP TABLE t1p;
259 SET foreign_key_checks=1;
260
261 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
262 SHOW CREATE TABLE t1c;
263
264 --echo ### files in MYSQL_DATA_DIR/test
265 --replace_regex $regexp
266 --list_files $MYSQL_DATA_DIR/test
267 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
268 --replace_regex $regexp
269 --list_files $MYSQL_TMP_DIR/alt_dir/test
270
271 -- source suite/innodb/include/innodb_dict.inc
272
273 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
274 eval CREATE TABLE t1p (c1 INT PRIMARY KEY, c2 INT, INDEX(c2))
275 ENGINE=InnoDB $data_directory_clause;
276
277 --error ER_DROP_INDEX_FK
278 ALTER TABLE t1c DROP INDEX C2, DROP INDEX C3;
279 --error ER_DROP_INDEX_FK
280 ALTER TABLE t1c DROP INDEX C3;
281
282 SET foreign_key_checks=0;
283 --error ER_DROP_INDEX_FK
284 ALTER TABLE t1c DROP INDEX C3;
285
286 --echo ### files in MYSQL_DATA_DIR/test
287 --replace_regex $regexp
288 --list_files $MYSQL_DATA_DIR/test
289 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
290 --replace_regex $regexp
291 --list_files $MYSQL_TMP_DIR/alt_dir/test
292
293 SET foreign_key_checks=1;
294
295 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
296 SHOW CREATE TABLE t1c;
297
298 -- source suite/innodb/include/innodb_dict.inc
299
300 ALTER TABLE t1c DROP FOREIGN KEY t1C3;
301
302 --echo ### files in MYSQL_DATA_DIR/test
303 --list_files $MYSQL_DATA_DIR/test
304 --replace_regex $regexp
305 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
306 --replace_regex $regexp
307 --list_files $MYSQL_TMP_DIR/alt_dir/test
308
309 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
310 SHOW CREATE TABLE t1c;
311 -- source suite/innodb/include/innodb_dict.inc
312
313 ALTER TABLE t1c DROP INDEX c2, DROP FOREIGN KEY t1C2;
314
315 --echo ### files in MYSQL_DATA_DIR/test
316 --replace_regex $regexp
317 --list_files $MYSQL_DATA_DIR/test
318 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
319 --replace_regex $regexp
320 --list_files $MYSQL_TMP_DIR/alt_dir/test
321
322 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
323 SHOW CREATE TABLE t1c;
324
325 -- source suite/innodb/include/innodb_dict.inc
326
327 ALTER TABLE t1 DROP INDEX c2, CHANGE c3 c2 INT;
328
329 --echo ### files in MYSQL_DATA_DIR/test
330 --replace_regex $regexp
331 --list_files $MYSQL_DATA_DIR/test
332 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
333 --replace_regex $regexp
334 --list_files $MYSQL_TMP_DIR/alt_dir/test
335
336 -- source suite/innodb/include/innodb_dict.inc
337
338 CREATE TABLE t1o LIKE t1;
339
340 # This will implicitly add a DOC_ID column.
341 # The LOCK=NONE should thus fail.
342 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
343 ALTER TABLE t1 ADD FULLTEXT INDEX (ct),
344 CHANGE c1 pk INT, ALTER c2 SET DEFAULT 42, RENAME TO tt,
345 ALGORITHM=INPLACE, LOCK=NONE;
346
347 # Retry with LOCK=EXCLUSIVE.
348 ALTER TABLE t1 ADD FULLTEXT INDEX (ct),
349 CHANGE c1 pk INT, ALTER c2 SET DEFAULT 42, RENAME TO tt,
350 ALGORITHM=INPLACE, LOCK=SHARED;
351
352 --echo ### files in MYSQL_DATA_DIR/test
353 --replace_regex $regexp
354 --list_files $MYSQL_DATA_DIR/test
355 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
356 --replace_regex $regexp
357 --list_files $MYSQL_TMP_DIR/alt_dir/test
358
359 # The output should be empty, because index->id was reassigned.
360 -- source suite/innodb/include/innodb_dict.inc
361
362 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
363 SHOW CREATE TABLE tt;
364
365 # DB_ROW_ID, DB_TRX_ID, DB_ROLL_PTR are reserved InnoDB system column names.
366 --error ER_WRONG_COLUMN_NAME
367 ALTER TABLE t1o CHANGE c1 dB_row_Id INT, ALGORITHM=COPY;
368 --error ER_WRONG_COLUMN_NAME
369 ALTER TABLE t1o CHANGE c1 dB_row_Id INT, ALGORITHM=INPLACE;
370 --error ER_WRONG_COLUMN_NAME
371 ALTER TABLE t1o CHANGE c1 DB_TRX_ID INT;
372 --error ER_WRONG_COLUMN_NAME
373 ALTER TABLE t1o CHANGE c1 db_roll_ptr INT;
374
375 # FTS_DOC_ID is the internal row identifier for full-text search.
376 # It should be of type BIGINT UNSIGNED NOT NULL.
377 --error ER_INNODB_FT_WRONG_DOCID_COLUMN
378 ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_DOC_ID INT,
379 ALGORITHM=COPY;
380
381 --error ER_INNODB_FT_WRONG_DOCID_COLUMN
382 ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_DOC_ID INT,
383 ALGORITHM=INPLACE;
384 --error ER_INNODB_FT_WRONG_DOCID_COLUMN
385 ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_Doc_ID INT,
386 ALGORITHM=INPLACE;
387 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
388 ALTER TABLE t1o ADD FULLTEXT INDEX(ct),
389 CHANGE c1 FTS_DOC_ID BIGINT UNSIGNED NOT NULL,
390 ALGORITHM=INPLACE;
391
392 CREATE TABLE t1n LIKE t1o;
393
394 ALTER TABLE t1n ADD FULLTEXT INDEX(ct);
395
396 --echo ### files in MYSQL_DATA_DIR/test
397 --replace_regex $regexp
398 --list_files $MYSQL_DATA_DIR/test
399 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
400 --replace_regex $regexp
401 --list_files $MYSQL_TMP_DIR/alt_dir/test
402
403 --error ER_INNODB_FT_WRONG_DOCID_COLUMN
404 ALTER TABLE t1n CHANGE c1 Fts_DOC_ID INT, ALGORITHM=INPLACE;
405 --error ER_INNODB_FT_WRONG_DOCID_COLUMN
406 ALTER TABLE t1n CHANGE c1 Fts_DOC_ID INT, ALGORITHM=COPY;
407 --error ER_BAD_FIELD_ERROR
408 ALTER TABLE t1n CHANGE FTS_DOC_ID c11 INT, ALGORITHM=INPLACE;
409 ALTER TABLE t1n CHANGE c1 FTS_DOC_ïD INT, ALGORITHM=INPLACE;
410
411 --echo ### files in MYSQL_DATA_DIR/test
412 --replace_regex $regexp
413 --list_files $MYSQL_DATA_DIR/test
414 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
415 --replace_regex $regexp
416 --list_files $MYSQL_TMP_DIR/alt_dir/test
417
418 ALTER TABLE t1n CHANGE FTS_DOC_ÏD c1 INT, ALGORITHM=INPLACE;
419
420 --echo ### files in MYSQL_DATA_DIR/test
421 --replace_regex $regexp
422 --list_files $MYSQL_DATA_DIR/test
423 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
424 --replace_regex $regexp
425 --list_files $MYSQL_TMP_DIR/alt_dir/test
426
427 ALTER TABLE t1n CHANGE c1 c2 INT, CHANGE c2 ct INT, CHANGE ct c1 TEXT,
428 ALGORITHM=INPLACE;
429
430 --echo ### files in MYSQL_DATA_DIR/test
431 --replace_regex $regexp
432 --list_files $MYSQL_DATA_DIR/test
433 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
434 --replace_regex $regexp
435 --list_files $MYSQL_TMP_DIR/alt_dir/test
436
437 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
438 SHOW CREATE TABLE t1n;
439 ALTER TABLE t1n CHANGE c2 c1 INT, CHANGE ct c2 INT, CHANGE c1 ct TEXT,
440 ALGORITHM=COPY;
441
442 --echo ### files in MYSQL_DATA_DIR/test
443 --replace_regex $regexp
444 --list_files $MYSQL_DATA_DIR/test
445 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
446 --replace_regex $regexp
447 --list_files $MYSQL_TMP_DIR/alt_dir/test
448
449 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
450 SHOW CREATE TABLE t1n;
451
452 --error ER_KEY_COLUMN_DOES_NOT_EXITS
453 ALTER TABLE t1n ADD INDEX(c2), CHANGE c2 c4 INT, ALGORITHM=INPLACE;
454 --error ER_KEY_COLUMN_DOES_NOT_EXITS
455 ALTER TABLE t1n ADD INDEX(c2), CHANGE c2 c4 INT, ALGORITHM=COPY;
456
457 ALTER TABLE t1n ADD INDEX(c4), CHANGE c2 c4 INT, ALGORITHM=INPLACE;
458
459 --echo ### files in MYSQL_DATA_DIR/test
460 --replace_regex $regexp
461 --list_files $MYSQL_DATA_DIR/test
462 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
463 --replace_regex $regexp
464 --list_files $MYSQL_TMP_DIR/alt_dir/test
465
466 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
467 SHOW CREATE TABLE t1n;
468 ALTER TABLE t1n DROP INDEX c4;
469
470 --echo ### files in MYSQL_DATA_DIR/test
471 --replace_regex $regexp
472 --list_files $MYSQL_DATA_DIR/test
473 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
474 --replace_regex $regexp
475 --list_files $MYSQL_TMP_DIR/alt_dir/test
476
477 --error ER_DUP_FIELDNAME
478 ALTER TABLE t1n CHANGE c4 c1 INT, ADD INDEX(c1), ALGORITHM=INPLACE;
479 ALTER TABLE t1n CHANGE c4 c11 INT, ADD INDEX(c11), ALGORITHM=INPLACE;
480
481 --echo ### files in MYSQL_DATA_DIR/test
482 --replace_regex $regexp
483 --list_files $MYSQL_DATA_DIR/test
484 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
485 --replace_regex $regexp
486 --list_files $MYSQL_TMP_DIR/alt_dir/test
487
488 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
489 SHOW CREATE TABLE t1n;
490 DROP TABLE t1n;
491
492 ALTER TABLE t1o MODIFY c1 BIGINT UNSIGNED NOT NULL;
493
494 --echo ### files in MYSQL_DATA_DIR/test
495 --replace_regex $regexp
496 --list_files $MYSQL_DATA_DIR/test
497 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
498 --replace_regex $regexp
499 --list_files $MYSQL_TMP_DIR/alt_dir/test
500
501 ALTER TABLE t1o ADD FULLTEXT INDEX(ct),
502 CHANGE c1 FTS_DOC_ID BIGINT UNSIGNED NOT NULL,
503 ALGORITHM=INPLACE;
504
505 --echo ### files in MYSQL_DATA_DIR/test
506 --replace_regex $regexp
507 --list_files $MYSQL_DATA_DIR/test
508 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
509 --replace_regex $regexp
510 --list_files $MYSQL_TMP_DIR/alt_dir/test
511
512 # This would create a hidden FTS_DOC_ID column, which cannot be done online.
513 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
514 ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL,
515 LOCK=NONE;
516
517 # This should not show duplicates.
518 SELECT sc.pos FROM information_schema.innodb_columns sc
519 INNER JOIN information_schema.innodb_tables st
520 ON sc.TABLE_ID=st.TABLE_ID
521 WHERE st.NAME='test/t1o' AND sc.NAME='FTS_DOC_ID';
522
523 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
524 SHOW CREATE TABLE t1o;
525
526 ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL,
527 DROP INDEX ct, LOCK=NONE;
528
529 --echo ### files in MYSQL_DATA_DIR/test
530 --replace_regex $regexp
531 --list_files $MYSQL_DATA_DIR/test
532 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
533 --replace_regex $regexp
534 --list_files $MYSQL_TMP_DIR/alt_dir/test
535
536 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
537 SHOW CREATE TABLE t1o;
538
539 DROP TABLE t1c, t1p, sys_tables, sys_indexes, sys_foreign;
540
541 # Check the internal schemata of tt, t1o.
542
543 CREATE TABLE sys_tables SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES
544 WHERE NAME='test/t1o';
545 CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_INDEXES i
546 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
547 CREATE TABLE sys_foreign SELECT i.*
548 FROM INFORMATION_SCHEMA.INNODB_FOREIGN i WHERE FOR_NAME='test/t1o';
549
550 -- source suite/innodb/include/innodb_dict.inc
551
552 # Ensure that there exists no hidden FTS_DOC_ID_INDEX on foo_id.
553
554 ALTER TABLE t1o ADD UNIQUE INDEX FTS_DOC_ID_INDEX(foo_id);
555
556 --echo ### files in MYSQL_DATA_DIR/test
557 --replace_regex $regexp
558 --list_files $MYSQL_DATA_DIR/test
559 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
560 --replace_regex $regexp
561 --list_files $MYSQL_TMP_DIR/alt_dir/test
562
563 ALTER TABLE t1o CHANGE foo_id FTS_DOC_ID BIGINT UNSIGNED NOT NULL,
564 ADD FULLTEXT INDEX(ct);
565
566 --echo ### files in MYSQL_DATA_DIR/test
567 --replace_regex $regexp
568 --list_files $MYSQL_DATA_DIR/test
569 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
570 --replace_regex $regexp
571 --list_files $MYSQL_TMP_DIR/alt_dir/test
572
573 --error ER_INNODB_FT_WRONG_DOCID_INDEX
574 ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL;
575
576 DROP TABLE sys_indexes;
577 CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_INDEXES i
578 INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID;
579
580 -- source suite/innodb/include/innodb_dict.inc
581
582 --echo #
583 --echo # Cleanup
584 --echo #
585
586 DROP TABLE tt, t1o, sys_tables, sys_indexes, sys_foreign;
587
588 --echo ### files in MYSQL_DATA_DIR/test
589 --replace_regex $regexp
590 --list_files $MYSQL_DATA_DIR/test
591 --echo ### files in MYSQL_TMP_DIR/alt_dir/test
592 --replace_regex $regexp
593 --list_files $MYSQL_TMP_DIR/alt_dir/test
594 --rmdir $MYSQL_TMP_DIR/alt_dir/test
595 --rmdir $MYSQL_TMP_DIR/alt_dir
596
597 -- disable_query_log
598 eval set global innodb_file_per_table=$innodb_file_per_table_orig;
599 call mtr.add_suppression("deleting orphaned .ibd file");
600 -- enable_query_log