diff options
| author | unknown <sergefp@mysql.com> | 2004-12-11 15:51:52 +0300 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2004-12-11 15:51:52 +0300 |
| commit | 8e4251dd855e81215281b958e97a3dc6b9153a4b (patch) | |
| tree | 1d9994a8d04ec084c5f016e008c4b0c8b0c051cd /mysql-test/r/multi_update.result | |
| parent | 96a927b5dd531249a8b7f6ef2827c0e5f841e021 (diff) | |
| download | mariadb-git-8e4251dd855e81215281b958e97a3dc6b9153a4b.tar.gz | |
Fix for BUG#5837 - attempt 3.
Call mark_as_null_row in join_read_const and join_read_system.
mysql-test/r/multi_update.result:
Testcase for BUG#5837
mysql-test/t/multi_update.test:
Testcase for BUG#5837
sql/table.h:
Added comments
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 fc414f2f46b..5e7b392b503 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -399,3 +399,9 @@ select * from t2; c2_id c2_p_id c2_note c2_active 1 1 A Note 1 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; |