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 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
8 [connection master]
9 connection master
10 SET TIME_ZONE="+10:30";
11 SET TIMESTAMP=123456.789123;
12 SELECT CURRENT_TIMESTAMP;
13 CURRENT_TIMESTAMP
14 1970-01-02 20:47:36
15 connection slave
16 SET TIME_ZONE="+00:00";
17 SET TIMESTAMP=987654321.123456;
18 SELECT CURRENT_TIMESTAMP;
19 CURRENT_TIMESTAMP
20 2001-04-19 04:25:21
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 INSERT INTO t1 ( o ) VALUES ( 1 );
40 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
41 CREATE TABLE t2 (
42 a TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
43 b TIMESTAMP(1) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(1),
44 c TIMESTAMP(2) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(2),
45 d TIMESTAMP(3) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(3),
46 e TIMESTAMP(4) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(4),
47 f TIMESTAMP(5) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(5),
48 g TIMESTAMP(6) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(6),
49 h DATETIME ON UPDATE CURRENT_TIMESTAMP,
50 i DATETIME(1) ON UPDATE CURRENT_TIMESTAMP(1),
51 j DATETIME(2) ON UPDATE CURRENT_TIMESTAMP(2),
52 k DATETIME(3) ON UPDATE CURRENT_TIMESTAMP(3),
53 l DATETIME(4) ON UPDATE CURRENT_TIMESTAMP(4),
54 m DATETIME(5) ON UPDATE CURRENT_TIMESTAMP(5),
55 n DATETIME(6) ON UPDATE CURRENT_TIMESTAMP(6),
56 o INT
57 );
58 INSERT INTO t2 ( o ) VALUES ( 1 );
59 SET sql_mode = default;
60 sync_slave_with_master
61 include/sync_slave_sql_with_master.inc
62 connection slave
63 SELECT * FROM t1;
64 a 1970-01-02 10:17:36
65 b 1970-01-02 10:17:36.7
66 c 1970-01-02 10:17:36.78
67 d 1970-01-02 10:17:36.789
68 e 1970-01-02 10:17:36.7891
69 f 1970-01-02 10:17:36.78912
70 g 1970-01-02 10:17:36.789123
71 h 1970-01-02 20:47:36
72 i 1970-01-02 20:47:36.7
73 j 1970-01-02 20:47:36.78
74 k 1970-01-02 20:47:36.789
75 l 1970-01-02 20:47:36.7891
76 m 1970-01-02 20:47:36.78912
77 n 1970-01-02 20:47:36.789123
78 o 1
79 SELECT * FROM t2;
80 a 0000-00-00 00:00:00
81 b 0000-00-00 00:00:00.0
82 c 0000-00-00 00:00:00.00
83 d 0000-00-00 00:00:00.000
84 e 0000-00-00 00:00:00.0000
85 f 0000-00-00 00:00:00.00000
86 g 0000-00-00 00:00:00.000000
87 h NULL
88 i NULL
89 j NULL
90 k NULL
91 l NULL
92 m NULL
93 n NULL
94 o 1
95 connection master
96 SET TIMESTAMP=1234567890.123456;
97 SELECT CURRENT_TIMESTAMP;
98 CURRENT_TIMESTAMP
99 2009-02-14 10:01:30
100 UPDATE t1 SET o = 2;
101 UPDATE t2 SET o = 2;
102 sync_slave_with_master
103 include/sync_slave_sql_with_master.inc
104 connection slave
105 SELECT * FROM t1;
106 a 1970-01-02 10:17:36
107 b 1970-01-02 10:17:36.7
108 c 1970-01-02 10:17:36.78
109 d 1970-01-02 10:17:36.789
110 e 1970-01-02 10:17:36.7891
111 f 1970-01-02 10:17:36.78912
112 g 1970-01-02 10:17:36.789123
113 h 1970-01-02 20:47:36
114 i 1970-01-02 20:47:36.7
115 j 1970-01-02 20:47:36.78
116 k 1970-01-02 20:47:36.789
117 l 1970-01-02 20:47:36.7891
118 m 1970-01-02 20:47:36.78912
119 n 1970-01-02 20:47:36.789123
120 o 2
121 SELECT * FROM t2;
122 a 2009-02-13 23:31:30
123 b 2009-02-13 23:31:30.1
124 c 2009-02-13 23:31:30.12
125 d 2009-02-13 23:31:30.123
126 e 2009-02-13 23:31:30.1234
127 f 2009-02-13 23:31:30.12345
128 g 2009-02-13 23:31:30.123456
129 h 2009-02-14 10:01:30
130 i 2009-02-14 10:01:30.1
131 j 2009-02-14 10:01:30.12
132 k 2009-02-14 10:01:30.123
133 l 2009-02-14 10:01:30.1234
134 m 2009-02-14 10:01:30.12345
135 n 2009-02-14 10:01:30.123456
136 o 2
137 connection master
138 DROP TABLE t1, t2;
139 include/rpl_end.inc