summaryrefslogtreecommitdiff
path: root/repl-tests/test-repl-ts/run.test
blob: 8e5abbd4a3e99bf5805664335cfd5af3f036fa67 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
#! ../client/mysql-test
# tests if the replicaion preserves timestamp properly

source ../include/master-slave.inc;
connection master;
set timestamp=200006;
drop table if exists foo;
create table foo(t timestamp not null,a char(1));
insert into foo ( a) values ('F');
@repl-timestamp.master select unix_timestamp(t) from foo;
sleep 3;
connection slave;
drop table if exists foo;
load table foo from master;
@repl-timestamp.master select unix_timestamp(t) from foo;