Bug #32042 alter table ... row_format=default got an error on compressed table

• Submitted: 2 Nov 2007 5:11
• Modified: 7 Nov 2007 11:48
• Reporter: Jedy Wu
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.1.22-rc
• OS: Any
• Assigned to: Jon Stephens
• CPU Architecture: Any
• Tags: decompress, myisam, ROW_FORMAT

[2 Nov 2007 5:11] Jedy Wu

Description:
I used "alter table city row_format=default" to decompress table "city" according to http://dev.mysql.com/doc/refman/5.1/en/myisam-table-formats.html, "You can decompress tables by specifying ROW_FORMAT=DEFAULT with ALTER TABLE. ", but got an error: ERROR 1036 (HY000): Table 'city' is read only.

How to repeat:
use world database

shell> myisampack city
shell> myisamchk -rq city
mysql> >alter table city row_format=default;
ERROR 1036 (HY000): Table 'city' is read only

[2 Nov 2007 7:08] Jon Stephens

http://dev.mysql.com/doc/refman/5.1/en/myisampack.html says: "To unpack a packed table, use the --unpack option to myisamchk" so it seems we may have a contradiction.

Verified bug and assigned to myself for further investigation/resolution.

[7 Nov 2007 11:48] Jon Stephens

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.

Verified the precise error reported by the submitter (using 5.1-telco-6.3.6-bk and 6.0.4-bk).

Also verified directly that the only way to decompress packed MyISAM tables is by using myisamchk, and updated the indicated page in the Manual to say so.