1--source include/master-slave.inc 2 3SET sql_mode=TIME_ROUND_FRACTIONAL; 4SET time_zone='+00:00'; 5SET timestamp=UNIX_TIMESTAMP('2010-12-31 23:59:59.999999'); 6 7CREATE TABLE t1 (id SERIAL, a TIMESTAMP(4)); 8INSERT INTO t1 (a) VALUES (now(6)); 9INSERT INTO t1 (a) VALUES ('2011-01-01 23:59:59.999999'); 10 11CREATE TABLE t2 (id SERIAL, a DATETIME(4)); 12INSERT INTO t2 (a) VALUES (now(6)); 13INSERT INTO t2 (a) VALUES ('2011-01-01 23:59:59.999999'); 14 15CREATE TABLE t3 (id SERIAL, a TIME(4)); 16INSERT INTO t3 (a) VALUES (now(6)); 17INSERT INTO t3 (a) VALUES ('2011-01-01 23:59:59.999999'); 18 19SELECT * FROM t1; 20SELECT * FROM t2; 21SELECT * FROM t3; 22 23sync_slave_with_master; 24connection slave; 25SET time_zone='+00:00'; 26SELECT * FROM t1; 27SELECT * FROM t2; 28SELECT * FROM t3; 29 30connection master; 31DROP TABLE t1; 32DROP TABLE t2; 33DROP TABLE t3; 34 35--source include/rpl_end.inc 36