diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2015-04-22 10:14:11 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2015-04-22 13:59:18 +0200 |
| commit | 8cbaafd22b145512cc91f7b512290320849e77bd (patch) | |
| tree | 883256655c931a6bb940b7d7d67d5d985673d17c /mysql-test/t/multi_update.test | |
| parent | e428c809d7e2176834ed9889483643e4ef2c2c2b (diff) | |
| download | mariadb-git-8cbaafd22b145512cc91f7b512290320849e77bd.tar.gz | |
MDEV-8018: main.multi_update fails with --ps-protocol
save_prep_leaf_tables() made recursive to work with underlying view
Arena restoiring fixed in case of EOM.
Diffstat (limited to 'mysql-test/t/multi_update.test')
| -rw-r--r-- | mysql-test/t/multi_update.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test index 720d9503eb2..8184d8ded1a 100644 --- a/mysql-test/t/multi_update.test +++ b/mysql-test/t/multi_update.test @@ -1047,6 +1047,12 @@ VIEW `v3` AS select `t1c`.`fe2` AS `fe2`,`t1c`.`f34` AS `f34`,`t1c`.`f33` AS `f3 UPDATE t1 t1 left join v3 t2 on t1.f4 = t2.fe2 SET t1.f20 = t2.ft6_1, t1.f32 = t2.f32, t1.f33 = t2.f33, t1.f37 = t2.f37 WHERE f5 >= '2015-02-01'; +--echo #MDEV-8018: main.multi_update fails with --ps-protocol +prepare stmt1 from "UPDATE t1 t1 left join v3 t2 on t1.f4 = t2.fe2 SET t1.f20 = t2.ft6_1, t1.f32 = t2.f32, t1.f33 = t2.f33, t1.f37 = t2.f37 WHERE f5 >= '2015-02-01'"; +execute stmt1; +execute stmt1; +deallocate prepare stmt1; + drop view v3,v2,v1; drop table t1,t2,t3; --echo end of 5.5 tests |