summaryrefslogtreecommitdiff
path: root/mysql-test/suite/versioning/t/rpl_mix.test
blob: 64025c74625aa1867ba65b44090a0c201c8a82a6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
--source include/have_binlog_format_mixed.inc
--source include/master-slave.inc

#
# MDEV-15405 Mixed replication fails with "Could not execute Delete_rows_v1 event" upon DELETE HISTORY
#

CREATE TABLE t1 (pk INT PRIMARY KEY, i INT) WITH SYSTEM VERSIONING;
INSERT INTO t1 VALUES (1,10),(2,20);
UPDATE t1 SET i = 100;
# This is to imitiate any real-life situation which causes a switch to row format
SET BINLOG_FORMAT= ROW;
DELETE HISTORY FROM t1;
--sync_slave_with_master

connection master;
drop table t1;

--source include/rpl_end.inc