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 | |
| 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')
| -rw-r--r-- | mysql-test/r/multi_update.result | 16 | ||||
| -rw-r--r-- | mysql-test/t/multi_update.test | 10 |
2 files changed, 25 insertions, 1 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 ; 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 ; |