Debian Codegraph @

mysql-test/suite/federated/timestamps.test

raw
1 source have_federatedx.inc;
2 source include/federated.inc;
3
4 connection slave;
5 set global time_zone='Europe/Moscow';
6 set time_zone='Europe/Moscow';
7 create table federated.t1 (dt datetime, ts timestamp, unique(ts));
8
9 connection master;
10 set time_zone='+01:00';
11 replace_result $SLAVE_MYPORT SLAVE_PORT;
12 eval create table t1 engine=federated connection='mysql://[email protected]:$SLAVE_MYPORT/federated/t1';
13
14 set @@timestamp=1; # min value
15 insert t1 values (now(), now());
16 set @@timestamp=2147483647; # max value
17 insert t1 values (now(), now());
18 set @@timestamp=1067121000; # DST ambiguous (in Europe/Moscow)
19 insert t1 values (now(), now());
20 set @@timestamp=1067124600; # DST ambiguous (in Europe/Moscow)
21 insert t1 values (now(), now());
22 set @@timestamp=0;
23
24 # reads
25 select * from t1;
26
27 # deletes
28 delete from t1 where ts='1970-01-01 01:00:01';
29 select * from t1;
30
31 # updates
32 insert t1 values ('1970-01-01 01:00:01', now());
33 update t1 set ts=dt;
34 select * from t1;
35
36 # index lookups
37 select * from t1 where ts='2003-10-25 23:30:00';
38 select * from t1 where ts='2003-10-26 00:30:00';
39
40 connection slave;
41 select * from federated.t1;
42 set global time_zone=default;
43 connection master;
44 drop table t1;
45 source include/federated_cleanup.inc;