Bug #30566 | Can't use ALTER TABLE to rename a compressed MyISAM table | ||
---|---|---|---|
Submitted: | 22 Aug 2007 15:08 | Modified: | 28 Nov 2008 20:11 |
Reporter: | Sean Chighizola | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S3 (Non-critical) |
Version: | 4.1.20/5.0/5.1BK | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | ALTER TABLE, compressed, myisam |
[22 Aug 2007 15:08]
Sean Chighizola
[26 Aug 2007 16:32]
MySQL Verification Team
Thank you for the bug report. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.22-beta-debug Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show table status like 'table_1'\G *************************** 1. row *************************** Name: table_1 Engine: MyISAM Version: 10 Row_format: Compressed Rows: 2097152 Avg_row_length: 4 Data_length: 8389258 Max_data_length: 281474976710655 Index_length: 23700480 Data_free: 0 Auto_increment: 2097153 Create_time: 2007-08-26 13:23:18 Update_time: 2007-08-26 13:26:11 Check_time: 2007-08-26 13:29:34 Collation: latin1_swedish_ci Checksum: 1998802833 Create_options: Comment: 1 row in set (0.01 sec) mysql> ALTER TABLE table_1 RENAME TO table_2; ERROR 1036 (HY000): Table 'table_1' is read only mysql> RENAME TABLE table_1 TO table_2; Query OK, 0 rows affected (0.00 sec) mysql> show table status like 'table_2'\G *************************** 1. row *************************** Name: table_2 Engine: MyISAM Version: 10 Row_format: Compressed Rows: 2097152 Avg_row_length: 4 Data_length: 8389258 Max_data_length: 281474976710655 Index_length: 23700480 Data_free: 0 Auto_increment: 2097153 Create_time: 2007-08-26 13:23:18 Update_time: 2007-08-26 13:26:11 Check_time: 2007-08-26 13:29:34 Collation: latin1_swedish_ci Checksum: 1998802833 Create_options: Comment: 1 row in set (0.00 sec) mysql>