← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/suite/bugs/r/rpl_bug12691.result

  • 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/suite/bugs/r/rpl_bug12691.result
 
1
stop slave;
 
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
3
reset master;
 
4
reset slave;
 
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
6
start slave;
 
7
 
 
8
**** On Master ****
 
9
CREATE TABLE t1 (b CHAR(10));
 
10
 
 
11
**** On Slave ****
 
12
STOP SLAVE;
 
13
 
 
14
**** On Master ****
 
15
LOAD DATA INFILE FILENAME
 
16
SELECT COUNT(*) FROM t1;
 
17
COUNT(*)
 
18
3
 
19
SHOW BINLOG EVENTS;
 
20
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
 
21
master-bin.000001       #       Format_desc     1       #       Server ver: #
 
22
master-bin.000001       #       Query   1       #       use `test`; CREATE TABLE t1 (b CHAR(10))
 
23
master-bin.000001       #       Begin_load_query        1       #       ;file_id=#;block_len=#
 
24
master-bin.000001       #       Execute_load_query      1       #       use `test`; LOAD DATA INFILE FILENAME ;file_id=#
 
25
 
 
26
**** On Slave ****
 
27
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
 
28
START SLAVE;
 
29
SELECT COUNT(*) FROM t1;
 
30
COUNT(*)
 
31
0
 
32
 
 
33
**** On Master ****
 
34
DROP TABLE t1;