Debian Codegraph @

mysql-test/suite/rpl/t/rpl_temporal_fractional.test

raw
1 --source include/not_group_replication_plugin.inc
2 --source include/master-slave.inc
3
4 SET @@time_zone='+00:00';
5 SET @@timestamp=25810.123456;
6
7 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
8
9 CREATE TABLE t1
10 (
11 ts0 TIMESTAMP(0),
12 ts1 TIMESTAMP(1),
13 ts2 TIMESTAMP(2),
14 ts3 TIMESTAMP(3),
15 ts4 TIMESTAMP(4),
16 ts5 TIMESTAMP(5),
17 ts6 TIMESTAMP(6)
18 );
19
20 SET sql_mode = default;
21
22 SET @ts='2001-01-01 10:10:10.123456';
23 INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
24 INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
25 INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
26 --query_vertical SELECT * FROM t1
27 --source include/sync_slave_sql_with_master.inc
28 connection slave;
29 --query_vertical SELECT * FROM t1
30 connection master;
31 DROP TABLE t1;
32 --source include/sync_slave_sql_with_master.inc
33
34
35 connection master;
36 CREATE TABLE t1
37 (
38 dt0 DATETIME(0),
39 dt1 DATETIME(1),
40 dt2 DATETIME(2),
41 dt3 DATETIME(3),
42 dt4 DATETIME(4),
43 dt5 DATETIME(5),
44 dt6 DATETIME(6)
45 );
46 SET @ts='2001-01-01 10:10:10.123456';
47 INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
48 INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
49 INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
50 --query_vertical SELECT * FROM t1
51 --source include/sync_slave_sql_with_master.inc
52 connection slave;
53 --query_vertical SELECT * FROM t1
54 connection master;
55 DROP TABLE t1;
56 --source include/sync_slave_sql_with_master.inc
57
58
59 connection master;
60 CREATE TABLE t1
61 (
62 t0 TIME(0),
63 t1 TIME(1),
64 t2 TIME(2),
65 t3 TIME(3),
66 t4 TIME(4),
67 t5 TIME(5),
68 t6 TIME(6)
69 );
70 SET @t='10:10:10.123456';
71 INSERT INTO t1 VALUES (@t, @t, @t, @t, @t, @t, @t);
72 INSERT INTO t1 VALUES (CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME());
73 INSERT INTO t1 VALUES (CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6));
74 --query_vertical SELECT * FROM t1
75 --source include/sync_slave_sql_with_master.inc
76 connection slave;
77 --query_vertical SELECT * FROM t1
78 connection master;
79 DROP TABLE t1;
80 --source include/sync_slave_sql_with_master.inc
81
82 connection master;
83 --source include/rpl_end.inc