diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-01-20 19:16:18 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-01-20 19:16:18 +0200 |
| commit | 7a1a5cd2d828d67120d10eb623c6c5bd83733260 (patch) | |
| tree | af970ff106cbb71ff85b826216049e1b995d8e5e /mysql-test/t | |
| parent | fbf563e86a219d02fa9bae0c8fb52c34c60bacbe (diff) | |
| download | mariadb-git-7a1a5cd2d828d67120d10eb623c6c5bd83733260.tar.gz | |
for multy-delete command used same algorithm of table reference (alias)
mysql-test/t/multi_update.test:
new results of changed multi-delete
mysql-test/t/update.test:
new results of changed multi-delete
mysql-test/r/multi_update.result:
new results of changed multi-delete
mysql-test/r/update.result:
new results of changed multi-delete
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/multi_update.test | 2 | ||||
| -rw-r--r-- | mysql-test/t/update.test | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test index 6f012801972..e52b373a4a6 100644 --- a/mysql-test/t/multi_update.test +++ b/mysql-test/t/multi_update.test @@ -218,7 +218,7 @@ select * from t2; UPDATE t1 a ,t2 b SET a.d=b.d,b.d=30 WHERE a.n=b.n; select * from t1; select * from t2; -DELETE t1, t2 FROM t1 a,t2 b where a.n=b.n; +DELETE a, b FROM t1 a,t2 b where a.n=b.n; select * from t1; select * from t2; drop table t1,t2; diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index 8e50fee56fd..3406dfd6158 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -126,6 +126,6 @@ insert into t1 (F1,F2,F3,cnt,groupid) values ('0','0','0',1,6), ('1','2','1',1,1), ('1','2','2',1,1), ('2','0','1',2,4), ('2','2','0',1,7); -delete from t1 using t1 m1,t1 m2 where m1.groupid=m2.groupid and (m1.cnt < m2.cnt or m1.cnt=m2.cnt and m1.F3>m2.F3); +delete from m1 using t1 m1,t1 m2 where m1.groupid=m2.groupid and (m1.cnt < m2.cnt or m1.cnt=m2.cnt and m1.F3>m2.F3); select * from t1; drop table t1; |