Bug #50733 "optimize table" decompress silently
Submitted: 29 Jan 2010 14:40 Modified: 29 Jan 2010 17:25
Reporter: Harald Reindl Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: InnoDB Plugin storage engine Severity:S3 (Non-critical)
Version:5.1.41 / 5.1.43 OS:Any
Assigned to: CPU Architecture:Any

[29 Jan 2010 14:40] Harald Reindl 
Description:
"ALTER TABLE dbmail_acl ROW_FORMAT=COMPRESSED;" works first time:
Format:   Compressed
Options:  row_format=COMPRESSED

After "optimize table dbmail_acl;"
Format:   Compact
Options:  row_format=COMPRESSED

The data are uncompress after that, the options are still "row_format=compressed", so there must be a bug that compression get lost while recreate a table

How to repeat:
* Change to row_format=COMPRESSED
* optimize table
* look at the format

Suggested fix:
The row format must not get lost while re-creating a table
[29 Jan 2010 15:12] Valeriy Kravchuk 
Looks like a duplicate of bug #39200. Please, check.
[29 Jan 2010 15:55] Harald Reindl 
Yes, this is the same bug!
wonder how old the report is...

Sorry i did not look exactly before submit because i have "bugreport-day" and reported today a couple of bus to kde/fedora/php/mysql/mozilla to get rid of the things i hate since months
[29 Jan 2010 17:25] Valeriy Kravchuk 
Duplicate of bug #39200.