Debian Codegraph @

mysql-test/suite/rpl/r/rpl_function_defaults.result

raw
1 #
2 # Test of function defaults on replicated tables.
3 #
4 include/master-slave.inc
5 [connection master]
6 connection master;
7 SET TIME_ZONE="+10:30";
8 SET TIMESTAMP=123456.789123;
9 SELECT CURRENT_TIMESTAMP;
10 CURRENT_TIMESTAMP
11 1970-01-02 20:47:36
12 connection slave;
13 SET TIME_ZONE="+00:00";
14 SET TIMESTAMP=987654321.123456;
15 SELECT CURRENT_TIMESTAMP;
16 CURRENT_TIMESTAMP
17 2001-04-19 04:25:21
18 connection master;
19 CREATE TABLE t1 (
20 a TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
21 b TIMESTAMP(1) NOT NULL DEFAULT CURRENT_TIMESTAMP(1),
22 c TIMESTAMP(2) NOT NULL DEFAULT CURRENT_TIMESTAMP(2),
23 d TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
24 e TIMESTAMP(4) NOT NULL DEFAULT CURRENT_TIMESTAMP(4),
25 f TIMESTAMP(5) NOT NULL DEFAULT CURRENT_TIMESTAMP(5),
26 g TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
27 h DATETIME DEFAULT CURRENT_TIMESTAMP,
28 i DATETIME(1) DEFAULT CURRENT_TIMESTAMP(1),
29 j DATETIME(2) DEFAULT CURRENT_TIMESTAMP(2),
30 k DATETIME(3) DEFAULT CURRENT_TIMESTAMP(3),
31 l DATETIME(4) DEFAULT CURRENT_TIMESTAMP(4),
32 m DATETIME(5) DEFAULT CURRENT_TIMESTAMP(5),
33 n DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6),
34 o INT
35 );
36 INSERT INTO t1 ( o ) VALUES ( 1 );
37 CREATE TABLE t2 (
38 a TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
39 b TIMESTAMP(1) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(1),
40 c TIMESTAMP(2) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(2),
41 d TIMESTAMP(3) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(3),
42 e TIMESTAMP(4) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(4),
43 f TIMESTAMP(5) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(5),
44 g TIMESTAMP(6) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(6),
45 h DATETIME ON UPDATE CURRENT_TIMESTAMP,
46 i DATETIME(1) ON UPDATE CURRENT_TIMESTAMP(1),
47 j DATETIME(2) ON UPDATE CURRENT_TIMESTAMP(2),
48 k DATETIME(3) ON UPDATE CURRENT_TIMESTAMP(3),
49 l DATETIME(4) ON UPDATE CURRENT_TIMESTAMP(4),
50 m DATETIME(5) ON UPDATE CURRENT_TIMESTAMP(5),
51 n DATETIME(6) ON UPDATE CURRENT_TIMESTAMP(6),
52 o INT
53 );
54 INSERT INTO t2 ( o ) VALUES ( 1 );
55 sync_slave_with_master
56 connection slave;
57 connection slave;
58 SELECT * FROM t1;
59 a 1970-01-02 10:17:36
60 b 1970-01-02 10:17:36.7
61 c 1970-01-02 10:17:36.78
62 d 1970-01-02 10:17:36.789
63 e 1970-01-02 10:17:36.7891
64 f 1970-01-02 10:17:36.78912
65 g 1970-01-02 10:17:36.789123
66 h 1970-01-02 20:47:36
67 i 1970-01-02 20:47:36.7
68 j 1970-01-02 20:47:36.78
69 k 1970-01-02 20:47:36.789
70 l 1970-01-02 20:47:36.7891
71 m 1970-01-02 20:47:36.78912
72 n 1970-01-02 20:47:36.789123
73 o 1
74 SELECT * FROM t2;
75 a 0000-00-00 00:00:00
76 b 0000-00-00 00:00:00.0
77 c 0000-00-00 00:00:00.00
78 d 0000-00-00 00:00:00.000
79 e 0000-00-00 00:00:00.0000
80 f 0000-00-00 00:00:00.00000
81 g 0000-00-00 00:00:00.000000
82 h NULL
83 i NULL
84 j NULL
85 k NULL
86 l NULL
87 m NULL
88 n NULL
89 o 1
90 connection master;
91 SET TIMESTAMP=1234567890.123456;
92 SELECT CURRENT_TIMESTAMP;
93 CURRENT_TIMESTAMP
94 2009-02-14 10:01:30
95 UPDATE t1 SET o = 2;
96 UPDATE t2 SET o = 2;
97 sync_slave_with_master
98 connection slave;
99 connection slave;
100 SELECT * FROM t1;
101 a 1970-01-02 10:17:36
102 b 1970-01-02 10:17:36.7
103 c 1970-01-02 10:17:36.78
104 d 1970-01-02 10:17:36.789
105 e 1970-01-02 10:17:36.7891
106 f 1970-01-02 10:17:36.78912
107 g 1970-01-02 10:17:36.789123
108 h 1970-01-02 20:47:36
109 i 1970-01-02 20:47:36.7
110 j 1970-01-02 20:47:36.78
111 k 1970-01-02 20:47:36.789
112 l 1970-01-02 20:47:36.7891
113 m 1970-01-02 20:47:36.78912
114 n 1970-01-02 20:47:36.789123
115 o 2
116 SELECT * FROM t2;
117 a 2009-02-13 23:31:30
118 b 2009-02-13 23:31:30.1
119 c 2009-02-13 23:31:30.12
120 d 2009-02-13 23:31:30.123
121 e 2009-02-13 23:31:30.1234
122 f 2009-02-13 23:31:30.12345
123 g 2009-02-13 23:31:30.123456
124 h 2009-02-14 10:01:30
125 i 2009-02-14 10:01:30.1
126 j 2009-02-14 10:01:30.12
127 k 2009-02-14 10:01:30.123
128 l 2009-02-14 10:01:30.1234
129 m 2009-02-14 10:01:30.12345
130 n 2009-02-14 10:01:30.123456
131 o 2
132 connection master;
133 DROP TABLE t1, t2;
134 include/rpl_end.inc