Debian Codegraph @

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

raw
1 #
2 # BUG#21816041 - ROW_FORMAT=DYNAMIC IS RESTRICTIVE THAN ROW_FORMAT=COMPACT
3 #
4 CREATE TABLE t1 (a VARCHAR(300), b VARCHAR(16383) CHARACTER SET UTF8MB3,
5 PRIMARY KEY(a(255), b(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
6 Warnings:
7 Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
8 DROP TABLE t1;
9 CREATE TABLE t1 (a VARCHAR(300), b VARCHAR(16383) CHARACTER SET UTF8MB3,
10 PRIMARY KEY(a(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
11 Warnings:
12 Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
13 DROP TABLE t1;
14 CREATE TABLE t1 (a VARCHAR(300), b VARCHAR(16280) CHARACTER SET UTF8MB4,
15 PRIMARY KEY(a(255), b(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC charset latin1;
16 DROP TABLE t1;
17 CREATE TABLE t1 (a VARCHAR(16383) CHARACTER SET UTF8MB4) ENGINE=INNODB
18 ROW_FORMAT=DYNAMIC;
19 ALTER TABLE t1 ADD PRIMARY KEY(a(100));
20 DROP TABLE t1;
21 CREATE TABLE t1 (a VARCHAR(16383) CHARACTER SET UTF8MB3,
22 PRIMARY KEY(a(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
23 Warnings:
24 Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
25 DROP TABLE t1;
26 CREATE TABLE t1 (a VARCHAR(12383) CHARACTER SET UTF8MB3,
27 PRIMARY KEY(a(255)), KEY k1(a(1024))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
28 Warnings:
29 Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
30 INSERT INTO t1 VALUES(REPEAT('A', 500));
31 UPDATE t1 SET a = REPEAT('B', 999);
32 DROP TABLE t1;
33 CREATE TABLE t1 (a VARCHAR(16383) CHARACTER SET UTF8MB3,
34 PRIMARY KEY(a(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
35 Warnings:
36 Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
37 DROP TABLE t1;
38 CREATE TABLE t1 (a VARCHAR(16383), b VARCHAR(3000), c TEXT,
39 PRIMARY KEY(a(255), c(10)), KEY k1(a(500)), KEY k2(b(72), c(3000)))
40 charset latin1 ENGINE=INNODB ROW_FORMAT=DYNAMIC;
41 DROP TABLE t1;
42 CREATE TABLE t1 (a VARCHAR(3070) , b TEXT,
43 PRIMARY KEY(a(400)), KEY k1(a)) ENGINE=INNODB ROW_FORMAT=DYNAMIC charset latin1;
44 DROP TABLE t1;
45 CREATE TABLE t1 (a VARCHAR(3000) , b TEXT, c INT, d TEXT,
46 PRIMARY KEY(a, b(3), c), KEY k1(a, b(25))) charset latin1 ENGINE=INNODB ROW_FORMAT=DYNAMIC;
47 DROP TABLE t1;
48 CREATE TABLE t1 (a INT , b TEXT,
49 PRIMARY KEY(a, b(3)), KEY k1(a)) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
50 DROP TABLE t1;
51 CREATE TABLE t1(a CHAR(10), KEY(a(5)));
52 DROP TABLE t1;
53 CREATE TABLE t1(a CHAR(255), KEY(a(200)));
54 DROP TABLE t1;
55 CREATE TABLE t1(a CHAR(255), KEY(a));
56 DROP TABLE t1;
57 CREATE TABLE t1(a VARCHAR(4000), KEY(a(2000))) charset latin1;
58 DROP TABLE t1;
59 CREATE TABLE t1(a VARCHAR(2000), PRIMARY KEY (a), KEY k1(a(2000))) charset latin1;
60 DROP TABLE t1;
61 CREATE TABLE t1(a VARCHAR(5000), PRIMARY KEY (a(3000)), KEY k1(a(2000))) charset latin1;
62 DROP TABLE t1;
63 CREATE TABLE t1 (
64 c1 INT AUTO_INCREMENT,
65 c2 GEOMETRY NOT NULL SRID 0,
66 PRIMARY KEY(c1),
67 SPATIAL INDEX(c2)
68 ) ENGINE=INNODB;
69 DROP TABLE t1;
70 CREATE TABLE t1(a TEXT, b TEXT, c TEXT, FULLTEXT `AB`(a, b), FULLTEXT `C1`(c));
71 DROP TABLE t1;
72 CREATE TABLE t1 (
73 col_1_VARBINARY VARBINARY (4000) ,
74 col_2_VARCHAR VARCHAR (4000) ,
75 col_3_TEXT TEXT (4000),
76 col_4_BLOB BLOB (4000),
77 col_5_TEXT TEXT (4000),
78 col_6_TEXT TEXT (4000),
79 col_7_TEXT TEXT (4000),
80 col_8_TEXT TEXT (4000),
81 col_9_TEXT TEXT (4000),
82 col_10_TEXT TEXT (4000),
83 col_11_TEXT TEXT (4000),
84 col_12_TEXT TEXT (4000),
85 col_13_TEXT TEXT (4000),
86 col_14_TEXT TEXT (4000),
87 col_15_TEXT TEXT (4000),
88 col_16_TEXT TEXT (4000),
89 col_17_TEXT TEXT (4000),
90 col_18_TEXT TEXT (4000),
91 col_19_TEXT TEXT (4000),
92 col_20_TEXT TEXT (4000),
93 col_21_TEXT TEXT (4000),
94 col_22_TEXT TEXT (4000),
95 col_23_TEXT TEXT (4000),
96 col_24_BINARY BINARY (255)
97 ) ROW_FORMAT=DYNAMIC, engine = innodb;
98 INSERT INTO t1 VALUES(
99 repeat("a", 4000), repeat("o", 4000),
100 repeat("a", 4000), repeat("o", 4000),
101 repeat("a", 4000), repeat("o", 4000),
102 repeat("a", 4000), repeat("o", 4000),
103 repeat("a", 4000), repeat("o", 4000),
104 repeat("a", 4000), repeat("o", 4000),
105 repeat("a", 4000), repeat("o", 4000),
106 repeat("a", 4000), repeat("o", 4000),
107 repeat("a", 4000), repeat("o", 4000),
108 repeat("a", 4000), repeat("o", 4000),
109 repeat("a", 4000), repeat("o", 4000),
110 repeat("a", 4000), repeat("a", 255)
111 );
112 CREATE INDEX prefix_idx1 ON t1(col_1_VARBINARY (767));
113 CREATE INDEX prefix_idx2 ON t1(col_2_VARCHAR (767));
114 CREATE INDEX prefix_idx3 ON t1(col_3_TEXT (767));
115 CREATE INDEX prefix_idx4 ON t1(col_4_BLOB (767));
116 CREATE INDEX prefix_idx5 ON t1(col_5_TEXT (767));
117 CREATE INDEX prefix_idx6 ON t1(col_6_TEXT (767));
118 CREATE INDEX prefix_idx7 ON t1(col_7_TEXT (767));
119 CREATE INDEX prefix_idx8 ON t1(col_8_TEXT (767));
120 CREATE INDEX prefix_idx9 ON t1(col_9_TEXT (767));
121 CREATE INDEX prefix_idx10 ON t1(col_10_TEXT (767));
122 CREATE INDEX prefix_idx11 ON t1(col_11_TEXT (767));
123 CREATE INDEX prefix_idx12 ON t1(col_12_TEXT (767));
124 CREATE INDEX prefix_idx13 ON t1(col_13_TEXT (767));
125 CREATE INDEX prefix_idx14 ON t1(col_14_TEXT (767));
126 CREATE INDEX prefix_idx15 ON t1(col_15_TEXT (767));
127 CREATE INDEX prefix_idx16 ON t1(col_16_TEXT (767));
128 CREATE INDEX prefix_idx17 ON t1(col_17_TEXT (767));
129 CREATE INDEX prefix_idx18 ON t1(col_18_TEXT (767));
130 CREATE INDEX prefix_idx19 ON t1(col_19_TEXT (767));
131 CREATE INDEX prefix_idx24 ON t1(col_24_BINARY (250));
132 UPDATE t1 SET col_1_VARBINARY = repeat("x", 4000), col_2_VARCHAR=
133 repeat("c",
134 4000) WHERE col_1_VARBINARY = repeat("a", 4000) AND col_2_VARCHAR =
135 repeat("o", 4000);
136 ERROR HY000: Undo log record is too big.
137 DROP TABLE t1;
138 CREATE TABLE t1(a INT, b FLOAT, c CHAR(10),
139 v1 VARCHAR(1001),
140 v2 VARCHAR(1002),
141 vx_blob BLOB,
142 vx_text TEXT,
143 vx_varchar VARCHAR(3005),
144 v3 VARCHAR(1006),
145 v4 VARCHAR(1007),
146 PRIMARY KEY (a,b,c,vx_text(200))) charset latin1 ROW_FORMAT=DYNAMIC;
147 CREATE INDEX idx1 ON t1(a,b,c);
148 CREATE INDEX idx2 ON t1(a,v1(101));
149 CREATE INDEX idx3 ON t1(b,v2(102));
150 CREATE INDEX idx4 ON t1(c,vx_blob(3003));
151 CREATE INDEX idx5 ON t1(a,vx_text(1004));
152 SHOW WARNINGS;
153 Level Code Message
154 INSERT INTO t1 VALUES(1,1,'111111111',
155 repeat('a',1001),
156 repeat('a',1002),
157 repeat('a',4003),
158 repeat('a',3004),
159 repeat('a',3005),
160 repeat('a',1006),
161 repeat('a',1007));
162 UPDATE t1 SET
163 v1=repeat('b',1001),
164 v2=repeat('b',1002),
165 vx_blob=repeat('b',4003),
166 vx_varchar=repeat('b',3005),
167 v3=repeat('b',1006),
168 v4=repeat('b',1007);
169 DROP TABLE t1;
170 create table t1(a int, b float, c char(10), d date,
171 vx_varchar varchar(10000), vx_text text, vx_blob BLOB,
172 v1 varchar(1000), v2 varchar(1000),
173 v3 varchar(1000), v4 varchar(3000))
174 charset latin1 ROW_FORMAT=DYNAMIC;
175 create index idx1 on t1(a,b,c,d);
176 create index idx2 on t1(vx_varchar(2000));
177 create index idx3 on t1(vx_text(2000));
178 create index idx8 on t1(vx_blob(2000));
179 create index idx4 on t1(v1);
180 create index idx5 on t1(v2);
181 create index idx6 on t1(v3);
182 create index idx7 on t1(v4);
183 insert into t1 values(1,1,'111111111', '2011-07-11',
184 repeat('a',10000),
185 repeat('a',10000),
186 repeat('a',10000),
187 repeat('a',1000), repeat('a',1000),
188 repeat('a',1000), repeat('a',3000));
189 update t1 set a=2,b=2,c='2222222222',d='2011-07-12',
190 vx_varchar=repeat('b',10000),
191 vx_text=repeat('b',10000),
192 vx_blob=repeat('b',10000),
193 v1=repeat('b',1000), v2=repeat('b',1000),
194 v3=repeat('b',1000), v4=repeat('b',3000);
195 ERROR HY000: Undo log record is too big.
196 drop table t1;
197 CREATE TABLE t1(x VARCHAR(300), y VARCHAR(200), KEY k1(y,x));
198 ALTER TABLE t1 ADD INDEX k2(x(10));
199 DROP TABLE t1;
200 SHOW CREATE TABLE t1;
201 Table Create Table
202 t1 CREATE TABLE `t1` (
203 `c1` text,
204 `c2` text,
205 `c3` text,
206 `c4` text,
207 `c5` text,
208 `c6` text,
209 `c7` text,
210 `c8` text,
211 `c9` text,
212 `c10` text,
213 `c11` text,
214 `c12` text,
215 `c13` text,
216 `c14` text,
217 `c15` text,
218 `c16` text,
219 `c17` text,
220 `c18` text,
221 `c19` text,
222 `c20` text,
223 `c21` text,
224 `c22` text,
225 `c23` text,
226 `c24` text,
227 `c25` text,
228 `c26` text,
229 `c27` text,
230 `c28` text,
231 `c29` text,
232 `c30` text,
233 `c31` text,
234 `c32` text,
235 `c33` text,
236 `c34` text,
237 `c35` text,
238 `c36` text,
239 `c37` text,
240 `c38` text,
241 `c39` text,
242 `c40` text,
243 `c41` text,
244 `c42` text,
245 `c43` text,
246 `c44` text,
247 `c45` text,
248 `c46` text,
249 `c47` text,
250 `c48` text,
251 `c49` text,
252 `c50` text,
253 `c51` text,
254 `c52` text,
255 `c53` text,
256 `c54` text,
257 `c55` text,
258 `c56` text,
259 `c57` text,
260 `c58` text,
261 `c59` text,
262 `c60` text,
263 `c61` text,
264 `c62` text,
265 `c63` text,
266 `c64` text,
267 `c65` text,
268 `c66` text,
269 `c67` text,
270 `c68` text,
271 `c69` text,
272 `c70` text,
273 `c71` text,
274 `c72` text,
275 `c73` text,
276 `c74` text,
277 `c75` text,
278 `c76` text,
279 `c77` text,
280 `c78` text,
281 `c79` text,
282 `c80` text,
283 `c81` text,
284 `c82` text,
285 `c83` text,
286 `c84` text,
287 `c85` text,
288 `c86` text,
289 `c87` text,
290 `c88` text,
291 `c89` text,
292 `c90` text,
293 `c91` text,
294 `c92` text,
295 `c93` text,
296 `c94` text,
297 `c95` text,
298 `c96` text,
299 `c97` text,
300 `c98` text,
301 `c99` text,
302 `c100` text,
303 `c101` text,
304 `c102` text,
305 `c103` text,
306 `c104` text,
307 `c105` text,
308 `c106` text,
309 `c107` text,
310 `c108` text,
311 `c109` text,
312 `c110` text,
313 `c111` text,
314 `c112` text,
315 `c113` text,
316 `c114` text,
317 `c115` text,
318 `c116` text,
319 `c117` text,
320 `c118` text,
321 `c119` text,
322 `c120` text,
323 `c121` text,
324 `c122` text,
325 `c123` text,
326 `c124` text,
327 `c125` text,
328 `c126` text,
329 `c127` text,
330 `c128` text,
331 `c129` text,
332 `c130` text,
333 `c131` text,
334 `c132` text,
335 `c133` text,
336 `c134` text,
337 `c135` text,
338 `c136` text,
339 `c137` text,
340 `c138` text,
341 `c139` text,
342 `c140` text,
343 `c141` text,
344 `c142` text,
345 `c143` text,
346 `c144` text,
347 `c145` text,
348 `c146` text,
349 `c147` text,
350 `c148` text,
351 `c149` text,
352 `c150` text,
353 `c151` text,
354 `c152` text,
355 `c153` text,
356 `c154` text,
357 `c155` text,
358 `c156` text,
359 `c157` text,
360 `c158` text,
361 `c159` text,
362 `c160` text,
363 `c161` text,
364 `c162` text,
365 `c163` text,
366 `c164` text,
367 `c165` text,
368 `c166` text,
369 `c167` text,
370 `c168` text,
371 `c169` text,
372 `c170` text,
373 `c171` text,
374 `c172` text,
375 `c173` text,
376 `c174` text,
377 `c175` text,
378 `c176` text,
379 `c177` text,
380 `c178` text,
381 `c179` text,
382 `c180` text,
383 `c181` text,
384 `c182` text,
385 `c183` text,
386 `c184` text,
387 `c185` text,
388 `c186` text,
389 `c187` text,
390 `c188` text,
391 `c189` text,
392 `c190` text,
393 `c191` text,
394 `c192` text,
395 `c193` text,
396 `c194` text,
397 `c195` text,
398 `c196` text,
399 KEY `k1` (`c1`(767)),
400 KEY `k2` (`c2`(767)),
401 KEY `k3` (`c3`(767)),
402 KEY `k4` (`c4`(767)),
403 KEY `k5` (`c5`(767)),
404 KEY `k6` (`c6`(767)),
405 KEY `k7` (`c7`(767)),
406 KEY `k8` (`c8`(767)),
407 KEY `k9` (`c9`(767)),
408 KEY `k10` (`c10`(767)),
409 KEY `k11` (`c11`(767)),
410 KEY `k12` (`c12`(767)),
411 KEY `k13` (`c13`(767)),
412 KEY `k14` (`c14`(767)),
413 KEY `k15` (`c15`(767)),
414 KEY `k16` (`c16`(767)),
415 KEY `k17` (`c17`(767)),
416 KEY `k18` (`c18`(767)),
417 KEY `k19` (`c19`(767)),
418 KEY `k20` (`c20`(767)),
419 KEY `k21` (`c21`(767)),
420 KEY `k22` (`c22`(767)),
421 KEY `k23` (`c23`(767)),
422 KEY `k24` (`c24`(767)),
423 KEY `k25` (`c25`(767)),
424 KEY `k26` (`c26`(767)),
425 KEY `k27` (`c27`(767)),
426 KEY `k28` (`c28`(767)),
427 KEY `k29` (`c29`(767)),
428 KEY `k30` (`c30`(767)),
429 KEY `k31` (`c31`(767)),
430 KEY `k32` (`c32`(767)),
431 KEY `k33` (`c33`(767)),
432 KEY `k34` (`c34`(767)),
433 KEY `k35` (`c35`(767)),
434 KEY `k36` (`c36`(767)),
435 KEY `k37` (`c37`(767)),
436 KEY `k38` (`c38`(767)),
437 KEY `k39` (`c39`(767)),
438 KEY `k40` (`c40`(767)),
439 KEY `k41` (`c41`(767)),
440 KEY `k42` (`c42`(767)),
441 KEY `k43` (`c43`(767)),
442 KEY `k44` (`c44`(767)),
443 KEY `k45` (`c45`(767)),
444 KEY `k46` (`c46`(767)),
445 KEY `k47` (`c47`(767)),
446 KEY `k48` (`c48`(767)),
447 KEY `k49` (`c49`(767)),
448 KEY `k50` (`c50`(767)),
449 KEY `k51` (`c51`(767)),
450 KEY `k52` (`c52`(767)),
451 KEY `k53` (`c53`(767)),
452 KEY `k54` (`c54`(767)),
453 KEY `k55` (`c55`(767)),
454 KEY `k56` (`c56`(767)),
455 KEY `k57` (`c57`(767)),
456 KEY `k58` (`c58`(767)),
457 KEY `k59` (`c59`(767)),
458 KEY `k60` (`c60`(767)),
459 KEY `k61` (`c61`(767)),
460 KEY `k62` (`c62`(767)),
461 KEY `k63` (`c63`(767)),
462 KEY `k64` (`c64`(767))
463 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
464 UPDATE t1 SET
465 c1=REPEAT('a', 65535),
466 c2=REPEAT('b', 65535),
467 c3=REPEAT('c', 65535),
468 c4=REPEAT('d', 65535),
469 c5=REPEAT('e', 65535),
470 c6=REPEAT('f', 65535),
471 c7=REPEAT('g', 65535),
472 c8=REPEAT('h', 65535),
473 c9=REPEAT('i', 65535),
474 c10=REPEAT('j', 65535),
475 c11=REPEAT('k', 65535),
476 c12=REPEAT('l', 65535),
477 c13=REPEAT('m', 65535),
478 c14=REPEAT('n', 65535),
479 c15=REPEAT('o', 65535);
480 UPDATE t1 SET
481 c14=REPEAT('a', 65535),
482 c13=REPEAT('b', 65535),
483 c12=REPEAT('c', 65535),
484 c11=REPEAT('d', 65535),
485 c10=REPEAT('e', 65535),
486 c9=REPEAT('f', 65535),
487 c8=REPEAT('g', 65535),
488 c7=REPEAT('h', 65535),
489 c6=REPEAT('i', 65535),
490 c5=REPEAT('j', 65535),
491 c4=REPEAT('k', 65535),
492 c3=REPEAT('l', 65535),
493 c2=REPEAT('m', 65535),
494 c1=REPEAT('n', 65535);
495 ERROR HY000: Undo log record is too big.
496 UPDATE t1 SET
497 c14 = REPEAT('a', 65535);
498 DROP TABLE t1;
499 SHOW CREATE TABLE t1;
500 Table Create Table
501 t1 CREATE TABLE `t1` (
502 `c1` text,
503 `c2` text,
504 `c3` text,
505 `c4` text,
506 `c5` text,
507 `c6` text,
508 `c7` text,
509 `c8` text,
510 `c9` text,
511 `c10` text,
512 `c11` text,
513 `c12` text,
514 `c13` text,
515 `c14` text,
516 `c15` text,
517 `c16` text,
518 `c17` text,
519 `c18` text,
520 `c19` text,
521 `c20` text,
522 `c21` text,
523 `c22` text,
524 `c23` text,
525 `c24` text,
526 `c25` text,
527 `c26` text,
528 `c27` text,
529 `c28` text,
530 `c29` text,
531 `c30` text,
532 `c31` text,
533 `c32` text,
534 `c33` text,
535 `c34` text,
536 `c35` text,
537 `c36` text,
538 `c37` text,
539 `c38` text,
540 `c39` text,
541 `c40` text,
542 `c41` text,
543 `c42` text,
544 `c43` text,
545 `c44` text,
546 `c45` text,
547 `c46` text,
548 `c47` text,
549 `c48` text,
550 `c49` text,
551 `c50` text,
552 `c51` text,
553 `c52` text,
554 `c53` text,
555 `c54` text,
556 `c55` text,
557 `c56` text,
558 `c57` text,
559 `c58` text,
560 `c59` text,
561 `c60` text,
562 `c61` text,
563 `c62` text,
564 `c63` text,
565 `c64` text,
566 `c65` text,
567 `c66` text,
568 `c67` text,
569 `c68` text,
570 `c69` text,
571 `c70` text,
572 `c71` text,
573 `c72` text,
574 `c73` text,
575 `c74` text,
576 `c75` text,
577 `c76` text,
578 `c77` text,
579 `c78` text,
580 `c79` text,
581 `c80` text,
582 `c81` text,
583 `c82` text,
584 `c83` text,
585 `c84` text,
586 `c85` text,
587 `c86` text,
588 `c87` text,
589 `c88` text,
590 `c89` text,
591 `c90` text,
592 `c91` text,
593 `c92` text,
594 `c93` text,
595 `c94` text,
596 `c95` text,
597 `c96` text,
598 `c97` text,
599 `c98` text,
600 `c99` text,
601 `c100` text,
602 `c101` text,
603 `c102` text,
604 `c103` text,
605 `c104` text,
606 `c105` text,
607 `c106` text,
608 `c107` text,
609 `c108` text,
610 `c109` text,
611 `c110` text,
612 `c111` text,
613 `c112` text,
614 `c113` text,
615 `c114` text,
616 `c115` text,
617 `c116` text,
618 `c117` text,
619 `c118` text,
620 `c119` text,
621 `c120` text,
622 `c121` text,
623 `c122` text,
624 `c123` text,
625 `c124` text,
626 `c125` text,
627 `c126` text,
628 `c127` text,
629 `c128` text,
630 `c129` text,
631 `c130` text,
632 `c131` text,
633 `c132` text,
634 `c133` text,
635 `c134` text,
636 `c135` text,
637 `c136` text,
638 `c137` text,
639 `c138` text,
640 `c139` text,
641 `c140` text,
642 `c141` text,
643 `c142` text,
644 `c143` text,
645 `c144` text,
646 `c145` text,
647 `c146` text,
648 `c147` text,
649 `c148` text,
650 `c149` text,
651 `c150` text,
652 `c151` text,
653 `c152` text,
654 `c153` text,
655 `c154` text,
656 `c155` text,
657 `c156` text,
658 `c157` text,
659 `c158` text,
660 `c159` text,
661 `c160` text,
662 `c161` text,
663 `c162` text,
664 `c163` text,
665 `c164` text,
666 `c165` text,
667 `c166` text,
668 `c167` text,
669 `c168` text,
670 `c169` text,
671 `c170` text,
672 `c171` text,
673 `c172` text,
674 `c173` text,
675 `c174` text,
676 `c175` text,
677 `c176` text,
678 `c177` text,
679 `c178` text,
680 `c179` text,
681 `c180` text,
682 `c181` text,
683 `c182` text,
684 `c183` text,
685 `c184` text,
686 `c185` text,
687 `c186` text,
688 `c187` text,
689 `c188` text,
690 `c189` text,
691 `c190` text,
692 `c191` text,
693 `c192` text,
694 `c193` text,
695 `c194` text,
696 `c195` text,
697 `c196` text,
698 KEY `k1` (`c1`(3072)),
699 KEY `k2` (`c2`(3072)),
700 KEY `k3` (`c3`(3072)),
701 KEY `k4` (`c4`(3072)),
702 KEY `k5` (`c5`(3072)),
703 KEY `k6` (`c6`(3072)),
704 KEY `k7` (`c7`(3072)),
705 KEY `k8` (`c8`(3072)),
706 KEY `k9` (`c9`(3072)),
707 KEY `k10` (`c10`(3072)),
708 KEY `k11` (`c11`(3072)),
709 KEY `k12` (`c12`(3072)),
710 KEY `k13` (`c13`(3072)),
711 KEY `k14` (`c14`(3072)),
712 KEY `k15` (`c15`(3072)),
713 KEY `k16` (`c16`(3072)),
714 KEY `k17` (`c17`(3072)),
715 KEY `k18` (`c18`(3072)),
716 KEY `k19` (`c19`(3072)),
717 KEY `k20` (`c20`(3072)),
718 KEY `k21` (`c21`(3072)),
719 KEY `k22` (`c22`(3072)),
720 KEY `k23` (`c23`(3072)),
721 KEY `k24` (`c24`(3072)),
722 KEY `k25` (`c25`(3072)),
723 KEY `k26` (`c26`(3072)),
724 KEY `k27` (`c27`(3072)),
725 KEY `k28` (`c28`(3072)),
726 KEY `k29` (`c29`(3072)),
727 KEY `k30` (`c30`(3072)),
728 KEY `k31` (`c31`(3072)),
729 KEY `k32` (`c32`(3072)),
730 KEY `k33` (`c33`(3072)),
731 KEY `k34` (`c34`(3072)),
732 KEY `k35` (`c35`(3072)),
733 KEY `k36` (`c36`(3072)),
734 KEY `k37` (`c37`(3072)),
735 KEY `k38` (`c38`(3072)),
736 KEY `k39` (`c39`(3072)),
737 KEY `k40` (`c40`(3072)),
738 KEY `k41` (`c41`(3072)),
739 KEY `k42` (`c42`(3072)),
740 KEY `k43` (`c43`(3072)),
741 KEY `k44` (`c44`(3072)),
742 KEY `k45` (`c45`(3072)),
743 KEY `k46` (`c46`(3072)),
744 KEY `k47` (`c47`(3072)),
745 KEY `k48` (`c48`(3072)),
746 KEY `k49` (`c49`(3072)),
747 KEY `k50` (`c50`(3072)),
748 KEY `k51` (`c51`(3072)),
749 KEY `k52` (`c52`(3072)),
750 KEY `k53` (`c53`(3072)),
751 KEY `k54` (`c54`(3072)),
752 KEY `k55` (`c55`(3072)),
753 KEY `k56` (`c56`(3072)),
754 KEY `k57` (`c57`(3072)),
755 KEY `k58` (`c58`(3072)),
756 KEY `k59` (`c59`(3072)),
757 KEY `k60` (`c60`(3072)),
758 KEY `k61` (`c61`(3072)),
759 KEY `k62` (`c62`(3072)),
760 KEY `k63` (`c63`(3072)),
761 KEY `k64` (`c64`(3072))
762 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
763 UPDATE t1 SET
764 c1=REPEAT('a', 65535),
765 c2=REPEAT('b', 65535),
766 c3=REPEAT('c', 65535),
767 c4=REPEAT('d', 65535),
768 c5=REPEAT('e', 65535),
769 c6=REPEAT('f', 65535),
770 c7=REPEAT('g', 65535),
771 c8=REPEAT('h', 65535),
772 c9=REPEAT('i', 65535),
773 c10=REPEAT('j', 65535),
774 c11=REPEAT('k', 65535),
775 c12=REPEAT('l', 65535),
776 c13=REPEAT('m', 65535),
777 c14=REPEAT('n', 65535),
778 c15=REPEAT('o', 65535);
779 UPDATE t1 SET
780 c14=REPEAT('a', 65535),
781 c13=REPEAT('b', 65535),
782 c12=REPEAT('c', 65535),
783 c11=REPEAT('d', 65535),
784 c10=REPEAT('e', 65535),
785 c9=REPEAT('f', 65535),
786 c8=REPEAT('g', 65535),
787 c7=REPEAT('h', 65535),
788 c6=REPEAT('i', 65535),
789 c5=REPEAT('j', 65535),
790 c4=REPEAT('k', 65535),
791 c3=REPEAT('l', 65535),
792 c2=REPEAT('m', 65535),
793 c1=REPEAT('n', 65535);
794 ERROR HY000: Undo log record is too big.
795 UPDATE t1 SET
796 c14 = REPEAT('a', 65535);
797 ERROR HY000: Undo log record is too big.
798 DROP TABLE t1;
799 #
800 # Bug#21880445 - FAILING ASSERTION: !FIELD->PREFIX_LEN ||
801 # FIELD->FIXED_LEN == FIELD->PREFIX_LEN
802 #
803 CREATE TABLE t1(
804 a CHAR(255) CHARACTER SET UTF32,
805 KEY k1(a(254))
806 ) ENGINE=INNODB;
807 DROP TABLE t1;
808 CREATE TABLE t1(
809 a VARCHAR(16383) CHARACTER SET UTF32,
810 KEY k1(a(768))
811 ) ENGINE=INNODB;
812 DROP TABLE t1;
813 CREATE TABLE t1(
814 a TEXT CHARACTER SET UTF32,
815 KEY k1(a(768))
816 ) ENGINE=INNODB;
817 DROP TABLE t1;
818 CREATE TABLE t1(
819 a CHAR(255) CHARACTER SET UTF32,
820 KEY k1(a)
821 )ENGINE=INNODB;
822 DROP TABLE t1;
823 CREATE TABLE t1(
824 a CHAR(20) CHARACTER SET UTF32,
825 KEY k1(a(5))
826 ) ENGINE=INNODB;
827 DROP TABLE t1;
828 CREATE TABLE t1(
829 a CHAR(255) CHARACTER SET UTF32,
830 KEY k1(a(195))
831 ) ENGINE=INNODB;
832 ALTER TABLE t1 ADD COLUMN b CHAR(255) CHARACTER SET UTF32;
833 ALTER TABLE t1 ADD COLUMN c CHAR(255) CHARACTER SET UTF32;
834 ALTER TABLE t1 ADD INDEX k2(b);
835 ALTER TABLE t1 ADD INDEX k3(c);
836 DROP TABLE t1;
837 CREATE TABLE t1(a VARCHAR(1000)) charset latin1 ROW_FORMAT=DYNAMIC;
838 CREATE INDEX idx1 ON t1(a);
839 ALTER TABLE t1 ROW_FORMAT=COMPACT;
840 ERROR 42000: Specified key was too long; max key length is 767 bytes
841 DROP TABLE t1;
842 #
843 # Bug#25579578 - FAILING ASSERTION: !FIELD->PREFIX_LEN ||
844 # FIELD->FIXED_LEN == FIELD->PREFIX_LEN
845 #
846 CREATE TABLE t1(a CHAR(255) CHARACTER SET UTF32,KEY k1(a(195))) ENGINE=INNODB;
847 INSERT INTO t1 VALUES(-233);
848 DROP TABLE t1;
849 CREATE TABLE t1(a CHAR(255) CHARACTER SET UTF32,KEY k1(a(195)));
850 INSERT INTO t1 VALUES('x');
851 DROP TABLE t1;
852 CREATE TABLE t1(a CHAR(255) CHARACTER SET latin1,KEY k1(a(195)));
853 INSERT INTO t1 VALUES('x');
854 DROP TABLE t1;
855 CREATE TABLE t1(a CHAR(255), KEY k1(a(195)));
856 INSERT INTO t1 VALUES('x');
857 DROP TABLE t1;