1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
#### Binary log ENABLED ####
==== Don't set any option ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err
include/assert_grep.inc [There shall be no deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 60*60*24*30]
include/assert.inc [expire_logs_days shall be 0]
==== Set one option to zero ====
---- days=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
---- seconds=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be no deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set one option to non-zero ====
---- days=14 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=14
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 14]
---- seconds=3600 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=3600
include/assert_grep.inc [There shall be no deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 3600]
include/assert.inc [expire_logs_days shall be 0]
==== Set both options to zero ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set both options: one to zero and one to non-zero ====
---- seconds=0 days=14 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=14 --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 14]
---- seconds=14 days=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=14
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 14]
include/assert.inc [expire_logs_days shall be 0]
==== Set both options to non-zero ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=14 --binlog-expire-logs-seconds=14
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be a combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 14]
include/assert.inc [expire_logs_days shall be 0]
#### Binary log DISABLED ####
==== Don't set any option ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin
include/assert_grep.inc [There shall be no deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 60*60*24*30]
include/assert.inc [expire_logs_days shall be 0]
==== Set one option to zero ====
---- days=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be a binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
---- seconds=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be no deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set one option to non-zero ====
---- days=14 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=14
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert_grep.inc [There shall be a binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 14]
---- seconds=3600 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=3600
include/assert_grep.inc [There shall be no deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert_grep.inc [There shall be no binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 3600]
include/assert.inc [expire_logs_days shall be 0]
==== Set both options to zero ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert_grep.inc [There shall be a binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set both options: one to zero and one to non-zero ====
---- seconds=0 days=14 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=14 --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert_grep.inc [There shall be a binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 14]
---- seconds=14 days=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=14
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be no combination warning]
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert_grep.inc [There shall be a binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 14]
include/assert.inc [expire_logs_days shall be 0]
==== Set both options to non-zero ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=14 --binlog-expire-logs-seconds=14
include/assert_grep.inc [There shall be a deprecation warning]
include/assert_grep.inc [There shall be a combination warning]
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert_grep.inc [There shall be a binlog_off+days warning]
include/assert.inc [binlog_expire_logs_seconds shall be 14]
include/assert.inc [expire_logs_days shall be 0]
|
