Bug #80521 I can't create a big talbe in new mysql5.7.11

• Submitted: 26 Feb 2016 3:44
• Modified: 4 Apr 2016 9:54
• Reporter: xunpeng li
• Status: Can't repeat
• Category: MySQL Server: DDL
• Severity: S2 (Serious)
• Version: mysql 5.7.11
• OS: Any (Centos 6.6)
• CPU Architecture: Any
• Tags: mysql5.7.11 ERROR 1118 (42000): Row size too large (> 8126)

[26 Feb 2016 3:44] xunpeng li

Description:
I can't create a big talbe in new mysql5.7.11,but this table can be build in mysql 5.6.22,why?
CREATE TABLE `def_model_detail_lxpresize_20160224` (
    ->   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '策源车型id',
    ->   `series_id` int(11) NOT NULL COMMENT '车系id',
    ->   `series_name_id` int(11) NOT NULL COMMENT '车系名id',
    ->   `model` varchar(225) NOT NULL COMMENT '车型',
    ->   `come_from` int(10) DEFAULT NULL COMMENT '1:表示策源 2:易车 3:汽车之家',

............... omit some lines because of your system limit
     ->   `central_lcd_splitview` varchar(20) DEFAULT NULL COMMENT '中控液晶屏分屏显示',
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=InnoDB AUTO_INCREMENT=1034911 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
mysql> 

How to repeat:
run this sql in mysql5.7.11

[4 Apr 2016 9:54] MySQL Verification Team

Hi xunpeng,

Thank you for the report.
It seems to me that provided table DDL is truncated. Could you please upload un-truncated SHOW CREATE TABLE <table_name>\G output?

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Umesh