MySQL Bugs: #49584: SHOW TABLE STATUS doc should say that InnoDB tables can be Compressed or Dynamic

Bug #49584	SHOW TABLE STATUS doc should say that InnoDB tables can be Compressed or Dynamic
Submitted:	10 Dec 2009 12:48	Modified:	10 Dec 2009 16:16
Reporter:	Marko Mäkelä	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1.41	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
This piece in http://dev.mysql.com/doc/refman/5.1/en/show-table-status.html is out of date:

“The row storage format (Fixed, Dynamic, Compressed, Redundant, Compact). The format of InnoDB tables is reported as Redundant or Compact.”

In the Barracuda file format of the InnoDB Plugin that is bundled with MySQL 5.1, row storage format can be Dynamic or Compressed.

How to repeat:
set global innodb_file_format=barracuda;
create table d(a int)engine=innodb row_format=dynamic;
create table c(a int)engine=innodb row_format=compressed;
show table status;

Suggested fix:
Say that in the Barracuda file format of the InnoDB plugin, row_format may also be Compressed or Dynamic.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.