[#MDEV-5513] Row-based triggers: Trigger is applied to the rows after first one

The test case below creates one trigger (after insert) on the master and another trigger (before insert) on the slave.
The master trigger writes into a different table. The slave trigger modifies the values on its own table (sets 2nd column := 1st column).

--source include/master-slave.inc

--source include/have_binlog_format_row.inc

--connection master

create table t1 (a int, b int);

create table tlog (a int);

set sql_log_bin=0;

create trigger tr1 after insert on t1 for each row insert into tlog values (1);

set sql_log_bin=1;

--connection slave

set @slave_run_triggers_for_rbr.saved = @@slave_run_triggers_for_rbr;

set global slave_run_triggers_for_rbr=1;

create trigger tr2 before insert on t1 for each row set new.b = new.a;

--connection master

insert into t1 values (1,10),(2,20),(3,30);

--sync_slave_with_master

select * from t1;

# Cleanup

set global slave_run_triggers_for_rbr = @slave_run_triggers_for_rbr.saved;

--connection master

drop table t1, tlog;

--source include/rpl_end.inc

[MDEV-5513] Row-based triggers: Trigger is applied to the rows after first one Created: 2014-01-09 Updated: 2014-02-12 Resolved: 2014-02-12
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	None
Fix Version/s:	10.0.9

[MDEV-5513] Row-based triggers: Trigger is applied to the rows after first one Created: 2014-01-09 Updated: 2014-02-12 Resolved: 2014-02-12