Debian Codegraph @

mysql-test/suite/rpl/t/rpl_blackhole.test

raw
1 # PURPOSE. Test that blackhole works with replication in all three
2 # modes: STATEMENT, MIXED, and ROW.
3 #
4 # METHOD. We start by creating a table on the master and then change
5 # the engine to use blackhole on the slave.
6 #
7 # After insert/update/delete of one or more rows, the test the
8 # proceeds to check that replication is running after replicating an
9 # change, that the blackhole engine does not contain anything (which
10 # is just a check that the correct engine is used), and that something
11 # is written to the binary log.
12 #
13 # Whe check INSERT, UPDATE, and DELETE statement for tables with no
14 # key (forcing a range search on the slave), primary keys (using a
15 # primary key lookup), and index/key with multiple matches (forcing an
16 # index search).
17
18 source include/have_blackhole.inc;
19 source include/master-slave.inc;
20
21 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
22
23 source include/rpl_blackhole_basic.test;
24
25 --source include/rpl_end.inc