List:Internals« Previous MessageNext Message »
From:Marko Mäkelä Date:April 3 2007 11:40am
Subject:Some forms of ALTER TABLE are a no-op in 5.1?
View as plain text  
Hi all,

I come across this strange behaviour:

create table t(t int primary key)engine=innodb;
alter table t row_format=redundant;
alter table t row_format=compact;
alter table t avg_row_length=8;
alter table t avg_row_length=4;

None of the ALTER TABLE commands are reaching ha_innobase::create().
This feels like a severe bug.  The InnoDB method is called only after
appending ENGINE=InnoDB to the statements.  The CREATE TABLE does create
an InnoDB tablespace for the table.

I've repeated this with a tree from the end of January.  However,
I believe that the bug still exists, because Vadim Tkachenko was having
similar problems, and I believe he must have checked out the MySQL 5.1
tree at most a couple of weeks ago.

Best regards,

	Marko
Thread
Some forms of ALTER TABLE are a no-op in 5.1?Marko Mäkelä3 Apr
  • Re: Some forms of ALTER TABLE are a no-op in 5.1?Marko Mäkelä3 Apr