1
SET GLOBAL innodb_file_format='Barracuda';
2
SET GLOBAL innodb_file_per_table=on;
4
CREATE TABLE bug53591(a text charset utf8 not null)
5
ENGINE=InnoDB KEY_BLOCK_SIZE=1;
6
ALTER TABLE bug53591 ADD PRIMARY KEY(a(220));
7
ERROR HY000: Too big row
11
Error 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
13
SET GLOBAL innodb_file_format=Antelope;
14
SET GLOBAL innodb_file_per_table=0;