Debian Codegraph @

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

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 CREATE PROCEDURE get_index_id(IN tbl_id INT, IN idx_name char(100), OUT idx_id INT)
3 BEGIN
4 SELECT index_id into idx_id FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE
5 NAME=idx_name and TABLE_ID=tbl_id;
6 END|
7 CREATE PROCEDURE get_table_id(IN tbl_name char(100), OUT tbl_id INT)
8 BEGIN
9 SELECT table_id into tbl_id FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE
10 NAME = tbl_name;
11 END|
12 SET @tbl_id = 0;
13 SET @tbl1_id = 0;
14 SET @idx_id = 0;
15 SET @idx1_id = 0;
16 CREATE TABLE t1(f1 INT NOT NULL,
17 f2 VARCHAR(100) PRIMARY KEY)ENGINE=InnoDB;
18 CALL get_table_id("test/t1", @tbl_id);
19 ALTER TABLE t1 MODIFY f2 VARCHAR(200), ALGORITHM=INSTANT;
20 CALL get_table_id("test/t1", @tbl1_id);
21 SELECT @tbl1_id = @tbl_id;
22 @tbl1_id = @tbl_id
23 1
24 SHOW CREATE TABLE t1;
25 Table Create Table
26 t1 CREATE TABLE `t1` (
27 `f1` int(11) NOT NULL,
28 `f2` varchar(200) NOT NULL,
29 PRIMARY KEY (`f2`)
30 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
31 DROP TABLE t1;
32 CREATE TABLE t1(f1 INT NOT NULL,
33 f2 VARCHAR(100),
34 INDEX idx(f2))ENGINE=InnoDB;
35 CALL get_table_id("test/t1", @tbl_id);
36 ALTER TABLE t1 MODIFY f2 VARCHAR(200), ALGORITHM=INSTANT;
37 CALL get_table_id("test/t1", @tbl1_id);
38 SELECT @tbl1_id = @tbl_id;
39 @tbl1_id = @tbl_id
40 1
41 SHOW CREATE TABLE t1;
42 Table Create Table
43 t1 CREATE TABLE `t1` (
44 `f1` int(11) NOT NULL,
45 `f2` varchar(200) DEFAULT NULL,
46 KEY `idx` (`f2`)
47 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
48 DROP TABLE t1;
49 CREATE TABLE t1(f1 INT NOT NULL, f2 VARCHAR(100), f3 VARCHAR(100),
50 INDEX idx(f2, f3), index idx1(f3, f2))ENGINE=InnoDB;
51 CALL get_table_id("test/t1", @tbl_id);
52 CALL get_index_id(@tbl_id, "idx", @idx_id);
53 ALTER TABLE t1 MODIFY f2 VARCHAR(200), MODIFY f3 VARCHAR(150), ALGORITHM=INSTANT;
54 CALL get_table_id("test/t1", @tbl1_id);
55 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
56 SELECT @tbl1_id = @tbl_id;
57 @tbl1_id = @tbl_id
58 1
59 SELECT @idx1_id = @idx_id;
60 @idx1_id = @idx_id
61 1
62 SHOW CREATE TABLE t1;
63 Table Create Table
64 t1 CREATE TABLE `t1` (
65 `f1` int(11) NOT NULL,
66 `f2` varchar(200) DEFAULT NULL,
67 `f3` varchar(150) DEFAULT NULL,
68 KEY `idx` (`f2`,`f3`),
69 KEY `idx1` (`f3`,`f2`)
70 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
71 DROP TABLE t1;
72 CREATE TABLE t1(f1 INT NOT NULL, f2 VARCHAR(100),
73 INDEX idx(f2(40)))ENGINE=InnoDB;
74 CALL get_table_id("test/t1", @tbl_id);
75 CALL get_index_id(@tbl_id, "idx", @idx_id);
76 ALTER TABLE t1 MODIFY f2 VARCHAR(200), ALGORITHM=INSTANT;
77 CALL get_table_id("test/t1", @tbl1_id);
78 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
79 SELECT @tbl1_id = @tbl_id;
80 @tbl1_id = @tbl_id
81 1
82 SELECT @idx1_id = @idx_id;
83 @idx1_id = @idx_id
84 1
85 SHOW CREATE TABLE t1;
86 Table Create Table
87 t1 CREATE TABLE `t1` (
88 `f1` int(11) NOT NULL,
89 `f2` varchar(200) DEFAULT NULL,
90 KEY `idx` (`f2`(40))
91 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
92 DROP TABLE t1;
93 CREATE TABLE t1(f1 INT NOT NULL,
94 f2 VARCHAR(100), FULLTEXT idx(f2))ENGINE=InnoDB;
95 CALL get_table_id("test/t1", @tbl_id);
96 CALL get_index_id(@tbl_id, "idx", @idx_id);
97 ALTER TABLE t1 MODIFY f2 VARCHAR(200), ALGORITHM=INSTANT;
98 CALL get_table_id("test/t1", @tbl1_id);
99 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
100 SELECT @tbl1_id = @tbl_id;
101 @tbl1_id = @tbl_id
102 1
103 SELECT @idx1_id = @idx_id;
104 @idx1_id = @idx_id
105 1
106 SHOW CREATE TABLE t1;
107 Table Create Table
108 t1 CREATE TABLE `t1` (
109 `f1` int(11) NOT NULL,
110 `f2` varchar(200) DEFAULT NULL,
111 FULLTEXT KEY `idx` (`f2`)
112 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
113 DROP TABLE t1;
114 CREATE TABLE t1(f1 INT NOT NULL,
115 f2 VARCHAR(100),
116 f3 VARCHAR(50) as (f2) VIRTUAL,
117 INDEX idx(f3))ENGINE=InnoDB;
118 INSERT INTO t1(f1, f2) VALUES(1, repeat('a', 40));
119 CALL get_table_id("test/t1", @tbl_id);
120 CALL get_index_id(@tbl_id, "idx", @idx_id);
121 ALTER TABLE t1 MODIFY f2 VARCHAR(100), ALGORITHM=INSTANT;
122 CALL get_table_id("test/t1", @tbl1_id);
123 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
124 SELECT @tbl1_id = @tbl_id;
125 @tbl1_id = @tbl_id
126 1
127 SELECT @idx1_id = @idx_id;
128 @idx1_id = @idx_id
129 1
130 SHOW CREATE TABLE t1;
131 Table Create Table
132 t1 CREATE TABLE `t1` (
133 `f1` int(11) NOT NULL,
134 `f2` varchar(100) DEFAULT NULL,
135 `f3` varchar(50) GENERATED ALWAYS AS (`f2`) VIRTUAL,
136 KEY `idx` (`f3`)
137 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
138 DROP TABLE t1;
139 CREATE TABLE t1(f1 INT NOT NULL,
140 f2 VARCHAR(100),
141 INDEX idx(f2(10)),
142 INDEX idx1(f1))ENGINE=InnoDB;
143 CALL get_table_id("test/t1", @tbl_id);
144 CALL get_index_id(@tbl_id, "idx", @idx_id);
145 ALTER TABLE t1 MODIFY f2 VARCHAR(200), DROP INDEX idx1;
146 CALL get_table_id("test/t1", @tbl1_id);
147 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
148 SELECT @tbl1_id = @tbl_id;
149 @tbl1_id = @tbl_id
150 1
151 SELECT @idx1_id = @idx_id;
152 @idx1_id = @idx_id
153 1
154 SHOW CREATE TABLE t1;
155 Table Create Table
156 t1 CREATE TABLE `t1` (
157 `f1` int(11) NOT NULL,
158 `f2` varchar(200) DEFAULT NULL,
159 KEY `idx` (`f2`(10))
160 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
161 DROP TABLE t1;
162 CREATE TABLE t1(f1 INT NOT NULL,
163 f2 VARCHAR(100),
164 INDEX idx(f2(10)))ENGINE=InnoDB;
165 CALL get_table_id("test/t1", @tbl_id);
166 CALL get_index_id(@tbl_id, "idx", @idx_id);
167 ALTER TABLE t1 MODIFY f2 VARCHAR(200), DROP INDEX idx, ADD INDEX idx(f2(10)), ALGORITHM=INSTANT;
168 CALL get_table_id("test/t1", @tbl1_id);
169 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
170 SELECT @tbl1_id = @tbl_id;
171 @tbl1_id = @tbl_id
172 1
173 SELECT @idx1_id = @idx_id;
174 @idx1_id = @idx_id
175 1
176 SHOW CREATE TABLE t1;
177 Table Create Table
178 t1 CREATE TABLE `t1` (
179 `f1` int(11) NOT NULL,
180 `f2` varchar(200) DEFAULT NULL,
181 KEY `idx` (`f2`(10))
182 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
183 DROP TABLE t1;
184 CREATE TABLE t1(f1 INT NOT NULL,
185 f2 VARCHAR(100),
186 INDEX idx(f2(10)))ENGINE=InnoDB;
187 CALL get_table_id("test/t1", @tbl_id);
188 CALL get_index_id(@tbl_id, "idx", @idx_id);
189 ALTER TABLE t1 MODIFY f2 VARCHAR(200), DROP INDEX idx, ADD INDEX idx(f2(50));
190 CALL get_table_id("test/t1", @tbl1_id);
191 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
192 SELECT @tbl1_id = @tbl_id;
193 @tbl1_id = @tbl_id
194 1
195 SELECT @idx1_id = @idx_id;
196 @idx1_id = @idx_id
197 0
198 SHOW CREATE TABLE t1;
199 Table Create Table
200 t1 CREATE TABLE `t1` (
201 `f1` int(11) NOT NULL,
202 `f2` varchar(200) DEFAULT NULL,
203 KEY `idx` (`f2`(50))
204 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
205 DROP TABLE t1;
206 CREATE TABLE t1(f1 INT NOT NULL,
207 f2 VARCHAR(100),
208 INDEX idx(f2(100)))ENGINE=InnoDB;
209 CALL get_table_id("test/t1", @tbl_id);
210 CALL get_index_id(@tbl_id, "idx", @idx_id);
211 ALTER TABLE t1 MODIFY f2 VARCHAR(200), ADD INDEX idx1(f1);
212 CALL get_table_id("test/t1", @tbl1_id);
213 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
214 SELECT @tbl1_id = @tbl_id;
215 @tbl1_id = @tbl_id
216 1
217 SELECT @idx1_id = @idx_id;
218 @idx1_id = @idx_id
219 1
220 SHOW CREATE TABLE t1;
221 Table Create Table
222 t1 CREATE TABLE `t1` (
223 `f1` int(11) NOT NULL,
224 `f2` varchar(200) DEFAULT NULL,
225 KEY `idx` (`f2`),
226 KEY `idx1` (`f1`)
227 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
228 DROP TABLE t1;
229 CREATE TABLE t1(f1 INT NOT NULL,
230 f2 VARCHAR(100),
231 INDEX idx(f2(10)))ENGINE=InnoDB;
232 CALL get_table_id("test/t1", @tbl_id);
233 CALL get_index_id(@tbl_id, "idx", @idx_id);
234 ALTER TABLE t1 MODIFY f2 VARCHAR(200), DROP INDEX idx, ADD INDEX idx(f2(6));
235 CALL get_table_id("test/t1", @tbl1_id);
236 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
237 SELECT @tbl1_id = @tbl_id;
238 @tbl1_id = @tbl_id
239 1
240 SELECT @idx1_id = @idx_id;
241 @idx1_id = @idx_id
242 0
243 SHOW CREATE TABLE t1;
244 Table Create Table
245 t1 CREATE TABLE `t1` (
246 `f1` int(11) NOT NULL,
247 `f2` varchar(200) DEFAULT NULL,
248 KEY `idx` (`f2`(6))
249 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
250 DROP TABLE t1;
251 CREATE TABLE t1(f1 INT NOT NULL,
252 f2 VARCHAR(100),
253 INDEX idx(f2))ENGINE=InnoDB;
254 CALL get_table_id("test/t1", @tbl_id);
255 ALTER TABLE t1 MODIFY f2 VARCHAR(200), ADD COLUMN f3 INT, ALGORITHM=INSTANT;
256 CALL get_table_id("test/t1", @tbl1_id);
257 SELECT @tbl1_id = @tbl_id;
258 @tbl1_id = @tbl_id
259 1
260 SHOW CREATE TABLE t1;
261 Table Create Table
262 t1 CREATE TABLE `t1` (
263 `f1` int(11) NOT NULL,
264 `f2` varchar(200) DEFAULT NULL,
265 `f3` int(11) DEFAULT NULL,
266 KEY `idx` (`f2`)
267 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
268 DROP TABLE t1;
269 CREATE TABLE t1(f1 INT NOT NULL, f2 VARCHAR(100) PRIMARY KEY)ENGINE=InnoDB;
270 CALL get_table_id("test/t1", @tbl_id);
271 ALTER TABLE t1 MODIFY f2 VARCHAR(200), ADD COLUMN f3 INT, ALGORITHM=INSTANT;
272 CALL get_table_id("test/t1", @tbl1_id);
273 SELECT @tbl1_id = @tbl_id;
274 @tbl1_id = @tbl_id
275 1
276 SHOW CREATE TABLE t1;
277 Table Create Table
278 t1 CREATE TABLE `t1` (
279 `f1` int(11) NOT NULL,
280 `f2` varchar(200) NOT NULL,
281 `f3` int(11) DEFAULT NULL,
282 PRIMARY KEY (`f2`)
283 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
284 DROP TABLE t1;
285 CREATE TABLE t1(f1 INT NOT NULL, f2 VARCHAR(100))ENGINE=INNODB;
286 CALL get_table_id("test/t1", @tbl_id);
287 ALTER TABLE t1 MODIFY f2 VARCHAR(200), ADD FULLTEXT idx(f2);
288 CALL get_table_id("test/t1", @tbl1_id);
289 SELECT @tbl1_id = @tbl_id;
290 @tbl1_id = @tbl_id
291 0
292 SHOW CREATE TABLE t1;
293 Table Create Table
294 t1 CREATE TABLE `t1` (
295 `f1` int(11) NOT NULL,
296 `f2` varchar(200) DEFAULT NULL,
297 FULLTEXT KEY `idx` (`f2`)
298 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
299 DROP TABLE t1;
300 CREATE TABLE t1(f1 INT NOT NULL,
301 f2 CHAR(100) PRIMARY KEY)ENGINE=InnoDB;
302 CALL get_table_id("test/t1", @tbl_id);
303 ALTER TABLE t1 MODIFY f2 CHAR(200);
304 CALL get_table_id("test/t1", @tbl1_id);
305 SELECT @tbl1_id = @tbl_id;
306 @tbl1_id = @tbl_id
307 0
308 SHOW CREATE TABLE t1;
309 Table Create Table
310 t1 CREATE TABLE `t1` (
311 `f1` int(11) NOT NULL,
312 `f2` char(200) NOT NULL,
313 PRIMARY KEY (`f2`)
314 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
315 DROP TABLE t1;
316 CREATE TABLE t1(f1 INT NOT NULL,
317 f2 VARCHAR(100),
318 INDEX idx(f2(10)),
319 INDEX idx1(f1))ENGINE=InnoDB;
320 CALL get_table_id("test/t1", @tbl_id);
321 ALTER TABLE t1 MODIFY f2 VARCHAR(50);
322 CALL get_table_id("test/t1", @tbl1_id);
323 SELECT @tbl1_id = @tbl_id;
324 @tbl1_id = @tbl_id
325 0
326 SHOW CREATE TABLE t1;
327 Table Create Table
328 t1 CREATE TABLE `t1` (
329 `f1` int(11) NOT NULL,
330 `f2` varchar(50) DEFAULT NULL,
331 KEY `idx` (`f2`(10)),
332 KEY `idx1` (`f1`)
333 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
334 DROP TABLE t1;
335 CREATE TABLE t1(f1 INT NOT NULL,
336 f2 VARCHAR(100),
337 INDEX idx(f2(10)),
338 INDEX idx1(f1))ENGINE=InnoDB;
339 CALL get_table_id("test/t1", @tbl_id);
340 ALTER TABLE t1 MODIFY f2 VARCHAR(5), DROP INDEX idx1;
341 CALL get_table_id("test/t1", @tbl1_id);
342 SELECT @tbl1_id = @tbl_id;
343 @tbl1_id = @tbl_id
344 0
345 SHOW CREATE TABLE t1;
346 Table Create Table
347 t1 CREATE TABLE `t1` (
348 `f1` int(11) NOT NULL,
349 `f2` varchar(5) DEFAULT NULL,
350 KEY `idx` (`f2`)
351 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
352 DROP TABLE t1;
353 CREATE TABLE t1(f1 INT NOT NULL,
354 f2 VARCHAR(100), FULLTEXT idx(f2))ENGINE=InnoDB;
355 CALL get_table_id("test/t1", @tbl_id);
356 CALL get_index_id(@tbl_id, "idx", @idx_id);
357 ALTER TABLE t1 MODIFY f2 VARCHAR(50);
358 CALL get_table_id("test/t1", @tbl1_id);
359 CALL get_index_id(@tbl1_id, "idx", @idx1_id);
360 SELECT @tbl1_id = @tbl_id;
361 @tbl1_id = @tbl_id
362 0
363 SELECT @idx1_id = @idx_id;
364 @idx1_id = @idx_id
365 0
366 SHOW CREATE TABLE t1;
367 Table Create Table
368 t1 CREATE TABLE `t1` (
369 `f1` int(11) NOT NULL,
370 `f2` varchar(50) DEFAULT NULL,
371 FULLTEXT KEY `idx` (`f2`)
372 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
373 DROP TABLE t1;
374 CREATE TABLE t1(f1 INT NOT NULL,
375 f2 VARCHAR(100),
376 INDEX idx(f2))ENGINE=InnoDB;
377 CALL get_table_id("test/t1", @tbl_id);
378 ALTER TABLE t1 MODIFY f2 CHAR(200);
379 CALL get_table_id("test/t1", @tbl1_id);
380 SELECT @tbl1_id = @tbl_id;
381 @tbl1_id = @tbl_id
382 0
383 SHOW CREATE TABLE t1;
384 Table Create Table
385 t1 CREATE TABLE `t1` (
386 `f1` int(11) NOT NULL,
387 `f2` char(200) DEFAULT NULL,
388 KEY `idx` (`f2`)
389 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
390 DROP TABLE t1;
391 CREATE TABLE t1(f1 INT NOT NULL,
392 f2 VARCHAR(100),
393 INDEX idx(f2(40)))ENGINE=InnoDB;
394 CALL get_table_id("test/t1", @tbl_id);
395 ALTER TABLE t1 MODIFY f2 TEXT;
396 CALL get_table_id("test/t1", @tbl1_id);
397 SELECT @tbl1_id = @tbl_id;
398 @tbl1_id = @tbl_id
399 0
400 SHOW CREATE TABLE t1;
401 Table Create Table
402 t1 CREATE TABLE `t1` (
403 `f1` int(11) NOT NULL,
404 `f2` text DEFAULT NULL,
405 KEY `idx` (`f2`(40))
406 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
407 DROP TABLE t1;
408 CREATE TABLE t1(f1 INT NOT NULL,
409 f2 VARCHAR(100),
410 INDEX idx(f2(40)))ENGINE=InnoDB;
411 CALL get_table_id("test/t1", @tbl_id);
412 ALTER TABLE t1 MODIFY f2 VARCHAR(300);
413 CALL get_table_id("test/t1", @tbl1_id);
414 SELECT @tbl1_id = @tbl_id;
415 @tbl1_id = @tbl_id
416 1
417 SHOW CREATE TABLE t1;
418 Table Create Table
419 t1 CREATE TABLE `t1` (
420 `f1` int(11) NOT NULL,
421 `f2` varchar(300) DEFAULT NULL,
422 KEY `idx` (`f2`(40))
423 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
424 DROP TABLE t1;
425 CREATE TABLE t1(f1 INT NOT NULL,
426 f2 VARCHAR(128),
427 INDEX idx(f2(40)))ENGINE=InnoDB;
428 CALL get_table_id("test/t1", @tbl_id);
429 ALTER TABLE t1 MODIFY f2 VARCHAR(300);
430 CALL get_table_id("test/t1", @tbl1_id);
431 SELECT @tbl1_id = @tbl_id;
432 @tbl1_id = @tbl_id
433 0
434 SHOW CREATE TABLE t1;
435 Table Create Table
436 t1 CREATE TABLE `t1` (
437 `f1` int(11) NOT NULL,
438 `f2` varchar(300) DEFAULT NULL,
439 KEY `idx` (`f2`(40))
440 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
441 DROP TABLE t1;
442 CREATE TABLE t1(f1 INT NOT NULL,
443 f2 VARCHAR(128),
444 INDEX idx(f2(40)))ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
445 CALL get_table_id("test/t1", @tbl_id);
446 ALTER TABLE t1 MODIFY f2 VARCHAR(300);
447 CALL get_table_id("test/t1", @tbl1_id);
448 SELECT @tbl1_id = @tbl_id;
449 @tbl1_id = @tbl_id
450 1
451 SHOW CREATE TABLE t1;
452 Table Create Table
453 t1 CREATE TABLE `t1` (
454 `f1` int(11) NOT NULL,
455 `f2` varchar(300) DEFAULT NULL,
456 KEY `idx` (`f2`(40))
457 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=REDUNDANT
458 DROP TABLE t1;
459 CREATE TABLE t1(f1 INT NOT NULL,
460 f2 VARCHAR(100),
461 INDEX idx(f2(40)))ENGINE=InnoDB;
462 CALL get_table_id("test/t1", @tbl_id);
463 ALTER TABLE t1 MODIFY f2 VARCHAR(200) CHARACTER SET UTF16;
464 CALL get_table_id("test/t1", @tbl1_id);
465 SELECT @tbl1_id = @tbl_id;
466 @tbl1_id = @tbl_id
467 0
468 SHOW CREATE TABLE t1;
469 Table Create Table
470 t1 CREATE TABLE `t1` (
471 `f1` int(11) NOT NULL,
472 `f2` varchar(200) CHARACTER SET utf16 COLLATE utf16_uca1400_ai_ci DEFAULT NULL,
473 KEY `idx` (`f2`(40))
474 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
475 DROP TABLE t1;
476 CREATE TABLE t1(f1 INT NOT NULL,
477 f2 VARCHAR(100),
478 f3 VARCHAR(50) as (f2) VIRTUAL,
479 INDEX idx(f3))ENGINE=InnoDB;
480 # If varchar virtual column extension is allowed in the future then
481 # InnoDB must rebuild the index
482 ALTER TABLE t1 MODIFY f3 VARCHAR(100);
483 ERROR HY000: This is not yet supported for generated columns
484 SHOW CREATE TABLE t1;
485 Table Create Table
486 t1 CREATE TABLE `t1` (
487 `f1` int(11) NOT NULL,
488 `f2` varchar(100) DEFAULT NULL,
489 `f3` varchar(50) GENERATED ALWAYS AS (`f2`) VIRTUAL,
490 KEY `idx` (`f3`)
491 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
492 DROP TABLE t1;
493 DROP PROCEDURE get_index_id;
494 DROP PROCEDURE get_table_id;
495 create table t (a varchar(100)) engine=innodb;
496 select sc.name, sc.pos, sc.mtype, sc.prtype, sc.len
497 from information_schema.innodb_sys_columns sc
498 inner join information_schema.innodb_sys_tables st
499 on sc.table_id=st.table_id where st.name='test/t' and sc.name='a';
500 name pos mtype prtype len
501 a 0 1 524303 100
502 alter table t modify a varchar(110), algorithm=inplace;
503 select sc.name, sc.pos, sc.mtype, sc.prtype, sc.len
504 from information_schema.innodb_sys_columns sc
505 inner join information_schema.innodb_sys_tables st
506 on sc.table_id=st.table_id where st.name='test/t' and sc.name='a';
507 name pos mtype prtype len
508 a 0 1 524303 110
509 drop table t;
510 # End of 10.2 tests
511 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;