Debian Codegraph @

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