diff options
| author | unknown <evgen@moonbone.local> | 2006-05-29 19:07:35 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-05-29 19:07:35 +0400 |
| commit | c56193330101e6dfeb6afd43f76553aae8a3929e (patch) | |
| tree | e912a14613d16ad36d42650a2a91c86ba37696e7 /mysql-test/r/multi_update.result | |
| parent | 8e025f51f12eb505d80b25f19fc21ef75f55591f (diff) | |
| parent | 2264b644735e869fdbb16397c75170d86e2de127 (diff) | |
| download | mariadb-git-c56193330101e6dfeb6afd43f76553aae8a3929e.tar.gz | |
Manually merged
mysql-test/t/multi_update.test:
Auto merged
Diffstat (limited to 'mysql-test/r/multi_update.result')
| -rw-r--r-- | mysql-test/r/multi_update.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index ea02a703c65..8d56cf6f2dc 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -476,6 +476,10 @@ aclid bigint, index idx_acl(aclid) insert into t2 values(1,null); delete t2, t1 from t2 left join t1 on (t2.aclid=t1.aclid) where t2.refid='1'; drop table t1, t2; +create table t1(a int); +create table t2(a int); +delete from t1,t2 using t1,t2 where t1.a=(select a from t1); +ERROR HY000: You can't specify target table 't1' for update in FROM clause create table t1 ( c char(8) not null ) engine=innodb; insert into t1 values ('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9'); insert into t1 values ('A'),('B'),('C'),('D'),('E'),('F'); |