diff options
author | monty@hundin.mysql.fi <> | 2001-06-15 05:03:15 +0300 |
---|---|---|
committer | monty@hundin.mysql.fi <> | 2001-06-15 05:03:15 +0300 |
commit | a06f391e7ada4c05e34e54a517014aa3968d7df4 (patch) | |
tree | 90883e19e7220eb27c1fa092220fe373c7e82d80 /mysql-test/t/multi_update.test | |
parent | 595d087e05579a9b8420b9267423b054fcca42c9 (diff) | |
download | mariadb-git-a06f391e7ada4c05e34e54a517014aa3968d7df4.tar.gz |
Fixed multi-table-delete
Optimize fixed length MyISAM rows to use pread/pwrite.
Diffstat (limited to 'mysql-test/t/multi_update.test')
-rw-r--r-- | mysql-test/t/multi_update.test | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test index c9c705b2e64..a1ebc64504f 100644 --- a/mysql-test/t/multi_update.test +++ b/mysql-test/t/multi_update.test @@ -16,10 +16,11 @@ while ($1) dec $1; } +delete t1.*,t2.* from t1,t2 where t1.id1 = t2.id2 and t1.id1 = 3; +delete t3 from t3 left join t1 on (id1=id3) where t1.id1 is null; +delete t2 from t1,t2,t3 where id1=id2 and id2=id3 and id1=2; select * from t1; select * from t2; select * from t3; - -delete from t1,t2 where t1.id = t2.id and t1.id = 3; -select * from t1; -select * from t2; +delete t1,t2 from t1,t2 where 1; +drop table t1,t2,t3; |