diff options
| author | heikki@hundin.mysql.fi <> | 2004-02-02 01:30:59 +0200 |
|---|---|---|
| committer | heikki@hundin.mysql.fi <> | 2004-02-02 01:30:59 +0200 |
| commit | 77d60aa63c4be815f63c3b959df0c1e4b6e0da99 (patch) | |
| tree | f53ddf8621117079600f3403859f6700b59b0108 /mysql-test/r | |
| parent | 7e19a8ee6571b3d1c3d7d8f5e2d2812a4b1935db (diff) | |
| download | mariadb-git-77d60aa63c4be815f63c3b959df0c1e4b6e0da99.tar.gz | |
innodb.result, innodb.test:
Change tests so that tables are dropped in an order respecting the FOREIGN KEY constraints
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/innodb.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index ca4a49fea4e..416c583a8d7 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -1004,7 +1004,7 @@ select * from t1; id select * from t2; id t1_id -drop table t1,t2; +drop table t2,t1; DROP TABLE IF EXISTS t1,t2; CREATE TABLE t1(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE t2(id INT PRIMARY KEY, t1_id INT, INDEX par_ind (t1_id) ) TYPE=INNODB; @@ -1245,4 +1245,4 @@ a drop table t1; CREATE TABLE t1 (`id 1` INT NOT NULL, PRIMARY KEY (`id 1`)) TYPE=INNODB; CREATE TABLE t2 (id INT PRIMARY KEY, t1_id INT, INDEX par_ind (t1_id), FOREIGN KEY (`t1_id`) REFERENCES `t1`(`id 1`) ON DELETE CASCADE ) TYPE=INNODB; -drop table t1,t2; +drop table t2,t1; |