diff options
| author | serg@sergbook.mysql.com <> | 2004-12-31 15:26:24 +0100 |
|---|---|---|
| committer | serg@sergbook.mysql.com <> | 2004-12-31 15:26:24 +0100 |
| commit | a04fc26c5429284ddae3b5aa19220b057d84b302 (patch) | |
| tree | 928b06c231edee4cb95ace87ed30e879e3dcb0fb /mysql-test/t/multi_update.test | |
| parent | 849d1203ffb0a68ccec2e9e6e1baba00b2fbe536 (diff) | |
| parent | 45ce994e5dc31c6eb802c3b8eb8955c320a4c111 (diff) | |
| download | mariadb-git-a04fc26c5429284ddae3b5aa19220b057d84b302.tar.gz | |
manually merged
Diffstat (limited to 'mysql-test/t/multi_update.test')
| -rw-r--r-- | mysql-test/t/multi_update.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test index b74b06fe191..de66218c4a6 100644 --- a/mysql-test/t/multi_update.test +++ b/mysql-test/t/multi_update.test @@ -434,6 +434,7 @@ delete t1 from t1,t2 where t1.col1 < (select max(col1) from t1) and t1.col1 = t2 drop table t1,t2; # Test for BUG#5837 - delete with outer join and const tables +--disable_warnings create table t1 ( aclid bigint not null primary key, status tinyint(1) not null @@ -443,6 +444,7 @@ create table t2 ( refid bigint not null primary key, aclid bigint, index idx_acl(aclid) ) engine = innodb; +--enable_warnings 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; |