Debian Codegraph @

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

raw
1 set names utf8;
2 create table no_rebuild (
3 a char(150) charset utf8mb3 collate utf8mb3_general_ci
4 ) engine=innodb;
5 create table rebuild (
6 a varchar(150) charset ascii
7 ) engine=innodb;
8 set @id = (select table_id from information_schema.innodb_sys_tables
9 where name = 'test/no_rebuild');
10 select name, prtype, len from information_schema.innodb_sys_columns
11 where table_id = @id;
12 name prtype len
13 a 2162942 450
14 select c.prtype, c.len from information_schema.innodb_sys_columns as c inner join information_schema.innodb_sys_tables t on c.table_id = t.table_id
15 where t.name = 'test/rebuild' and c.name = 'a';
16 prtype len
17 720911 150
18 alter table no_rebuild
19 change a a char(150) charset utf8mb3 collate utf8mb3_spanish_ci,
20 algorithm=inplace;
21 alter table rebuild
22 change a a varchar(150) charset latin1 not null default 'asdf',
23 algorithm=inplace;
24 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
25 alter table rebuild
26 change a a varchar(150) charset latin1 not null default 'asdf',
27 algorithm=copy;
28 select name, prtype, len from information_schema.innodb_sys_columns
29 where table_id = @id;
30 name prtype len
31 a 13041918 450
32 select c.prtype, c.len from information_schema.innodb_sys_columns as c inner join information_schema.innodb_sys_tables t on c.table_id = t.table_id
33 where t.name = 'test/rebuild' and c.name = 'a';
34 prtype len
35 524559 150
36 drop table no_rebuild, rebuild;
37 create table supported_types (
38 id int primary key auto_increment,
39 a varchar(150) charset ascii,
40 b text(150) charset ascii,
41 c text charset ascii,
42 d tinytext charset ascii,
43 e mediumtext charset ascii,
44 f longtext charset ascii
45 ) engine=innodb;
46 alter table supported_types
47 convert to charset ascii collate ascii_bin,
48 algorithm=instant;
49 drop table supported_types;
50 create table various_cases (
51 a char(150) charset ascii,
52 b varchar(150) as (a) virtual,
53 c char(150) as (a) persistent
54 ) engine=innodb;
55 alter table various_cases
56 change a a char(150) charset ascii collate ascii_bin,
57 algorithm=inplace;
58 alter table various_cases
59 change a a varchar(222),
60 algorithm=inplace;
61 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
62 alter table various_cases
63 change b b varchar(150) as (a) virtual,
64 algorithm=inplace;
65 alter table various_cases
66 change c c char(150) as (a) persistent,
67 algorithm=inplace;
68 ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
69 alter table various_cases
70 modify a char(150) charset utf8mb4,
71 algorithm=instant;
72 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
73 drop table various_cases;
74 create table all_texts (
75 a tinytext charset ascii,
76 b text charset ascii,
77 c mediumtext charset ascii,
78 d longtext charset ascii,
79 footer int
80 ) engine=innodb;
81 alter table all_texts
82 convert to charset ascii collate ascii_bin,
83 algorithm=instant;
84 drop table all_texts;
85 create table all_binaries (
86 a tinyblob,
87 b blob,
88 c mediumblob,
89 d longblob,
90 e varbinary(150),
91 f binary(150)
92 ) engine=innodb;
93 alter table all_binaries modify a tinytext, algorithm=instant;
94 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
95 alter table all_binaries modify b text, algorithm=instant;
96 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
97 alter table all_binaries modify c mediumtext, algorithm=instant;
98 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
99 alter table all_binaries modify d longtext, algorithm=instant;
100 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
101 alter table all_binaries modify e varchar(150), algorithm=instant;
102 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
103 alter table all_binaries modify f char(150), algorithm=instant;
104 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
105 drop table all_binaries;
106 create table all_strings (
107 a tinytext,
108 b text,
109 c mediumtext,
110 d longtext,
111 e varchar(150),
112 f char(150)
113 ) engine=innodb;
114 alter table all_strings modify a tinyblob, algorithm=instant;
115 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
116 alter table all_strings modify b blob, algorithm=instant;
117 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
118 alter table all_strings modify c mediumblob, algorithm=instant;
119 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
120 alter table all_strings modify d longblob, algorithm=instant;
121 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
122 alter table all_strings modify e varbinary(150), algorithm=instant;
123 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
124 alter table all_strings modify f binary(150), algorithm=instant;
125 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
126 alter table all_strings modify a tinytext charset binary, algorithm=instant;
127 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
128 alter table all_strings modify b text charset binary, algorithm=instant;
129 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
130 alter table all_strings modify c mediumtext charset binary, algorithm=instant;
131 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
132 alter table all_strings modify d longtext charset binary, algorithm=instant;
133 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
134 alter table all_strings modify e varchar(150) charset binary, algorithm=instant;
135 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
136 alter table all_strings modify f char(150) charset binary, algorithm=instant;
137 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
138 drop table all_strings;
139 create table key_part_change (
140 a char(150) charset ascii,
141 b char(150) charset ascii,
142 c char(150) charset ascii,
143 unique key ab (a,b)
144 ) engine=innodb;
145 alter table key_part_change
146 modify a char(150) charset utf8mb4,
147 drop index ab,
148 add unique key ab(a,c),
149 algorithm=instant;
150 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
151 drop table key_part_change;
152 create table key_part_change_and_rename (
153 a char(100) charset ascii,
154 b char(100) charset ascii,
155 unique key ab (a,b)
156 ) engine=innodb;
157 alter table key_part_change_and_rename
158 change a b char(100) charset utf8mb4,
159 change b a char(100) charset utf8mb4,
160 drop index ab,
161 add unique key ab(a,b),
162 algorithm=instant;
163 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
164 drop table key_part_change_and_rename;
165 create table enum_and_set (
166 a enum('one', 'two') charset utf8mb3,
167 b set('three', 'four') charset utf8mb3
168 ) engine=innodb;
169 alter table enum_and_set
170 modify a enum('one', 'two') charset utf8mb4,
171 algorithm=instant;
172 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
173 alter table enum_and_set
174 modify b enum('three', 'four') charset utf8mb4,
175 algorithm=instant;
176 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
177 drop table enum_and_set;
178 create table compressed (
179 a varchar(255) compressed charset utf8mb3
180 ) engine=innodb;
181 insert into compressed values ('AAA'), ('bbb'), ('CCC');
182 alter table compressed
183 modify a varchar(255) compressed charset utf8mb4,
184 algorithm=instant;
185 select * from compressed;
186 a
187 AAA
188 bbb
189 CCC
190 check table compresed;
191 Table Op Msg_type Msg_text
192 test.compresed check Error Table 'test.compresed' doesn't exist
193 test.compresed check status Operation failed
194 drop table compressed;
195 create table key_part_bug (
196 id int primary key auto_increment,
197 a varchar(150) charset utf8mb3 unique key
198 ) engine=innodb;
199 alter table key_part_bug
200 modify a varchar(150) charset utf8mb4,
201 algorithm=instant;
202 drop table key_part_bug;
203 create table latin1_swedish_special_case (
204 copy1 varchar(150) charset ascii collate ascii_general_ci,
205 copy2 char(150) charset ascii collate ascii_general_ci,
206 instant1 varchar(150) charset ascii collate ascii_general_ci,
207 instant2 char(150) charset ascii collate ascii_general_ci
208 ) engine=innodb;
209 select c.name, c.prtype, c.mtype, c.len from information_schema.innodb_sys_columns as c inner join information_schema.innodb_sys_tables t on c.table_id = t.table_id
210 where t.name = 'test/latin1_swedish_special_case';
211 name prtype mtype len
212 copy1 720911 12 150
213 copy2 721150 13 150
214 instant1 720911 12 150
215 instant2 721150 13 150
216 alter table latin1_swedish_special_case
217 modify copy1 varchar(150) charset latin1 collate latin1_swedish_ci,
218 modify copy2 char(150) charset latin1 collate latin1_swedish_ci,
219 algorithm=copy;
220 alter table latin1_swedish_special_case
221 modify instant1 varchar(150) charset latin1 collate latin1_swedish_ci,
222 modify instant2 char(150) charset latin1 collate latin1_swedish_ci,
223 algorithm=instant;
224 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
225 alter table latin1_swedish_special_case
226 modify instant1 varchar(150) charset latin1 collate latin1_swedish_ci,
227 modify instant2 char(150) charset latin1 collate latin1_swedish_ci,
228 algorithm=copy;
229 select c.name, c.prtype, c.mtype, c.len from information_schema.innodb_sys_columns as c inner join information_schema.innodb_sys_tables t on c.table_id = t.table_id
230 where t.name = 'test/latin1_swedish_special_case';
231 name prtype mtype len
232 copy1 524303 1 150
233 copy2 524542 2 150
234 instant1 524303 1 150
235 instant2 524542 2 150
236 alter table latin1_swedish_special_case
237 modify copy1 varchar(150) charset latin1 collate latin1_general_ci,
238 modify copy2 char(150) charset latin1 collate latin1_general_ci,
239 algorithm=copy;
240 alter table latin1_swedish_special_case
241 modify instant1 varchar(150) charset latin1 collate latin1_general_ci,
242 modify instant2 char(150) charset latin1 collate latin1_general_ci,
243 algorithm=instant;
244 select c.name, c.prtype, c.mtype, c.len from information_schema.innodb_sys_columns as c inner join information_schema.innodb_sys_tables t on c.table_id = t.table_id
245 where t.name = 'test/latin1_swedish_special_case';
246 name prtype mtype len
247 copy1 3145743 12 150
248 copy2 3145982 13 150
249 instant1 3145743 12 150
250 instant2 3145982 13 150
251 drop table latin1_swedish_special_case;
252 create table regression (a varchar(100) charset utf8mb3 primary key, b int) engine=innodb;
253 alter table regression convert to character set utf8mb4;
254 drop table regression;
255 create table boundary_255 (
256 a varchar(50) charset ascii,
257 b varchar(200) charset ascii,
258 c varchar(300) charset ascii
259 ) engine=innodb;
260 alter table boundary_255
261 modify a varchar(50) charset utf8mb3,
262 algorithm=instant;
263 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
264 alter table boundary_255
265 modify a varchar(50) charset utf8mb3,
266 algorithm=copy;
267 alter table boundary_255
268 modify b varchar(200) charset utf8mb3,
269 algorithm=instant;
270 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
271 alter table boundary_255
272 modify c varchar(300) charset utf8mb3,
273 algorithm=instant;
274 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
275 drop table boundary_255;
276 create table boundary_255 (
277 a varchar(70) charset utf8mb3
278 ) engine=innodb;
279 alter table boundary_255
280 modify a varchar(70) charset utf8mb4,
281 algorithm=instant;
282 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
283 drop table boundary_255;
284 create table t (
285 a char(10) collate utf8mb3_general_ci,
286 b char(70) collate utf8mb3_general_ci,
287 c char(100) collate utf8mb3_general_ci,
288 aa char(10) collate utf8mb3_general_ci unique,
289 bb char(70) collate utf8mb3_general_ci unique,
290 cc char(100) collate utf8mb3_general_ci unique,
291 d char(10) collate utf8mb3_general_ci,
292 dd char(10) collate utf8mb3_general_ci unique
293 ) engine=innodb;
294 insert into t values
295 (repeat('a', 10), repeat('a', 70), repeat('a', 100),
296 repeat('a', 10), repeat('a', 70), repeat('a', 100),
297 repeat('a', 10), repeat('a', 10)
298 );
299 alter table t modify a char(10) collate utf8mb4_general_ci, algorithm=instant;
300 check table t;
301 Table Op Msg_type Msg_text
302 test.t check status OK
303 alter table t modify b char(70) collate utf8mb4_general_ci, algorithm=instant;
304 check table t;
305 Table Op Msg_type Msg_text
306 test.t check status OK
307 alter table t modify c char(100) collate utf8mb4_general_ci, algorithm=instant;
308 check table t;
309 Table Op Msg_type Msg_text
310 test.t check status OK
311 alter table t modify aa char(10) collate utf8mb4_general_ci, algorithm=instant;
312 check table t;
313 Table Op Msg_type Msg_text
314 test.t check status OK
315 alter table t modify bb char(70) collate utf8mb4_general_ci, algorithm=instant;
316 check table t;
317 Table Op Msg_type Msg_text
318 test.t check status OK
319 alter table t modify cc char(100) collate utf8mb4_general_ci, algorithm=instant;
320 check table t;
321 Table Op Msg_type Msg_text
322 test.t check status OK
323 alter table t modify d char(10) collate utf8mb4_spanish_ci, algorithm=instant;
324 alter table t modify dd char(10) collate utf8mb4_spanish_ci, algorithm=instant;
325 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
326 select * from t;
327 a b c aa bb cc d dd
328 aaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa aaaaaaaaaa
329 drop table t;
330 create table fully_compatible (
331 id int auto_increment unique key,
332 from_charset char(255),
333 from_collate char(255),
334 to_charset char(255),
335 to_collate char(255)
336 );
337 insert into fully_compatible (from_charset, from_collate, to_charset, to_collate) values
338 ('utf8mb3', 'utf8mb3_general_ci', 'utf8mb4', 'utf8mb4_general_ci'),
339 ('utf8mb3', 'utf8mb3_bin', 'utf8mb4', 'utf8mb4_bin'),
340 ('utf8mb3', 'utf8mb3_unicode_ci', 'utf8mb4', 'utf8mb4_unicode_ci'),
341 ('utf8mb3', 'utf8mb3_icelandic_ci', 'utf8mb4', 'utf8mb4_icelandic_ci'),
342 ('utf8mb3', 'utf8mb3_latvian_ci', 'utf8mb4', 'utf8mb4_latvian_ci'),
343 ('utf8mb3', 'utf8mb3_romanian_ci', 'utf8mb4', 'utf8mb4_romanian_ci'),
344 ('utf8mb3', 'utf8mb3_slovenian_ci', 'utf8mb4', 'utf8mb4_slovenian_ci'),
345 ('utf8mb3', 'utf8mb3_polish_ci', 'utf8mb4', 'utf8mb4_polish_ci'),
346 ('utf8mb3', 'utf8mb3_estonian_ci', 'utf8mb4', 'utf8mb4_estonian_ci'),
347 ('utf8mb3', 'utf8mb3_spanish_ci', 'utf8mb4', 'utf8mb4_spanish_ci'),
348 ('utf8mb3', 'utf8mb3_swedish_ci', 'utf8mb4', 'utf8mb4_swedish_ci'),
349 ('utf8mb3', 'utf8mb3_turkish_ci', 'utf8mb4', 'utf8mb4_turkish_ci'),
350 ('utf8mb3', 'utf8mb3_czech_ci', 'utf8mb4', 'utf8mb4_czech_ci'),
351 ('utf8mb3', 'utf8mb3_danish_ci', 'utf8mb4', 'utf8mb4_danish_ci'),
352 ('utf8mb3', 'utf8mb3_lithuanian_ci', 'utf8mb4', 'utf8mb4_lithuanian_ci'),
353 ('utf8mb3', 'utf8mb3_slovak_ci', 'utf8mb4', 'utf8mb4_slovak_ci'),
354 ('utf8mb3', 'utf8mb3_spanish2_ci', 'utf8mb4', 'utf8mb4_spanish2_ci'),
355 ('utf8mb3', 'utf8mb3_roman_ci', 'utf8mb4', 'utf8mb4_roman_ci'),
356 ('utf8mb3', 'utf8mb3_persian_ci', 'utf8mb4', 'utf8mb4_persian_ci'),
357 ('utf8mb3', 'utf8mb3_esperanto_ci', 'utf8mb4', 'utf8mb4_esperanto_ci'),
358 ('utf8mb3', 'utf8mb3_hungarian_ci', 'utf8mb4', 'utf8mb4_hungarian_ci'),
359 ('utf8mb3', 'utf8mb3_sinhala_ci', 'utf8mb4', 'utf8mb4_sinhala_ci'),
360 ('utf8mb3', 'utf8mb3_german2_ci', 'utf8mb4', 'utf8mb4_german2_ci'),
361 ('utf8mb3', 'utf8mb3_croatian_mysql561_ci', 'utf8mb4', 'utf8mb4_croatian_mysql561_ci'),
362 ('utf8mb3', 'utf8mb3_unicode_520_ci', 'utf8mb4', 'utf8mb4_unicode_520_ci'),
363 ('utf8mb3', 'utf8mb3_vietnamese_ci', 'utf8mb4', 'utf8mb4_vietnamese_ci'),
364 ('utf8mb3', 'utf8mb3_croatian_ci', 'utf8mb4', 'utf8mb4_croatian_ci'),
365 ('utf8mb3', 'utf8mb3_myanmar_ci', 'utf8mb4', 'utf8mb4_myanmar_ci'),
366 ('utf8mb3', 'utf8mb3_thai_520_w2', 'utf8mb4', 'utf8mb4_thai_520_w2'),
367 ('utf8mb3', 'utf8mb3_general_nopad_ci', 'utf8mb4', 'utf8mb4_general_nopad_ci'),
368 ('utf8mb3', 'utf8mb3_nopad_bin', 'utf8mb4', 'utf8mb4_nopad_bin'),
369 ('utf8mb3', 'utf8mb3_unicode_nopad_ci', 'utf8mb4', 'utf8mb4_unicode_nopad_ci'),
370 ('utf8mb3', 'utf8mb3_unicode_520_nopad_ci', 'utf8mb4', 'utf8mb4_unicode_520_nopad_ci')
371 ;
372 create table tmp (
373 a varchar(50) charset utf8mb3 collate utf8mb3_general_ci,
374 b varchar(50) charset utf8mb3 collate utf8mb3_general_ci primary key
375 ) engine=innodb;
376 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
377 alter table tmp
378 change a a varchar(50) charset utf8mb4 collate utf8mb4_general_ci,
379 modify b varchar(50) charset utf8mb4 collate utf8mb4_general_ci,
380 algorithm=instant;
381 check table tmp;
382 Table Op Msg_type Msg_text
383 test.tmp check status OK
384 drop table tmp;
385 create table tmp (
386 a varchar(50) charset utf8mb3 collate utf8mb3_bin,
387 b varchar(50) charset utf8mb3 collate utf8mb3_bin primary key
388 ) engine=innodb;
389 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
390 alter table tmp
391 change a a varchar(50) charset utf8mb4 collate utf8mb4_bin,
392 modify b varchar(50) charset utf8mb4 collate utf8mb4_bin,
393 algorithm=instant;
394 check table tmp;
395 Table Op Msg_type Msg_text
396 test.tmp check status OK
397 drop table tmp;
398 create table tmp (
399 a varchar(50) charset utf8mb3 collate utf8mb3_unicode_ci,
400 b varchar(50) charset utf8mb3 collate utf8mb3_unicode_ci primary key
401 ) engine=innodb;
402 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
403 alter table tmp
404 change a a varchar(50) charset utf8mb4 collate utf8mb4_unicode_ci,
405 modify b varchar(50) charset utf8mb4 collate utf8mb4_unicode_ci,
406 algorithm=instant;
407 check table tmp;
408 Table Op Msg_type Msg_text
409 test.tmp check status OK
410 drop table tmp;
411 create table tmp (
412 a varchar(50) charset utf8mb3 collate utf8mb3_icelandic_ci,
413 b varchar(50) charset utf8mb3 collate utf8mb3_icelandic_ci primary key
414 ) engine=innodb;
415 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
416 alter table tmp
417 change a a varchar(50) charset utf8mb4 collate utf8mb4_icelandic_ci,
418 modify b varchar(50) charset utf8mb4 collate utf8mb4_icelandic_ci,
419 algorithm=instant;
420 check table tmp;
421 Table Op Msg_type Msg_text
422 test.tmp check status OK
423 drop table tmp;
424 create table tmp (
425 a varchar(50) charset utf8mb3 collate utf8mb3_latvian_ci,
426 b varchar(50) charset utf8mb3 collate utf8mb3_latvian_ci primary key
427 ) engine=innodb;
428 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
429 alter table tmp
430 change a a varchar(50) charset utf8mb4 collate utf8mb4_latvian_ci,
431 modify b varchar(50) charset utf8mb4 collate utf8mb4_latvian_ci,
432 algorithm=instant;
433 check table tmp;
434 Table Op Msg_type Msg_text
435 test.tmp check status OK
436 drop table tmp;
437 create table tmp (
438 a varchar(50) charset utf8mb3 collate utf8mb3_romanian_ci,
439 b varchar(50) charset utf8mb3 collate utf8mb3_romanian_ci primary key
440 ) engine=innodb;
441 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
442 alter table tmp
443 change a a varchar(50) charset utf8mb4 collate utf8mb4_romanian_ci,
444 modify b varchar(50) charset utf8mb4 collate utf8mb4_romanian_ci,
445 algorithm=instant;
446 check table tmp;
447 Table Op Msg_type Msg_text
448 test.tmp check status OK
449 drop table tmp;
450 create table tmp (
451 a varchar(50) charset utf8mb3 collate utf8mb3_slovenian_ci,
452 b varchar(50) charset utf8mb3 collate utf8mb3_slovenian_ci primary key
453 ) engine=innodb;
454 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
455 alter table tmp
456 change a a varchar(50) charset utf8mb4 collate utf8mb4_slovenian_ci,
457 modify b varchar(50) charset utf8mb4 collate utf8mb4_slovenian_ci,
458 algorithm=instant;
459 check table tmp;
460 Table Op Msg_type Msg_text
461 test.tmp check status OK
462 drop table tmp;
463 create table tmp (
464 a varchar(50) charset utf8mb3 collate utf8mb3_polish_ci,
465 b varchar(50) charset utf8mb3 collate utf8mb3_polish_ci primary key
466 ) engine=innodb;
467 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
468 alter table tmp
469 change a a varchar(50) charset utf8mb4 collate utf8mb4_polish_ci,
470 modify b varchar(50) charset utf8mb4 collate utf8mb4_polish_ci,
471 algorithm=instant;
472 check table tmp;
473 Table Op Msg_type Msg_text
474 test.tmp check status OK
475 drop table tmp;
476 create table tmp (
477 a varchar(50) charset utf8mb3 collate utf8mb3_estonian_ci,
478 b varchar(50) charset utf8mb3 collate utf8mb3_estonian_ci primary key
479 ) engine=innodb;
480 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
481 alter table tmp
482 change a a varchar(50) charset utf8mb4 collate utf8mb4_estonian_ci,
483 modify b varchar(50) charset utf8mb4 collate utf8mb4_estonian_ci,
484 algorithm=instant;
485 check table tmp;
486 Table Op Msg_type Msg_text
487 test.tmp check status OK
488 drop table tmp;
489 create table tmp (
490 a varchar(50) charset utf8mb3 collate utf8mb3_spanish_ci,
491 b varchar(50) charset utf8mb3 collate utf8mb3_spanish_ci primary key
492 ) engine=innodb;
493 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
494 alter table tmp
495 change a a varchar(50) charset utf8mb4 collate utf8mb4_spanish_ci,
496 modify b varchar(50) charset utf8mb4 collate utf8mb4_spanish_ci,
497 algorithm=instant;
498 check table tmp;
499 Table Op Msg_type Msg_text
500 test.tmp check status OK
501 drop table tmp;
502 create table tmp (
503 a varchar(50) charset utf8mb3 collate utf8mb3_swedish_ci,
504 b varchar(50) charset utf8mb3 collate utf8mb3_swedish_ci primary key
505 ) engine=innodb;
506 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
507 alter table tmp
508 change a a varchar(50) charset utf8mb4 collate utf8mb4_swedish_ci,
509 modify b varchar(50) charset utf8mb4 collate utf8mb4_swedish_ci,
510 algorithm=instant;
511 check table tmp;
512 Table Op Msg_type Msg_text
513 test.tmp check status OK
514 drop table tmp;
515 create table tmp (
516 a varchar(50) charset utf8mb3 collate utf8mb3_turkish_ci,
517 b varchar(50) charset utf8mb3 collate utf8mb3_turkish_ci primary key
518 ) engine=innodb;
519 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
520 alter table tmp
521 change a a varchar(50) charset utf8mb4 collate utf8mb4_turkish_ci,
522 modify b varchar(50) charset utf8mb4 collate utf8mb4_turkish_ci,
523 algorithm=instant;
524 check table tmp;
525 Table Op Msg_type Msg_text
526 test.tmp check status OK
527 drop table tmp;
528 create table tmp (
529 a varchar(50) charset utf8mb3 collate utf8mb3_czech_ci,
530 b varchar(50) charset utf8mb3 collate utf8mb3_czech_ci primary key
531 ) engine=innodb;
532 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
533 alter table tmp
534 change a a varchar(50) charset utf8mb4 collate utf8mb4_czech_ci,
535 modify b varchar(50) charset utf8mb4 collate utf8mb4_czech_ci,
536 algorithm=instant;
537 check table tmp;
538 Table Op Msg_type Msg_text
539 test.tmp check status OK
540 drop table tmp;
541 create table tmp (
542 a varchar(50) charset utf8mb3 collate utf8mb3_danish_ci,
543 b varchar(50) charset utf8mb3 collate utf8mb3_danish_ci primary key
544 ) engine=innodb;
545 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
546 alter table tmp
547 change a a varchar(50) charset utf8mb4 collate utf8mb4_danish_ci,
548 modify b varchar(50) charset utf8mb4 collate utf8mb4_danish_ci,
549 algorithm=instant;
550 check table tmp;
551 Table Op Msg_type Msg_text
552 test.tmp check status OK
553 drop table tmp;
554 create table tmp (
555 a varchar(50) charset utf8mb3 collate utf8mb3_lithuanian_ci,
556 b varchar(50) charset utf8mb3 collate utf8mb3_lithuanian_ci primary key
557 ) engine=innodb;
558 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
559 alter table tmp
560 change a a varchar(50) charset utf8mb4 collate utf8mb4_lithuanian_ci,
561 modify b varchar(50) charset utf8mb4 collate utf8mb4_lithuanian_ci,
562 algorithm=instant;
563 check table tmp;
564 Table Op Msg_type Msg_text
565 test.tmp check status OK
566 drop table tmp;
567 create table tmp (
568 a varchar(50) charset utf8mb3 collate utf8mb3_slovak_ci,
569 b varchar(50) charset utf8mb3 collate utf8mb3_slovak_ci primary key
570 ) engine=innodb;
571 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
572 alter table tmp
573 change a a varchar(50) charset utf8mb4 collate utf8mb4_slovak_ci,
574 modify b varchar(50) charset utf8mb4 collate utf8mb4_slovak_ci,
575 algorithm=instant;
576 check table tmp;
577 Table Op Msg_type Msg_text
578 test.tmp check status OK
579 drop table tmp;
580 create table tmp (
581 a varchar(50) charset utf8mb3 collate utf8mb3_spanish2_ci,
582 b varchar(50) charset utf8mb3 collate utf8mb3_spanish2_ci primary key
583 ) engine=innodb;
584 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
585 alter table tmp
586 change a a varchar(50) charset utf8mb4 collate utf8mb4_spanish2_ci,
587 modify b varchar(50) charset utf8mb4 collate utf8mb4_spanish2_ci,
588 algorithm=instant;
589 check table tmp;
590 Table Op Msg_type Msg_text
591 test.tmp check status OK
592 drop table tmp;
593 create table tmp (
594 a varchar(50) charset utf8mb3 collate utf8mb3_roman_ci,
595 b varchar(50) charset utf8mb3 collate utf8mb3_roman_ci primary key
596 ) engine=innodb;
597 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
598 alter table tmp
599 change a a varchar(50) charset utf8mb4 collate utf8mb4_roman_ci,
600 modify b varchar(50) charset utf8mb4 collate utf8mb4_roman_ci,
601 algorithm=instant;
602 check table tmp;
603 Table Op Msg_type Msg_text
604 test.tmp check status OK
605 drop table tmp;
606 create table tmp (
607 a varchar(50) charset utf8mb3 collate utf8mb3_persian_ci,
608 b varchar(50) charset utf8mb3 collate utf8mb3_persian_ci primary key
609 ) engine=innodb;
610 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
611 alter table tmp
612 change a a varchar(50) charset utf8mb4 collate utf8mb4_persian_ci,
613 modify b varchar(50) charset utf8mb4 collate utf8mb4_persian_ci,
614 algorithm=instant;
615 check table tmp;
616 Table Op Msg_type Msg_text
617 test.tmp check status OK
618 drop table tmp;
619 create table tmp (
620 a varchar(50) charset utf8mb3 collate utf8mb3_esperanto_ci,
621 b varchar(50) charset utf8mb3 collate utf8mb3_esperanto_ci primary key
622 ) engine=innodb;
623 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
624 alter table tmp
625 change a a varchar(50) charset utf8mb4 collate utf8mb4_esperanto_ci,
626 modify b varchar(50) charset utf8mb4 collate utf8mb4_esperanto_ci,
627 algorithm=instant;
628 check table tmp;
629 Table Op Msg_type Msg_text
630 test.tmp check status OK
631 drop table tmp;
632 create table tmp (
633 a varchar(50) charset utf8mb3 collate utf8mb3_hungarian_ci,
634 b varchar(50) charset utf8mb3 collate utf8mb3_hungarian_ci primary key
635 ) engine=innodb;
636 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
637 alter table tmp
638 change a a varchar(50) charset utf8mb4 collate utf8mb4_hungarian_ci,
639 modify b varchar(50) charset utf8mb4 collate utf8mb4_hungarian_ci,
640 algorithm=instant;
641 check table tmp;
642 Table Op Msg_type Msg_text
643 test.tmp check status OK
644 drop table tmp;
645 create table tmp (
646 a varchar(50) charset utf8mb3 collate utf8mb3_sinhala_ci,
647 b varchar(50) charset utf8mb3 collate utf8mb3_sinhala_ci primary key
648 ) engine=innodb;
649 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
650 alter table tmp
651 change a a varchar(50) charset utf8mb4 collate utf8mb4_sinhala_ci,
652 modify b varchar(50) charset utf8mb4 collate utf8mb4_sinhala_ci,
653 algorithm=instant;
654 check table tmp;
655 Table Op Msg_type Msg_text
656 test.tmp check status OK
657 drop table tmp;
658 create table tmp (
659 a varchar(50) charset utf8mb3 collate utf8mb3_german2_ci,
660 b varchar(50) charset utf8mb3 collate utf8mb3_german2_ci primary key
661 ) engine=innodb;
662 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
663 alter table tmp
664 change a a varchar(50) charset utf8mb4 collate utf8mb4_german2_ci,
665 modify b varchar(50) charset utf8mb4 collate utf8mb4_german2_ci,
666 algorithm=instant;
667 check table tmp;
668 Table Op Msg_type Msg_text
669 test.tmp check status OK
670 drop table tmp;
671 create table tmp (
672 a varchar(50) charset utf8mb3 collate utf8mb3_croatian_mysql561_ci,
673 b varchar(50) charset utf8mb3 collate utf8mb3_croatian_mysql561_ci primary key
674 ) engine=innodb;
675 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
676 alter table tmp
677 change a a varchar(50) charset utf8mb4 collate utf8mb4_croatian_mysql561_ci,
678 modify b varchar(50) charset utf8mb4 collate utf8mb4_croatian_mysql561_ci,
679 algorithm=instant;
680 check table tmp;
681 Table Op Msg_type Msg_text
682 test.tmp check status OK
683 drop table tmp;
684 create table tmp (
685 a varchar(50) charset utf8mb3 collate utf8mb3_unicode_520_ci,
686 b varchar(50) charset utf8mb3 collate utf8mb3_unicode_520_ci primary key
687 ) engine=innodb;
688 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
689 alter table tmp
690 change a a varchar(50) charset utf8mb4 collate utf8mb4_unicode_520_ci,
691 modify b varchar(50) charset utf8mb4 collate utf8mb4_unicode_520_ci,
692 algorithm=instant;
693 check table tmp;
694 Table Op Msg_type Msg_text
695 test.tmp check status OK
696 drop table tmp;
697 create table tmp (
698 a varchar(50) charset utf8mb3 collate utf8mb3_vietnamese_ci,
699 b varchar(50) charset utf8mb3 collate utf8mb3_vietnamese_ci primary key
700 ) engine=innodb;
701 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
702 alter table tmp
703 change a a varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
704 modify b varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
705 algorithm=instant;
706 check table tmp;
707 Table Op Msg_type Msg_text
708 test.tmp check status OK
709 drop table tmp;
710 create table tmp (
711 a varchar(50) charset utf8mb3 collate utf8mb3_croatian_ci,
712 b varchar(50) charset utf8mb3 collate utf8mb3_croatian_ci primary key
713 ) engine=innodb;
714 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
715 alter table tmp
716 change a a varchar(50) charset utf8mb4 collate utf8mb4_croatian_ci,
717 modify b varchar(50) charset utf8mb4 collate utf8mb4_croatian_ci,
718 algorithm=instant;
719 check table tmp;
720 Table Op Msg_type Msg_text
721 test.tmp check status OK
722 drop table tmp;
723 create table tmp (
724 a varchar(50) charset utf8mb3 collate utf8mb3_myanmar_ci,
725 b varchar(50) charset utf8mb3 collate utf8mb3_myanmar_ci primary key
726 ) engine=innodb;
727 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
728 alter table tmp
729 change a a varchar(50) charset utf8mb4 collate utf8mb4_myanmar_ci,
730 modify b varchar(50) charset utf8mb4 collate utf8mb4_myanmar_ci,
731 algorithm=instant;
732 check table tmp;
733 Table Op Msg_type Msg_text
734 test.tmp check status OK
735 drop table tmp;
736 create table tmp (
737 a varchar(50) charset utf8mb3 collate utf8mb3_thai_520_w2,
738 b varchar(50) charset utf8mb3 collate utf8mb3_thai_520_w2 primary key
739 ) engine=innodb;
740 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
741 alter table tmp
742 change a a varchar(50) charset utf8mb4 collate utf8mb4_thai_520_w2,
743 modify b varchar(50) charset utf8mb4 collate utf8mb4_thai_520_w2,
744 algorithm=instant;
745 check table tmp;
746 Table Op Msg_type Msg_text
747 test.tmp check status OK
748 drop table tmp;
749 create table tmp (
750 a varchar(50) charset utf8mb3 collate utf8mb3_general_nopad_ci,
751 b varchar(50) charset utf8mb3 collate utf8mb3_general_nopad_ci primary key
752 ) engine=innodb;
753 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
754 alter table tmp
755 change a a varchar(50) charset utf8mb4 collate utf8mb4_general_nopad_ci,
756 modify b varchar(50) charset utf8mb4 collate utf8mb4_general_nopad_ci,
757 algorithm=instant;
758 check table tmp;
759 Table Op Msg_type Msg_text
760 test.tmp check status OK
761 drop table tmp;
762 create table tmp (
763 a varchar(50) charset utf8mb3 collate utf8mb3_nopad_bin,
764 b varchar(50) charset utf8mb3 collate utf8mb3_nopad_bin primary key
765 ) engine=innodb;
766 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
767 alter table tmp
768 change a a varchar(50) charset utf8mb4 collate utf8mb4_nopad_bin,
769 modify b varchar(50) charset utf8mb4 collate utf8mb4_nopad_bin,
770 algorithm=instant;
771 check table tmp;
772 Table Op Msg_type Msg_text
773 test.tmp check status OK
774 drop table tmp;
775 create table tmp (
776 a varchar(50) charset utf8mb3 collate utf8mb3_unicode_nopad_ci,
777 b varchar(50) charset utf8mb3 collate utf8mb3_unicode_nopad_ci primary key
778 ) engine=innodb;
779 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
780 alter table tmp
781 change a a varchar(50) charset utf8mb4 collate utf8mb4_unicode_nopad_ci,
782 modify b varchar(50) charset utf8mb4 collate utf8mb4_unicode_nopad_ci,
783 algorithm=instant;
784 check table tmp;
785 Table Op Msg_type Msg_text
786 test.tmp check status OK
787 drop table tmp;
788 create table tmp (
789 a varchar(50) charset utf8mb3 collate utf8mb3_unicode_520_nopad_ci,
790 b varchar(50) charset utf8mb3 collate utf8mb3_unicode_520_nopad_ci primary key
791 ) engine=innodb;
792 insert into tmp values ('AAA', 'AAA'), ('bbb', 'bbb');
793 alter table tmp
794 change a a varchar(50) charset utf8mb4 collate utf8mb4_unicode_520_nopad_ci,
795 modify b varchar(50) charset utf8mb4 collate utf8mb4_unicode_520_nopad_ci,
796 algorithm=instant;
797 check table tmp;
798 Table Op Msg_type Msg_text
799 test.tmp check status OK
800 drop table tmp;
801 drop table fully_compatible;
802 create table compatible_without_index (
803 id int auto_increment unique key,
804 from_charset char(255),
805 from_collate char(255),
806 to_charset char(255),
807 to_collate char(255)
808 );
809 insert into compatible_without_index (from_charset, from_collate, to_charset, to_collate) values
810 ('utf8mb3', 'utf8mb3_general_ci', 'utf8mb4', 'utf8mb4_vietnamese_ci'),
811 ('utf8mb3', 'utf8mb3_bin', 'utf8mb4', 'utf8mb4_vietnamese_ci'),
812 ('utf8mb3', 'utf8mb3_general_nopad_ci', 'utf8mb4', 'utf8mb4_vietnamese_ci'),
813 ('utf8mb3', 'utf8mb3_nopad_bin', 'utf8mb4', 'utf8mb4_vietnamese_ci'),
814 ('ascii', 'ascii_general_ci', 'ascii', 'ascii_bin'),
815 ('utf8mb3', 'utf8mb3_roman_ci', 'utf8mb3', 'utf8mb3_lithuanian_ci'),
816 ('utf8mb4', 'utf8mb4_thai_520_w2', 'utf8mb4', 'utf8mb4_persian_ci'),
817 ('utf8mb3', 'utf8mb3_myanmar_ci', 'utf8mb4', 'utf8mb4_german2_ci'),
818 ('utf8mb3', 'utf8mb3_general_ci', 'utf8mb3', 'utf8mb3_unicode_ci'),
819 ('latin1', 'latin1_general_cs', 'latin1', 'latin1_general_ci'),
820 ('utf16', 'utf16_general_ci', 'utf16', 'utf16_german2_ci')
821 ;
822 create table tmp (
823 a varchar(50) charset utf8mb3 collate utf8mb3_general_ci,
824 b varchar(50) charset utf8mb3 collate utf8mb3_general_ci unique key,
825 c varchar(50) charset utf8mb3 collate utf8mb3_general_ci primary key
826 ) engine=innodb;
827 alter table tmp
828 change a a varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
829 algorithm=instant;
830 alter table tmp
831 modify b varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
832 algorithm=instant;
833 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
834 alter table tmp
835 modify c varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
836 algorithm=instant;
837 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
838 drop table tmp;
839 create table tmp (
840 a varchar(50) charset utf8mb3 collate utf8mb3_bin,
841 b varchar(50) charset utf8mb3 collate utf8mb3_bin unique key,
842 c varchar(50) charset utf8mb3 collate utf8mb3_bin primary key
843 ) engine=innodb;
844 alter table tmp
845 change a a varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
846 algorithm=instant;
847 alter table tmp
848 modify b varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
849 algorithm=instant;
850 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
851 alter table tmp
852 modify c varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
853 algorithm=instant;
854 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
855 drop table tmp;
856 create table tmp (
857 a varchar(50) charset utf8mb3 collate utf8mb3_general_nopad_ci,
858 b varchar(50) charset utf8mb3 collate utf8mb3_general_nopad_ci unique key,
859 c varchar(50) charset utf8mb3 collate utf8mb3_general_nopad_ci primary key
860 ) engine=innodb;
861 alter table tmp
862 change a a varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
863 algorithm=instant;
864 alter table tmp
865 modify b varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
866 algorithm=instant;
867 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
868 alter table tmp
869 modify c varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
870 algorithm=instant;
871 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
872 drop table tmp;
873 create table tmp (
874 a varchar(50) charset utf8mb3 collate utf8mb3_nopad_bin,
875 b varchar(50) charset utf8mb3 collate utf8mb3_nopad_bin unique key,
876 c varchar(50) charset utf8mb3 collate utf8mb3_nopad_bin primary key
877 ) engine=innodb;
878 alter table tmp
879 change a a varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
880 algorithm=instant;
881 alter table tmp
882 modify b varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
883 algorithm=instant;
884 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
885 alter table tmp
886 modify c varchar(50) charset utf8mb4 collate utf8mb4_vietnamese_ci,
887 algorithm=instant;
888 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
889 drop table tmp;
890 create table tmp (
891 a varchar(50) charset ascii collate ascii_general_ci,
892 b varchar(50) charset ascii collate ascii_general_ci unique key,
893 c varchar(50) charset ascii collate ascii_general_ci primary key
894 ) engine=innodb;
895 alter table tmp
896 change a a varchar(50) charset ascii collate ascii_bin,
897 algorithm=instant;
898 alter table tmp
899 modify b varchar(50) charset ascii collate ascii_bin,
900 algorithm=instant;
901 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
902 alter table tmp
903 modify c varchar(50) charset ascii collate ascii_bin,
904 algorithm=instant;
905 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
906 drop table tmp;
907 create table tmp (
908 a varchar(50) charset utf8mb3 collate utf8mb3_roman_ci,
909 b varchar(50) charset utf8mb3 collate utf8mb3_roman_ci unique key,
910 c varchar(50) charset utf8mb3 collate utf8mb3_roman_ci primary key
911 ) engine=innodb;
912 alter table tmp
913 change a a varchar(50) charset utf8mb3 collate utf8mb3_lithuanian_ci,
914 algorithm=instant;
915 alter table tmp
916 modify b varchar(50) charset utf8mb3 collate utf8mb3_lithuanian_ci,
917 algorithm=instant;
918 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
919 alter table tmp
920 modify c varchar(50) charset utf8mb3 collate utf8mb3_lithuanian_ci,
921 algorithm=instant;
922 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
923 drop table tmp;
924 create table tmp (
925 a varchar(50) charset utf8mb4 collate utf8mb4_thai_520_w2,
926 b varchar(50) charset utf8mb4 collate utf8mb4_thai_520_w2 unique key,
927 c varchar(50) charset utf8mb4 collate utf8mb4_thai_520_w2 primary key
928 ) engine=innodb;
929 alter table tmp
930 change a a varchar(50) charset utf8mb4 collate utf8mb4_persian_ci,
931 algorithm=instant;
932 alter table tmp
933 modify b varchar(50) charset utf8mb4 collate utf8mb4_persian_ci,
934 algorithm=instant;
935 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
936 alter table tmp
937 modify c varchar(50) charset utf8mb4 collate utf8mb4_persian_ci,
938 algorithm=instant;
939 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
940 drop table tmp;
941 create table tmp (
942 a varchar(50) charset utf8mb3 collate utf8mb3_myanmar_ci,
943 b varchar(50) charset utf8mb3 collate utf8mb3_myanmar_ci unique key,
944 c varchar(50) charset utf8mb3 collate utf8mb3_myanmar_ci primary key
945 ) engine=innodb;
946 alter table tmp
947 change a a varchar(50) charset utf8mb4 collate utf8mb4_german2_ci,
948 algorithm=instant;
949 alter table tmp
950 modify b varchar(50) charset utf8mb4 collate utf8mb4_german2_ci,
951 algorithm=instant;
952 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
953 alter table tmp
954 modify c varchar(50) charset utf8mb4 collate utf8mb4_german2_ci,
955 algorithm=instant;
956 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
957 drop table tmp;
958 create table tmp (
959 a varchar(50) charset utf8mb3 collate utf8mb3_general_ci,
960 b varchar(50) charset utf8mb3 collate utf8mb3_general_ci unique key,
961 c varchar(50) charset utf8mb3 collate utf8mb3_general_ci primary key
962 ) engine=innodb;
963 alter table tmp
964 change a a varchar(50) charset utf8mb3 collate utf8mb3_unicode_ci,
965 algorithm=instant;
966 alter table tmp
967 modify b varchar(50) charset utf8mb3 collate utf8mb3_unicode_ci,
968 algorithm=instant;
969 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
970 alter table tmp
971 modify c varchar(50) charset utf8mb3 collate utf8mb3_unicode_ci,
972 algorithm=instant;
973 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
974 drop table tmp;
975 create table tmp (
976 a varchar(50) charset latin1 collate latin1_general_cs,
977 b varchar(50) charset latin1 collate latin1_general_cs unique key,
978 c varchar(50) charset latin1 collate latin1_general_cs primary key
979 ) engine=innodb;
980 alter table tmp
981 change a a varchar(50) charset latin1 collate latin1_general_ci,
982 algorithm=instant;
983 alter table tmp
984 modify b varchar(50) charset latin1 collate latin1_general_ci,
985 algorithm=instant;
986 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
987 alter table tmp
988 modify c varchar(50) charset latin1 collate latin1_general_ci,
989 algorithm=instant;
990 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
991 drop table tmp;
992 create table tmp (
993 a varchar(50) charset utf16 collate utf16_general_ci,
994 b varchar(50) charset utf16 collate utf16_general_ci unique key,
995 c varchar(50) charset utf16 collate utf16_general_ci primary key
996 ) engine=innodb;
997 alter table tmp
998 change a a varchar(50) charset utf16 collate utf16_german2_ci,
999 algorithm=instant;
1000 alter table tmp
1001 modify b varchar(50) charset utf16 collate utf16_german2_ci,
1002 algorithm=instant;
1003 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
1004 alter table tmp
1005 modify c varchar(50) charset utf16 collate utf16_german2_ci,
1006 algorithm=instant;
1007 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1008 drop table tmp;
1009 drop table compatible_without_index;
1010 create table fully_incompatible (
1011 id int auto_increment unique key,
1012 from_charset char(255),
1013 from_collate char(255),
1014 to_charset char(255),
1015 to_collate char(255)
1016 );
1017 insert into fully_incompatible (from_charset, from_collate, to_charset, to_collate) values
1018 ('ascii', 'ascii_general_ci', 'utf8mb3', 'utf8mb3_general_ci'),
1019 ('ascii', 'ascii_general_ci', 'utf8mb4', 'utf8mb4_general_ci'),
1020 ('ascii', 'ascii_general_ci', 'latin1', 'latin1_general_ci'),
1021 ('ascii', 'ascii_bin', 'latin1', 'latin1_bin'),
1022 ('ascii', 'ascii_nopad_bin', 'latin1', 'latin1_nopad_bin'),
1023 ('ascii', 'ascii_general_ci', 'latin2', 'latin2_general_ci'),
1024 ('ascii', 'ascii_general_ci', 'latin7', 'latin7_general_ci'),
1025 ('ascii', 'ascii_bin', 'koi8u', 'koi8u_bin'),
1026 ('ascii', 'ascii_bin', 'ujis', 'ujis_bin'),
1027 ('ascii', 'ascii_bin', 'big5', 'big5_bin'),
1028 ('ascii', 'ascii_bin', 'gbk', 'gbk_bin'),
1029 ('ascii', 'ascii_general_ci', 'utf8mb3', 'utf8mb3_swedish_ci'),
1030 ('ascii', 'ascii_bin', 'latin1', 'latin1_swedish_ci'),
1031 ('ascii', 'ascii_general_nopad_ci', 'latin1', 'latin1_swedish_ci'),
1032 ('ascii', 'ascii_nopad_bin', 'latin1', 'latin1_swedish_ci'),
1033 ('ascii', 'ascii_general_ci', 'koi8u', 'koi8u_bin'),
1034 ('ascii', 'ascii_general_nopad_ci', 'koi8u', 'koi8u_bin'),
1035 ('ascii', 'ascii_nopad_bin', 'koi8u', 'koi8u_bin'),
1036 ('ascii', 'ascii_general_ci', 'latin1', 'latin1_swedish_ci'),
1037 ('ascii', 'ascii_bin', 'utf8mb3', 'utf8mb3_swedish_ci'),
1038 ('ascii', 'ascii_general_nopad_ci', 'utf8mb3', 'utf8mb3_swedish_ci'),
1039 ('ascii', 'ascii_nopad_bin', 'utf8mb3', 'utf8mb3_swedish_ci'),
1040 ('ascii', 'ascii_general_ci', 'utf8mb4', 'utf8mb4_danish_ci'),
1041 ('ascii', 'ascii_bin', 'utf8mb4', 'utf8mb4_danish_ci'),
1042 ('ascii', 'ascii_general_nopad_ci', 'utf8mb4', 'utf8mb4_danish_ci'),
1043 ('ascii', 'ascii_nopad_bin', 'utf8mb4', 'utf8mb4_danish_ci'),
1044 ('ascii', 'ascii_general_ci', 'gbk', 'gbk_chinese_ci'),
1045 ('ascii', 'ascii_general_ci', 'gbk', 'gbk_chinese_nopad_ci'),
1046 ('ascii', 'ascii_general_ci', 'ujis', 'ujis_japanese_ci'),
1047 ('ascii', 'ascii_general_ci', 'big5', 'big5_chinese_ci'),
1048 ('ascii', 'ascii_general_ci', 'latin2', 'latin2_croatian_ci'),
1049 ('ascii', 'ascii_general_ci', 'latin7', 'latin7_estonian_cs'),
1050 ('ucs2', 'ucs2_general_ci', 'utf16', 'utf16_general_ci'),
1051 ('ucs2', 'ucs2_unicode_ci', 'utf16', 'utf16_unicode_ci'),
1052 ('ucs2', 'ucs2_icelandic_ci', 'utf16', 'utf16_icelandic_ci'),
1053 ('ucs2', 'ucs2_latvian_ci', 'utf16', 'utf16_latvian_ci'),
1054 ('ucs2', 'ucs2_romanian_ci', 'utf16', 'utf16_romanian_ci'),
1055 ('ucs2', 'ucs2_slovenian_ci', 'utf16', 'utf16_slovenian_ci'),
1056 ('ucs2', 'ucs2_polish_ci', 'utf16', 'utf16_polish_ci'),
1057 ('ucs2', 'ucs2_estonian_ci', 'utf16', 'utf16_estonian_ci'),
1058 ('ucs2', 'ucs2_spanish_ci', 'utf16', 'utf16_spanish_ci'),
1059 ('ucs2', 'ucs2_general_ci', 'utf16', 'utf16_general_ci'),
1060 ('ucs2', 'ucs2_myanmar_ci', 'utf16', 'utf16_thai_520_w2'),
1061 ('ucs2', 'ucs2_general_ci', 'utf16', 'utf16_unicode_nopad_ci'),
1062 ('ucs2', 'ucs2_general_mysql500_ci', 'utf16', 'utf16_spanish2_ci'),
1063 ('utf8mb4', 'utf8mb4_general_ci', 'utf8mb3', 'utf8mb3_general_ci'),
1064 ('utf8mb4', 'utf8mb4_general_ci', 'ascii', 'ascii_general_ci'),
1065 ('utf8mb3', 'utf8mb3_general_ci', 'ascii', 'ascii_general_ci'),
1066 ('utf8mb3', 'utf8mb3_general_ci', 'latin1', 'latin1_general_ci'),
1067 ('utf16', 'utf16_general_ci', 'utf32', 'utf32_general_ci'),
1068 ('latin1', 'latin1_general_ci', 'ascii', 'ascii_general_ci'),
1069 ('ascii', 'ascii_general_ci', 'swe7', 'swe7_swedish_ci'),
1070 ('eucjpms', 'eucjpms_japanese_nopad_ci', 'geostd8', 'geostd8_general_ci'),
1071 ('latin1', 'latin1_general_ci', 'utf16', 'utf16_general_ci')
1072 ;
1073 create table tmp (
1074 a varchar(150) charset ascii collate ascii_general_ci,
1075 b text(150) charset ascii collate ascii_general_ci,
1076 unique key b_idx (b(150))
1077 ) engine=innodb;
1078 alter table tmp
1079 change a a varchar(150) charset utf8mb3 collate utf8mb3_general_ci,
1080 algorithm=instant;
1081 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1082 alter table tmp
1083 modify b text charset utf8mb3 collate utf8mb3_general_ci,
1084 algorithm=instant;
1085 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1086 drop table tmp;
1087 create table tmp (
1088 a varchar(150) charset ascii collate ascii_general_ci,
1089 b text(150) charset ascii collate ascii_general_ci,
1090 unique key b_idx (b(150))
1091 ) engine=innodb;
1092 alter table tmp
1093 change a a varchar(150) charset utf8mb4 collate utf8mb4_general_ci,
1094 algorithm=instant;
1095 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1096 alter table tmp
1097 modify b text charset utf8mb4 collate utf8mb4_general_ci,
1098 algorithm=instant;
1099 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1100 drop table tmp;
1101 create table tmp (
1102 a varchar(150) charset ascii collate ascii_general_ci,
1103 b text(150) charset ascii collate ascii_general_ci,
1104 unique key b_idx (b(150))
1105 ) engine=innodb;
1106 alter table tmp
1107 change a a varchar(150) charset latin1 collate latin1_general_ci,
1108 algorithm=instant;
1109 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1110 alter table tmp
1111 modify b text charset latin1 collate latin1_general_ci,
1112 algorithm=instant;
1113 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1114 drop table tmp;
1115 create table tmp (
1116 a varchar(150) charset ascii collate ascii_bin,
1117 b text(150) charset ascii collate ascii_bin,
1118 unique key b_idx (b(150))
1119 ) engine=innodb;
1120 alter table tmp
1121 change a a varchar(150) charset latin1 collate latin1_bin,
1122 algorithm=instant;
1123 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1124 alter table tmp
1125 modify b text charset latin1 collate latin1_bin,
1126 algorithm=instant;
1127 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1128 drop table tmp;
1129 create table tmp (
1130 a varchar(150) charset ascii collate ascii_nopad_bin,
1131 b text(150) charset ascii collate ascii_nopad_bin,
1132 unique key b_idx (b(150))
1133 ) engine=innodb;
1134 alter table tmp
1135 change a a varchar(150) charset latin1 collate latin1_nopad_bin,
1136 algorithm=instant;
1137 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1138 alter table tmp
1139 modify b text charset latin1 collate latin1_nopad_bin,
1140 algorithm=instant;
1141 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1142 drop table tmp;
1143 create table tmp (
1144 a varchar(150) charset ascii collate ascii_general_ci,
1145 b text(150) charset ascii collate ascii_general_ci,
1146 unique key b_idx (b(150))
1147 ) engine=innodb;
1148 alter table tmp
1149 change a a varchar(150) charset latin2 collate latin2_general_ci,
1150 algorithm=instant;
1151 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1152 alter table tmp
1153 modify b text charset latin2 collate latin2_general_ci,
1154 algorithm=instant;
1155 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1156 drop table tmp;
1157 create table tmp (
1158 a varchar(150) charset ascii collate ascii_general_ci,
1159 b text(150) charset ascii collate ascii_general_ci,
1160 unique key b_idx (b(150))
1161 ) engine=innodb;
1162 alter table tmp
1163 change a a varchar(150) charset latin7 collate latin7_general_ci,
1164 algorithm=instant;
1165 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1166 alter table tmp
1167 modify b text charset latin7 collate latin7_general_ci,
1168 algorithm=instant;
1169 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1170 drop table tmp;
1171 create table tmp (
1172 a varchar(150) charset ascii collate ascii_bin,
1173 b text(150) charset ascii collate ascii_bin,
1174 unique key b_idx (b(150))
1175 ) engine=innodb;
1176 alter table tmp
1177 change a a varchar(150) charset koi8u collate koi8u_bin,
1178 algorithm=instant;
1179 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1180 alter table tmp
1181 modify b text charset koi8u collate koi8u_bin,
1182 algorithm=instant;
1183 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1184 drop table tmp;
1185 create table tmp (
1186 a varchar(150) charset ascii collate ascii_bin,
1187 b text(150) charset ascii collate ascii_bin,
1188 unique key b_idx (b(150))
1189 ) engine=innodb;
1190 alter table tmp
1191 change a a varchar(150) charset ujis collate ujis_bin,
1192 algorithm=instant;
1193 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1194 alter table tmp
1195 modify b text charset ujis collate ujis_bin,
1196 algorithm=instant;
1197 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1198 drop table tmp;
1199 create table tmp (
1200 a varchar(150) charset ascii collate ascii_bin,
1201 b text(150) charset ascii collate ascii_bin,
1202 unique key b_idx (b(150))
1203 ) engine=innodb;
1204 alter table tmp
1205 change a a varchar(150) charset big5 collate big5_bin,
1206 algorithm=instant;
1207 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1208 alter table tmp
1209 modify b text charset big5 collate big5_bin,
1210 algorithm=instant;
1211 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1212 drop table tmp;
1213 create table tmp (
1214 a varchar(150) charset ascii collate ascii_bin,
1215 b text(150) charset ascii collate ascii_bin,
1216 unique key b_idx (b(150))
1217 ) engine=innodb;
1218 alter table tmp
1219 change a a varchar(150) charset gbk collate gbk_bin,
1220 algorithm=instant;
1221 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1222 alter table tmp
1223 modify b text charset gbk collate gbk_bin,
1224 algorithm=instant;
1225 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1226 drop table tmp;
1227 create table tmp (
1228 a varchar(150) charset ascii collate ascii_general_ci,
1229 b text(150) charset ascii collate ascii_general_ci,
1230 unique key b_idx (b(150))
1231 ) engine=innodb;
1232 alter table tmp
1233 change a a varchar(150) charset utf8mb3 collate utf8mb3_swedish_ci,
1234 algorithm=instant;
1235 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1236 alter table tmp
1237 modify b text charset utf8mb3 collate utf8mb3_swedish_ci,
1238 algorithm=instant;
1239 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1240 drop table tmp;
1241 create table tmp (
1242 a varchar(150) charset ascii collate ascii_bin,
1243 b text(150) charset ascii collate ascii_bin,
1244 unique key b_idx (b(150))
1245 ) engine=innodb;
1246 alter table tmp
1247 change a a varchar(150) charset latin1 collate latin1_swedish_ci,
1248 algorithm=instant;
1249 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1250 alter table tmp
1251 modify b text charset latin1 collate latin1_swedish_ci,
1252 algorithm=instant;
1253 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1254 drop table tmp;
1255 create table tmp (
1256 a varchar(150) charset ascii collate ascii_general_nopad_ci,
1257 b text(150) charset ascii collate ascii_general_nopad_ci,
1258 unique key b_idx (b(150))
1259 ) engine=innodb;
1260 alter table tmp
1261 change a a varchar(150) charset latin1 collate latin1_swedish_ci,
1262 algorithm=instant;
1263 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1264 alter table tmp
1265 modify b text charset latin1 collate latin1_swedish_ci,
1266 algorithm=instant;
1267 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1268 drop table tmp;
1269 create table tmp (
1270 a varchar(150) charset ascii collate ascii_nopad_bin,
1271 b text(150) charset ascii collate ascii_nopad_bin,
1272 unique key b_idx (b(150))
1273 ) engine=innodb;
1274 alter table tmp
1275 change a a varchar(150) charset latin1 collate latin1_swedish_ci,
1276 algorithm=instant;
1277 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1278 alter table tmp
1279 modify b text charset latin1 collate latin1_swedish_ci,
1280 algorithm=instant;
1281 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1282 drop table tmp;
1283 create table tmp (
1284 a varchar(150) charset ascii collate ascii_general_ci,
1285 b text(150) charset ascii collate ascii_general_ci,
1286 unique key b_idx (b(150))
1287 ) engine=innodb;
1288 alter table tmp
1289 change a a varchar(150) charset koi8u collate koi8u_bin,
1290 algorithm=instant;
1291 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1292 alter table tmp
1293 modify b text charset koi8u collate koi8u_bin,
1294 algorithm=instant;
1295 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1296 drop table tmp;
1297 create table tmp (
1298 a varchar(150) charset ascii collate ascii_general_nopad_ci,
1299 b text(150) charset ascii collate ascii_general_nopad_ci,
1300 unique key b_idx (b(150))
1301 ) engine=innodb;
1302 alter table tmp
1303 change a a varchar(150) charset koi8u collate koi8u_bin,
1304 algorithm=instant;
1305 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1306 alter table tmp
1307 modify b text charset koi8u collate koi8u_bin,
1308 algorithm=instant;
1309 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1310 drop table tmp;
1311 create table tmp (
1312 a varchar(150) charset ascii collate ascii_nopad_bin,
1313 b text(150) charset ascii collate ascii_nopad_bin,
1314 unique key b_idx (b(150))
1315 ) engine=innodb;
1316 alter table tmp
1317 change a a varchar(150) charset koi8u collate koi8u_bin,
1318 algorithm=instant;
1319 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1320 alter table tmp
1321 modify b text charset koi8u collate koi8u_bin,
1322 algorithm=instant;
1323 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1324 drop table tmp;
1325 create table tmp (
1326 a varchar(150) charset ascii collate ascii_general_ci,
1327 b text(150) charset ascii collate ascii_general_ci,
1328 unique key b_idx (b(150))
1329 ) engine=innodb;
1330 alter table tmp
1331 change a a varchar(150) charset latin1 collate latin1_swedish_ci,
1332 algorithm=instant;
1333 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1334 alter table tmp
1335 modify b text charset latin1 collate latin1_swedish_ci,
1336 algorithm=instant;
1337 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1338 drop table tmp;
1339 create table tmp (
1340 a varchar(150) charset ascii collate ascii_bin,
1341 b text(150) charset ascii collate ascii_bin,
1342 unique key b_idx (b(150))
1343 ) engine=innodb;
1344 alter table tmp
1345 change a a varchar(150) charset utf8mb3 collate utf8mb3_swedish_ci,
1346 algorithm=instant;
1347 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1348 alter table tmp
1349 modify b text charset utf8mb3 collate utf8mb3_swedish_ci,
1350 algorithm=instant;
1351 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1352 drop table tmp;
1353 create table tmp (
1354 a varchar(150) charset ascii collate ascii_general_nopad_ci,
1355 b text(150) charset ascii collate ascii_general_nopad_ci,
1356 unique key b_idx (b(150))
1357 ) engine=innodb;
1358 alter table tmp
1359 change a a varchar(150) charset utf8mb3 collate utf8mb3_swedish_ci,
1360 algorithm=instant;
1361 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1362 alter table tmp
1363 modify b text charset utf8mb3 collate utf8mb3_swedish_ci,
1364 algorithm=instant;
1365 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1366 drop table tmp;
1367 create table tmp (
1368 a varchar(150) charset ascii collate ascii_nopad_bin,
1369 b text(150) charset ascii collate ascii_nopad_bin,
1370 unique key b_idx (b(150))
1371 ) engine=innodb;
1372 alter table tmp
1373 change a a varchar(150) charset utf8mb3 collate utf8mb3_swedish_ci,
1374 algorithm=instant;
1375 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1376 alter table tmp
1377 modify b text charset utf8mb3 collate utf8mb3_swedish_ci,
1378 algorithm=instant;
1379 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1380 drop table tmp;
1381 create table tmp (
1382 a varchar(150) charset ascii collate ascii_general_ci,
1383 b text(150) charset ascii collate ascii_general_ci,
1384 unique key b_idx (b(150))
1385 ) engine=innodb;
1386 alter table tmp
1387 change a a varchar(150) charset utf8mb4 collate utf8mb4_danish_ci,
1388 algorithm=instant;
1389 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1390 alter table tmp
1391 modify b text charset utf8mb4 collate utf8mb4_danish_ci,
1392 algorithm=instant;
1393 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1394 drop table tmp;
1395 create table tmp (
1396 a varchar(150) charset ascii collate ascii_bin,
1397 b text(150) charset ascii collate ascii_bin,
1398 unique key b_idx (b(150))
1399 ) engine=innodb;
1400 alter table tmp
1401 change a a varchar(150) charset utf8mb4 collate utf8mb4_danish_ci,
1402 algorithm=instant;
1403 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1404 alter table tmp
1405 modify b text charset utf8mb4 collate utf8mb4_danish_ci,
1406 algorithm=instant;
1407 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1408 drop table tmp;
1409 create table tmp (
1410 a varchar(150) charset ascii collate ascii_general_nopad_ci,
1411 b text(150) charset ascii collate ascii_general_nopad_ci,
1412 unique key b_idx (b(150))
1413 ) engine=innodb;
1414 alter table tmp
1415 change a a varchar(150) charset utf8mb4 collate utf8mb4_danish_ci,
1416 algorithm=instant;
1417 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1418 alter table tmp
1419 modify b text charset utf8mb4 collate utf8mb4_danish_ci,
1420 algorithm=instant;
1421 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1422 drop table tmp;
1423 create table tmp (
1424 a varchar(150) charset ascii collate ascii_nopad_bin,
1425 b text(150) charset ascii collate ascii_nopad_bin,
1426 unique key b_idx (b(150))
1427 ) engine=innodb;
1428 alter table tmp
1429 change a a varchar(150) charset utf8mb4 collate utf8mb4_danish_ci,
1430 algorithm=instant;
1431 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1432 alter table tmp
1433 modify b text charset utf8mb4 collate utf8mb4_danish_ci,
1434 algorithm=instant;
1435 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1436 drop table tmp;
1437 create table tmp (
1438 a varchar(150) charset ascii collate ascii_general_ci,
1439 b text(150) charset ascii collate ascii_general_ci,
1440 unique key b_idx (b(150))
1441 ) engine=innodb;
1442 alter table tmp
1443 change a a varchar(150) charset gbk collate gbk_chinese_ci,
1444 algorithm=instant;
1445 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1446 alter table tmp
1447 modify b text charset gbk collate gbk_chinese_ci,
1448 algorithm=instant;
1449 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1450 drop table tmp;
1451 create table tmp (
1452 a varchar(150) charset ascii collate ascii_general_ci,
1453 b text(150) charset ascii collate ascii_general_ci,
1454 unique key b_idx (b(150))
1455 ) engine=innodb;
1456 alter table tmp
1457 change a a varchar(150) charset gbk collate gbk_chinese_nopad_ci,
1458 algorithm=instant;
1459 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1460 alter table tmp
1461 modify b text charset gbk collate gbk_chinese_nopad_ci,
1462 algorithm=instant;
1463 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1464 drop table tmp;
1465 create table tmp (
1466 a varchar(150) charset ascii collate ascii_general_ci,
1467 b text(150) charset ascii collate ascii_general_ci,
1468 unique key b_idx (b(150))
1469 ) engine=innodb;
1470 alter table tmp
1471 change a a varchar(150) charset ujis collate ujis_japanese_ci,
1472 algorithm=instant;
1473 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1474 alter table tmp
1475 modify b text charset ujis collate ujis_japanese_ci,
1476 algorithm=instant;
1477 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1478 drop table tmp;
1479 create table tmp (
1480 a varchar(150) charset ascii collate ascii_general_ci,
1481 b text(150) charset ascii collate ascii_general_ci,
1482 unique key b_idx (b(150))
1483 ) engine=innodb;
1484 alter table tmp
1485 change a a varchar(150) charset big5 collate big5_chinese_ci,
1486 algorithm=instant;
1487 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1488 alter table tmp
1489 modify b text charset big5 collate big5_chinese_ci,
1490 algorithm=instant;
1491 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1492 drop table tmp;
1493 create table tmp (
1494 a varchar(150) charset ascii collate ascii_general_ci,
1495 b text(150) charset ascii collate ascii_general_ci,
1496 unique key b_idx (b(150))
1497 ) engine=innodb;
1498 alter table tmp
1499 change a a varchar(150) charset latin2 collate latin2_croatian_ci,
1500 algorithm=instant;
1501 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1502 alter table tmp
1503 modify b text charset latin2 collate latin2_croatian_ci,
1504 algorithm=instant;
1505 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1506 drop table tmp;
1507 create table tmp (
1508 a varchar(150) charset ascii collate ascii_general_ci,
1509 b text(150) charset ascii collate ascii_general_ci,
1510 unique key b_idx (b(150))
1511 ) engine=innodb;
1512 alter table tmp
1513 change a a varchar(150) charset latin7 collate latin7_estonian_cs,
1514 algorithm=instant;
1515 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1516 alter table tmp
1517 modify b text charset latin7 collate latin7_estonian_cs,
1518 algorithm=instant;
1519 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1520 drop table tmp;
1521 create table tmp (
1522 a varchar(150) charset ucs2 collate ucs2_general_ci,
1523 b text(150) charset ucs2 collate ucs2_general_ci,
1524 unique key b_idx (b(150))
1525 ) engine=innodb;
1526 alter table tmp
1527 change a a varchar(150) charset utf16 collate utf16_general_ci,
1528 algorithm=instant;
1529 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1530 alter table tmp
1531 modify b text charset utf16 collate utf16_general_ci,
1532 algorithm=instant;
1533 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1534 drop table tmp;
1535 create table tmp (
1536 a varchar(150) charset ucs2 collate ucs2_unicode_ci,
1537 b text(150) charset ucs2 collate ucs2_unicode_ci,
1538 unique key b_idx (b(150))
1539 ) engine=innodb;
1540 alter table tmp
1541 change a a varchar(150) charset utf16 collate utf16_unicode_ci,
1542 algorithm=instant;
1543 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1544 alter table tmp
1545 modify b text charset utf16 collate utf16_unicode_ci,
1546 algorithm=instant;
1547 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1548 drop table tmp;
1549 create table tmp (
1550 a varchar(150) charset ucs2 collate ucs2_icelandic_ci,
1551 b text(150) charset ucs2 collate ucs2_icelandic_ci,
1552 unique key b_idx (b(150))
1553 ) engine=innodb;
1554 alter table tmp
1555 change a a varchar(150) charset utf16 collate utf16_icelandic_ci,
1556 algorithm=instant;
1557 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1558 alter table tmp
1559 modify b text charset utf16 collate utf16_icelandic_ci,
1560 algorithm=instant;
1561 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1562 drop table tmp;
1563 create table tmp (
1564 a varchar(150) charset ucs2 collate ucs2_latvian_ci,
1565 b text(150) charset ucs2 collate ucs2_latvian_ci,
1566 unique key b_idx (b(150))
1567 ) engine=innodb;
1568 alter table tmp
1569 change a a varchar(150) charset utf16 collate utf16_latvian_ci,
1570 algorithm=instant;
1571 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1572 alter table tmp
1573 modify b text charset utf16 collate utf16_latvian_ci,
1574 algorithm=instant;
1575 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1576 drop table tmp;
1577 create table tmp (
1578 a varchar(150) charset ucs2 collate ucs2_romanian_ci,
1579 b text(150) charset ucs2 collate ucs2_romanian_ci,
1580 unique key b_idx (b(150))
1581 ) engine=innodb;
1582 alter table tmp
1583 change a a varchar(150) charset utf16 collate utf16_romanian_ci,
1584 algorithm=instant;
1585 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1586 alter table tmp
1587 modify b text charset utf16 collate utf16_romanian_ci,
1588 algorithm=instant;
1589 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1590 drop table tmp;
1591 create table tmp (
1592 a varchar(150) charset ucs2 collate ucs2_slovenian_ci,
1593 b text(150) charset ucs2 collate ucs2_slovenian_ci,
1594 unique key b_idx (b(150))
1595 ) engine=innodb;
1596 alter table tmp
1597 change a a varchar(150) charset utf16 collate utf16_slovenian_ci,
1598 algorithm=instant;
1599 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1600 alter table tmp
1601 modify b text charset utf16 collate utf16_slovenian_ci,
1602 algorithm=instant;
1603 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1604 drop table tmp;
1605 create table tmp (
1606 a varchar(150) charset ucs2 collate ucs2_polish_ci,
1607 b text(150) charset ucs2 collate ucs2_polish_ci,
1608 unique key b_idx (b(150))
1609 ) engine=innodb;
1610 alter table tmp
1611 change a a varchar(150) charset utf16 collate utf16_polish_ci,
1612 algorithm=instant;
1613 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1614 alter table tmp
1615 modify b text charset utf16 collate utf16_polish_ci,
1616 algorithm=instant;
1617 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1618 drop table tmp;
1619 create table tmp (
1620 a varchar(150) charset ucs2 collate ucs2_estonian_ci,
1621 b text(150) charset ucs2 collate ucs2_estonian_ci,
1622 unique key b_idx (b(150))
1623 ) engine=innodb;
1624 alter table tmp
1625 change a a varchar(150) charset utf16 collate utf16_estonian_ci,
1626 algorithm=instant;
1627 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1628 alter table tmp
1629 modify b text charset utf16 collate utf16_estonian_ci,
1630 algorithm=instant;
1631 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1632 drop table tmp;
1633 create table tmp (
1634 a varchar(150) charset ucs2 collate ucs2_spanish_ci,
1635 b text(150) charset ucs2 collate ucs2_spanish_ci,
1636 unique key b_idx (b(150))
1637 ) engine=innodb;
1638 alter table tmp
1639 change a a varchar(150) charset utf16 collate utf16_spanish_ci,
1640 algorithm=instant;
1641 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1642 alter table tmp
1643 modify b text charset utf16 collate utf16_spanish_ci,
1644 algorithm=instant;
1645 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1646 drop table tmp;
1647 create table tmp (
1648 a varchar(150) charset ucs2 collate ucs2_general_ci,
1649 b text(150) charset ucs2 collate ucs2_general_ci,
1650 unique key b_idx (b(150))
1651 ) engine=innodb;
1652 alter table tmp
1653 change a a varchar(150) charset utf16 collate utf16_general_ci,
1654 algorithm=instant;
1655 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1656 alter table tmp
1657 modify b text charset utf16 collate utf16_general_ci,
1658 algorithm=instant;
1659 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1660 drop table tmp;
1661 create table tmp (
1662 a varchar(150) charset ucs2 collate ucs2_myanmar_ci,
1663 b text(150) charset ucs2 collate ucs2_myanmar_ci,
1664 unique key b_idx (b(150))
1665 ) engine=innodb;
1666 alter table tmp
1667 change a a varchar(150) charset utf16 collate utf16_thai_520_w2,
1668 algorithm=instant;
1669 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1670 alter table tmp
1671 modify b text charset utf16 collate utf16_thai_520_w2,
1672 algorithm=instant;
1673 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1674 drop table tmp;
1675 create table tmp (
1676 a varchar(150) charset ucs2 collate ucs2_general_ci,
1677 b text(150) charset ucs2 collate ucs2_general_ci,
1678 unique key b_idx (b(150))
1679 ) engine=innodb;
1680 alter table tmp
1681 change a a varchar(150) charset utf16 collate utf16_unicode_nopad_ci,
1682 algorithm=instant;
1683 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1684 alter table tmp
1685 modify b text charset utf16 collate utf16_unicode_nopad_ci,
1686 algorithm=instant;
1687 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1688 drop table tmp;
1689 create table tmp (
1690 a varchar(150) charset ucs2 collate ucs2_general_mysql500_ci,
1691 b text(150) charset ucs2 collate ucs2_general_mysql500_ci,
1692 unique key b_idx (b(150))
1693 ) engine=innodb;
1694 alter table tmp
1695 change a a varchar(150) charset utf16 collate utf16_spanish2_ci,
1696 algorithm=instant;
1697 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1698 alter table tmp
1699 modify b text charset utf16 collate utf16_spanish2_ci,
1700 algorithm=instant;
1701 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1702 drop table tmp;
1703 create table tmp (
1704 a varchar(150) charset utf8mb4 collate utf8mb4_general_ci,
1705 b text(150) charset utf8mb4 collate utf8mb4_general_ci,
1706 unique key b_idx (b(150))
1707 ) engine=innodb;
1708 alter table tmp
1709 change a a varchar(150) charset utf8mb3 collate utf8mb3_general_ci,
1710 algorithm=instant;
1711 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1712 alter table tmp
1713 modify b text charset utf8mb3 collate utf8mb3_general_ci,
1714 algorithm=instant;
1715 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1716 drop table tmp;
1717 create table tmp (
1718 a varchar(150) charset utf8mb4 collate utf8mb4_general_ci,
1719 b text(150) charset utf8mb4 collate utf8mb4_general_ci,
1720 unique key b_idx (b(150))
1721 ) engine=innodb;
1722 alter table tmp
1723 change a a varchar(150) charset ascii collate ascii_general_ci,
1724 algorithm=instant;
1725 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1726 alter table tmp
1727 modify b text charset ascii collate ascii_general_ci,
1728 algorithm=instant;
1729 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1730 drop table tmp;
1731 create table tmp (
1732 a varchar(150) charset utf8mb3 collate utf8mb3_general_ci,
1733 b text(150) charset utf8mb3 collate utf8mb3_general_ci,
1734 unique key b_idx (b(150))
1735 ) engine=innodb;
1736 alter table tmp
1737 change a a varchar(150) charset ascii collate ascii_general_ci,
1738 algorithm=instant;
1739 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1740 alter table tmp
1741 modify b text charset ascii collate ascii_general_ci,
1742 algorithm=instant;
1743 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1744 drop table tmp;
1745 create table tmp (
1746 a varchar(150) charset utf8mb3 collate utf8mb3_general_ci,
1747 b text(150) charset utf8mb3 collate utf8mb3_general_ci,
1748 unique key b_idx (b(150))
1749 ) engine=innodb;
1750 alter table tmp
1751 change a a varchar(150) charset latin1 collate latin1_general_ci,
1752 algorithm=instant;
1753 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1754 alter table tmp
1755 modify b text charset latin1 collate latin1_general_ci,
1756 algorithm=instant;
1757 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1758 drop table tmp;
1759 create table tmp (
1760 a varchar(150) charset utf16 collate utf16_general_ci,
1761 b text(150) charset utf16 collate utf16_general_ci,
1762 unique key b_idx (b(150))
1763 ) engine=innodb;
1764 alter table tmp
1765 change a a varchar(150) charset utf32 collate utf32_general_ci,
1766 algorithm=instant;
1767 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1768 alter table tmp
1769 modify b text charset utf32 collate utf32_general_ci,
1770 algorithm=instant;
1771 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1772 drop table tmp;
1773 create table tmp (
1774 a varchar(150) charset latin1 collate latin1_general_ci,
1775 b text(150) charset latin1 collate latin1_general_ci,
1776 unique key b_idx (b(150))
1777 ) engine=innodb;
1778 alter table tmp
1779 change a a varchar(150) charset ascii collate ascii_general_ci,
1780 algorithm=instant;
1781 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1782 alter table tmp
1783 modify b text charset ascii collate ascii_general_ci,
1784 algorithm=instant;
1785 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1786 drop table tmp;
1787 create table tmp (
1788 a varchar(150) charset ascii collate ascii_general_ci,
1789 b text(150) charset ascii collate ascii_general_ci,
1790 unique key b_idx (b(150))
1791 ) engine=innodb;
1792 alter table tmp
1793 change a a varchar(150) charset swe7 collate swe7_swedish_ci,
1794 algorithm=instant;
1795 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1796 alter table tmp
1797 modify b text charset swe7 collate swe7_swedish_ci,
1798 algorithm=instant;
1799 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1800 drop table tmp;
1801 create table tmp (
1802 a varchar(150) charset eucjpms collate eucjpms_japanese_nopad_ci,
1803 b text(150) charset eucjpms collate eucjpms_japanese_nopad_ci,
1804 unique key b_idx (b(150))
1805 ) engine=innodb;
1806 alter table tmp
1807 change a a varchar(150) charset geostd8 collate geostd8_general_ci,
1808 algorithm=instant;
1809 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1810 alter table tmp
1811 modify b text charset geostd8 collate geostd8_general_ci,
1812 algorithm=instant;
1813 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1814 drop table tmp;
1815 create table tmp (
1816 a varchar(150) charset latin1 collate latin1_general_ci,
1817 b text(150) charset latin1 collate latin1_general_ci,
1818 unique key b_idx (b(150))
1819 ) engine=innodb;
1820 alter table tmp
1821 change a a varchar(150) charset utf16 collate utf16_general_ci,
1822 algorithm=instant;
1823 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1824 alter table tmp
1825 modify b text charset utf16 collate utf16_general_ci,
1826 algorithm=instant;
1827 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1828 drop table tmp;
1829 drop table fully_incompatible;
1830 #
1831 # MDEV-19284 INSTANT ALTER with ucs2-to-utf16 conversion produces bad data
1832 #
1833 CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET ucs2, PRIMARY KEY(a)) ENGINE=InnoDB;
1834 INSERT INTO t1 VALUES ('a'),(0xD800);
1835 ALTER TABLE t1 ALGORITHM=COPY, MODIFY a VARCHAR(10) CHARACTER SET utf16;
1836 ERROR 22007: Incorrect string value: '\xD8\x00' for column `test`.`t1`.`a` at row 2
1837 ALTER TABLE t1 ALGORITHM=INSTANT, MODIFY a VARCHAR(10) CHARACTER SET utf16;
1838 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1839 ALTER IGNORE TABLE t1 MODIFY a VARCHAR(10) CHARACTER SET utf16;
1840 affected rows: 2
1841 info: Records: 2 Duplicates: 0 Warnings: 1
1842 Warnings:
1843 Warning 1366 Incorrect string value: '\xD8\x00' for column `test`.`t1`.`a` at row 2
1844 SELECT HEX(a) FROM t1;
1845 HEX(a)
1846 003F
1847 0061
1848 DROP TABLE t1;
1849 #
1850 # MDEV-19285 INSTANT ALTER from ascii_general_ci to latin1_general_ci produces corrupt data
1851 #
1852 CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET ascii COLLATE ascii_general_ci, PRIMARY KEY(a)) ENGINE=InnoDB;
1853 INSERT INTO t1 VALUES ('a'),(0xC0),('b');
1854 ALTER TABLE t1 ALGORITHM=COPY, MODIFY a VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci;
1855 ERROR 22007: Incorrect string value: '\xC0' for column `test`.`t1`.`a` at row 3
1856 ALTER TABLE t1 ALGORITHM=INSTANT, MODIFY a VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci;
1857 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1858 ALTER IGNORE TABLE t1 MODIFY a VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci;
1859 affected rows: 3
1860 info: Records: 3 Duplicates: 0 Warnings: 1
1861 Warnings:
1862 Warning 1366 Incorrect string value: '\xC0' for column `test`.`t1`.`a` at row 3
1863 SELECT HEX(a) FROM t1;
1864 HEX(a)
1865 3F
1866 61
1867 62
1868 DROP TABLE t1;
1869 #
1870 # MDEV-19524 Server crashes in Bitmap<64u>::is_clear_all / Field_longstr::csinfo_change_allows_instant_alter
1871 #
1872 CREATE TABLE t1 (a VARCHAR(1), UNIQUE(a)) ENGINE=InnoDB;
1873 ALTER TABLE t1 MODIFY a INT, ADD b INT, ADD UNIQUE (b), ALGORITHM=INSTANT;
1874 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1875 DROP TABLE t1;
1876 #
1877 # MDEV-17301 Change of COLLATE unnecessarily requires ALGORITHM=COPY
1878 #
1879 create table t (
1880 a char(10) collate latin1_general_ci primary key,
1881 b char(10) collate latin1_general_ci,
1882 c char(10) collate latin1_general_ci,
1883 unique key b_key(b)
1884 ) engine=innodb;
1885 insert into t values
1886 ('aaa', 'aaa', 'aaa'), ('ccc', 'ccc', 'ccc'), ('bbb', 'bbb', 'bbb');
1887 alter table t modify a char(10) collate latin1_general_cs, algorithm=inplace;
1888 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1889 alter table t modify b char(10) collate latin1_general_cs, algorithm=instant;
1890 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
1891 alter table t modify b char(10) collate latin1_general_cs, algorithm=nocopy;
1892 check table t;
1893 Table Op Msg_type Msg_text
1894 test.t check status OK
1895 alter table t modify c char(10) collate latin1_general_cs, algorithm=instant;
1896 check table t;
1897 Table Op Msg_type Msg_text
1898 test.t check status OK
1899 drop table t;
1900 create table t (
1901 a varchar(10) collate latin1_general_ci primary key,
1902 b varchar(10) collate latin1_general_ci,
1903 c varchar(10) collate latin1_general_ci,
1904 unique key b_key(b)
1905 ) engine=innodb;
1906 insert into t values
1907 ('aaa', 'aaa', 'aaa'), ('ccc', 'ccc', 'ccc'), ('bbb', 'bbb', 'bbb');
1908 alter table t modify a varchar(10) collate latin1_general_cs, algorithm=inplace;
1909 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
1910 alter table t modify b varchar(10) collate latin1_general_cs, algorithm=instant;
1911 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
1912 alter table t modify b varchar(10) collate latin1_general_cs, algorithm=nocopy;
1913 check table t;
1914 Table Op Msg_type Msg_text
1915 test.t check status OK
1916 alter table t modify c varchar(10) collate latin1_general_cs, algorithm=instant;
1917 check table t;
1918 Table Op Msg_type Msg_text
1919 test.t check status OK
1920 drop table t;
1921 #
1922 # MDEV-20726: InnoDB: Assertion failure in file data0type.cc line 67
1923 #
1924 CREATE TABLE t (
1925 id int(10) unsigned NOT NULL PRIMARY KEY,
1926 a text CHARSET utf8mb3,
1927 KEY a_idx(a(1))
1928 ) ENGINE=InnoDB;
1929 INSERT INTO t VALUES (1, 'something in the air');
1930 ALTER TABLE t MODIFY a text CHARSET utf8mb4;
1931 DROP TABLE t;
1932 #
1933 # MDEV-22899: Assertion `field->col->is_binary() || field->prefix_len % field->col->mbmaxlen == 0' failed in dict_index_add_to_cache
1934 #
1935 CREATE TABLE t1 (
1936 a text CHARACTER SET utf8 DEFAULT NULL,
1937 KEY a_key (a(1))
1938 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1939 INSERT INTO t1 VALUES ();
1940 ALTER TABLE t1 MODIFY a text DEFAULT NULL;
1941 DROP TABLE t1;
1942 CREATE TABLE t1 (
1943 a text CHARACTER SET utf8 DEFAULT NULL,
1944 b int,
1945 KEY a_key (b, a(1))
1946 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1947 INSERT INTO t1 VALUES ();
1948 ALTER TABLE t1 MODIFY a text DEFAULT NULL;
1949 DROP TABLE t1;
1950 CREATE TABLE t1 (
1951 a char(200) CHARACTER SET utf8 DEFAULT NULL,
1952 KEY a_key (a(1))
1953 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1954 INSERT INTO t1 VALUES ();
1955 ALTER TABLE t1 MODIFY a text DEFAULT NULL;
1956 DROP TABLE t1;
1957 CREATE TABLE t1 (
1958 a char(200) CHARACTER SET utf8 DEFAULT NULL,
1959 b int,
1960 KEY a_key (b, a(1))
1961 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1962 INSERT INTO t1 VALUES ();
1963 ALTER TABLE t1 MODIFY a text DEFAULT NULL;
1964 DROP TABLE t1;
1965 CREATE TABLE t1 (
1966 a varchar(200) CHARACTER SET utf8 DEFAULT NULL,
1967 KEY a_key (a(1))
1968 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1969 INSERT INTO t1 VALUES ();
1970 ALTER TABLE t1 MODIFY a text DEFAULT NULL;
1971 DROP TABLE t1;
1972 CREATE TABLE t1 (
1973 a varchar(200) CHARACTER SET utf8 DEFAULT NULL,
1974 b int,
1975 KEY a_key (b, a(1))
1976 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1977 INSERT INTO t1 VALUES ();
1978 ALTER TABLE t1 MODIFY a text DEFAULT NULL;
1979 DROP TABLE t1;
1980 CREATE TABLE t1 (
1981 a varchar(2000) CHARACTER SET utf8 DEFAULT NULL,
1982 KEY a_key (a(1))
1983 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1984 INSERT INTO t1 VALUES ();
1985 ALTER TABLE t1 MODIFY a text DEFAULT NULL;
1986 DROP TABLE t1;
1987 CREATE TABLE t1 (
1988 a varchar(2000) CHARACTER SET utf8 DEFAULT NULL,
1989 b int,
1990 KEY a_key (b, a(1))
1991 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1992 INSERT INTO t1 VALUES ();
1993 ALTER TABLE t1 MODIFY a text DEFAULT NULL;
1994 DROP TABLE t1;
1995 #
1996 # MDEV-23245 Still getting assertion failure in file data0type.cc line 67
1997 #
1998 CREATE TABLE Foo
1999 (
2000 Bar char(2) CHARACTER SET utf8,
2001 KEY Bar (Bar(1))
2002 ) ENGINE = InnoDB;
2003 ALTER TABLE Foo MODIFY Bar char(2) CHARACTER SET utf8mb4;
2004 INSERT INTO Foo VALUES ('a');
2005 DROP TABLE Foo;
2006 CREATE TABLE Foo
2007 (
2008 Bar varchar(2) CHARACTER SET utf8,
2009 KEY Bar (Bar(1))
2010 ) ENGINE = InnoDB;
2011 ALTER TABLE Foo MODIFY Bar varchar(2) CHARACTER SET utf8mb4;
2012 INSERT INTO Foo VALUES ('a');
2013 DROP TABLE Foo;
2014 CREATE TABLE Foo
2015 (
2016 Bar text CHARACTER SET utf8,
2017 KEY Bar (Bar(1))
2018 ) ENGINE = InnoDB;
2019 ALTER TABLE Foo MODIFY Bar text CHARACTER SET utf8mb4;
2020 INSERT INTO Foo VALUES ('a');
2021 DROP TABLE Foo;
2022 CREATE TABLE t1 (a VARCHAR(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
2023 PRIMARY KEY (a(1)))
2024 ENGINE=InnoDB;
2025 SHOW CREATE TABLE t1;
2026 Table Create Table
2027 t1 CREATE TABLE `t1` (
2028 `a` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
2029 PRIMARY KEY (`a`(1))
2030 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2031 ALTER TABLE t1 MODIFY a VARCHAR(2)
2032 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
2033 INSERT INTO t1 VALUES ('a');
2034 DROP TABLE t1;
2035 #
2036 # MDEV-22775 [HY000][1553] Changing name of primary key column with foreign key constraint fails.
2037 #
2038 create table t1 (id int primary key) engine=innodb default charset=utf8;
2039 create table t2 (input_id int primary key, id int not null,
2040 key a (id),
2041 constraint a foreign key (id) references t1 (id)
2042 )engine=innodb default charset=utf8;
2043 alter table t1 change id id2 int;
2044 drop table t2;
2045 drop table t1;
2046 #
2047 # MDEV-25951 MariaDB crash after ALTER TABLE convert to utf8mb4
2048 #
2049 CREATE TABLE t1 (id INT PRIMARY KEY, a VARCHAR(32), KEY (a(7))) ENGINE=INNODB DEFAULT CHARSET=UTF8;
2050 INSERT INTO t1 VALUES (1, 'a1'), (2, 'a1');
2051 ALTER TABLE t1
2052 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
2053 ADD UNIQUE INDEX test_key (a);
2054 ERROR 23000: Duplicate entry 'NULL' for key 'test_key'
2055 ALTER TABLE t1 CONVERT TO CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_520_CI;
2056 CHECK TABLE t1;
2057 Table Op Msg_type Msg_text
2058 test.t1 check status OK
2059 SELECT * FROM t1;
2060 id a
2061 1 a1
2062 2 a1
2063 DROP TABLE t1;
2064 CREATE TABLE t1 (id INT PRIMARY KEY, a CHAR(32), KEY (a(7))) ENGINE=INNODB DEFAULT CHARSET=UTF8;
2065 INSERT INTO t1 VALUES (1, 'a1'), (2, 'a1');
2066 ALTER TABLE t1
2067 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
2068 ADD UNIQUE INDEX test_key (a);
2069 ERROR 23000: Duplicate entry 'NULL' for key 'test_key'
2070 ALTER TABLE t1 CONVERT TO CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_520_CI;
2071 CHECK TABLE t1;
2072 Table Op Msg_type Msg_text
2073 test.t1 check status OK
2074 SELECT * FROM t1;
2075 id a
2076 1 a1
2077 2 a1
2078 DROP TABLE t1;