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