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