Hello,
Does anyone have any idea why the following don't work in MySQL
4.1.1-alpha with InnoDB tables:
1. cannot change column type without first dropping the foreign key
(when there is one)
2. cannot drop the column without first dropping the foreign key (if
there is one)
3. cannot explicitly d
Take the following InnoDB table in MySQL 4.1.1-alpha:
create table tt1 (
r1 int(10),
key (r1),
constraint r1 foreign key (r1) references pfwuser(usrid)
) type=InnoDB;
If I try to change the column type like this:
alter table tt1 modify r1 varchar(255);
I get an error:
mysql> alter table t
