LIMIT partition switching doesn't work until the end of statement

-- source include/have_partition.inc

-- source include/have_sequence.inc

create or replace table t1 (x int)

with system versioning

partition by system_time limit 100 (

  partition p0 history,

  partition p1 history,

  partition pn current);

insert into t1 select seq from seq_0_to_199;

--echo # Expected 100 rows in p0 and 100 rows in p1

delete from t1 where x < 150;

delete from t1;

select count(*) from t1 partition (p0);

select count(*) from t1 partition (p1);

drop table t1;

select count(*) from t1 partition (p0);

count(*)

150

select count(*) from t1 partition (p1);

count(*)

50

select count(*) from t1 partition (p0);

count(*)

100

select count(*) from t1 partition (p1);

count(*)

100