summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb.test
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2004-05-15 11:26:58 +0200
committerunknown <serg@serg.mylan>2004-05-15 11:26:58 +0200
commit36bce251128b8fd300c4a6329d0c2d8f601a14bc (patch)
tree7511a87efd9dc5060078495d60fc5092288b31ec /mysql-test/t/innodb.test
parentb40430e08cf40d931c511d4d31ea517b7294417b (diff)
parentfdd4717730796ba178cc59c3609e8693ed967105 (diff)
downloadmariadb-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.test10
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;