← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/extra/rpl_tests/rpl_multi_query.test

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/extra/rpl_tests/rpl_multi_query.test
 
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
--disable_warnings
 
11
drop database if exists mysqltest;
 
12
--enable_warnings
 
13
create database mysqltest;
 
14
 
 
15
delimiter /;
 
16
create table mysqltest.t1 ( n int);
 
17
insert into mysqltest.t1 values(1)/
 
18
insert into mysqltest.t1 values(2);
 
19
insert into mysqltest.t1 values(3);
 
20
insert into mysqltest.t1 values(4);
 
21
insert into mysqltest.t1 values(5)/
 
22
delimiter ;/
 
23
sync_slave_with_master;
 
24
select * from mysqltest.t1;
 
25
connection master;
 
26
source include/show_binlog_events.inc;
 
27
drop database mysqltest;
 
28
sync_slave_with_master;