Bug #77625 clarify in the doc row_format=fixed is not supported for InnoDB Storage engine

• Submitted: 6 Jul 2015 10:44
• Modified: 16 Jul 2015 18:14
• Reporter: Rahul Sisondia
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.7.8
• OS: Any
• CPU Architecture: Any

[6 Jul 2015 10:44] Rahul Sisondia

Description:
Hi,

I am referring the following page for create table. 

https://dev.mysql.com/doc/refman/5.7/en/create-table.html

Following supported Row_formats are mentioned here. 

  | ROW_FORMAT [=] {DEFAULT|DYNAMIC|FIXED|COMPRESSED|REDUNDANT|COMPACT}

In 5.6 InnoDB silently used to convert row_format from Fixed to Compact and create table but looks like for InnoDB row_format=FIXED is not supported anymore in 5.7.  

I think we should clarify following in our documentation - 
If ROW_FORMAT=FIXED is not supported by InnoDB Storage engine starting from 5.7 but it might be supported for other storage engines e.g. MyISAM. 

How to repeat:
mysql> CREATE TABLE dbb.td4(a CHAR(4))ENGINE=INNODB ROW_FORMAT=FIXED;
ERROR 1031 (HY000): Table storage engine for 'td4' doesn't have this option

Suggested fix:
Improve the documentation

[16 Jul 2015 18:14] Daniel Price

"ROW_FORMAT=FIXED is not supported. If ROW_FORMAT=FIXED is specified while
innodb_strict_mode is disabled, InnoDB issues a warning and assumes
ROW_FORMAT=COMPACT. If ROW_FORMAT=FIXED is specified while
innodb_strict_mode is enabled, which is the default as of MySQL 5.7.7,
InnoDB returns an error."

5.1, 5.5, 5.6 versions of the reference manual were also updated. Changes
should appear online within 24 hours.

Thank you for the bug report.