From 8cbaafd22b145512cc91f7b512290320849e77bd Mon Sep 17 00:00:00 2001 From: Oleksandr Byelkin Date: Wed, 22 Apr 2015 10:14:11 +0200 Subject: 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. --- mysql-test/t/multi_update.test | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/t/multi_update.test') 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 -- cgit v1.2.1