MDEV-3798: EXPLAIN UPDATE/DELETE

- Handle the case when EXPLAIN UPDATE/DELETE has pruned away all partitions.

1 files changed, 19 insertions, 0 deletions

diff --git a/mysql-test/t/explain_non_select.test b/mysql-test/t/explain_non_select.test
index 4da4b894d69..3c4c2d0739d 100644
--- a/mysql-test/t/explain_non_select.test
+++ b/mysql-test/t/explain_non_select.test
@@ -136,3 +136,22 @@ explain extended delete from t2 where a in (3,4);
 
 drop table t1,t2;
 
+--echo #
+--echo #  Check the special case where partition pruning removed all partitions
+--echo #
+
+create table t1 (a int, b int) 
+partition by range (a) (
+ partition p0 values less than (10),
+ partition p1 values less than (20),
+ partition p2 values less than (30)
+);
+insert into t1 values (9,9), (19,19), (29,29);
+
+explain partitions select * from t1 where a in (32,33);
+
+explain partitions delete from t1 where a in (32,33);
+
+explain partitions update t1 set b=12345 where a in (32,33);
+
+drop table t1;