create temporary table mp_n0_temp (a string) partitioned by (b string, c string);

alter table mp_n0_temp add partition (b='1', c='1');
alter table mp_n0_temp add partition (b='1', c='2');
alter table mp_n0_temp add partition (b='2', c='2');

show partitions mp_n0_temp;

--explain extended alter table dmp.mp_n0_temp drop partition (b='1');
alter table mp_n0_temp drop partition (b='1');

show partitions mp_n0_temp;

drop table mp_n0_temp;