Bug #702 Merge table does not allow if it contains compressed tables

• Submitted: 23 Jun 2003 14:40
• Modified: 15 Jul 2003 12:58
• Reporter: Arun Devaravar
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 3.23.49a
• OS: Linux (Linux)
• Assigned to: Sergei Golubchik
• CPU Architecture: Any

[23 Jun 2003 14:40] Arun Devaravar

Description:
*Merge table does not allow the 'ALTER TABLE' command if it contains compressed tables.  Is it bug in MySQL? 

How to repeat:
1) create table arunt1 (id int);
2) create table arunt2 (id int);
3) create data file (/tmp/a.txt) with 10000 rows
4) load data infile '/tmp/a.txt' into table arunt1;
5) $ myisampack arunt1 (shell command)
6) create table arunt (id int) union=(arunt1, arunt2) type=merge;
7) disconnect MySQL connection.
8) alter table arunt union=(arunt1, arunt2) ;
ERROR 1036: Table 'arunt' is read only

[7 Jul 2003 10:43] MySQL Verification Team

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Compressed table like stand in the Manual and the error message
showed are read only, this mean that alter table or any other
action which perform write operation aren't supported.

[7 Jul 2003 11:03] Sergei Golubchik

ok, acknowledged.
Of course, ALTER TABLE ... UNION=() should be allowed

[7 Jul 2003 11:16] Arun Devaravar

I am NOT altering compressed table. Trying to alter MERGE table definition to add/remove a table.

[15 Jul 2003 11:42] Sergei Golubchik

fixed in 4.0.15

[15 Jul 2003 12:09] Sergei Golubchik

actually, it'll be in 4.0.14

[15 Jul 2003 12:46] Arun Devaravar

Any plan to port it back to 3.23.xx?

[15 Jul 2003 12:58] Sergei Golubchik

no. It's not critical enough for that.