Bug #702 Merge table does not allow if it contains compressed tables
Submitted: 23 Jun 2003 16:40 Modified: 15 Jul 2003 14:58
Reporter: Arun Devaravar
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:3.23.49a OS:Linux (Linux)
Assigned to: Sergei Golubchik Target Version:

[23 Jun 2003 16: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 12:43] Miguel Solorzano 
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 13:03] Sergei Golubchik 
ok, acknowledged.
Of course, ALTER TABLE ... UNION=() should be allowed
[7 Jul 2003 13:16] Arun Devaravar 
I am NOT altering compressed table. Trying to alter MERGE table definition to add/remove a
table.
[15 Jul 2003 13:42] Sergei Golubchik 
fixed in 4.0.15
[15 Jul 2003 14:09] Sergei Golubchik 
actually, it'll be in 4.0.14
[15 Jul 2003 14:46] Arun Devaravar 
Any plan to port it back to 3.23.xx?
[15 Jul 2003 14:58] Sergei Golubchik 
no. It's not critical enough for that.