Debian Codegraph @

mysql-test/suite/rpl/include/rpl_multi_query.test

raw
1 # Test for BUG#8436: verify that a multi-query (i.e. one query
2 # containing several queries (assuming client has
3 # CLIENT_MULTI_STATEMENTS) will be binlogged ONE-query-per-event (not
4 # one binlog event containing all queries)
5
6
7 # PS doesn't support multi-statements
8 --disable_ps_protocol
9 -- source include/master-slave.inc
10 create database mysqltest;
11
12 delimiter /;
13 create table mysqltest.t1 ( n int);
14 insert into mysqltest.t1 values(1)/
15 insert into mysqltest.t1 values(2);
16 insert into mysqltest.t1 values(3);
17 insert into mysqltest.t1 values(4);
18 insert into mysqltest.t1 values(5)/
19 delimiter ;/
20 sync_slave_with_master;
21 select * from mysqltest.t1;
22 connection master;
23 source include/show_binlog_events.inc;
24 drop database mysqltest;
25
26 --source include/rpl_end.inc