diff options
author | Matthias Leich <Matthias.Leich@sun.com> | 2009-02-09 22:00:15 +0100 |
---|---|---|
committer | Matthias Leich <Matthias.Leich@sun.com> | 2009-02-09 22:00:15 +0100 |
commit | 0ef6e2a5ab39fc1d2768ba651d0c3ef85612c2c6 (patch) | |
tree | cd78b56e7f59f946ca6f42d96b186a1489fb8bd2 /mysql-test/r/multi_update.result | |
parent | 3ba87c370005437656bbcafb0b9ee75527342752 (diff) | |
parent | 4c0dd2a7b346604ca57ea5871bc04298f174561c (diff) | |
download | mariadb-git-0ef6e2a5ab39fc1d2768ba651d0c3ef85612c2c6.tar.gz |
Merge 5.0 -> 5.1
Diffstat (limited to 'mysql-test/r/multi_update.result')
-rw-r--r-- | mysql-test/r/multi_update.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index b8f6aa9e4d4..449333a4ae6 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -375,7 +375,7 @@ update t2, t1 set t2.field=t1.field where t1.id1=t2.id2 and 0=1; delete t1, t2 from t2 inner join t1 on t1.id1=t2.id2 where 0=1; -delete t1, t2 from t2,t1 +delete t1, t2 from t2,t1 where t1.id1=t2.id2 and 0=1; drop table t1,t2; CREATE TABLE t1 ( a int ); @@ -443,12 +443,12 @@ delete t1 from t1,t2 where t1.col1 < (select max(col1) from t1) and t1.col1 = t2 ERROR HY000: You can't specify target table 't1' for update in FROM clause drop table t1,t2; create table t1 ( -aclid bigint not null primary key, -status tinyint(1) not null +aclid bigint not null primary key, +status tinyint(1) not null ) engine = innodb; create table t2 ( -refid bigint not null primary key, -aclid bigint, index idx_acl(aclid) +refid bigint not null primary key, +aclid bigint, index idx_acl(aclid) ) engine = innodb; insert into t2 values(1,null); delete t2, t1 from t2 left join t1 on (t2.aclid=t1.aclid) where t2.refid='1'; |