diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2002-10-12 21:36:39 +0300 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2002-10-12 21:36:39 +0300 |
| commit | 7ba2242803837b411394b154e476dc577f957718 (patch) | |
| tree | 5cf956e0b5395792bb8782c640847c6e92f005a4 /mysql-test/t/multi_update.test | |
| parent | 3805a5edfeee171a5dd1945f4f44ea67a00fdb29 (diff) | |
| download | mariadb-git-7ba2242803837b411394b154e476dc577f957718.tar.gz | |
Two bug fixes
Diffstat (limited to 'mysql-test/t/multi_update.test')
| -rw-r--r-- | mysql-test/t/multi_update.test | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test index 205dbb10ccf..7d855dd54ea 100644 --- a/mysql-test/t/multi_update.test +++ b/mysql-test/t/multi_update.test @@ -139,4 +139,12 @@ WHERE child.ParId = parent.Id; select * from child; -drop table parent, child;
\ No newline at end of file +drop table parent, child; +drop table if exists t1, t2 ; +create table t1 (n numeric(10)); +create table t2 (n numeric(10)); +insert into t2 values (1),(2),(4),(8),(16),(32); +select * from t2 left outer join t1 using (n); +delete t1,t2 from t2 left outer join t1 using (n); +select * from t2 left outer join t1 using (n); +drop table if exists t1,t2 ; |