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 Email Updates:
Status: Closed Impact on me:
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
*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.