1
# Test of Maria-specific replication bugs
3
--source include/have_maria.inc
4
--source include/have_binlog_format_mixed_or_statement.inc
5
--source include/master-slave.inc
8
DROP TABLE IF EXISTS t1;
9
DROP TABLE IF EXISTS t2;
10
DROP TABLE IF EXISTS t3;
13
# This one taken from rpl_trigger.test (from BUG#12482)
14
# used to segfault slave in execution of row-based events
16
# Need an explicit ENGINE= clause as @@STORAGE_ENGINE is not replicated
17
create table t1 (a int auto_increment, primary key (a), b int,
18
rand_value double not null) engine=maria;
19
create table t2 (a int auto_increment, primary key (a), b int) engine=maria;
20
create table t3 (a int auto_increment, primary key (a), name
21
varchar(64) not null, old_a int, old_b int, rand_value double not
25
create trigger t1 before insert on t1 for each row
27
insert into t3 values (NULL, "t1", new.a, new.b, rand());
30
create trigger t2 after insert on t2 for each row
32
insert into t3 values (NULL, "t2", new.a, new.b, rand());
36
insert into t3 values(100,"log",0,0,0);
38
SET @@RAND_SEED1=658490765, @@RAND_SEED2=635893186;
40
insert into t1 values(1,1,rand()),(NULL,2,rand());
41
insert into t2 (b) values(last_insert_id());
42
insert into t2 values(3,0),(NULL,0);
43
insert into t2 values(NULL,0),(500,0);
45
select a,b, truncate(rand_value,4) from t1;
47
select a,name, old_a, old_b, truncate(rand_value,4) from t3;
48
sync_slave_with_master;
51
sync_slave_with_master;