From 321d50fd06c7ddcc9a32ed661c3a91e48178e6f8 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 14 May 2004 12:49:18 +0200 Subject: better fix for bug#3749 - do not consider already removed keys in key removal process mysql-test/r/innodb.result: tests for bug#3749 mysql-test/t/innodb.test: tests for bug#3749 --- mysql-test/t/innodb.test | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) (limited to 'mysql-test/t/innodb.test') diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index a260ab1263d..babfdcb535f 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -1086,4 +1086,14 @@ drop table t2; --error 1005 create table t2 (id int(11) not null, id2 int(11) not null, constraint t1_id_fk foreign key (id2,id) references t1 (id)) engine = innodb; -drop table t1; +# bug#3749 + +create table t2 (a int auto_increment primary key, b int, index(b), foreign key (b) references t1(id), unique(b)) engine=innodb; +show create table t2; +drop table t2; +create table t2 (a int auto_increment primary key, b int, foreign key (b) references t1(id), foreign key (b) references t1(id), unique(b)) engine=innodb; +show create table t2; +drop table t2, t1; + + + -- cgit v1.2.1