include/master-slave.inc
[connection master]
connection slave;
set global time_zone='Europe/Moscow';
set time_zone='UTC';
stop slave;
start slave;
connection master;
set global mysql56_temporal_format=false;
set global time_zone='Europe/Moscow';
set time_zone='UTC';
create table t1 (pk int primary key, t timestamp not null);
set timestamp = 1288477526;
insert into t1 values (1,null);
set timestamp = 1288481126;
insert into t1 values (2,null);
connection slave;
select pk, t, unix_timestamp(t) from t1;
pk	t	unix_timestamp(t)
1	2010-10-30 22:25:26	1288477526
2	2010-10-30 23:25:26	1288481126
set time_zone=default;
select pk, t, unix_timestamp(t) from t1;
pk	t	unix_timestamp(t)
1	2010-10-31 02:25:26	1288477526
2	2010-10-31 02:25:26	1288481126
set global time_zone=default;
connection master;
drop table t1;
set global time_zone=default;
set global mysql56_temporal_format=default;
include/rpl_end.inc