diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-10-12 21:36:39 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-10-12 21:36:39 +0300 |
| commit | 228bfb05e31363775fac59fdc9ef8e2041183f08 (patch) | |
| tree | 5cf956e0b5395792bb8782c640847c6e92f005a4 /mysql-test/r/multi_update.result | |
| parent | 782dccfbfe14f7e0366934faafd515c2435a7d7c (diff) | |
| download | mariadb-git-228bfb05e31363775fac59fdc9ef8e2041183f08.tar.gz | |
Two bug fixes
Docs/manual.texi:
added text for fixes
mysql-test/r/multi_update.result:
new test case for multi-table deletes
mysql-test/t/multi_update.test:
new test case for multi-table deletes
sql/sql_delete.cc:
fix for multi-table deletes
sql/sql_update.cc:
fix for multi-table updates
Diffstat (limited to 'mysql-test/r/multi_update.result')
| -rw-r--r-- | mysql-test/r/multi_update.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index 328eb9b394e..9dff4fba825 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -135,3 +135,19 @@ ID ParId tst tst1 2 2 MSSQL Microsoft 3 3 ORACLE ORACLE 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); +n n +1 NULL +2 NULL +4 NULL +8 NULL +16 NULL +32 NULL +delete t1,t2 from t2 left outer join t1 using (n); +select * from t2 left outer join t1 using (n); +n n +drop table if exists t1,t2 ; |