diff options
| author | unknown <serg@serg.mylan> | 2004-05-14 12:49:18 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-05-14 12:49:18 +0200 |
| commit | 321d50fd06c7ddcc9a32ed661c3a91e48178e6f8 (patch) | |
| tree | de887cd555d5743340c1f8dcc0cf303148cdb537 /mysql-test/t/innodb.test | |
| parent | 1d51406e298ed7e3f6ddb5e239088a03774418ef (diff) | |
| download | mariadb-git-321d50fd06c7ddcc9a32ed661c3a91e48178e6f8.tar.gz | |
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
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 12 |
1 files changed, 11 insertions, 1 deletions
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; + + + |