~drizzle-trunk/drizzle/development

--source include/master-slave.inc

--source include/have_debug.inc

--echo **** On Master ****

CREATE TABLE t1 (a INT);

INSERT INTO t1 VALUES (1),(2),(3);

SELECT * FROM t1;

# This will generate an incident log event and store it in the binary

# log before the replace statement.

REPLACE INTO t1 VALUES (4);

--save_master_pos

SELECT * FROM t1;

connection slave;

--wait_for_slave_to_stop

# The 4 should not be inserted into the table, since the incident log

# event should have stop the slave.

--echo **** On Slave ****

SELECT * FROM t1;

--replace_result $MASTER_MYPORT MASTER_PORT

--replace_column 1 # 6 # 7 # 8 # 9 # 22 # 23 # 33 #

--query_vertical SHOW SLAVE STATUS

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;

START SLAVE;

--sync_with_master

# Now, we should have inserted the row into the table and the slave

# should be running. We should also have rotated to a new binary log.

SELECT * FROM t1;

--replace_result $MASTER_MYPORT MASTER_PORT

--replace_column 1 # 6 # 7 # 8 # 9 # 22 # 23 # 33 #

--query_vertical SHOW SLAVE STATUS

connection master;

DROP TABLE t1;

--sync_slave_with_master