Auto-create: Auto partitioning is unsafe for row-based replication

--source include/have_partition.inc

--source include/have_binlog_format_row.inc

--source include/master-slave.inc

create table t (a int) with system versioning

  partition by system_time interval 1 hour auto;

insert into t values (1),(2);

set @@timestamp= @@timestamp+3601;

update t set a = 3 limit 0;

show create table t;

--sync_slave_with_master

show create table t;

--connection master

alter table t drop partition p0;

--sync_slave_with_master

show create table t;

Table	Create Table

t	CREATE TABLE `t` (

  `a` int(11) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1 WITH SYSTEM VERSIONING

 PARTITION BY SYSTEM_TIME INTERVAL 1 HOUR STARTS TIMESTAMP'2021-04-21 23:00:00' AUTO

PARTITIONS 3

connection slave;

show create table t;

Table	Create Table

t	CREATE TABLE `t` (

  `a` int(11) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1 WITH SYSTEM VERSIONING

 PARTITION BY SYSTEM_TIME INTERVAL 1 HOUR STARTS TIMESTAMP'2021-04-21 23:00:00' AUTO

PARTITIONS 2

Last_Errno	4128

Last_Error	Error 'Wrong partitions for `t`: must have at least one HISTORY and exactly one last CURRENT' on query. Default database: 'test'. Query: 'alter table t drop partition p0'