1# 2# Test of REPLACE with replication 3# 4 5source include/master-slave.inc; 6 7# 8# Test of doing replace on unique key on table with auto_increment 9# 10 11drop table if exists t1; 12CREATE TABLE t1 (pr_id int(10) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, pr_page int(11) NOT NULL, pr_type varbinary(60) NOT NULL, test int, UNIQUE KEY pr_pagetype (pr_page,pr_type)) ENGINE=myisam AUTO_INCREMENT=136; 13insert into t1 (pr_page, pr_type, test) values(1,"one",0),(2,"two",0); 14select * from t1; 15replace into t1 (pr_page, pr_type,test) values(1,"one",2); 16select * from t1; 17sync_slave_with_master; 18connection slave; 19select * from t1; 20connection master; 21drop table t1; 22 23# End of 5.5 tests 24--source include/rpl_end.inc 25