Bug #7643 ALTER TABLE fails for CSV, EXAMPLE, ARCHIVE engines
Submitted: 3 Jan 2005 18:05 Modified: 4 May 2006 15:55
Reporter: Paul DuBois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.9 OS:
Assigned to: Ramil Kalimullin CPU Architecture:Any

[3 Jan 2005 18:05] Paul DuBois
Description:
ALTER TABLE generally fails for tables created using the CSV,
EXAMPLE, or ARCHIVE engines. For example, a table of any
of the three types cannot be altered to a table of either of
the other types.  ALTER TABLE from CSV to MyISAM appears
to work, but this seems to be the exception.

How to repeat:
drop table if exists t;
create table t (i int) engine = csv;
show create table t;
alter table t engine = archive;
show create table t;
alter table t engine = example;
show create table t;
drop table if exists t;
create table t (i int) engine = archive;
show create table t;
alter table t engine = csv;
show create table t;
alter table t engine = example;
show create table t;
drop table if exists t;
create table t (i int) engine = example;
show create table t;
alter table t engine = csv;
show create table t;
alter table t engine = archive;
show create table t;
[4 Jan 2005 4:33] MySQL Verification Team
Thank you for the bug report.
[21 Nov 2005 11:31] Ramil Kalimullin
The following altering works fine on my box:
csv <-> MyISAM
csv <-> archive
archive <-> MyISAM

But I cannot alter example tables.
[21 Nov 2005 14:14] Ramil Kalimullin
... which is expected because of its entity.
[20 Feb 2006 7:51] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2887
[20 Feb 2006 10:30] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2895
[10 Apr 2006 13:25] Magnus Blåudd
Patch looks fine to me.
[18 Apr 2006 0:05] Brian Aker
See email on review.
[25 Apr 2006 10:29] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/5462
[27 Apr 2006 13:02] Magnus Blåudd
Ok to push
[2 May 2006 11:02] Ramil Kalimullin
fixed in 4.1.20
[4 May 2006 15:55] Paul DuBois
Noted in 4.1.20 changelog.

No error message was being issued for storage engines that do
not support <literal>ALTER TABLE</literal>. Now an
<literal>ER_NOT_SUPPORTED_YET</literal> error occurs. (Bug
#7643)