Debian Codegraph @

mysql-test/suite/innodb_zip/t/bug36169.test

raw
1 #
2 # Bug#36169 create innodb compressed table with too large row size crashed
3 # http://bugs.mysql.com/36169
4 #
5
6 -- source include/innodb_page_size_small.inc
7 --source include/test_db_charset_latin1.inc
8
9 #
10 # The following is copied from http://bugs.mysql.com/36169
11 # (http://bugs.mysql.com/file.php?id=9121)
12 # Probably it can be simplified but that is not obvious.
13 #
14
15 # we care only that the following SQL commands do produce errors
16 # as expected and do not crash the server
17 -- disable_query_log
18 -- disable_result_log
19 call mtr.add_suppression("Cannot add field .* in table .* because after adding it, the row size is");
20 # Generating 10 tables
21 # Creating a table with 94 columns and 24 indexes
22 DROP TABLE IF EXISTS `table0`;
23 set innodb_strict_mode=on;
24 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
25 --error ER_TOO_BIG_ROWSIZE
26 CREATE TABLE IF NOT EXISTS `table0`
27 (`col0` BOOL,
28 `col1` BOOL,
29 `col2` TINYINT,
30 `col3` DATE,
31 `col4` TIME,
32 `col5` SET ('test1','test2','test3'),
33 `col6` TIME,
34 `col7` TEXT,
35 `col8` DECIMAL,
36 `col9` SET ('test1','test2','test3'),
37 `col10` FLOAT,
38 `col11` DOUBLE PRECISION,
39 `col12` ENUM ('test1','test2','test3'),
40 `col13` TINYBLOB,
41 `col14` YEAR,
42 `col15` SET ('test1','test2','test3'),
43 `col16` NUMERIC,
44 `col17` NUMERIC,
45 `col18` BLOB,
46 `col19` DATETIME,
47 `col20` DOUBLE PRECISION,
48 `col21` DECIMAL,
49 `col22` DATETIME,
50 `col23` NUMERIC,
51 `col24` NUMERIC,
52 `col25` LONGTEXT,
53 `col26` TINYBLOB,
54 `col27` TIME,
55 `col28` TINYBLOB,
56 `col29` ENUM ('test1','test2','test3'),
57 `col30` SMALLINT,
58 `col31` REAL,
59 `col32` FLOAT,
60 `col33` CHAR (175),
61 `col34` TINYTEXT,
62 `col35` TINYTEXT,
63 `col36` TINYBLOB,
64 `col37` TINYBLOB,
65 `col38` TINYTEXT,
66 `col39` MEDIUMBLOB,
67 `col40` TIMESTAMP,
68 `col41` DOUBLE,
69 `col42` SMALLINT,
70 `col43` LONGBLOB,
71 `col44` VARCHAR (80),
72 `col45` MEDIUMTEXT,
73 `col46` NUMERIC,
74 `col47` BIGINT,
75 `col48` DATE,
76 `col49` TINYBLOB,
77 `col50` DATE,
78 `col51` BOOL,
79 `col52` MEDIUMINT,
80 `col53` FLOAT,
81 `col54` TINYBLOB,
82 `col55` LONGTEXT,
83 `col56` SMALLINT,
84 `col57` ENUM ('test1','test2','test3'),
85 `col58` DATETIME,
86 `col59` MEDIUMTEXT,
87 `col60` VARCHAR (232),
88 `col61` NUMERIC,
89 `col62` YEAR,
90 `col63` SMALLINT,
91 `col64` TIMESTAMP,
92 `col65` BLOB,
93 `col66` LONGBLOB,
94 `col67` INT,
95 `col68` LONGTEXT,
96 `col69` ENUM ('test1','test2','test3'),
97 `col70` INT,
98 `col71` TIME,
99 `col72` TIMESTAMP,
100 `col73` TIMESTAMP,
101 `col74` VARCHAR (170),
102 `col75` SET ('test1','test2','test3'),
103 `col76` TINYBLOB,
104 `col77` BIGINT,
105 `col78` NUMERIC,
106 `col79` DATETIME,
107 `col80` YEAR,
108 `col81` NUMERIC,
109 `col82` LONGBLOB,
110 `col83` TEXT,
111 `col84` CHAR (83),
112 `col85` DECIMAL,
113 `col86` FLOAT,
114 `col87` INT,
115 `col88` VARCHAR (145),
116 `col89` DATE,
117 `col90` DECIMAL,
118 `col91` DECIMAL,
119 `col92` MEDIUMBLOB,
120 `col93` TIME,
121 KEY `idx0` (`col69`,`col90`,`col8`),
122 KEY `idx1` (`col60`),
123 KEY `idx2` (`col60`,`col70`,`col74`),
124 KEY `idx3` (`col22`,`col32`,`col72`,`col30`),
125 KEY `idx4` (`col29`),
126 KEY `idx5` (`col19`,`col45`(143)),
127 KEY `idx6` (`col46`,`col48`,`col5`,`col39`(118)),
128 KEY `idx7` (`col48`,`col61`),
129 KEY `idx8` (`col93`),
130 KEY `idx9` (`col31`),
131 KEY `idx10` (`col30`,`col21`),
132 KEY `idx11` (`col67`),
133 KEY `idx12` (`col44`,`col6`,`col8`,`col38`(226)),
134 KEY `idx13` (`col71`,`col41`,`col15`,`col49`(88)),
135 KEY `idx14` (`col78`),
136 KEY `idx15` (`col63`,`col67`,`col64`),
137 KEY `idx16` (`col17`,`col86`),
138 KEY `idx17` (`col77`,`col56`,`col10`,`col55`(24)),
139 KEY `idx18` (`col62`),
140 KEY `idx19` (`col31`,`col57`,`col56`,`col53`),
141 KEY `idx20` (`col46`),
142 KEY `idx21` (`col83`(54)),
143 KEY `idx22` (`col51`,`col7`(120)),
144 KEY `idx23` (`col7`(163),`col31`,`col71`,`col14`)
145 )engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
146 SET sql_mode = default;
147
148 # Creating a table with 10 columns and 32 indexes
149 DROP TABLE IF EXISTS `table1`;
150 --error ER_TOO_BIG_ROWSIZE
151 CREATE TABLE IF NOT EXISTS `table1`
152 (`col0` CHAR (113),
153 `col1` FLOAT,
154 `col2` BIGINT,
155 `col3` DECIMAL,
156 `col4` BLOB,
157 `col5` LONGTEXT,
158 `col6` SET ('test1','test2','test3'),
159 `col7` BIGINT,
160 `col8` BIGINT,
161 `col9` TINYBLOB,
162 KEY `idx0` (`col5`(101),`col7`,`col8`),
163 KEY `idx1` (`col8`),
164 KEY `idx2` (`col4`(177),`col9`(126),`col6`,`col3`),
165 KEY `idx3` (`col5`(160)),
166 KEY `idx4` (`col9`(242)),
167 KEY `idx5` (`col4`(139),`col2`,`col3`),
168 KEY `idx6` (`col7`),
169 KEY `idx7` (`col6`,`col2`,`col0`,`col3`),
170 KEY `idx8` (`col9`(66)),
171 KEY `idx9` (`col5`(253)),
172 KEY `idx10` (`col1`,`col7`,`col2`),
173 KEY `idx11` (`col9`(242),`col0`,`col8`,`col5`(163)),
174 KEY `idx12` (`col8`),
175 KEY `idx13` (`col0`,`col9`(37)),
176 KEY `idx14` (`col0`),
177 KEY `idx15` (`col5`(111)),
178 KEY `idx16` (`col8`,`col0`,`col5`(13)),
179 KEY `idx17` (`col4`(139)),
180 KEY `idx18` (`col5`(189),`col2`,`col3`,`col9`(136)),
181 KEY `idx19` (`col0`,`col3`,`col1`,`col8`),
182 KEY `idx20` (`col8`),
183 KEY `idx21` (`col0`,`col7`,`col9`(227),`col3`),
184 KEY `idx22` (`col0`),
185 KEY `idx23` (`col2`),
186 KEY `idx24` (`col3`),
187 KEY `idx25` (`col2`,`col3`),
188 KEY `idx26` (`col0`),
189 KEY `idx27` (`col5`(254)),
190 KEY `idx28` (`col3`),
191 KEY `idx29` (`col3`),
192 KEY `idx30` (`col7`,`col3`,`col0`,`col4`(220)),
193 KEY `idx31` (`col4`(1),`col0`)
194 )engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
195
196 # Creating a table with 141 columns and 18 indexes
197 DROP TABLE IF EXISTS `table2`;
198 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
199 --error ER_TOO_BIG_ROWSIZE
200 CREATE TABLE IF NOT EXISTS `table2`
201 (`col0` BOOL,
202 `col1` MEDIUMINT,
203 `col2` VARCHAR (209),
204 `col3` MEDIUMBLOB,
205 `col4` CHAR (13),
206 `col5` DOUBLE,
207 `col6` TINYTEXT,
208 `col7` REAL,
209 `col8` SMALLINT,
210 `col9` BLOB,
211 `col10` TINYINT,
212 `col11` DECIMAL,
213 `col12` BLOB,
214 `col13` DECIMAL,
215 `col14` LONGBLOB,
216 `col15` SMALLINT,
217 `col16` LONGBLOB,
218 `col17` TINYTEXT,
219 `col18` FLOAT,
220 `col19` CHAR (78),
221 `col20` MEDIUMTEXT,
222 `col21` SET ('test1','test2','test3'),
223 `col22` MEDIUMINT,
224 `col23` INT,
225 `col24` MEDIUMBLOB,
226 `col25` ENUM ('test1','test2','test3'),
227 `col26` TINYBLOB,
228 `col27` VARCHAR (116),
229 `col28` TIMESTAMP,
230 `col29` BLOB,
231 `col30` SMALLINT,
232 `col31` DOUBLE PRECISION,
233 `col32` DECIMAL,
234 `col33` DECIMAL,
235 `col34` TEXT,
236 `col35` MEDIUMINT,
237 `col36` MEDIUMINT,
238 `col37` BIGINT,
239 `col38` VARCHAR (253),
240 `col39` TINYBLOB,
241 `col40` MEDIUMBLOB,
242 `col41` BIGINT,
243 `col42` DOUBLE,
244 `col43` TEXT,
245 `col44` BLOB,
246 `col45` TIME,
247 `col46` MEDIUMINT,
248 `col47` DOUBLE PRECISION,
249 `col48` SET ('test1','test2','test3'),
250 `col49` DOUBLE PRECISION,
251 `col50` VARCHAR (97),
252 `col51` TEXT,
253 `col52` NUMERIC,
254 `col53` ENUM ('test1','test2','test3'),
255 `col54` MEDIUMTEXT,
256 `col55` MEDIUMINT,
257 `col56` DATETIME,
258 `col57` DATETIME,
259 `col58` MEDIUMTEXT,
260 `col59` CHAR (244),
261 `col60` LONGBLOB,
262 `col61` MEDIUMBLOB,
263 `col62` DOUBLE,
264 `col63` SMALLINT,
265 `col64` BOOL,
266 `col65` SMALLINT,
267 `col66` VARCHAR (212),
268 `col67` TIME,
269 `col68` REAL,
270 `col69` BOOL,
271 `col70` BIGINT,
272 `col71` DATE,
273 `col72` TINYINT,
274 `col73` ENUM ('test1','test2','test3'),
275 `col74` DATE,
276 `col75` TIME,
277 `col76` DATETIME,
278 `col77` BOOL,
279 `col78` TINYTEXT,
280 `col79` MEDIUMINT,
281 `col80` NUMERIC,
282 `col81` LONGTEXT,
283 `col82` SET ('test1','test2','test3'),
284 `col83` DOUBLE PRECISION,
285 `col84` NUMERIC,
286 `col85` VARCHAR (184),
287 `col86` DOUBLE PRECISION,
288 `col87` MEDIUMTEXT,
289 `col88` MEDIUMBLOB,
290 `col89` BOOL,
291 `col90` SMALLINT,
292 `col91` TINYINT,
293 `col92` ENUM ('test1','test2','test3'),
294 `col93` BOOL,
295 `col94` TIMESTAMP,
296 `col95` BOOL,
297 `col96` MEDIUMTEXT,
298 `col97` DECIMAL,
299 `col98` BOOL,
300 `col99` DECIMAL,
301 `col100` MEDIUMINT,
302 `col101` DOUBLE PRECISION,
303 `col102` TINYINT,
304 `col103` BOOL,
305 `col104` MEDIUMINT,
306 `col105` DECIMAL,
307 `col106` NUMERIC,
308 `col107` TIMESTAMP,
309 `col108` MEDIUMBLOB,
310 `col109` TINYBLOB,
311 `col110` SET ('test1','test2','test3'),
312 `col111` YEAR,
313 `col112` TIMESTAMP,
314 `col113` CHAR (201),
315 `col114` BOOL,
316 `col115` TINYINT,
317 `col116` DOUBLE,
318 `col117` TINYINT,
319 `col118` TIMESTAMP,
320 `col119` SET ('test1','test2','test3'),
321 `col120` SMALLINT,
322 `col121` TINYBLOB,
323 `col122` TIMESTAMP,
324 `col123` BLOB,
325 `col124` DATE,
326 `col125` SMALLINT,
327 `col126` ENUM ('test1','test2','test3'),
328 `col127` MEDIUMBLOB,
329 `col128` DOUBLE PRECISION,
330 `col129` REAL,
331 `col130` VARCHAR (159),
332 `col131` MEDIUMBLOB,
333 `col132` BIGINT,
334 `col133` INT,
335 `col134` SET ('test1','test2','test3'),
336 `col135` CHAR (198),
337 `col136` SET ('test1','test2','test3'),
338 `col137` MEDIUMTEXT,
339 `col138` SMALLINT,
340 `col139` BLOB,
341 `col140` LONGBLOB,
342 KEY `idx0` (`col14`(139),`col24`(208),`col38`,`col35`),
343 KEY `idx1` (`col48`,`col118`,`col29`(131),`col100`),
344 KEY `idx2` (`col86`,`col67`,`col43`(175)),
345 KEY `idx3` (`col19`),
346 KEY `idx4` (`col40`(220),`col67`),
347 KEY `idx5` (`col99`,`col56`),
348 KEY `idx6` (`col68`,`col28`,`col137`(157)),
349 KEY `idx7` (`col51`(160),`col99`,`col45`,`col39`(9)),
350 KEY `idx8` (`col15`,`col52`,`col90`,`col94`),
351 KEY `idx9` (`col24`(3),`col139`(248),`col108`(118),`col41`),
352 KEY `idx10` (`col36`,`col92`,`col114`),
353 KEY `idx11` (`col115`,`col9`(116)),
354 KEY `idx12` (`col130`,`col93`,`col134`),
355 KEY `idx13` (`col123`(65)),
356 KEY `idx14` (`col44`(90),`col86`,`col119`),
357 KEY `idx15` (`col69`),
358 KEY `idx16` (`col132`,`col81`(118),`col18`),
359 KEY `idx17` (`col24`(250),`col7`,`col92`,`col45`)
360 )engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
361
362 # Creating a table with 199 columns and 1 indexes
363 DROP TABLE IF EXISTS `table3`;
364 --error ER_TOO_BIG_ROWSIZE
365 CREATE TABLE IF NOT EXISTS `table3`
366 (`col0` SMALLINT,
367 `col1` SET ('test1','test2','test3'),
368 `col2` TINYTEXT,
369 `col3` DOUBLE,
370 `col4` NUMERIC,
371 `col5` DATE,
372 `col6` BIGINT,
373 `col7` DOUBLE,
374 `col8` TEXT,
375 `col9` INT,
376 `col10` REAL,
377 `col11` TINYINT,
378 `col12` NUMERIC,
379 `col13` NUMERIC,
380 `col14` TIME,
381 `col15` DOUBLE,
382 `col16` REAL,
383 `col17` MEDIUMBLOB,
384 `col18` YEAR,
385 `col19` TINYTEXT,
386 `col20` YEAR,
387 `col21` CHAR (250),
388 `col22` TINYINT,
389 `col23` TINYINT,
390 `col24` SMALLINT,
391 `col25` DATETIME,
392 `col26` MEDIUMINT,
393 `col27` LONGBLOB,
394 `col28` VARCHAR (106),
395 `col29` FLOAT,
396 `col30` MEDIUMTEXT,
397 `col31` TINYBLOB,
398 `col32` BIGINT,
399 `col33` YEAR,
400 `col34` REAL,
401 `col35` MEDIUMBLOB,
402 `col36` LONGTEXT,
403 `col37` LONGBLOB,
404 `col38` BIGINT,
405 `col39` FLOAT,
406 `col40` TIME,
407 `col41` DATETIME,
408 `col42` BOOL,
409 `col43` BIGINT,
410 `col44` SMALLINT,
411 `col45` TIME,
412 `col46` DOUBLE PRECISION,
413 `col47` TIME,
414 `col48` TINYTEXT,
415 `col49` DOUBLE PRECISION,
416 `col50` BIGINT,
417 `col51` NUMERIC,
418 `col52` TINYBLOB,
419 `col53` DATE,
420 `col54` DECIMAL,
421 `col55` SMALLINT,
422 `col56` TINYTEXT,
423 `col57` ENUM ('test1','test2','test3'),
424 `col58` YEAR,
425 `col59` TIME,
426 `col60` TINYINT,
427 `col61` DECIMAL,
428 `col62` DOUBLE,
429 `col63` DATE,
430 `col64` LONGTEXT,
431 `col65` DOUBLE,
432 `col66` VARCHAR (88),
433 `col67` MEDIUMTEXT,
434 `col68` DATE,
435 `col69` MEDIUMINT,
436 `col70` DECIMAL,
437 `col71` MEDIUMTEXT,
438 `col72` LONGTEXT,
439 `col73` REAL,
440 `col74` DOUBLE,
441 `col75` TIME,
442 `col76` DATE,
443 `col77` DECIMAL,
444 `col78` MEDIUMBLOB,
445 `col79` NUMERIC,
446 `col80` BIGINT,
447 `col81` YEAR,
448 `col82` SMALLINT,
449 `col83` MEDIUMINT,
450 `col84` TINYINT,
451 `col85` MEDIUMBLOB,
452 `col86` TIME,
453 `col87` MEDIUMBLOB,
454 `col88` LONGTEXT,
455 `col89` BOOL,
456 `col90` BLOB,
457 `col91` LONGBLOB,
458 `col92` YEAR,
459 `col93` BLOB,
460 `col94` INT,
461 `col95` TINYTEXT,
462 `col96` TINYINT,
463 `col97` DECIMAL,
464 `col98` ENUM ('test1','test2','test3'),
465 `col99` MEDIUMINT,
466 `col100` TINYINT,
467 `col101` MEDIUMBLOB,
468 `col102` TINYINT,
469 `col103` SET ('test1','test2','test3'),
470 `col104` TIMESTAMP,
471 `col105` TEXT,
472 `col106` DATETIME,
473 `col107` MEDIUMTEXT,
474 `col108` CHAR (220),
475 `col109` TIME,
476 `col110` VARCHAR (131),
477 `col111` DECIMAL,
478 `col112` FLOAT,
479 `col113` SMALLINT,
480 `col114` BIGINT,
481 `col115` LONGBLOB,
482 `col116` SET ('test1','test2','test3'),
483 `col117` ENUM ('test1','test2','test3'),
484 `col118` BLOB,
485 `col119` MEDIUMTEXT,
486 `col120` SET ('test1','test2','test3'),
487 `col121` DATETIME,
488 `col122` FLOAT,
489 `col123` VARCHAR (242),
490 `col124` YEAR,
491 `col125` MEDIUMBLOB,
492 `col126` TIME,
493 `col127` BOOL,
494 `col128` TINYBLOB,
495 `col129` DOUBLE,
496 `col130` TINYINT,
497 `col131` BIGINT,
498 `col132` SMALLINT,
499 `col133` INT,
500 `col134` DOUBLE PRECISION,
501 `col135` MEDIUMBLOB,
502 `col136` SET ('test1','test2','test3'),
503 `col137` TINYTEXT,
504 `col138` DOUBLE PRECISION,
505 `col139` NUMERIC,
506 `col140` BLOB,
507 `col141` SET ('test1','test2','test3'),
508 `col142` INT,
509 `col143` VARCHAR (26),
510 `col144` BLOB,
511 `col145` REAL,
512 `col146` SET ('test1','test2','test3'),
513 `col147` LONGBLOB,
514 `col148` TEXT,
515 `col149` BLOB,
516 `col150` CHAR (189),
517 `col151` LONGTEXT,
518 `col152` INT,
519 `col153` FLOAT,
520 `col154` LONGTEXT,
521 `col155` DATE,
522 `col156` LONGBLOB,
523 `col157` TINYBLOB,
524 `col158` REAL,
525 `col159` DATE,
526 `col160` TIME,
527 `col161` YEAR,
528 `col162` DOUBLE,
529 `col163` VARCHAR (90),
530 `col164` FLOAT,
531 `col165` NUMERIC,
532 `col166` ENUM ('test1','test2','test3'),
533 `col167` DOUBLE PRECISION,
534 `col168` DOUBLE PRECISION,
535 `col169` TINYBLOB,
536 `col170` TIME,
537 `col171` SMALLINT,
538 `col172` TINYTEXT,
539 `col173` SMALLINT,
540 `col174` DOUBLE,
541 `col175` VARCHAR (14),
542 `col176` VARCHAR (90),
543 `col177` REAL,
544 `col178` MEDIUMINT,
545 `col179` TINYBLOB,
546 `col180` FLOAT,
547 `col181` TIMESTAMP,
548 `col182` REAL,
549 `col183` DOUBLE PRECISION,
550 `col184` BIGINT,
551 `col185` INT,
552 `col186` MEDIUMTEXT,
553 `col187` TIME,
554 `col188` FLOAT,
555 `col189` TIME,
556 `col190` INT,
557 `col191` FLOAT,
558 `col192` MEDIUMINT,
559 `col193` TINYINT,
560 `col194` MEDIUMTEXT,
561 `col195` DATE,
562 `col196` TIME,
563 `col197` YEAR,
564 `col198` CHAR (206),
565 KEY `idx0` (`col39`,`col23`)
566 )engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
567
568 # Creating a table with 133 columns and 16 indexes
569 DROP TABLE IF EXISTS `table4`;
570 --error ER_TOO_BIG_ROWSIZE
571 CREATE TABLE IF NOT EXISTS `table4`
572 (`col0` VARCHAR (60),
573 `col1` NUMERIC,
574 `col2` LONGTEXT,
575 `col3` MEDIUMTEXT,
576 `col4` LONGTEXT,
577 `col5` LONGBLOB,
578 `col6` LONGBLOB,
579 `col7` DATETIME,
580 `col8` TINYTEXT,
581 `col9` BLOB,
582 `col10` BOOL,
583 `col11` BIGINT,
584 `col12` TEXT,
585 `col13` VARCHAR (213),
586 `col14` TINYBLOB,
587 `col15` BOOL,
588 `col16` MEDIUMTEXT,
589 `col17` DOUBLE,
590 `col18` TEXT,
591 `col19` BLOB,
592 `col20` SET ('test1','test2','test3'),
593 `col21` TINYINT,
594 `col22` DATETIME,
595 `col23` TINYINT,
596 `col24` ENUM ('test1','test2','test3'),
597 `col25` REAL,
598 `col26` BOOL,
599 `col27` FLOAT,
600 `col28` LONGBLOB,
601 `col29` DATETIME,
602 `col30` FLOAT,
603 `col31` SET ('test1','test2','test3'),
604 `col32` LONGBLOB,
605 `col33` NUMERIC,
606 `col34` YEAR,
607 `col35` VARCHAR (146),
608 `col36` BIGINT,
609 `col37` DATETIME,
610 `col38` DATE,
611 `col39` SET ('test1','test2','test3'),
612 `col40` CHAR (112),
613 `col41` FLOAT,
614 `col42` YEAR,
615 `col43` TIME,
616 `col44` DOUBLE,
617 `col45` NUMERIC,
618 `col46` FLOAT,
619 `col47` DECIMAL,
620 `col48` BIGINT,
621 `col49` DECIMAL,
622 `col50` YEAR,
623 `col51` MEDIUMTEXT,
624 `col52` LONGBLOB,
625 `col53` SET ('test1','test2','test3'),
626 `col54` BLOB,
627 `col55` FLOAT,
628 `col56` REAL,
629 `col57` REAL,
630 `col58` TEXT,
631 `col59` MEDIUMBLOB,
632 `col60` INT,
633 `col61` INT,
634 `col62` DATE,
635 `col63` TEXT,
636 `col64` DATE,
637 `col65` ENUM ('test1','test2','test3'),
638 `col66` DOUBLE PRECISION,
639 `col67` TINYTEXT,
640 `col68` TINYBLOB,
641 `col69` FLOAT,
642 `col70` BLOB,
643 `col71` DATETIME,
644 `col72` DOUBLE,
645 `col73` LONGTEXT,
646 `col74` TIME,
647 `col75` DATETIME,
648 `col76` VARCHAR (122),
649 `col77` MEDIUMTEXT,
650 `col78` MEDIUMTEXT,
651 `col79` BOOL,
652 `col80` LONGTEXT,
653 `col81` TINYTEXT,
654 `col82` NUMERIC,
655 `col83` DOUBLE PRECISION,
656 `col84` DATE,
657 `col85` YEAR,
658 `col86` BLOB,
659 `col87` TINYTEXT,
660 `col88` DOUBLE PRECISION,
661 `col89` MEDIUMINT,
662 `col90` MEDIUMTEXT,
663 `col91` NUMERIC,
664 `col92` DATETIME,
665 `col93` NUMERIC,
666 `col94` SET ('test1','test2','test3'),
667 `col95` TINYTEXT,
668 `col96` SET ('test1','test2','test3'),
669 `col97` YEAR,
670 `col98` MEDIUMINT,
671 `col99` TEXT,
672 `col100` TEXT,
673 `col101` TIME,
674 `col102` VARCHAR (225),
675 `col103` TINYTEXT,
676 `col104` TEXT,
677 `col105` MEDIUMTEXT,
678 `col106` TINYINT,
679 `col107` TEXT,
680 `col108` LONGBLOB,
681 `col109` LONGTEXT,
682 `col110` TINYTEXT,
683 `col111` CHAR (56),
684 `col112` YEAR,
685 `col113` ENUM ('test1','test2','test3'),
686 `col114` TINYBLOB,
687 `col115` DATETIME,
688 `col116` DATE,
689 `col117` TIME,
690 `col118` MEDIUMTEXT,
691 `col119` DOUBLE PRECISION,
692 `col120` FLOAT,
693 `col121` TIMESTAMP,
694 `col122` MEDIUMINT,
695 `col123` YEAR,
696 `col124` DATE,
697 `col125` TEXT,
698 `col126` FLOAT,
699 `col127` TINYTEXT,
700 `col128` BOOL,
701 `col129` NUMERIC,
702 `col130` TIMESTAMP,
703 `col131` INT,
704 `col132` MEDIUMBLOB,
705 KEY `idx0` (`col130`),
706 KEY `idx1` (`col30`,`col55`,`col19`(31)),
707 KEY `idx2` (`col104`(186)),
708 KEY `idx3` (`col131`),
709 KEY `idx4` (`col64`,`col93`,`col2`(11)),
710 KEY `idx5` (`col34`,`col121`,`col22`),
711 KEY `idx6` (`col33`,`col55`,`col83`),
712 KEY `idx7` (`col17`,`col87`(245),`col99`(17)),
713 KEY `idx8` (`col65`,`col120`),
714 KEY `idx9` (`col82`),
715 KEY `idx10` (`col9`(72)),
716 KEY `idx11` (`col88`),
717 KEY `idx12` (`col128`,`col9`(200),`col71`,`col66`),
718 KEY `idx13` (`col77`(126)),
719 KEY `idx14` (`col105`(26),`col13`,`col117`),
720 KEY `idx15` (`col4`(246),`col130`,`col115`,`col3`(141))
721 )engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
722
723 # Creating a table with 176 columns and 13 indexes
724 DROP TABLE IF EXISTS `table5`;
725 --error ER_TOO_BIG_ROWSIZE
726 CREATE TABLE IF NOT EXISTS `table5`
727 (`col0` MEDIUMTEXT,
728 `col1` VARCHAR (90),
729 `col2` TINYTEXT,
730 `col3` TIME,
731 `col4` BOOL,
732 `col5` TINYTEXT,
733 `col6` BOOL,
734 `col7` TIMESTAMP,
735 `col8` TINYBLOB,
736 `col9` TINYINT,
737 `col10` YEAR,
738 `col11` SET ('test1','test2','test3'),
739 `col12` TEXT,
740 `col13` CHAR (248),
741 `col14` BIGINT,
742 `col15` TEXT,
743 `col16` TINYINT,
744 `col17` NUMERIC,
745 `col18` SET ('test1','test2','test3'),
746 `col19` LONGBLOB,
747 `col20` FLOAT,
748 `col21` INT,
749 `col22` TEXT,
750 `col23` BOOL,
751 `col24` DECIMAL,
752 `col25` DOUBLE PRECISION,
753 `col26` FLOAT,
754 `col27` TINYBLOB,
755 `col28` NUMERIC,
756 `col29` MEDIUMBLOB,
757 `col30` DATE,
758 `col31` LONGTEXT,
759 `col32` DATE,
760 `col33` FLOAT,
761 `col34` BIGINT,
762 `col35` TINYTEXT,
763 `col36` MEDIUMTEXT,
764 `col37` TIME,
765 `col38` INT,
766 `col39` TINYINT,
767 `col40` SET ('test1','test2','test3'),
768 `col41` CHAR (130),
769 `col42` SMALLINT,
770 `col43` INT,
771 `col44` MEDIUMTEXT,
772 `col45` VARCHAR (126),
773 `col46` INT,
774 `col47` DOUBLE PRECISION,
775 `col48` BIGINT,
776 `col49` MEDIUMTEXT,
777 `col50` TINYBLOB,
778 `col51` MEDIUMINT,
779 `col52` TEXT,
780 `col53` VARCHAR (208),
781 `col54` VARCHAR (207),
782 `col55` NUMERIC,
783 `col56` DATETIME,
784 `col57` ENUM ('test1','test2','test3'),
785 `col58` NUMERIC,
786 `col59` TINYBLOB,
787 `col60` VARCHAR (73),
788 `col61` MEDIUMTEXT,
789 `col62` TINYBLOB,
790 `col63` DATETIME,
791 `col64` NUMERIC,
792 `col65` MEDIUMINT,
793 `col66` DATETIME,
794 `col67` NUMERIC,
795 `col68` TINYINT,
796 `col69` VARCHAR (58),
797 `col70` DECIMAL,
798 `col71` MEDIUMTEXT,
799 `col72` DATE,
800 `col73` TIME,
801 `col74` DOUBLE PRECISION,
802 `col75` DECIMAL,
803 `col76` MEDIUMBLOB,
804 `col77` REAL,
805 `col78` YEAR,
806 `col79` YEAR,
807 `col80` LONGBLOB,
808 `col81` BLOB,
809 `col82` BIGINT,
810 `col83` ENUM ('test1','test2','test3'),
811 `col84` NUMERIC,
812 `col85` SET ('test1','test2','test3'),
813 `col86` MEDIUMTEXT,
814 `col87` LONGBLOB,
815 `col88` TIME,
816 `col89` ENUM ('test1','test2','test3'),
817 `col90` DECIMAL,
818 `col91` FLOAT,
819 `col92` DATETIME,
820 `col93` TINYTEXT,
821 `col94` TIMESTAMP,
822 `col95` TIMESTAMP,
823 `col96` TEXT,
824 `col97` REAL,
825 `col98` VARCHAR (198),
826 `col99` TIME,
827 `col100` TINYINT,
828 `col101` BIGINT,
829 `col102` LONGBLOB,
830 `col103` LONGBLOB,
831 `col104` MEDIUMINT,
832 `col105` MEDIUMTEXT,
833 `col106` TIMESTAMP,
834 `col107` SMALLINT,
835 `col108` NUMERIC,
836 `col109` DECIMAL,
837 `col110` FLOAT,
838 `col111` DECIMAL,
839 `col112` REAL,
840 `col113` TINYTEXT,
841 `col114` FLOAT,
842 `col115` VARCHAR (7),
843 `col116` LONGTEXT,
844 `col117` DATE,
845 `col118` BIGINT,
846 `col119` TEXT,
847 `col120` BIGINT,
848 `col121` BLOB,
849 `col122` CHAR (110),
850 `col123` NUMERIC,
851 `col124` MEDIUMBLOB,
852 `col125` NUMERIC,
853 `col126` NUMERIC,
854 `col127` BOOL,
855 `col128` TIME,
856 `col129` TINYBLOB,
857 `col130` TINYBLOB,
858 `col131` DATE,
859 `col132` INT,
860 `col133` VARCHAR (123),
861 `col134` CHAR (238),
862 `col135` VARCHAR (225),
863 `col136` LONGTEXT,
864 `col137` LONGBLOB,
865 `col138` REAL,
866 `col139` TINYBLOB,
867 `col140` DATETIME,
868 `col141` TINYTEXT,
869 `col142` LONGBLOB,
870 `col143` BIGINT,
871 `col144` VARCHAR (236),
872 `col145` TEXT,
873 `col146` YEAR,
874 `col147` DECIMAL,
875 `col148` TEXT,
876 `col149` MEDIUMBLOB,
877 `col150` TINYINT,
878 `col151` BOOL,
879 `col152` VARCHAR (72),
880 `col153` INT,
881 `col154` VARCHAR (165),
882 `col155` TINYINT,
883 `col156` MEDIUMTEXT,
884 `col157` DOUBLE PRECISION,
885 `col158` TIME,
886 `col159` MEDIUMBLOB,
887 `col160` LONGBLOB,
888 `col161` DATETIME,
889 `col162` DOUBLE PRECISION,
890 `col163` BLOB,
891 `col164` ENUM ('test1','test2','test3'),
892 `col165` TIMESTAMP,
893 `col166` DATE,
894 `col167` TINYBLOB,
895 `col168` TINYBLOB,
896 `col169` LONGBLOB,
897 `col170` DATETIME,
898 `col171` BIGINT,
899 `col172` VARCHAR (30),
900 `col173` LONGTEXT,
901 `col174` TIME,
902 `col175` FLOAT,
903 KEY `idx0` (`col16`,`col156`(139),`col97`,`col120`),
904 KEY `idx1` (`col24`,`col0`(108)),
905 KEY `idx2` (`col117`,`col173`(34),`col132`,`col82`),
906 KEY `idx3` (`col2`(86)),
907 KEY `idx4` (`col2`(43)),
908 KEY `idx5` (`col83`,`col35`(87),`col111`),
909 KEY `idx6` (`col6`,`col134`,`col92`),
910 KEY `idx7` (`col56`),
911 KEY `idx8` (`col30`,`col53`,`col129`(66)),
912 KEY `idx9` (`col53`,`col113`(211),`col32`,`col15`(75)),
913 KEY `idx10` (`col34`),
914 KEY `idx11` (`col126`),
915 KEY `idx12` (`col24`)
916 )engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
917
918 # Creating a table with 179 columns and 46 indexes
919 DROP TABLE IF EXISTS `table6`;
920 -- error ER_TOO_BIG_ROWSIZE
921 --error ER_TOO_BIG_ROWSIZE
922 CREATE TABLE IF NOT EXISTS `table6`
923 (`col0` ENUM ('test1','test2','test3'),
924 `col1` MEDIUMBLOB,
925 `col2` MEDIUMBLOB,
926 `col3` DATETIME,
927 `col4` DATE,
928 `col5` YEAR,
929 `col6` REAL,
930 `col7` NUMERIC,
931 `col8` MEDIUMBLOB,
932 `col9` TEXT,
933 `col10` TIMESTAMP,
934 `col11` DOUBLE,
935 `col12` DOUBLE,
936 `col13` SMALLINT,
937 `col14` TIMESTAMP,
938 `col15` DECIMAL,
939 `col16` DATE,
940 `col17` TEXT,
941 `col18` LONGBLOB,
942 `col19` BIGINT,
943 `col20` FLOAT,
944 `col21` DATETIME,
945 `col22` TINYINT,
946 `col23` MEDIUMBLOB,
947 `col24` SET ('test1','test2','test3'),
948 `col25` TIME,
949 `col26` TEXT,
950 `col27` LONGTEXT,
951 `col28` BIGINT,
952 `col29` REAL,
953 `col30` YEAR,
954 `col31` MEDIUMBLOB,
955 `col32` MEDIUMINT,
956 `col33` FLOAT,
957 `col34` TEXT,
958 `col35` DATE,
959 `col36` TIMESTAMP,
960 `col37` REAL,
961 `col38` BLOB,
962 `col39` BLOB,
963 `col40` BLOB,
964 `col41` TINYBLOB,
965 `col42` INT,
966 `col43` TINYINT,
967 `col44` REAL,
968 `col45` BIGINT,
969 `col46` TIMESTAMP,
970 `col47` BLOB,
971 `col48` ENUM ('test1','test2','test3'),
972 `col49` BOOL,
973 `col50` CHAR (109),
974 `col51` DOUBLE,
975 `col52` DOUBLE PRECISION,
976 `col53` ENUM ('test1','test2','test3'),
977 `col54` FLOAT,
978 `col55` DOUBLE PRECISION,
979 `col56` CHAR (166),
980 `col57` TEXT,
981 `col58` TIME,
982 `col59` DECIMAL,
983 `col60` TEXT,
984 `col61` ENUM ('test1','test2','test3'),
985 `col62` LONGTEXT,
986 `col63` YEAR,
987 `col64` DOUBLE,
988 `col65` CHAR (87),
989 `col66` DATE,
990 `col67` BOOL,
991 `col68` MEDIUMBLOB,
992 `col69` DATETIME,
993 `col70` DECIMAL,
994 `col71` TIME,
995 `col72` REAL,
996 `col73` LONGTEXT,
997 `col74` BLOB,
998 `col75` REAL,
999 `col76` INT,
1000 `col77` INT,
1001 `col78` FLOAT,
1002 `col79` DOUBLE,
1003 `col80` MEDIUMINT,
1004 `col81` ENUM ('test1','test2','test3'),
1005 `col82` VARCHAR (221),
1006 `col83` BIGINT,
1007 `col84` TINYINT,
1008 `col85` BIGINT,
1009 `col86` FLOAT,
1010 `col87` MEDIUMBLOB,
1011 `col88` CHAR (126),
1012 `col89` MEDIUMBLOB,
1013 `col90` DATETIME,
1014 `col91` TINYINT,
1015 `col92` DOUBLE,
1016 `col93` NUMERIC,
1017 `col94` DATE,
1018 `col95` BLOB,
1019 `col96` DATETIME,
1020 `col97` TIME,
1021 `col98` LONGBLOB,
1022 `col99` INT,
1023 `col100` SET ('test1','test2','test3'),
1024 `col101` TINYBLOB,
1025 `col102` INT,
1026 `col103` MEDIUMBLOB,
1027 `col104` MEDIUMTEXT,
1028 `col105` FLOAT,
1029 `col106` TINYBLOB,
1030 `col107` VARCHAR (26),
1031 `col108` TINYINT,
1032 `col109` TIME,
1033 `col110` TINYBLOB,
1034 `col111` LONGBLOB,
1035 `col112` TINYTEXT,
1036 `col113` FLOAT,
1037 `col114` TINYINT,
1038 `col115` NUMERIC,
1039 `col116` TIME,
1040 `col117` SET ('test1','test2','test3'),
1041 `col118` DATE,
1042 `col119` SMALLINT,
1043 `col120` BLOB,
1044 `col121` TINYTEXT,
1045 `col122` REAL,
1046 `col123` YEAR,
1047 `col124` REAL,
1048 `col125` BOOL,
1049 `col126` BLOB,
1050 `col127` REAL,
1051 `col128` MEDIUMBLOB,
1052 `col129` TIMESTAMP,
1053 `col130` LONGBLOB,
1054 `col131` MEDIUMBLOB,
1055 `col132` YEAR,
1056 `col133` YEAR,
1057 `col134` INT,
1058 `col135` MEDIUMINT,
1059 `col136` MEDIUMINT,
1060 `col137` TINYTEXT,
1061 `col138` TINYBLOB,
1062 `col139` BLOB,
1063 `col140` SET ('test1','test2','test3'),
1064 `col141` ENUM ('test1','test2','test3'),
1065 `col142` ENUM ('test1','test2','test3'),
1066 `col143` TINYTEXT,
1067 `col144` DATETIME,
1068 `col145` TEXT,
1069 `col146` DOUBLE PRECISION,
1070 `col147` DECIMAL,
1071 `col148` MEDIUMTEXT,
1072 `col149` TINYTEXT,
1073 `col150` SET ('test1','test2','test3'),
1074 `col151` MEDIUMTEXT,
1075 `col152` CHAR (126),
1076 `col153` DOUBLE,
1077 `col154` CHAR (243),
1078 `col155` SET ('test1','test2','test3'),
1079 `col156` SET ('test1','test2','test3'),
1080 `col157` DATETIME,
1081 `col158` DOUBLE,
1082 `col159` NUMERIC,
1083 `col160` DECIMAL,
1084 `col161` FLOAT,
1085 `col162` LONGBLOB,
1086 `col163` LONGTEXT,
1087 `col164` INT,
1088 `col165` TIME,
1089 `col166` CHAR (27),
1090 `col167` VARCHAR (63),
1091 `col168` TEXT,
1092 `col169` TINYBLOB,
1093 `col170` TINYBLOB,
1094 `col171` ENUM ('test1','test2','test3'),
1095 `col172` INT,
1096 `col173` TIME,
1097 `col174` DECIMAL,
1098 `col175` DOUBLE,
1099 `col176` MEDIUMBLOB,
1100 `col177` LONGBLOB,
1101 `col178` CHAR (43),
1102 KEY `idx0` (`col131`(219)),
1103 KEY `idx1` (`col67`,`col122`,`col59`,`col87`(33)),
1104 KEY `idx2` (`col83`,`col42`,`col57`(152)),
1105 KEY `idx3` (`col106`(124)),
1106 KEY `idx4` (`col173`,`col80`,`col165`,`col89`(78)),
1107 KEY `idx5` (`col174`,`col145`(108),`col23`(228),`col141`),
1108 KEY `idx6` (`col157`,`col140`),
1109 KEY `idx7` (`col130`(188),`col15`),
1110 KEY `idx8` (`col52`),
1111 KEY `idx9` (`col144`),
1112 KEY `idx10` (`col155`),
1113 KEY `idx11` (`col62`(230),`col1`(109)),
1114 KEY `idx12` (`col151`(24),`col95`(85)),
1115 KEY `idx13` (`col114`),
1116 KEY `idx14` (`col42`,`col98`(56),`col146`),
1117 KEY `idx15` (`col147`,`col39`(254),`col35`),
1118 KEY `idx16` (`col79`),
1119 KEY `idx17` (`col65`),
1120 KEY `idx18` (`col149`(165),`col168`(119),`col32`,`col117`),
1121 KEY `idx19` (`col64`),
1122 KEY `idx20` (`col93`),
1123 KEY `idx21` (`col64`,`col113`,`col104`(182)),
1124 KEY `idx22` (`col52`,`col111`(189)),
1125 KEY `idx23` (`col45`),
1126 KEY `idx24` (`col154`,`col107`,`col110`(159)),
1127 KEY `idx25` (`col149`(1),`col87`(131)),
1128 KEY `idx26` (`col58`,`col115`,`col63`),
1129 KEY `idx27` (`col95`(9),`col0`,`col87`(113)),
1130 KEY `idx28` (`col92`,`col130`(1)),
1131 KEY `idx29` (`col151`(129),`col137`(254),`col13`),
1132 KEY `idx30` (`col49`),
1133 KEY `idx31` (`col28`),
1134 KEY `idx32` (`col83`,`col146`),
1135 KEY `idx33` (`col155`,`col90`,`col17`(245)),
1136 KEY `idx34` (`col174`,`col169`(44),`col107`),
1137 KEY `idx35` (`col113`),
1138 KEY `idx36` (`col52`),
1139 KEY `idx37` (`col16`,`col120`(190)),
1140 KEY `idx38` (`col28`),
1141 KEY `idx39` (`col131`(165)),
1142 KEY `idx40` (`col135`,`col26`(86)),
1143 KEY `idx41` (`col69`,`col94`),
1144 KEY `idx42` (`col105`,`col151`(38),`col97`),
1145 KEY `idx43` (`col88`),
1146 KEY `idx44` (`col176`(100),`col42`,`col73`(189),`col94`),
1147 KEY `idx45` (`col2`(27),`col27`(116))
1148 )engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
1149
1150 DROP TABLE IF EXISTS table0;
1151 DROP TABLE IF EXISTS table1;
1152 DROP TABLE IF EXISTS table2;
1153 DROP TABLE IF EXISTS table3;
1154 DROP TABLE IF EXISTS table4;
1155 DROP TABLE IF EXISTS table5;
1156 -- enable_query_log
1157 DROP TABLE IF EXISTS table6;
1158
1159 --source include/test_db_charset_restore.inc