Debian Codegraph @

mysql-test/suite/rpl/include/hrtime.inc

raw
1 --source include/master-slave.inc
2
3 set time_zone='+03:00';
4 set timestamp=unix_timestamp('2011-01-01 01:01:01') + 0.123456;
5
6 create table t1 (a timestamp(4) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, b varchar(100), c datetime(2));
7
8 insert t1 (b,c) values (now(6), now(6));
9
10 insert t1 values ('2010-10-10 10:10:10.101010','2010-10-10 10:10:10.101010','2010-10-10 10:10:10.101010');
11
12 set timestamp=unix_timestamp('2022-02-02 02:02:02') + 0.654321;
13 insert t1 (b,c) values (now(), now());
14 insert t1 (b,c) values (0,0);
15 insert t1 (a,b,c) values (0,0,now(6));
16
17 select * from t1;
18
19 sync_slave_with_master;
20 connection slave;
21 set time_zone='+03:00';
22 select * from t1;
23 connection master;
24 drop table t1;
25
26 --source include/rpl_end.inc
27