diff options
| author | unknown <heikki@hundin.mysql.fi> | 2004-02-02 01:30:59 +0200 |
|---|---|---|
| committer | unknown <heikki@hundin.mysql.fi> | 2004-02-02 01:30:59 +0200 |
| commit | 2b9e17449932eed3458e098b23d8686538e21fa3 (patch) | |
| tree | f53ddf8621117079600f3403859f6700b59b0108 /mysql-test/r/innodb.result | |
| parent | 1b8d5ca887918ee77f4ccc7a73df115c00885a40 (diff) | |
| download | mariadb-git-2b9e17449932eed3458e098b23d8686538e21fa3.tar.gz | |
innodb.result, innodb.test:
Change tests so that tables are dropped in an order respecting the FOREIGN KEY constraints
mysql-test/t/innodb.test:
Change tests so that tables are dropped in an order respecting the FOREIGN KEY constraints
mysql-test/r/innodb.result:
Change tests so that tables are dropped in an order respecting the FOREIGN KEY constraints
Diffstat (limited to 'mysql-test/r/innodb.result')
| -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; |