2
# Test of function defaults on replicated tables.
4
include/master-slave.inc
6
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
10
SET TIME_ZONE="+10:30";
11
SET TIMESTAMP=123456.789123;
12
SELECT CURRENT_TIMESTAMP;
16
SET TIME_ZONE="+00:00";
17
SET TIMESTAMP=987654321.123456;
18
SELECT CURRENT_TIMESTAMP;
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),
39
INSERT INTO t1 ( o ) VALUES ( 1 );
41
a TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
42
b TIMESTAMP(1) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(1),
43
c TIMESTAMP(2) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(2),
44
d TIMESTAMP(3) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(3),
45
e TIMESTAMP(4) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(4),
46
f TIMESTAMP(5) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(5),
47
g TIMESTAMP(6) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(6),
48
h DATETIME ON UPDATE CURRENT_TIMESTAMP,
49
i DATETIME(1) ON UPDATE CURRENT_TIMESTAMP(1),
50
j DATETIME(2) ON UPDATE CURRENT_TIMESTAMP(2),
51
k DATETIME(3) ON UPDATE CURRENT_TIMESTAMP(3),
52
l DATETIME(4) ON UPDATE CURRENT_TIMESTAMP(4),
53
m DATETIME(5) ON UPDATE CURRENT_TIMESTAMP(5),
54
n DATETIME(6) ON UPDATE CURRENT_TIMESTAMP(6),
57
INSERT INTO t2 ( o ) VALUES ( 1 );
58
sync_slave_with_master
62
b 1970-01-02 10:17:36.7
63
c 1970-01-02 10:17:36.78
64
d 1970-01-02 10:17:36.789
65
e 1970-01-02 10:17:36.7891
66
f 1970-01-02 10:17:36.78912
67
g 1970-01-02 10:17:36.789123
69
i 1970-01-02 20:47:36.7
70
j 1970-01-02 20:47:36.78
71
k 1970-01-02 20:47:36.789
72
l 1970-01-02 20:47:36.7891
73
m 1970-01-02 20:47:36.78912
74
n 1970-01-02 20:47:36.789123
78
b 0000-00-00 00:00:00.0
79
c 0000-00-00 00:00:00.00
80
d 0000-00-00 00:00:00.000
81
e 0000-00-00 00:00:00.0000
82
f 0000-00-00 00:00:00.00000
83
g 0000-00-00 00:00:00.000000
93
SET TIMESTAMP=1234567890.123456;
94
SELECT CURRENT_TIMESTAMP;
99
sync_slave_with_master
102
a 1970-01-02 10:17:36
103
b 1970-01-02 10:17:36.7
104
c 1970-01-02 10:17:36.78
105
d 1970-01-02 10:17:36.789
106
e 1970-01-02 10:17:36.7891
107
f 1970-01-02 10:17:36.78912
108
g 1970-01-02 10:17:36.789123
109
h 1970-01-02 20:47:36
110
i 1970-01-02 20:47:36.7
111
j 1970-01-02 20:47:36.78
112
k 1970-01-02 20:47:36.789
113
l 1970-01-02 20:47:36.7891
114
m 1970-01-02 20:47:36.78912
115
n 1970-01-02 20:47:36.789123
118
a 2009-02-13 23:31:30
119
b 2009-02-13 23:31:30.1
120
c 2009-02-13 23:31:30.12
121
d 2009-02-13 23:31:30.123
122
e 2009-02-13 23:31:30.1234
123
f 2009-02-13 23:31:30.12345
124
g 2009-02-13 23:31:30.123456
125
h 2009-02-14 10:01:30
126
i 2009-02-14 10:01:30.1
127
j 2009-02-14 10:01:30.12
128
k 2009-02-14 10:01:30.123
129
l 2009-02-14 10:01:30.1234
130
m 2009-02-14 10:01:30.12345
131
n 2009-02-14 10:01:30.123456