diff options
author | unknown <serg@serg.mylan> | 2004-05-15 11:26:58 +0200 |
---|---|---|
committer | unknown <serg@serg.mylan> | 2004-05-15 11:26:58 +0200 |
commit | 36bce251128b8fd300c4a6329d0c2d8f601a14bc (patch) | |
tree | 7511a87efd9dc5060078495d60fc5092288b31ec /mysql-test/t/innodb.test | |
parent | b40430e08cf40d931c511d4d31ea517b7294417b (diff) | |
parent | fdd4717730796ba178cc59c3609e8693ed967105 (diff) | |
download | mariadb-git-36bce251128b8fd300c4a6329d0c2d8f601a14bc.tar.gz |
merged
mysql-test/r/innodb.result:
Auto merged
mysql-test/t/innodb.test:
Auto merged
sql/sql_select.cc:
Auto merged
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 babfdcb535f..47e82db2dc4 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; |