~drizzle-trunk/drizzle/development

#

# Testing replication delay reporting (bug#29309)

# there is an unavoidable non-determinism in the test

# please compare the results with the comments 

#

source include/master-slave.inc;

connection master;

#connection slave;

sync_slave_with_master;

--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT

--replace_column 1 # 8 # 9 # 23 #

--query_vertical show slave status /* Second_behind reports 0 */;

sleep 3;

### bug emulation

connection master;

drop table if exists t1;

create table t1 (f1 int);

sleep 3;

#connection slave;

sync_slave_with_master;

flush logs /* contaminate rli->last_master_timestamp */;

connection slave;

lock table t1 write;

connection master;

insert into t1 values (1);

sleep 3;

connection slave;

--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT

--replace_column 1 # 8 # 9 # 23 #

--query_vertical show slave status /* bug emulated: reports slave threads starting time about 3*3 not 3 secs */;

unlock tables;

connection master;

sync_slave_with_master;

### bugfix

connection slave;

flush logs /* this time rli->last_master_timestamp is not affected */;

lock table t1 write;

connection master;

insert into t1 values (2);

sleep 3;

connection slave;

--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT

--replace_column 1 # 8 # 9 # 23 #

--query_vertical show slave status /* reports the correct diff with master query time about 3+3 secs */;

unlock tables;

connection master;

drop table t1;

#connection slave;

sync_slave_with_master;

# End of tests