Debian Codegraph @

mysql-test/suite/x/r/system_variable_io_timeouts.result

raw
1 CREATE USER 'regular_user'@'%' IDENTIFIED WITH 'mysql_native_password';
2 CREATE USER 'var_admin_user'@'%' IDENTIFIED WITH 'mysql_native_password';
3 CREATE USER 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password';
4 GRANT 'SYSTEM_VARIABLES_ADMIN' ON *.* TO 'var_admin_user'@'%';
5 GRANT SUPER ON *.* TO 'super_user'@'%';
6 #
7 # Verify access to Mysqlx_wait_timeout system variable after plugin installation
8 #
9 # * invalid values
10 # * user with permissions
11 # * user without permissions
12 #
13 include/assert.inc [Mysqlx_wait_timeout global variablem must exist]
14 SET @@GLOBAL.Mysqlx_wait_timeout="TEXT";
15 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
16 SELECT @@GLOBAL.Mysqlx_wait_timeout;
17 @@GLOBAL.Mysqlx_wait_timeout
18 28800
19 include/assert.inc [Invalid set doesn't change the value of Mysqlx_wait_timeout (global variable)]
20 #
21 ## user with permissions
22 SET @@GLOBAL.Mysqlx_wait_timeout=10;
23 include/assert.inc [User with permissions can change Mysqlx_wait_timeout value]
24 #
25 ## user without permissions
26 SET @@GLOBAL.Mysqlx_wait_timeout=11;
27 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
28 include/assert.inc [User without permissions can't change Mysqlx_wait_timeout value]
29 connecting...
30 active session is now 'power_user'
31 RUN SET SESSION Mysqlx_wait_timeout=10;
32
33 0 rows affected
34 Verify [Session variable "Mysqlx_wait_timeout" needs to have a value of 10]
35 connecting...
36 active session is now 'regular_user'
37 RUN SET SESSION Mysqlx_wait_timeout=20;
38
39 0 rows affected
40 Verify [Session variable "Mysqlx_wait_timeout" needs to have a value of 20]
41 closing session regular_user
42 Mysqlx.Ok {
43 msg: "bye!"
44 }
45 SET @@GLOBAL.Mysqlx_wait_timeout=DEFAULT;
46 #
47 # Verify access to Mysqlx_wait_timeout system variable after plugin installation
48 #
49 # * invalid values
50 # * user with permissions
51 # * user without permissions
52 #
53 include/assert.inc [Mysqlx_wait_timeout global variablem must exist]
54 SET @@GLOBAL.Mysqlx_wait_timeout="TEXT";
55 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
56 SELECT @@GLOBAL.Mysqlx_wait_timeout;
57 @@GLOBAL.Mysqlx_wait_timeout
58 28800
59 include/assert.inc [Invalid set doesn't change the value of Mysqlx_wait_timeout (global variable)]
60 #
61 ## user with permissions
62 SET @@GLOBAL.Mysqlx_wait_timeout=10;
63 include/assert.inc [User with permissions can change Mysqlx_wait_timeout value]
64 #
65 ## user without permissions
66 SET @@GLOBAL.Mysqlx_wait_timeout=11;
67 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
68 include/assert.inc [User without permissions can't change Mysqlx_wait_timeout value]
69 connecting...
70 active session is now 'power_user'
71 RUN SET SESSION Mysqlx_wait_timeout=10;
72
73 0 rows affected
74 Verify [Session variable "Mysqlx_wait_timeout" needs to have a value of 10]
75 connecting...
76 active session is now 'regular_user'
77 RUN SET SESSION Mysqlx_wait_timeout=20;
78
79 0 rows affected
80 Verify [Session variable "Mysqlx_wait_timeout" needs to have a value of 20]
81 closing session regular_user
82 Mysqlx.Ok {
83 msg: "bye!"
84 }
85 SET @@GLOBAL.Mysqlx_wait_timeout=DEFAULT;
86 #
87 # Verify access to Mysqlx_interactive_timeout system variable after plugin installation
88 #
89 # * invalid values
90 # * user with permissions
91 # * user without permissions
92 #
93 include/assert.inc [Mysqlx_interactive_timeout global variablem must exist]
94 SET @@GLOBAL.Mysqlx_interactive_timeout="TEXT";
95 ERROR 42000: Incorrect argument type to variable 'mysqlx_interactive_timeout'
96 SELECT @@GLOBAL.Mysqlx_interactive_timeout;
97 @@GLOBAL.Mysqlx_interactive_timeout
98 28800
99 include/assert.inc [Invalid set doesn't change the value of Mysqlx_interactive_timeout (global variable)]
100 #
101 ## user with permissions
102 SET @@GLOBAL.Mysqlx_interactive_timeout=10;
103 include/assert.inc [User with permissions can change Mysqlx_interactive_timeout value]
104 #
105 ## user without permissions
106 SET @@GLOBAL.Mysqlx_interactive_timeout=11;
107 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
108 include/assert.inc [User without permissions can't change Mysqlx_interactive_timeout value]
109 SET @@GLOBAL.Mysqlx_interactive_timeout=DEFAULT;
110 #
111 # Verify access to Mysqlx_interactive_timeout system variable after plugin installation
112 #
113 # * invalid values
114 # * user with permissions
115 # * user without permissions
116 #
117 include/assert.inc [Mysqlx_interactive_timeout global variablem must exist]
118 SET @@GLOBAL.Mysqlx_interactive_timeout="TEXT";
119 ERROR 42000: Incorrect argument type to variable 'mysqlx_interactive_timeout'
120 SELECT @@GLOBAL.Mysqlx_interactive_timeout;
121 @@GLOBAL.Mysqlx_interactive_timeout
122 28800
123 include/assert.inc [Invalid set doesn't change the value of Mysqlx_interactive_timeout (global variable)]
124 #
125 ## user with permissions
126 SET @@GLOBAL.Mysqlx_interactive_timeout=10;
127 include/assert.inc [User with permissions can change Mysqlx_interactive_timeout value]
128 #
129 ## user without permissions
130 SET @@GLOBAL.Mysqlx_interactive_timeout=11;
131 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
132 include/assert.inc [User without permissions can't change Mysqlx_interactive_timeout value]
133 SET @@GLOBAL.Mysqlx_interactive_timeout=DEFAULT;
134 #
135 # Verify access to Mysqlx_read_timeout system variable after plugin installation
136 #
137 # * invalid values
138 # * user with permissions
139 # * user without permissions
140 #
141 include/assert.inc [Mysqlx_read_timeout global variablem must exist]
142 SET @@GLOBAL.Mysqlx_read_timeout="TEXT";
143 ERROR 42000: Incorrect argument type to variable 'mysqlx_read_timeout'
144 SELECT @@GLOBAL.Mysqlx_read_timeout;
145 @@GLOBAL.Mysqlx_read_timeout
146 30
147 include/assert.inc [Invalid set doesn't change the value of Mysqlx_read_timeout (global variable)]
148 #
149 ## user with permissions
150 SET @@GLOBAL.Mysqlx_read_timeout=10;
151 include/assert.inc [User with permissions can change Mysqlx_read_timeout value]
152 #
153 ## user without permissions
154 SET @@GLOBAL.Mysqlx_read_timeout=11;
155 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
156 include/assert.inc [User without permissions can't change Mysqlx_read_timeout value]
157 connecting...
158 active session is now 'power_user'
159 RUN SET SESSION Mysqlx_read_timeout=10;
160
161 0 rows affected
162 Verify [Session variable "Mysqlx_read_timeout" needs to have a value of 10]
163 connecting...
164 active session is now 'regular_user'
165 RUN SET SESSION Mysqlx_read_timeout=20;
166
167 0 rows affected
168 Verify [Session variable "Mysqlx_read_timeout" needs to have a value of 20]
169 closing session regular_user
170 Mysqlx.Ok {
171 msg: "bye!"
172 }
173 SET @@GLOBAL.Mysqlx_read_timeout=DEFAULT;
174 #
175 # Verify access to Mysqlx_read_timeout system variable after plugin installation
176 #
177 # * invalid values
178 # * user with permissions
179 # * user without permissions
180 #
181 include/assert.inc [Mysqlx_read_timeout global variablem must exist]
182 SET @@GLOBAL.Mysqlx_read_timeout="TEXT";
183 ERROR 42000: Incorrect argument type to variable 'mysqlx_read_timeout'
184 SELECT @@GLOBAL.Mysqlx_read_timeout;
185 @@GLOBAL.Mysqlx_read_timeout
186 30
187 include/assert.inc [Invalid set doesn't change the value of Mysqlx_read_timeout (global variable)]
188 #
189 ## user with permissions
190 SET @@GLOBAL.Mysqlx_read_timeout=10;
191 include/assert.inc [User with permissions can change Mysqlx_read_timeout value]
192 #
193 ## user without permissions
194 SET @@GLOBAL.Mysqlx_read_timeout=11;
195 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
196 include/assert.inc [User without permissions can't change Mysqlx_read_timeout value]
197 connecting...
198 active session is now 'power_user'
199 RUN SET SESSION Mysqlx_read_timeout=10;
200
201 0 rows affected
202 Verify [Session variable "Mysqlx_read_timeout" needs to have a value of 10]
203 connecting...
204 active session is now 'regular_user'
205 RUN SET SESSION Mysqlx_read_timeout=20;
206
207 0 rows affected
208 Verify [Session variable "Mysqlx_read_timeout" needs to have a value of 20]
209 closing session regular_user
210 Mysqlx.Ok {
211 msg: "bye!"
212 }
213 SET @@GLOBAL.Mysqlx_read_timeout=DEFAULT;
214 #
215 # Verify access to Mysqlx_write_timeout system variable after plugin installation
216 #
217 # * invalid values
218 # * user with permissions
219 # * user without permissions
220 #
221 include/assert.inc [Mysqlx_write_timeout global variablem must exist]
222 SET @@GLOBAL.Mysqlx_write_timeout="TEXT";
223 ERROR 42000: Incorrect argument type to variable 'mysqlx_write_timeout'
224 SELECT @@GLOBAL.Mysqlx_write_timeout;
225 @@GLOBAL.Mysqlx_write_timeout
226 60
227 include/assert.inc [Invalid set doesn't change the value of Mysqlx_write_timeout (global variable)]
228 #
229 ## user with permissions
230 SET @@GLOBAL.Mysqlx_write_timeout=10;
231 include/assert.inc [User with permissions can change Mysqlx_write_timeout value]
232 #
233 ## user without permissions
234 SET @@GLOBAL.Mysqlx_write_timeout=11;
235 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
236 include/assert.inc [User without permissions can't change Mysqlx_write_timeout value]
237 connecting...
238 active session is now 'power_user'
239 RUN SET SESSION Mysqlx_write_timeout=10;
240
241 0 rows affected
242 Verify [Session variable "Mysqlx_write_timeout" needs to have a value of 10]
243 connecting...
244 active session is now 'regular_user'
245 RUN SET SESSION Mysqlx_write_timeout=20;
246
247 0 rows affected
248 Verify [Session variable "Mysqlx_write_timeout" needs to have a value of 20]
249 closing session regular_user
250 Mysqlx.Ok {
251 msg: "bye!"
252 }
253 SET @@GLOBAL.Mysqlx_write_timeout=DEFAULT;
254 #
255 # Verify access to Mysqlx_write_timeout system variable after plugin installation
256 #
257 # * invalid values
258 # * user with permissions
259 # * user without permissions
260 #
261 include/assert.inc [Mysqlx_write_timeout global variablem must exist]
262 SET @@GLOBAL.Mysqlx_write_timeout="TEXT";
263 ERROR 42000: Incorrect argument type to variable 'mysqlx_write_timeout'
264 SELECT @@GLOBAL.Mysqlx_write_timeout;
265 @@GLOBAL.Mysqlx_write_timeout
266 60
267 include/assert.inc [Invalid set doesn't change the value of Mysqlx_write_timeout (global variable)]
268 #
269 ## user with permissions
270 SET @@GLOBAL.Mysqlx_write_timeout=10;
271 include/assert.inc [User with permissions can change Mysqlx_write_timeout value]
272 #
273 ## user without permissions
274 SET @@GLOBAL.Mysqlx_write_timeout=11;
275 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
276 include/assert.inc [User without permissions can't change Mysqlx_write_timeout value]
277 connecting...
278 active session is now 'power_user'
279 RUN SET SESSION Mysqlx_write_timeout=10;
280
281 0 rows affected
282 Verify [Session variable "Mysqlx_write_timeout" needs to have a value of 10]
283 connecting...
284 active session is now 'regular_user'
285 RUN SET SESSION Mysqlx_write_timeout=20;
286
287 0 rows affected
288 Verify [Session variable "Mysqlx_write_timeout" needs to have a value of 20]
289 closing session regular_user
290 Mysqlx.Ok {
291 msg: "bye!"
292 }
293 SET @@GLOBAL.Mysqlx_write_timeout=DEFAULT;
294 DROP USER 'regular_user'@'%';
295 DROP USER 'var_admin_user'@'%';
296 DROP USER 'super_user'@'%';