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