1include/master-slave.inc 2[connection master] 3connection master; 4DROP FUNCTION test.f1; 5DROP TABLE IF EXISTS test.t1; 6DROP TABLE IF EXISTS test.t2; 7CREATE TABLE test.t1 (a INT NOT NULL AUTO_INCREMENT, t TIMESTAMP, t2 TIMESTAMP, PRIMARY KEY(a)); 8CREATE TABLE test.t2 (a INT NOT NULL AUTO_INCREMENT, t TIMESTAMP, t2 TIMESTAMP, PRIMARY KEY(a)); 9create function test.f1() RETURNS TIMESTAMP 10BEGIN 11UPDATE test.t1 SET t = CURRENT_TIMESTAMP; 12RETURN CURRENT_TIMESTAMP; 13END// 14INSERT INTO test.t2 VALUES (null,f1(),CURRENT_TIMESTAMP); 15SET TIMESTAMP=2; 16INSERT INTO test.t2 VALUES (null,f1(),CURRENT_TIMESTAMP); 17SET TIMESTAMP=1; 18INSERT INTO test.t2 VALUES (null,f1(),CURRENT_TIMESTAMP); 19SET TIMESTAMP=333300000; 20INSERT INTO test.t2 VALUES (null,f1(),CURRENT_TIMESTAMP); 21connection slave; 22connection master; 23DROP FUNCTION test.f1; 24DROP TABLE test.t1; 25DROP TABLE test.t2; 26connection slave; 27include/rpl_end.inc 28