diff options
| author | unknown <monty@mysql.com> | 2004-05-15 11:57:40 +0300 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2004-05-15 11:57:40 +0300 |
| commit | c9667f114695bbf9dda1548b2c48a44b89c580b0 (patch) | |
| tree | bc0f1775f58953cbf0e41e15b7cb5874821c8578 /mysql-test/t/innodb.test | |
| parent | dd4be0244d57da44351d6788dc9e29d2bcb60ea3 (diff) | |
| download | mariadb-git-c9667f114695bbf9dda1548b2c48a44b89c580b0.tar.gz | |
Better fix for bug #3749 (bug in deleting automatic generated foreign keys)
mysql-test/r/func_encrypt.result:
Update tests (left after sanjas last push)
mysql-test/r/innodb.result:
Added test for bug #3749 (bug in deleting automatic generated foreign keys)
mysql-test/t/innodb.test:
Added test for bug #3749 (bug in deleting automatic generated foreign keys)
sql/sql_class.cc:
Updated comment
tests/client_test.c:
Added missing mysql_stmt_close()
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index a260ab1263d..36b2914ef46 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -1082,6 +1082,16 @@ create table t2 (id int(11) not null, id2 int(11) not null, unique (id,id2),cons show create table t2; drop table t2; +create table t2 (id int(11) not null auto_increment, id2 int(11) not null, constraint t1_id_fk foreign key (id) references t1 (id), primary key (id), index (id,id2)) engine = innodb; +show create table t2; +drop table t2; + +create table t2 (id int(11) not null auto_increment, id2 int(11) not null, constraint t1_id_fk foreign key (id) references t1 (id)) engine= innodb; +show create table t2; +alter table t2 add index id_test (id), add index id_test2 (id,id2); +show create table t2; +drop table t2; + # Test error handling --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; |