← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/bugs/t/rpl_bug12691.test

  • Committer: devananda
  • Date: 2009-06-30 14:27:54 UTC
  • mfrom: (1030.2.4 trunk)
  • mto: (1093.1.7 captain)
  • mto: This revision was merged to the branch mainline in revision 1095.
  • Revision ID: devananda.vdv@gmail.com-20090630142754-vm9w374yxkf1pikc
merge from lp

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/bugs/t/rpl_bug12691.test
1
 
# Bug#12691: Exec_master_log_pos corrupted with SQL_SLAVE_SKIP_COUNTER
2
 
# Date: 01/31/2008
3
 
# Added: Serge Kozlov <skozlov@mysql.com>
4
 
 
5
 
--source include/master-slave.inc
6
 
--connection master
7
 
--source include/have_binlog_format_mixed_or_statement.inc
8
 
 
9
 
--echo
10
 
--echo **** On Master ****
11
 
CREATE TABLE t1 (b CHAR(10));
12
 
--echo
13
 
--echo **** On Slave ****
14
 
--sync_slave_with_master
15
 
STOP SLAVE;
16
 
--source include/wait_for_slave_to_stop.inc
17
 
 
18
 
--connection master
19
 
 
20
 
--echo
21
 
--echo **** On Master ****
22
 
--exec cp $DRIZZLE_TEST_DIR/suite/bugs/data/rpl_bug12691.dat $MYSQLTEST_VARDIR/tmp/
23
 
--echo LOAD DATA INFILE FILENAME
24
 
--disable_query_log
25
 
--eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/rpl_bug12691.dat' INTO TABLE t1 FIELDS TERMINATED BY '|'
26
 
--enable_query_log
27
 
--remove_file $MYSQLTEST_VARDIR/tmp/rpl_bug12691.dat
28
 
 
29
 
SELECT COUNT(*) FROM t1;
30
 
 
31
 
--replace_column 2 # 5 #
32
 
--replace_regex /Server ver: .+/Server ver: #/ /table_id: [0-9]+/table_id: #/ /COMMIT.+xid=[0-9]+.+/#/ /file_id=[0-9]+/file_id=#/ /block_len=[0-9]+/block_len=#/ /'.+'/FILENAME/
33
 
SHOW BINLOG EVENTS;
34
 
 
35
 
--save_master_pos
36
 
 
37
 
--connection slave
38
 
--echo
39
 
--echo **** On Slave ****
40
 
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
41
 
START SLAVE;
42
 
--source include/wait_for_slave_to_start.inc
43
 
--sync_with_master
44
 
 
45
 
SELECT COUNT(*) FROM t1;
46
 
 
47
 
# Clean up
48
 
--connection master
49
 
--echo
50
 
--echo **** On Master ****
51
 
DROP TABLE t1;
52
 
--sync_slave_with_master
53