Debian Codegraph @

mysql-test/suite/innodb/t/innodb-32k.test

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