create or replace table t1 (a int, s date, e date, period for p(s,e));

insert into t1 values (1,'2012-01-01','2013-01-01'),(2,'2013-01-01','2014-01-01');

delete from t1 for portion of p from s to e;

select * from t1;

# Cleanup

drop table t1;

MariaDB [bug]> delete from t1 for portion of p from s to e;

Query OK, 2 rows affected (0.015 sec)

MariaDB [bug]> select * from t1;

Empty set (0.001 sec)