Debian Codegraph @

mysql-test/suite/innodb/r/innodb-32k.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 SET GLOBAL innodb_stats_persistent = 0;
3 call mtr.add_suppression("Innodb: Cannot add field.*row size is");
4 SET SESSION innodb_strict_mode=ON;
5 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
6 ERROR HY000: Can't create table `test`.`t1` (errno: 140 "Wrong create options")
7 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB KEY_BLOCK_SIZE=4;
8 ERROR HY000: Can't create table `test`.`t1` (errno: 140 "Wrong create options")
9 SET SESSION innodb_strict_mode=OFF;
10 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
11 Warnings:
12 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
13 SHOW WARNINGS;
14 Level Code Message
15 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
16 DROP TABLE t1;
17 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB KEY_BLOCK_SIZE=4;
18 Warnings:
19 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
20 SHOW WARNINGS;
21 Level Code Message
22 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
23 DROP TABLE t1;
24 # Test 1) Show the page size from Information Schema
25 SELECT variable_value FROM information_schema.global_status
26 WHERE LOWER(variable_name) = 'innodb_page_size';
27 variable_value
28 32768
29 # Test 4) The maximum row size is dependent upon the page size.
30 # Redundant: 16315, Compact: 16318.
31 # Compressed: 16318, Dynamic: ?.
32 # Each row format has its own amount of overhead that
33 # varies depending on number of fields and other overhead.
34 SET SESSION innodb_strict_mode = ON;
35 CREATE TABLE t1 (
36 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
37 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
38 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
39 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
40 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
41 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
42 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
43 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
44 c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
45 c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
46 c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
47 c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
48 c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
49 c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
50 c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
51 c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
52 c81 char(63)
53 ) ROW_FORMAT=compressed;
54 Got one of the listed errors
55 CREATE TABLE t1 (a varchar(255) character set utf8,
56 b varchar(255) character set utf8,
57 c varchar(255) character set utf8,
58 d varchar(255) character set utf8,
59 e varchar(4) character set utf8,
60 PRIMARY KEY (a,b,c,d,e))
61 ENGINE=innodb;
62 DROP TABLE t1;
63 CREATE TABLE t1 (a varchar(255) character set utf8,
64 b varchar(255) character set utf8,
65 c varchar(255) character set utf8,
66 d varchar(255) character set utf8,
67 e varchar(5) character set utf8,
68 PRIMARY KEY (a,b,c,d,e))
69 ENGINE=innodb;
70 ERROR 42000: Specified key was too long; max key length is 3072 bytes
71 CREATE TABLE t1 (a varchar(255) character set utf8,
72 b varchar(255) character set utf8,
73 c varchar(255) character set utf8,
74 d varchar(255) character set utf8,
75 e varchar(255) character set utf8,
76 f varchar(4) character set utf8,
77 PRIMARY KEY (a), KEY (b,c,d,e,f))
78 ENGINE=innodb;
79 DROP TABLE t1;
80 CREATE TABLE t1 (a varchar(255) character set utf8,
81 b varchar(255) character set utf8,
82 c varchar(255) character set utf8,
83 d varchar(255) character set utf8,
84 e varchar(255) character set utf8,
85 f varchar(5) character set utf8,
86 PRIMARY KEY (a), KEY (b,c,d,e,f))
87 ENGINE=innodb;
88 ERROR 42000: Specified key was too long; max key length is 3072 bytes
89 # Test 8) Test creating a table that could lead to undo log overflow.
90 CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
91 h blob,i blob,j blob,k blob,l blob,m blob,n blob,
92 o blob,p blob,q blob,r blob,s blob,t blob,u blob,
93 v blob, w blob, x blob, y blob, z blob,
94 aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob,
95 ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob,
96 oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob,
97 va blob, wa blob, xa blob, ya blob, za blob)
98 ENGINE=InnoDB ROW_FORMAT=dynamic;
99 SET @a = repeat('a', 767);
100 SET @b = repeat('b', 767);
101 SET @c = repeat('c', 767);
102 SET @d = repeat('d', 767);
103 SET @e = repeat('e', 767);
104 INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
105 UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
106 k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b,
107 v=@b,w=@b,x=@b,y=@b,z=@b,
108 aa=@b,ba=@b,ca=@b,da=@b,ea=@b,fa=@b,ga=@b,ha=@b,ia=@b,ja=@b,
109 ka=@b,la=@b,ma=@b,na=@b,oa=@b,pa=@b,qa=@b,ra=@b,sa=@b,ta=@b,ua=@b,
110 va=@b,wa=@b,xa=@b,ya=@b,za=@b;
111 CREATE INDEX t1a ON t1 (a(767));
112 CREATE INDEX t1b ON t1 (b(767));
113 CREATE INDEX t1c ON t1 (c(767));
114 CREATE INDEX t1d ON t1 (d(767));
115 CREATE INDEX t1e ON t1 (e(767));
116 CREATE INDEX t1f1 ON t1 (f(767));
117 CREATE INDEX t1f2 ON t1 (g(767));
118 CREATE INDEX t1f3 ON t1 (h(767));
119 CREATE INDEX t1f4 ON t1 (i(767));
120 CREATE INDEX t1f5 ON t1 (j(767));
121 UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
122 k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c,
123 v=@c,w=@c,x=@c,y=@c,z=@c,
124 aa=@c,ba=@c,ca=@c,da=@c,ea=@c,fa=@c,ga=@c,ha=@c,ia=@c,ja=@c,
125 ka=@c,la=@c,ma=@c,na=@c,oa=@c,pa=@c,qa=@c,ra=@c,sa=@c,ta=@c,ua=@c,
126 va=@c,wa=@c,xa=@c,ya=@c,za=@c;
127 CREATE INDEX t1f17 ON t1 (v(767));
128 BEGIN;
129 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d,f=@d,g=@d,h=@d,i=@d,j=@d,
130 k=@d,l=@d,m=@d,n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d,
131 v=@d,w=@d,x=@d,y=@d,z=@d,
132 aa=@d,ba=@d,ca=@d,da=@d,ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d,
133 ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d,qa=@d,ra=@d,sa=@d,ta=@d,ua=@d,
134 va=@d,wa=@d,xa=@d,ya=@d,za=@d;
135 ROLLBACK;
136 BEGIN;
137 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d;
138 UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d;
139 UPDATE t1 SET k=@d,l=@d,m=@d,n=@d,o=@d;
140 UPDATE t1 SET p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
141 UPDATE t1 SET v=@d,w=@d,x=@d,y=@d,z=@d;
142 UPDATE t1 SET aa=@d,ba=@d,ca=@d,da=@d;
143 UPDATE t1 SET ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d;
144 UPDATE t1 SET ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d;
145 UPDATE t1 SET qa=@d,ra=@d,sa=@d,ta=@d,ua=@d;
146 UPDATE t1 SET va=@d,wa=@d,xa=@d,ya=@d,za=@d;
147 COMMIT;
148 CREATE INDEX t1k ON t1 (k(767));
149 CREATE INDEX t1f7 ON t1 (m(767));
150 CREATE INDEX t1f8 ON t1 (n(767));
151 CREATE INDEX t1f9 ON t1 (o(767));
152 CREATE INDEX t1f11 ON t1 (p(767));
153 CREATE INDEX t1f12 ON t1 (q(767));
154 CREATE INDEX t1f13 ON t1 (r(767));
155 CREATE INDEX t1f14 ON t1 (s(767));
156 CREATE INDEX t1f15 ON t1 (t(767));
157 CREATE INDEX t1f16 ON t1 (u(767));
158 CREATE INDEX t1f18 ON t1 (w(767));
159 CREATE INDEX t1f19 ON t1 (x(767));
160 CREATE INDEX t1f20 ON t1 (y(767));
161 CREATE INDEX t1f21 ON t1 (z(767));
162 CREATE INDEX ta1a ON t1 (aa(767));
163 CREATE INDEX tb1b ON t1 (ba(767));
164 CREATE INDEX tc1c ON t1 (ca(767));
165 CREATE INDEX td1d ON t1 (da(767));
166 CREATE INDEX te1e ON t1 (ea(767));
167 CREATE INDEX tf1f1 ON t1 (fa(767));
168 CREATE INDEX tg1f2 ON t1 (ga(767));
169 CREATE INDEX th1f3 ON t1 (ha(767));
170 CREATE INDEX ti1f4 ON t1 (ia(767));
171 CREATE INDEX tj1f5 ON t1 (ka(767));
172 CREATE INDEX tk1f6 ON t1 (la(767));
173 CREATE INDEX tl1f7 ON t1 (ma(767));
174 CREATE INDEX tm1f8 ON t1 (na(767));
175 CREATE INDEX tn1f9 ON t1 (oa(767));
176 CREATE INDEX to1f11 ON t1 (pa(767));
177 UPDATE t1 SET t=@e;
178 CREATE INDEX t1f6 ON t1 (l(767));
179 drop table t1;
180 Test an assertion failure on purge.
181 CREATE TABLE t1_purge (
182 A int,
183 B blob, C blob, D blob, E blob,
184 F blob, G blob, H blob,
185 PRIMARY KEY (B(767), C(767), D(767), E(767), A),
186 INDEX (A)
187 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
188 INSERT INTO t1_purge VALUES (1,
189 REPEAT('b', 766), REPEAT('c', 766), REPEAT('d', 766), REPEAT('e', 766),
190 REPEAT('f', 766), REPEAT('g', 766), REPEAT('h', 766));
191 CREATE TABLE t2_purge (
192 A int PRIMARY KEY,
193 B blob, C blob, D blob, E blob,
194 F blob, G blob, H blob, I blob,
195 J blob, K blob, L blob,
196 INDEX (B(767))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
197 INSERT INTO t2_purge VALUES (1,
198 REPEAT('b', 766), REPEAT('c', 766), REPEAT('d', 766), REPEAT('e', 766),
199 REPEAT('f', 766), REPEAT('g', 766), REPEAT('h', 766), REPEAT('i', 766),
200 REPEAT('j', 766), REPEAT('k', 766), REPEAT('l', 766));
201 CREATE TABLE t3_purge (
202 A int,
203 B varchar(800), C varchar(800), D varchar(800), E varchar(800),
204 F varchar(800), G varchar(800), H varchar(800),
205 PRIMARY KEY (B(767), C(767), D(767), E(767), A),
206 INDEX (A)
207 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
208 INSERT INTO t3_purge SELECT * FROM t1_purge;
209 CREATE TABLE t4_purge (
210 A int PRIMARY KEY,
211 B varchar(800), C varchar(800), D varchar(800), E varchar(800),
212 F varchar(800), G varchar(800), H varchar(800), I varchar(800),
213 J varchar(800), K varchar(800), L varchar(800),
214 INDEX (B(767))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
215 INSERT INTO t4_purge SELECT * FROM t2_purge;
216 DELETE FROM t1_purge;
217 DELETE FROM t2_purge;
218 DELETE FROM t3_purge;
219 DELETE FROM t4_purge;
220 SET @r=REPEAT('a',500);
221 CREATE TABLE tlong(a int,
222 v1 varchar(500), v2 varchar(500), v3 varchar(500),
223 v4 varchar(500), v5 varchar(500), v6 varchar(500),
224 v7 varchar(500), v8 varchar(500), v9 varchar(500),
225 v10 varchar(500), v11 varchar(500), v12 varchar(500),
226 v13 varchar(500), v14 varchar(500), v15 varchar(500),
227 v16 varchar(500), v17 varchar(500), v18 varchar(500)
228 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
229 CREATE INDEX idx1 ON tlong(a,v1);
230 INSERT INTO tlong VALUES(9,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r);
231 UPDATE tlong SET a=1000;
232 DELETE FROM tlong;
233 CREATE TABLE tlong2(a blob,b blob,c blob,d blob,e blob,f blob,g blob,h blob,
234 i blob,j blob,k blob,l blob,m blob,n blob,o blob,p blob)
235 ENGINE=innodb ROW_FORMAT=dynamic;
236 SET @r = REPEAT('a', 767);
237 INSERT INTO tlong2 VALUES (@r,@r,@r,@r, @r,@r,@r,@r, @r,@r,@r,@r, @r,@r,@r,@r);
238 CREATE INDEX ndx_a ON tlong2 (a(500));
239 CREATE INDEX ndx_b ON tlong2 (b(500));
240 CREATE INDEX ndx_c ON tlong2 (c(500));
241 CREATE INDEX ndx_d ON tlong2 (d(500));
242 CREATE INDEX ndx_e ON tlong2 (e(500));
243 CREATE INDEX ndx_f ON tlong2 (f(500));
244 CREATE INDEX ndx_k ON tlong2 (k(500));
245 CREATE INDEX ndx_l ON tlong2 (l(500));
246 SET @r = REPEAT('b', 500);
247 UPDATE tlong2 set a=@r,b=@r,c=@r,d=@r;
248 UPDATE tlong2 set e=@r,f=@r,g=@r,h=@r;
249 UPDATE tlong2 set i=@r,j=@r,k=@r,l=@r;
250 UPDATE tlong2 set m=@r,n=@r,o=@r,p=@r;
251 ALTER TABLE tlong2 DROP INDEX ndx_a;
252 ALTER TABLE tlong2 DROP INDEX ndx_b;
253 CREATE INDEX ndx_g ON tlong2 (g(500));
254 CREATE INDEX ndx_h ON tlong2 (h(500));
255 CREATE INDEX ndx_i ON tlong2 (i(500));
256 CREATE INDEX ndx_j ON tlong2 (j(500));
257 CREATE INDEX ndx_m ON tlong2 (m(500));
258 CREATE INDEX ndx_n ON tlong2 (n(500));
259 CREATE INDEX ndx_o ON tlong2 (o(500));
260 CREATE INDEX ndx_p ON tlong2 (p(500));
261 SHOW CREATE TABLE tlong2;
262 Table Create Table
263 tlong2 CREATE TABLE `tlong2` (
264 `a` blob DEFAULT NULL,
265 `b` blob DEFAULT NULL,
266 `c` blob DEFAULT NULL,
267 `d` blob DEFAULT NULL,
268 `e` blob DEFAULT NULL,
269 `f` blob DEFAULT NULL,
270 `g` blob DEFAULT NULL,
271 `h` blob DEFAULT NULL,
272 `i` blob DEFAULT NULL,
273 `j` blob DEFAULT NULL,
274 `k` blob DEFAULT NULL,
275 `l` blob DEFAULT NULL,
276 `m` blob DEFAULT NULL,
277 `n` blob DEFAULT NULL,
278 `o` blob DEFAULT NULL,
279 `p` blob DEFAULT NULL,
280 KEY `ndx_c` (`c`(500)),
281 KEY `ndx_d` (`d`(500)),
282 KEY `ndx_e` (`e`(500)),
283 KEY `ndx_f` (`f`(500)),
284 KEY `ndx_k` (`k`(500)),
285 KEY `ndx_l` (`l`(500)),
286 KEY `ndx_g` (`g`(500)),
287 KEY `ndx_h` (`h`(500)),
288 KEY `ndx_i` (`i`(500)),
289 KEY `ndx_j` (`j`(500)),
290 KEY `ndx_m` (`m`(500)),
291 KEY `ndx_n` (`n`(500)),
292 KEY `ndx_o` (`o`(500)),
293 KEY `ndx_p` (`p`(500))
294 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
295 SET SESSION innodb_strict_mode = ON;
296 CREATE TABLE t3(
297 a int NOT NULL, b blob NOT NULL, c text,
298 PRIMARY KEY (b(10), a), INDEX (c(767)), INDEX(b(767))
299 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
300 INSERT INTO t3 VALUES (5,REPEAT('khdfo5AlOq',1900),REPEAT('g',7751));
301 COMMIT;
302 UPDATE t3 SET c = REPEAT('b',16928);
303 SHOW WARNINGS;
304 Level Code Message
305 UPDATE t3 SET c = REPEAT('b',32800);
306 SHOW WARNINGS;
307 Level Code Message
308 InnoDB 0 transactions not purged
309 DROP TABLE t3;
310 DROP TABLE t1_purge, t2_purge, t3_purge, t4_purge;
311 DROP TABLE tlong;
312 DROP TABLE tlong2;
313 CREATE TABLE t2(COL1 TEXT,
314 COL2 TEXT,
315 COL3 TEXT,
316 COL4 TEXT,
317 COL5 TEXT,
318 COL6 TEXT,
319 COL7 TEXT,
320 COL8 TEXT,
321 COL9 TEXT,
322 COL10 TEXT,
323 COL11 TEXT,
324 COL12 TEXT,
325 COL13 TEXT,
326 COL14 TEXT,
327 COL15 TEXT,
328 COL16 TEXT,
329 COL17 TEXT,
330 COL18 TEXT,
331 COL19 TEXT,
332 COL20 TEXT,
333 COL21 TEXT,
334 COL22 TEXT,
335 COL23 TEXT,
336 COL24 TEXT,
337 COL25 TEXT,
338 COL26 TEXT,
339 COL27 TEXT,
340 COL28 TEXT,
341 COL29 TEXT,
342 COL30 TEXT,
343 COL31 TEXT,
344 COL32 TEXT,
345 COL33 TEXT,
346 COL34 TEXT,
347 COL35 TEXT,
348 COL36 TEXT,
349 COL37 TEXT,
350 COL38 TEXT,
351 COL39 TEXT,
352 COL40 TEXT,
353 COL41 TEXT,
354 COL42 TEXT,
355 COL43 TEXT,
356 COL44 TEXT,
357 COL45 TEXT,
358 COL46 TEXT,
359 COL47 TEXT,
360 COL48 TEXT,
361 COL49 TEXT,
362 COL50 TEXT,
363 COL51 TEXT,
364 COL52 TEXT,
365 COL53 TEXT,
366 COL54 TEXT,
367 COL55 TEXT,
368 COL56 TEXT,
369 COL57 TEXT,
370 COL58 TEXT,
371 COL59 TEXT,
372 COL60 TEXT,
373 COL61 TEXT,
374 COL62 TEXT,
375 COL63 TEXT,
376 COL64 TEXT,
377 COL65 TEXT,
378 COL66 TEXT,
379 COL67 TEXT,
380 COL68 TEXT,
381 COL69 TEXT,
382 COL70 TEXT,
383 COL71 TEXT,
384 COL72 TEXT,
385 COL73 TEXT,
386 COL74 TEXT,
387 COL75 TEXT,
388 COL76 TEXT,
389 COL77 TEXT,
390 COL78 TEXT,
391 COL79 TEXT,
392 COL80 TEXT,
393 COL81 TEXT,
394 COL82 TEXT,
395 COL83 TEXT,
396 COL84 TEXT,
397 COL85 TEXT,
398 COL86 TEXT,
399 COL87 TEXT,
400 COL88 TEXT,
401 COL89 TEXT,
402 COL90 TEXT,
403 COL91 TEXT,
404 COL92 TEXT,
405 COL93 TEXT,
406 COL94 TEXT,
407 COL95 TEXT,
408 COL96 TEXT,
409 COL97 TEXT,
410 COL98 TEXT,
411 COL99 TEXT,
412 COL100 TEXT,
413 COL101 TEXT,
414 COL102 TEXT,
415 COL103 TEXT,
416 COL104 TEXT,
417 COL105 TEXT,
418 COL106 TEXT,
419 COL107 TEXT,
420 COL108 TEXT,
421 COL109 TEXT,
422 COL110 TEXT,
423 COL111 TEXT,
424 COL112 TEXT,
425 COL113 TEXT,
426 COL114 TEXT,
427 COL115 TEXT,
428 COL116 TEXT,
429 COL117 TEXT,
430 COL118 TEXT,
431 COL119 TEXT,
432 COL120 TEXT,
433 COL121 TEXT,
434 COL122 TEXT,
435 COL123 TEXT,
436 COL124 TEXT,
437 COL125 TEXT,
438 COL126 TEXT,
439 COL127 TEXT,
440 COL128 TEXT,
441 COL129 TEXT,
442 COL130 TEXT,
443 COL131 TEXT,
444 COL132 TEXT,
445 COL133 TEXT,
446 COL134 TEXT,
447 COL135 TEXT,
448 COL136 TEXT,
449 COL137 TEXT,
450 COL138 TEXT,
451 COL139 TEXT,
452 COL140 TEXT,
453 COL141 TEXT,
454 COL142 TEXT,
455 COL143 TEXT,
456 COL144 TEXT,
457 COL145 TEXT,
458 COL146 TEXT,
459 COL147 TEXT,
460 COL148 TEXT,
461 COL149 TEXT,
462 COL150 TEXT,
463 COL151 TEXT,
464 COL152 TEXT,
465 COL153 TEXT,
466 COL154 TEXT,
467 COL155 TEXT,
468 COL156 TEXT,
469 COL157 TEXT,
470 COL158 TEXT,
471 COL159 TEXT,
472 COL160 TEXT,
473 COL161 TEXT,
474 COL162 TEXT,
475 COL163 TEXT,
476 COL164 TEXT,
477 COL165 TEXT,
478 COL166 TEXT,
479 COL167 TEXT,
480 COL168 TEXT,
481 COL169 TEXT,
482 COL170 TEXT,
483 COL171 TEXT,
484 COL172 TEXT,
485 COL173 TEXT,
486 COL174 TEXT,
487 COL175 TEXT,
488 COL176 TEXT,
489 COL177 TEXT,
490 COL178 TEXT,
491 COL179 TEXT,
492 COL180 TEXT,
493 COL181 TEXT,
494 COL182 TEXT,
495 COL183 TEXT,
496 COL184 TEXT,
497 COL185 TEXT,
498 COL186 TEXT,
499 COL187 TEXT,
500 COL188 TEXT,
501 COL189 TEXT,
502 COL190 TEXT,
503 COL191 TEXT,
504 COL192 TEXT,
505 COL193 TEXT,
506 COL194 TEXT,
507 COL195 TEXT,
508 COL196 TEXT,
509 COL197 TEXT)
510 row_format=dynamic,ENGINE=INNODB;
511 set @a = repeat('0123456789', 800);
512 set @b = repeat('9876543210', 800);
513 insert into t2 values(
514 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
515 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
516 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
517 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
518 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
519 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
520 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
521 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
522 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
523 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
524 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
525 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
526 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
527 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
528 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
529 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
530 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
531 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
532 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
533 @a,@a,@a,@a,@a,@a,@a);
534 update t2 set col190=@b;
535 set @a = repeat('0123456789', 1650);
536 set @b = repeat('9876543210', 2000);
537 insert into t2 values(
538 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
539 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
540 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
541 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
542 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
543 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
544 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
545 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
546 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
547 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
548 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
549 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
550 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
551 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
552 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
553 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
554 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
555 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
556 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
557 @a,@a,@a,@a,@a,@a,@a);
558 update t2 set col190=@b;
559 # restart
560 set @a = repeat('abcdefghijklmnopqrstuvwxyz', 1650);
561 set @b = repeat('zyxwvutsrqponmlkjihgfedcba', 2000);
562 show create table t2;
563 Table Create Table
564 t2 CREATE TABLE `t2` (
565 `COL1` text DEFAULT NULL,
566 `COL2` text DEFAULT NULL,
567 `COL3` text DEFAULT NULL,
568 `COL4` text DEFAULT NULL,
569 `COL5` text DEFAULT NULL,
570 `COL6` text DEFAULT NULL,
571 `COL7` text DEFAULT NULL,
572 `COL8` text DEFAULT NULL,
573 `COL9` text DEFAULT NULL,
574 `COL10` text DEFAULT NULL,
575 `COL11` text DEFAULT NULL,
576 `COL12` text DEFAULT NULL,
577 `COL13` text DEFAULT NULL,
578 `COL14` text DEFAULT NULL,
579 `COL15` text DEFAULT NULL,
580 `COL16` text DEFAULT NULL,
581 `COL17` text DEFAULT NULL,
582 `COL18` text DEFAULT NULL,
583 `COL19` text DEFAULT NULL,
584 `COL20` text DEFAULT NULL,
585 `COL21` text DEFAULT NULL,
586 `COL22` text DEFAULT NULL,
587 `COL23` text DEFAULT NULL,
588 `COL24` text DEFAULT NULL,
589 `COL25` text DEFAULT NULL,
590 `COL26` text DEFAULT NULL,
591 `COL27` text DEFAULT NULL,
592 `COL28` text DEFAULT NULL,
593 `COL29` text DEFAULT NULL,
594 `COL30` text DEFAULT NULL,
595 `COL31` text DEFAULT NULL,
596 `COL32` text DEFAULT NULL,
597 `COL33` text DEFAULT NULL,
598 `COL34` text DEFAULT NULL,
599 `COL35` text DEFAULT NULL,
600 `COL36` text DEFAULT NULL,
601 `COL37` text DEFAULT NULL,
602 `COL38` text DEFAULT NULL,
603 `COL39` text DEFAULT NULL,
604 `COL40` text DEFAULT NULL,
605 `COL41` text DEFAULT NULL,
606 `COL42` text DEFAULT NULL,
607 `COL43` text DEFAULT NULL,
608 `COL44` text DEFAULT NULL,
609 `COL45` text DEFAULT NULL,
610 `COL46` text DEFAULT NULL,
611 `COL47` text DEFAULT NULL,
612 `COL48` text DEFAULT NULL,
613 `COL49` text DEFAULT NULL,
614 `COL50` text DEFAULT NULL,
615 `COL51` text DEFAULT NULL,
616 `COL52` text DEFAULT NULL,
617 `COL53` text DEFAULT NULL,
618 `COL54` text DEFAULT NULL,
619 `COL55` text DEFAULT NULL,
620 `COL56` text DEFAULT NULL,
621 `COL57` text DEFAULT NULL,
622 `COL58` text DEFAULT NULL,
623 `COL59` text DEFAULT NULL,
624 `COL60` text DEFAULT NULL,
625 `COL61` text DEFAULT NULL,
626 `COL62` text DEFAULT NULL,
627 `COL63` text DEFAULT NULL,
628 `COL64` text DEFAULT NULL,
629 `COL65` text DEFAULT NULL,
630 `COL66` text DEFAULT NULL,
631 `COL67` text DEFAULT NULL,
632 `COL68` text DEFAULT NULL,
633 `COL69` text DEFAULT NULL,
634 `COL70` text DEFAULT NULL,
635 `COL71` text DEFAULT NULL,
636 `COL72` text DEFAULT NULL,
637 `COL73` text DEFAULT NULL,
638 `COL74` text DEFAULT NULL,
639 `COL75` text DEFAULT NULL,
640 `COL76` text DEFAULT NULL,
641 `COL77` text DEFAULT NULL,
642 `COL78` text DEFAULT NULL,
643 `COL79` text DEFAULT NULL,
644 `COL80` text DEFAULT NULL,
645 `COL81` text DEFAULT NULL,
646 `COL82` text DEFAULT NULL,
647 `COL83` text DEFAULT NULL,
648 `COL84` text DEFAULT NULL,
649 `COL85` text DEFAULT NULL,
650 `COL86` text DEFAULT NULL,
651 `COL87` text DEFAULT NULL,
652 `COL88` text DEFAULT NULL,
653 `COL89` text DEFAULT NULL,
654 `COL90` text DEFAULT NULL,
655 `COL91` text DEFAULT NULL,
656 `COL92` text DEFAULT NULL,
657 `COL93` text DEFAULT NULL,
658 `COL94` text DEFAULT NULL,
659 `COL95` text DEFAULT NULL,
660 `COL96` text DEFAULT NULL,
661 `COL97` text DEFAULT NULL,
662 `COL98` text DEFAULT NULL,
663 `COL99` text DEFAULT NULL,
664 `COL100` text DEFAULT NULL,
665 `COL101` text DEFAULT NULL,
666 `COL102` text DEFAULT NULL,
667 `COL103` text DEFAULT NULL,
668 `COL104` text DEFAULT NULL,
669 `COL105` text DEFAULT NULL,
670 `COL106` text DEFAULT NULL,
671 `COL107` text DEFAULT NULL,
672 `COL108` text DEFAULT NULL,
673 `COL109` text DEFAULT NULL,
674 `COL110` text DEFAULT NULL,
675 `COL111` text DEFAULT NULL,
676 `COL112` text DEFAULT NULL,
677 `COL113` text DEFAULT NULL,
678 `COL114` text DEFAULT NULL,
679 `COL115` text DEFAULT NULL,
680 `COL116` text DEFAULT NULL,
681 `COL117` text DEFAULT NULL,
682 `COL118` text DEFAULT NULL,
683 `COL119` text DEFAULT NULL,
684 `COL120` text DEFAULT NULL,
685 `COL121` text DEFAULT NULL,
686 `COL122` text DEFAULT NULL,
687 `COL123` text DEFAULT NULL,
688 `COL124` text DEFAULT NULL,
689 `COL125` text DEFAULT NULL,
690 `COL126` text DEFAULT NULL,
691 `COL127` text DEFAULT NULL,
692 `COL128` text DEFAULT NULL,
693 `COL129` text DEFAULT NULL,
694 `COL130` text DEFAULT NULL,
695 `COL131` text DEFAULT NULL,
696 `COL132` text DEFAULT NULL,
697 `COL133` text DEFAULT NULL,
698 `COL134` text DEFAULT NULL,
699 `COL135` text DEFAULT NULL,
700 `COL136` text DEFAULT NULL,
701 `COL137` text DEFAULT NULL,
702 `COL138` text DEFAULT NULL,
703 `COL139` text DEFAULT NULL,
704 `COL140` text DEFAULT NULL,
705 `COL141` text DEFAULT NULL,
706 `COL142` text DEFAULT NULL,
707 `COL143` text DEFAULT NULL,
708 `COL144` text DEFAULT NULL,
709 `COL145` text DEFAULT NULL,
710 `COL146` text DEFAULT NULL,
711 `COL147` text DEFAULT NULL,
712 `COL148` text DEFAULT NULL,
713 `COL149` text DEFAULT NULL,
714 `COL150` text DEFAULT NULL,
715 `COL151` text DEFAULT NULL,
716 `COL152` text DEFAULT NULL,
717 `COL153` text DEFAULT NULL,
718 `COL154` text DEFAULT NULL,
719 `COL155` text DEFAULT NULL,
720 `COL156` text DEFAULT NULL,
721 `COL157` text DEFAULT NULL,
722 `COL158` text DEFAULT NULL,
723 `COL159` text DEFAULT NULL,
724 `COL160` text DEFAULT NULL,
725 `COL161` text DEFAULT NULL,
726 `COL162` text DEFAULT NULL,
727 `COL163` text DEFAULT NULL,
728 `COL164` text DEFAULT NULL,
729 `COL165` text DEFAULT NULL,
730 `COL166` text DEFAULT NULL,
731 `COL167` text DEFAULT NULL,
732 `COL168` text DEFAULT NULL,
733 `COL169` text DEFAULT NULL,
734 `COL170` text DEFAULT NULL,
735 `COL171` text DEFAULT NULL,
736 `COL172` text DEFAULT NULL,
737 `COL173` text DEFAULT NULL,
738 `COL174` text DEFAULT NULL,
739 `COL175` text DEFAULT NULL,
740 `COL176` text DEFAULT NULL,
741 `COL177` text DEFAULT NULL,
742 `COL178` text DEFAULT NULL,
743 `COL179` text DEFAULT NULL,
744 `COL180` text DEFAULT NULL,
745 `COL181` text DEFAULT NULL,
746 `COL182` text DEFAULT NULL,
747 `COL183` text DEFAULT NULL,
748 `COL184` text DEFAULT NULL,
749 `COL185` text DEFAULT NULL,
750 `COL186` text DEFAULT NULL,
751 `COL187` text DEFAULT NULL,
752 `COL188` text DEFAULT NULL,
753 `COL189` text DEFAULT NULL,
754 `COL190` text DEFAULT NULL,
755 `COL191` text DEFAULT NULL,
756 `COL192` text DEFAULT NULL,
757 `COL193` text DEFAULT NULL,
758 `COL194` text DEFAULT NULL,
759 `COL195` text DEFAULT NULL,
760 `COL196` text DEFAULT NULL,
761 `COL197` text DEFAULT NULL
762 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
763 update t2 set col150=@a;
764 update t2 set col145=@b;
765 drop table t2;
766 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;