Debian Codegraph @

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

raw
1 --echo #
2 --echo # Test of function defaults on replicated tables.
3 --echo #
4
5 --source include/not_group_replication_plugin.inc
6 source include/master-slave.inc;
7
8 --echo connection master
9 connection master;
10 SET TIME_ZONE="+10:30";
11 SET TIMESTAMP=123456.789123;
12 SELECT CURRENT_TIMESTAMP;
13
14 --echo connection slave
15 connection slave;
16 SET TIME_ZONE="+00:00";
17 SET TIMESTAMP=987654321.123456;
18 SELECT CURRENT_TIMESTAMP;
19
20 --echo connection master
21 connection master;
22 CREATE TABLE t1 (
23 a TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
24 b TIMESTAMP(1) NOT NULL DEFAULT CURRENT_TIMESTAMP(1),
25 c TIMESTAMP(2) NOT NULL DEFAULT CURRENT_TIMESTAMP(2),
26 d TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
27 e TIMESTAMP(4) NOT NULL DEFAULT CURRENT_TIMESTAMP(4),
28 f TIMESTAMP(5) NOT NULL DEFAULT CURRENT_TIMESTAMP(5),
29 g TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
30 h DATETIME DEFAULT CURRENT_TIMESTAMP,
31 i DATETIME(1) DEFAULT CURRENT_TIMESTAMP(1),
32 j DATETIME(2) DEFAULT CURRENT_TIMESTAMP(2),
33 k DATETIME(3) DEFAULT CURRENT_TIMESTAMP(3),
34 l DATETIME(4) DEFAULT CURRENT_TIMESTAMP(4),
35 m DATETIME(5) DEFAULT CURRENT_TIMESTAMP(5),
36 n DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6),
37 o INT
38 );
39
40 INSERT INTO t1 ( o ) VALUES ( 1 );
41
42 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
43
44 CREATE TABLE t2 (
45 a TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
46 b TIMESTAMP(1) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(1),
47 c TIMESTAMP(2) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(2),
48 d TIMESTAMP(3) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(3),
49 e TIMESTAMP(4) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(4),
50 f TIMESTAMP(5) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(5),
51 g TIMESTAMP(6) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(6),
52 h DATETIME ON UPDATE CURRENT_TIMESTAMP,
53 i DATETIME(1) ON UPDATE CURRENT_TIMESTAMP(1),
54 j DATETIME(2) ON UPDATE CURRENT_TIMESTAMP(2),
55 k DATETIME(3) ON UPDATE CURRENT_TIMESTAMP(3),
56 l DATETIME(4) ON UPDATE CURRENT_TIMESTAMP(4),
57 m DATETIME(5) ON UPDATE CURRENT_TIMESTAMP(5),
58 n DATETIME(6) ON UPDATE CURRENT_TIMESTAMP(6),
59 o INT
60 );
61
62 INSERT INTO t2 ( o ) VALUES ( 1 );
63
64 SET sql_mode = default;
65
66 --echo sync_slave_with_master
67 --source include/sync_slave_sql_with_master.inc
68
69 --echo connection slave
70 connection slave;
71
72 query_vertical SELECT * FROM t1;
73 query_vertical SELECT * FROM t2;
74
75 --echo connection master
76 connection master;
77
78 SET TIMESTAMP=1234567890.123456;
79 SELECT CURRENT_TIMESTAMP;
80
81 UPDATE t1 SET o = 2;
82 UPDATE t2 SET o = 2;
83
84 --echo sync_slave_with_master
85 --source include/sync_slave_sql_with_master.inc
86
87 --echo connection slave
88 connection slave;
89
90 query_vertical SELECT * FROM t1;
91 query_vertical SELECT * FROM t2;
92
93 --echo connection master
94 connection master;
95
96 DROP TABLE t1, t2;
97
98 --source include/rpl_end.inc