Bug #7643 ALTER TABLE fails for CSV, EXAMPLE, ARCHIVE engines

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;

Thank you for the bug report.

The following altering works fine on my box:
csv <-> MyISAM
csv <-> archive
archive <-> MyISAM

But I cannot alter example tables.

... which is expected because of its entity.

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

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

Patch looks fine to me.

See email on review.

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

Ok to push

fixed in 4.1.20

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)