summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <heikki@hundin.mysql.fi>2004-02-02 01:41:35 +0200
committerunknown <heikki@hundin.mysql.fi>2004-02-02 01:41:35 +0200
commit0ba7ef007eb04fbe8e508878d02fb4a987f05250 (patch)
treeaffe55c81ed341aac7c2b3807b57b4dae564bec9 /mysql-test
parent2b9e17449932eed3458e098b23d8686538e21fa3 (diff)
downloadmariadb-git-0ba7ef007eb04fbe8e508878d02fb4a987f05250.tar.gz
rpl_insert_id.test, rpl_insert_id.result:
Change tests so that tables are dropped in an order respecting the FOREIGN KEY constraints mysql-test/r/rpl_insert_id.result: Change tests so that tables are dropped in an order respecting the FOREIGN KEY constraints mysql-test/t/rpl_insert_id.test: Change tests so that tables are dropped in an order respecting the FOREIGN KEY constraints
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/rpl_insert_id.result2
-rw-r--r--mysql-test/t/rpl_insert_id.test2
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/rpl_insert_id.result b/mysql-test/r/rpl_insert_id.result
index 889e7891770..d2dfbb05675 100644
--- a/mysql-test/r/rpl_insert_id.result
+++ b/mysql-test/r/rpl_insert_id.result
@@ -39,8 +39,8 @@ select * from t2;
b c
5 0
6 11
-drop table t1;
drop table t2;
+drop table t1;
create table t1(a int auto_increment, key(a));
create table t2(b int auto_increment, c int, key(b));
insert into t1 values (10);
diff --git a/mysql-test/t/rpl_insert_id.test b/mysql-test/t/rpl_insert_id.test
index 49fefae72b8..a6da44de456 100644
--- a/mysql-test/t/rpl_insert_id.test
+++ b/mysql-test/t/rpl_insert_id.test
@@ -42,8 +42,8 @@ connection master;
# check if INSERT SELECT in auto_increment is well replicated (bug #490)
-drop table t1;
drop table t2;
+drop table t1;
create table t1(a int auto_increment, key(a));
create table t2(b int auto_increment, c int, key(b));
insert into t1 values (10);