diff options
| author | timour@mysql.com <> | 2004-12-16 18:44:39 +0200 |
|---|---|---|
| committer | timour@mysql.com <> | 2004-12-16 18:44:39 +0200 |
| commit | cc6a30214c9b2e5f072115dededa10c9e960d296 (patch) | |
| tree | 2f8ac31128a34219a141a10948e8016064d62856 /mysql-test | |
| parent | 53a9af8f1da46f30b31c52ad14369ccee1718ede (diff) | |
| download | mariadb-git-cc6a30214c9b2e5f072115dededa10c9e960d296.tar.gz | |
Moved drop table statement to the end.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/update.result | 1 | ||||
| -rw-r--r-- | mysql-test/t/update.test | 2 |
2 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index 08b7f942ccc..2d0903a4dae 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -209,3 +209,4 @@ create table t2 (c1 int, c2 char(6)); insert into t1 values (1, "t1c2-1", 10), (2, "t1c2-2", 20); update t1 left join t2 on t1.c1 = t2.c1 set t2.c2 = "t2c2-1"; update t1 left join t2 on t1.c1 = t2.c1 set t2.c2 = "t2c2-1" where t1.c3 = 10; +drop table t1, t2; diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index fdf6a57cc11..62439dcc51b 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -158,9 +158,9 @@ DROP TABLE t2; # # Bug #6054 # -drop table if exists t1, t2; create table t1 (c1 int, c2 char(6), c3 int); create table t2 (c1 int, c2 char(6)); insert into t1 values (1, "t1c2-1", 10), (2, "t1c2-2", 20); update t1 left join t2 on t1.c1 = t2.c1 set t2.c2 = "t2c2-1"; update t1 left join t2 on t1.c1 = t2.c1 set t2.c2 = "t2c2-1" where t1.c3 = 10; +drop table t1, t2; |