Debian Codegraph @

mysql-test/suite/sys_vars/r/expire_logs_days_basic.result

raw
1 SET @start_value = @@global.expire_logs_days;
2 Warnings:
3 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
4 SELECT @start_value;
5 @start_value
6 0
7 SET @start_value_sec = @@global.binlog_expire_logs_seconds;
8 SELECT @start_value_sec;
9 @start_value_sec
10 2592000
11 SET @@global.binlog_expire_logs_seconds = 0;
12 '#--------------------FN_DYNVARS_029_01------------------------#'
13 SET @@global.expire_logs_days = 99;
14 Warnings:
15 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
16 SET @@global.expire_logs_days = DEFAULT;
17 Warnings:
18 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
19 SELECT @@global.expire_logs_days;
20 @@global.expire_logs_days
21 0
22 Warnings:
23 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
24 '#---------------------FN_DYNVARS_029_02-------------------------#'
25 SET @@global.expire_logs_days = @start_value;
26 Warnings:
27 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
28 SELECT @@global.expire_logs_days = 0;
29 @@global.expire_logs_days = 0
30 1
31 Warnings:
32 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
33 '#--------------------FN_DYNVARS_029_03_01------------------------#'
34 SET @@global.expire_logs_days = 0;
35 Warnings:
36 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
37 SELECT @@global.expire_logs_days;
38 @@global.expire_logs_days
39 0
40 Warnings:
41 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
42 SET @@global.expire_logs_days = 99;
43 Warnings:
44 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
45 SELECT @@global.expire_logs_days;
46 @@global.expire_logs_days
47 99
48 Warnings:
49 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
50 SET @@global.expire_logs_days = 10;
51 Warnings:
52 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
53 SELECT @@global.expire_logs_days;
54 @@global.expire_logs_days
55 10
56 Warnings:
57 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
58 SET @@global.expire_logs_days = 21;
59 Warnings:
60 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
61 SELECT @@global.expire_logs_days;
62 @@global.expire_logs_days
63 21
64 Warnings:
65 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
66 '#--------------------FN_DYNVARS_029_04_01-------------------------#'
67 SET @@global.expire_logs_days = -1;
68 Warnings:
69 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
70 Warning 1292 Truncated incorrect expire_logs_days value: '-1'
71 SELECT @@global.expire_logs_days;
72 @@global.expire_logs_days
73 0
74 Warnings:
75 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
76 SET @@global.expire_logs_days = 100;
77 Warnings:
78 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
79 Warning 1292 Truncated incorrect expire_logs_days value: '100'
80 SELECT @@global.expire_logs_days;
81 @@global.expire_logs_days
82 99
83 Warnings:
84 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
85 SET @@global.expire_logs_days = 1024;
86 Warnings:
87 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
88 Warning 1292 Truncated incorrect expire_logs_days value: '1024'
89 SELECT @@global.expire_logs_days;
90 @@global.expire_logs_days
91 99
92 Warnings:
93 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
94 SET @@global.expire_logs_days = 10000.01;
95 ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
96 SELECT @@global.expire_logs_days;
97 @@global.expire_logs_days
98 99
99 Warnings:
100 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
101 SET @@global.expire_logs_days = -1024;
102 Warnings:
103 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
104 Warning 1292 Truncated incorrect expire_logs_days value: '-1024'
105 SELECT @@global.expire_logs_days;
106 @@global.expire_logs_days
107 0
108 Warnings:
109 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
110 SET @@global.expire_logs_days = 42949672950;
111 Warnings:
112 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
113 Warning 1292 Truncated incorrect expire_logs_days value: '42949672950'
114 SELECT @@global.expire_logs_days;
115 @@global.expire_logs_days
116 99
117 Warnings:
118 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
119 SET @@global.expire_logs_days = ON;
120 ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
121 SELECT @@global.expire_logs_days;
122 @@global.expire_logs_days
123 99
124 Warnings:
125 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
126 SET @@global.expire_logs_days = 'test';
127 ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
128 SELECT @@global.expire_logs_days;
129 @@global.expire_logs_days
130 99
131 Warnings:
132 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
133 '#-------------------FN_DYNVARS_029_05_01----------------------------#'
134 SET @@session.expire_logs_days = 0;
135 ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
136 SELECT @@expire_logs_days;
137 @@expire_logs_days
138 99
139 Warnings:
140 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
141 '#----------------------FN_DYNVARS_029_06_01------------------------#'
142 SELECT @@global.expire_logs_days = VARIABLE_VALUE
143 FROM performance_schema.global_variables
144 WHERE VARIABLE_NAME='expire_logs_days';
145 @@global.expire_logs_days = VARIABLE_VALUE
146 1
147 SELECT @@expire_logs_days = VARIABLE_VALUE
148 FROM performance_schema.session_variables
149 WHERE VARIABLE_NAME='expire_logs_days';
150 @@expire_logs_days = VARIABLE_VALUE
151 1
152 '#---------------------FN_DYNVARS_029_07_01----------------------#'
153 SET @@global.expire_logs_days = TRUE;
154 Warnings:
155 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
156 SELECT @@global.expire_logs_days;
157 @@global.expire_logs_days
158 1
159 Warnings:
160 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
161 SET @@global.expire_logs_days = FALSE;
162 Warnings:
163 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
164 SELECT @@global.expire_logs_days;
165 @@global.expire_logs_days
166 0
167 Warnings:
168 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
169 '#---------------------FN_DYNVARS_029_08_01----------------------#'
170 SET @@global.expire_logs_days = 1;
171 Warnings:
172 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
173 SELECT @@expire_logs_days = @@global.expire_logs_days;
174 @@expire_logs_days = @@global.expire_logs_days
175 1
176 Warnings:
177 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
178 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
179 '#---------------------FN_DYNVARS_029_09_01----------------------#'
180 SET expire_logs_days = 1;
181 ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
182 SELECT @@expire_logs_days;
183 @@expire_logs_days
184 1
185 Warnings:
186 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
187 SET local.expire_logs_days = 1;
188 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.expire_logs_days = 1' at line 1
189 SELECT local.expire_logs_days;
190 ERROR 42S02: Unknown table 'local' in field list
191 SET global.expire_logs_days = 1;
192 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.expire_logs_days = 1' at line 1
193 SELECT global.expire_logs_days;
194 ERROR 42S02: Unknown table 'global' in field list
195 SELECT expire_logs_days;
196 ERROR 42S22: Unknown column 'expire_logs_days' in 'field list'
197 SELECT @@session.expire_logs_days;
198 ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable
199 SET @@global.expire_logs_days = @start_value;
200 Warnings:
201 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
202 SELECT @@global.expire_logs_days;
203 @@global.expire_logs_days
204 0
205 Warnings:
206 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
207 SET @@global.binlog_expire_logs_seconds = @start_value_sec;
208 SELECT @@global.binlog_expire_logs_seconds;
209 @@global.binlog_expire_logs_seconds
210 2592000