| 1 |
-- source include/have_innodb_max_16k.inc |
| 2 |
call mtr.add_suppression("Cannot alter the table .* because the record size will exceed the maximum allowed size for a record .*"); |
| 3 |
let $file_per_table=`select @@innodb_file_per_table`; |
| 4 |
|
| 5 |
SET GLOBAL innodb_file_per_table=on; |
| 6 |
|
| 7 |
set old_alter_table=0; |
| 8 |
|
| 9 |
CREATE TABLE bug53591(a text charset utf8 not null) |
| 10 |
ENGINE=InnoDB KEY_BLOCK_SIZE=1; |
| 11 |
-- replace_result 8126 {checked_valid} 4030 {checked_valid} 1982 {checked_valid} |
| 12 |
-- error ER_TOO_BIG_ROWSIZE |
| 13 |
ALTER TABLE bug53591 ADD PRIMARY KEY(a(220)); |
| 14 |
-- replace_result 8126 {checked_valid} 4030 {checked_valid} 1982 {checked_valid} |
| 15 |
SHOW WARNINGS; |
| 16 |
|
| 17 |
DROP TABLE bug53591; |
| 18 |
|
| 19 |
EVAL SET GLOBAL innodb_file_per_table=$file_per_table; |