diff options
| author | unknown <sergefp@mysql.com> | 2004-12-11 15:55:50 +0300 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2004-12-11 15:55:50 +0300 |
| commit | c77391b94fd94dd094b40035177fcaa678c9f3ee (patch) | |
| tree | 6a05615bea4b44c8dd83626b5770f4b8f1825bb2 /mysql-test/r/multi_update.result | |
| parent | da6a5f6ec095b88fb9d0bf63a4d9e4675f1450a8 (diff) | |
| parent | 8e4251dd855e81215281b958e97a3dc6b9153a4b (diff) | |
| download | mariadb-git-c77391b94fd94dd094b40035177fcaa678c9f3ee.tar.gz | |
Fix for BUG#5837 merged from 4.0
sql/sql_select.cc:
Auto merged
sql/table.h:
Auto merged
Diffstat (limited to 'mysql-test/r/multi_update.result')
| -rw-r--r-- | mysql-test/r/multi_update.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index 045a1b05e47..75a7c3e5a0c 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -464,3 +464,9 @@ ERROR HY000: You can't specify target table 't1' for update in FROM clause delete t1 from t1,t2 where t1.col1 < (select max(col1) from t1) and t1.col1 = t2.col1; ERROR HY000: You can't specify target table 't1' for update in FROM clause drop table t1,t2; +drop table if exists t2, t1; +create table t1(aclid bigint not null primary key, status tinyint(1) not null ) type = innodb; +create table t2(refid bigint not null primary key, aclid bigint, index idx_acl(aclid) )type = innodb; +insert into t2 values(1,null); +delete t2, t1 from t2 as a left join t1 as b on (a.aclid=b.aclid) where a.refid='1'; +drop table t1, t2; |