Debian Codegraph @

mysql-test/suite/federated/timestamps.result

raw
1 connect master,127.0.0.1,root,,test,$MASTER_MYPORT,;
2 connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT,;
3 connection master;
4 CREATE DATABASE federated;
5 connection slave;
6 CREATE DATABASE federated;
7 connection slave;
8 set global time_zone='Europe/Moscow';
9 set time_zone='Europe/Moscow';
10 create table federated.t1 (dt datetime, ts timestamp, unique(ts));
11 connection master;
12 set time_zone='+01:00';
13 create table t1 engine=federated connection='mysql://[email protected]:SLAVE_PORT/federated/t1';
14 set @@timestamp=1;
15 insert t1 values (now(), now());
16 set @@timestamp=2147483647;
17 insert t1 values (now(), now());
18 set @@timestamp=1067121000;
19 insert t1 values (now(), now());
20 set @@timestamp=1067124600;
21 insert t1 values (now(), now());
22 set @@timestamp=0;
23 select * from t1;
24 dt ts
25 1970-01-01 01:00:01 1970-01-01 01:00:01
26 2038-01-19 04:14:07 2038-01-19 04:14:07
27 2003-10-25 23:30:00 2003-10-25 23:30:00
28 2003-10-26 00:30:00 2003-10-26 00:30:00
29 delete from t1 where ts='1970-01-01 01:00:01';
30 select * from t1;
31 dt ts
32 2038-01-19 04:14:07 2038-01-19 04:14:07
33 2003-10-25 23:30:00 2003-10-25 23:30:00
34 2003-10-26 00:30:00 2003-10-26 00:30:00
35 insert t1 values ('1970-01-01 01:00:01', now());
36 update t1 set ts=dt;
37 select * from t1;
38 dt ts
39 1970-01-01 01:00:01 1970-01-01 01:00:01
40 2038-01-19 04:14:07 2038-01-19 04:14:07
41 2003-10-25 23:30:00 2003-10-25 23:30:00
42 2003-10-26 00:30:00 2003-10-26 00:30:00
43 select * from t1 where ts='2003-10-25 23:30:00';
44 dt ts
45 2003-10-25 23:30:00 2003-10-25 23:30:00
46 select * from t1 where ts='2003-10-26 00:30:00';
47 dt ts
48 2003-10-26 00:30:00 2003-10-26 00:30:00
49 connection slave;
50 select * from federated.t1;
51 dt ts
52 1970-01-01 01:00:01 1970-01-01 03:00:01
53 2038-01-19 04:14:07 2038-01-19 06:14:07
54 2003-10-25 23:30:00 2003-10-26 02:30:00
55 2003-10-26 00:30:00 2003-10-26 02:30:00
56 set global time_zone=default;
57 connection master;
58 drop table t1;
59 connection master;
60 DROP TABLE IF EXISTS federated.t1;
61 DROP DATABASE IF EXISTS federated;
62 connection slave;
63 DROP TABLE IF EXISTS federated.t1;
64 DROP DATABASE IF EXISTS federated;