Debian Codegraph @

mysql-test/suite/auth_sec/r/acl_tables_locking_big_negative_ser.result

raw
1 # -----------------------------------------------------------------------
2 # Setup
3 # Saving initial values
4 SET @global_start_value = @@global.transaction_isolation;
5 SELECT @global_start_value;
6 @global_start_value
7 REPEATABLE-READ
8 SET @session_start_value = @@session.transaction_isolation;
9 SELECT @session_start_value;
10 @session_start_value
11 REPEATABLE-READ
12 # Setting transaction isolation to 'SERIALIZABLE'
13 SET GLOBAL transaction_isolation = 'SERIALIZABLE';
14 # -----------------------------------------------------------------------
15 # ACL DDLs + Blocking READs
16 CREATE USER u1 IDENTIFIED BY 'abcd';
17 GRANT SELECT, UPDATE ON *.* TO u1;
18 connect conn_u1, localhost, u1, abcd,,,;
19 SET @@autocommit=0;
20 connect conn_root_1, localhost, root,,,,;
21 SET @@lock_wait_timeout=1;
22 connection conn_u1;
23 SELECT COUNT(*) FROM mysql.user WHERE user LIKE 'u1' FOR UPDATE;;
24 COUNT(*)
25 1
26 connection conn_root_1;
27 CREATE USER u2;
28 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
29 CREATE ROLE r1;
30 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
31 GRANT SELECT ON *.* TO r1;
32 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
33 GRANT r1 TO u2;
34 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
35 SET DEFAULT ROLE r1 TO u2;
36 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
37 ALTER USER u2 IDENTIFIED BY 'abcd';
38 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
39 RENAME USER u2 TO u3;
40 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
41 SET PASSWORD FOR u2 = 'abcd';
42 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
43 REVOKE r1 FROM u2;
44 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
45 REVOKE SELECT ON *.* FROM r1;
46 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
47 DROP ROLE r1;
48 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
49 DROP USER u2;
50 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
51 connection conn_u1;
52 ROLLBACK;
53 connection conn_root_1;
54 CREATE USER u2;
55 CREATE ROLE r1;
56 GRANT SELECT ON *.* TO r1;
57 GRANT r1 TO u2;
58 SET DEFAULT ROLE r1 TO u2;
59 ALTER USER u2 IDENTIFIED BY 'abcd';
60 RENAME USER u2 TO u3;
61 RENAME USER u3 TO u2;
62 SET PASSWORD FOR u2 = 'abcd';
63 REVOKE r1 FROM u2;
64 REVOKE SELECT ON *.* FROM r1;
65 DROP ROLE r1;
66 DROP USER u2;
67 connection default;
68 disconnect conn_root_1;
69 disconnect conn_u1;
70 DROP USER u1;
71 CREATE USER u1 IDENTIFIED BY 'abcd';
72 GRANT SELECT, UPDATE ON *.* TO u1;
73 connect conn_u1, localhost, u1, abcd,,,;
74 SET @@autocommit=0;
75 connect conn_root_1, localhost, root,,,,;
76 SET @@lock_wait_timeout=1;
77 connection conn_u1;
78 SELECT COUNT(*) FROM mysql.db WHERE user LIKE 'u1' FOR UPDATE;;
79 COUNT(*)
80 0
81 connection conn_root_1;
82 CREATE USER u2;
83 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
84 CREATE ROLE r1;
85 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
86 GRANT SELECT ON *.* TO r1;
87 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
88 GRANT r1 TO u2;
89 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
90 SET DEFAULT ROLE r1 TO u2;
91 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
92 ALTER USER u2 IDENTIFIED BY 'abcd';
93 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
94 RENAME USER u2 TO u3;
95 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
96 SET PASSWORD FOR u2 = 'abcd';
97 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
98 REVOKE r1 FROM u2;
99 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
100 REVOKE SELECT ON *.* FROM r1;
101 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
102 DROP ROLE r1;
103 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
104 DROP USER u2;
105 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
106 connection conn_u1;
107 ROLLBACK;
108 connection conn_root_1;
109 CREATE USER u2;
110 CREATE ROLE r1;
111 GRANT SELECT ON *.* TO r1;
112 GRANT r1 TO u2;
113 SET DEFAULT ROLE r1 TO u2;
114 ALTER USER u2 IDENTIFIED BY 'abcd';
115 RENAME USER u2 TO u3;
116 RENAME USER u3 TO u2;
117 SET PASSWORD FOR u2 = 'abcd';
118 REVOKE r1 FROM u2;
119 REVOKE SELECT ON *.* FROM r1;
120 DROP ROLE r1;
121 DROP USER u2;
122 connection default;
123 disconnect conn_root_1;
124 disconnect conn_u1;
125 DROP USER u1;
126 CREATE USER u1 IDENTIFIED BY 'abcd';
127 GRANT SELECT, UPDATE ON *.* TO u1;
128 connect conn_u1, localhost, u1, abcd,,,;
129 SET @@autocommit=0;
130 connect conn_root_1, localhost, root,,,,;
131 SET @@lock_wait_timeout=1;
132 connection conn_u1;
133 SELECT COUNT(*) FROM mysql.default_roles WHERE user LIKE 'u1' FOR UPDATE;;
134 COUNT(*)
135 0
136 connection conn_root_1;
137 CREATE USER u2;
138 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
139 CREATE ROLE r1;
140 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
141 GRANT SELECT ON *.* TO r1;
142 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
143 GRANT r1 TO u2;
144 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
145 SET DEFAULT ROLE r1 TO u2;
146 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
147 ALTER USER u2 IDENTIFIED BY 'abcd';
148 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
149 RENAME USER u2 TO u3;
150 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
151 SET PASSWORD FOR u2 = 'abcd';
152 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
153 REVOKE r1 FROM u2;
154 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
155 REVOKE SELECT ON *.* FROM r1;
156 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
157 DROP ROLE r1;
158 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
159 DROP USER u2;
160 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
161 connection conn_u1;
162 ROLLBACK;
163 connection conn_root_1;
164 CREATE USER u2;
165 CREATE ROLE r1;
166 GRANT SELECT ON *.* TO r1;
167 GRANT r1 TO u2;
168 SET DEFAULT ROLE r1 TO u2;
169 ALTER USER u2 IDENTIFIED BY 'abcd';
170 RENAME USER u2 TO u3;
171 RENAME USER u3 TO u2;
172 SET PASSWORD FOR u2 = 'abcd';
173 REVOKE r1 FROM u2;
174 REVOKE SELECT ON *.* FROM r1;
175 DROP ROLE r1;
176 DROP USER u2;
177 connection default;
178 disconnect conn_root_1;
179 disconnect conn_u1;
180 DROP USER u1;
181 CREATE USER u1 IDENTIFIED BY 'abcd';
182 GRANT SELECT, UPDATE ON *.* TO u1;
183 connect conn_u1, localhost, u1, abcd,,,;
184 SET @@autocommit=0;
185 connect conn_root_1, localhost, root,,,,;
186 SET @@lock_wait_timeout=1;
187 connection conn_u1;
188 SELECT COUNT(*) FROM mysql.role_edges WHERE from_user LIKE 'u1' FOR UPDATE;;
189 COUNT(*)
190 0
191 connection conn_root_1;
192 CREATE USER u2;
193 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
194 CREATE ROLE r1;
195 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
196 GRANT SELECT ON *.* TO r1;
197 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
198 GRANT r1 TO u2;
199 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
200 SET DEFAULT ROLE r1 TO u2;
201 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
202 ALTER USER u2 IDENTIFIED BY 'abcd';
203 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
204 RENAME USER u2 TO u3;
205 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
206 SET PASSWORD FOR u2 = 'abcd';
207 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
208 REVOKE r1 FROM u2;
209 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
210 REVOKE SELECT ON *.* FROM r1;
211 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
212 DROP ROLE r1;
213 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
214 DROP USER u2;
215 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
216 connection conn_u1;
217 ROLLBACK;
218 connection conn_root_1;
219 CREATE USER u2;
220 CREATE ROLE r1;
221 GRANT SELECT ON *.* TO r1;
222 GRANT r1 TO u2;
223 SET DEFAULT ROLE r1 TO u2;
224 ALTER USER u2 IDENTIFIED BY 'abcd';
225 RENAME USER u2 TO u3;
226 RENAME USER u3 TO u2;
227 SET PASSWORD FOR u2 = 'abcd';
228 REVOKE r1 FROM u2;
229 REVOKE SELECT ON *.* FROM r1;
230 DROP ROLE r1;
231 DROP USER u2;
232 connection default;
233 disconnect conn_root_1;
234 disconnect conn_u1;
235 DROP USER u1;
236 CREATE USER u1 IDENTIFIED BY 'abcd';
237 GRANT SELECT, UPDATE ON *.* TO u1;
238 connect conn_u1, localhost, u1, abcd,,,;
239 SET @@autocommit=0;
240 connect conn_root_1, localhost, root,,,,;
241 SET @@lock_wait_timeout=1;
242 connection conn_u1;
243 SELECT COUNT(*) FROM mysql.global_grants WHERE user LIKE 'u1' FOR UPDATE;;
244 COUNT(*)
245 0
246 connection conn_root_1;
247 CREATE USER u2;
248 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
249 CREATE ROLE r1;
250 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
251 GRANT SELECT ON *.* TO r1;
252 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
253 GRANT r1 TO u2;
254 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
255 SET DEFAULT ROLE r1 TO u2;
256 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
257 ALTER USER u2 IDENTIFIED BY 'abcd';
258 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
259 RENAME USER u2 TO u3;
260 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
261 SET PASSWORD FOR u2 = 'abcd';
262 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
263 REVOKE r1 FROM u2;
264 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
265 REVOKE SELECT ON *.* FROM r1;
266 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
267 DROP ROLE r1;
268 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
269 DROP USER u2;
270 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
271 connection conn_u1;
272 ROLLBACK;
273 connection conn_root_1;
274 CREATE USER u2;
275 CREATE ROLE r1;
276 GRANT SELECT ON *.* TO r1;
277 GRANT r1 TO u2;
278 SET DEFAULT ROLE r1 TO u2;
279 ALTER USER u2 IDENTIFIED BY 'abcd';
280 RENAME USER u2 TO u3;
281 RENAME USER u3 TO u2;
282 SET PASSWORD FOR u2 = 'abcd';
283 REVOKE r1 FROM u2;
284 REVOKE SELECT ON *.* FROM r1;
285 DROP ROLE r1;
286 DROP USER u2;
287 connection default;
288 disconnect conn_root_1;
289 disconnect conn_u1;
290 DROP USER u1;
291 CREATE USER u1 IDENTIFIED BY 'abcd';
292 GRANT SELECT, UPDATE ON *.* TO u1;
293 connect conn_u1, localhost, u1, abcd,,,;
294 SET @@autocommit=0;
295 connect conn_root_1, localhost, root,,,,;
296 SET @@lock_wait_timeout=1;
297 connection conn_u1;
298 SELECT COUNT(*) FROM mysql.global_grants WHERE user LIKE 'u1' FOR UPDATE;;
299 COUNT(*)
300 0
301 connection conn_root_1;
302 CREATE USER u2;
303 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
304 CREATE ROLE r1;
305 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
306 GRANT SELECT ON *.* TO r1;
307 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
308 GRANT r1 TO u2;
309 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
310 SET DEFAULT ROLE r1 TO u2;
311 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
312 ALTER USER u2 IDENTIFIED BY 'abcd';
313 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
314 RENAME USER u2 TO u3;
315 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
316 SET PASSWORD FOR u2 = 'abcd';
317 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
318 REVOKE r1 FROM u2;
319 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
320 REVOKE SELECT ON *.* FROM r1;
321 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
322 DROP ROLE r1;
323 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
324 DROP USER u2;
325 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
326 connection conn_u1;
327 ROLLBACK;
328 connection conn_root_1;
329 CREATE USER u2;
330 CREATE ROLE r1;
331 GRANT SELECT ON *.* TO r1;
332 GRANT r1 TO u2;
333 SET DEFAULT ROLE r1 TO u2;
334 ALTER USER u2 IDENTIFIED BY 'abcd';
335 RENAME USER u2 TO u3;
336 RENAME USER u3 TO u2;
337 SET PASSWORD FOR u2 = 'abcd';
338 REVOKE r1 FROM u2;
339 REVOKE SELECT ON *.* FROM r1;
340 DROP ROLE r1;
341 DROP USER u2;
342 connection default;
343 disconnect conn_root_1;
344 disconnect conn_u1;
345 DROP USER u1;
346 CREATE USER u1 IDENTIFIED BY 'abcd';
347 GRANT SELECT, UPDATE ON *.* TO u1;
348 connect conn_u1, localhost, u1, abcd,,,;
349 SET @@autocommit=0;
350 connect conn_root_1, localhost, root,,,,;
351 SET @@lock_wait_timeout=1;
352 connection conn_u1;
353 SELECT COUNT(*) FROM mysql.password_history WHERE user LIKE 'u1' FOR UPDATE;;
354 COUNT(*)
355 0
356 connection conn_root_1;
357 CREATE USER u2;
358 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
359 CREATE ROLE r1;
360 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
361 GRANT SELECT ON *.* TO r1;
362 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
363 GRANT r1 TO u2;
364 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
365 SET DEFAULT ROLE r1 TO u2;
366 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
367 ALTER USER u2 IDENTIFIED BY 'abcd';
368 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
369 RENAME USER u2 TO u3;
370 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
371 SET PASSWORD FOR u2 = 'abcd';
372 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
373 REVOKE r1 FROM u2;
374 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
375 REVOKE SELECT ON *.* FROM r1;
376 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
377 DROP ROLE r1;
378 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
379 DROP USER u2;
380 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
381 connection conn_u1;
382 ROLLBACK;
383 connection conn_root_1;
384 CREATE USER u2;
385 CREATE ROLE r1;
386 GRANT SELECT ON *.* TO r1;
387 GRANT r1 TO u2;
388 SET DEFAULT ROLE r1 TO u2;
389 ALTER USER u2 IDENTIFIED BY 'abcd';
390 RENAME USER u2 TO u3;
391 RENAME USER u3 TO u2;
392 SET PASSWORD FOR u2 = 'abcd';
393 REVOKE r1 FROM u2;
394 REVOKE SELECT ON *.* FROM r1;
395 DROP ROLE r1;
396 DROP USER u2;
397 connection default;
398 disconnect conn_root_1;
399 disconnect conn_u1;
400 DROP USER u1;
401 CREATE USER u1 IDENTIFIED BY 'abcd';
402 GRANT SELECT, UPDATE ON *.* TO u1;
403 connect conn_u1, localhost, u1, abcd,,,;
404 SET @@autocommit=0;
405 connect conn_root_1, localhost, root,,,,;
406 SET @@lock_wait_timeout=1;
407 connection conn_u1;
408 SELECT COUNT(*) FROM mysql.tables_priv WHERE user LIKE 'u1' FOR UPDATE;;
409 COUNT(*)
410 0
411 connection conn_root_1;
412 CREATE USER u2;
413 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
414 CREATE ROLE r1;
415 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
416 GRANT SELECT ON *.* TO r1;
417 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
418 GRANT r1 TO u2;
419 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
420 SET DEFAULT ROLE r1 TO u2;
421 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
422 ALTER USER u2 IDENTIFIED BY 'abcd';
423 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
424 RENAME USER u2 TO u3;
425 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
426 SET PASSWORD FOR u2 = 'abcd';
427 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
428 REVOKE r1 FROM u2;
429 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
430 REVOKE SELECT ON *.* FROM r1;
431 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
432 DROP ROLE r1;
433 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
434 DROP USER u2;
435 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
436 connection conn_u1;
437 ROLLBACK;
438 connection conn_root_1;
439 CREATE USER u2;
440 CREATE ROLE r1;
441 GRANT SELECT ON *.* TO r1;
442 GRANT r1 TO u2;
443 SET DEFAULT ROLE r1 TO u2;
444 ALTER USER u2 IDENTIFIED BY 'abcd';
445 RENAME USER u2 TO u3;
446 RENAME USER u3 TO u2;
447 SET PASSWORD FOR u2 = 'abcd';
448 REVOKE r1 FROM u2;
449 REVOKE SELECT ON *.* FROM r1;
450 DROP ROLE r1;
451 DROP USER u2;
452 connection default;
453 disconnect conn_root_1;
454 disconnect conn_u1;
455 DROP USER u1;
456 CREATE USER u1 IDENTIFIED BY 'abcd';
457 GRANT SELECT, UPDATE ON *.* TO u1;
458 connect conn_u1, localhost, u1, abcd,,,;
459 SET @@autocommit=0;
460 connect conn_root_1, localhost, root,,,,;
461 SET @@lock_wait_timeout=1;
462 connection conn_u1;
463 SELECT COUNT(*) FROM mysql.columns_priv WHERE user LIKE 'u1' FOR UPDATE;;
464 COUNT(*)
465 0
466 connection conn_root_1;
467 CREATE USER u2;
468 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
469 CREATE ROLE r1;
470 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
471 GRANT SELECT ON *.* TO r1;
472 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
473 GRANT r1 TO u2;
474 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
475 SET DEFAULT ROLE r1 TO u2;
476 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
477 ALTER USER u2 IDENTIFIED BY 'abcd';
478 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
479 RENAME USER u2 TO u3;
480 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
481 SET PASSWORD FOR u2 = 'abcd';
482 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
483 REVOKE r1 FROM u2;
484 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
485 REVOKE SELECT ON *.* FROM r1;
486 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
487 DROP ROLE r1;
488 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
489 DROP USER u2;
490 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
491 connection conn_u1;
492 ROLLBACK;
493 connection conn_root_1;
494 CREATE USER u2;
495 CREATE ROLE r1;
496 GRANT SELECT ON *.* TO r1;
497 GRANT r1 TO u2;
498 SET DEFAULT ROLE r1 TO u2;
499 ALTER USER u2 IDENTIFIED BY 'abcd';
500 RENAME USER u2 TO u3;
501 RENAME USER u3 TO u2;
502 SET PASSWORD FOR u2 = 'abcd';
503 REVOKE r1 FROM u2;
504 REVOKE SELECT ON *.* FROM r1;
505 DROP ROLE r1;
506 DROP USER u2;
507 connection default;
508 disconnect conn_root_1;
509 disconnect conn_u1;
510 DROP USER u1;
511 CREATE USER u1 IDENTIFIED BY 'abcd';
512 GRANT SELECT, UPDATE ON *.* TO u1;
513 connect conn_u1, localhost, u1, abcd,,,;
514 SET @@autocommit=0;
515 connect conn_root_1, localhost, root,,,,;
516 SET @@lock_wait_timeout=1;
517 connection conn_u1;
518 SELECT COUNT(*) FROM mysql.procs_priv WHERE user LIKE 'u1' FOR UPDATE;;
519 COUNT(*)
520 0
521 connection conn_root_1;
522 CREATE USER u2;
523 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
524 CREATE ROLE r1;
525 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
526 GRANT SELECT ON *.* TO r1;
527 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
528 GRANT r1 TO u2;
529 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
530 SET DEFAULT ROLE r1 TO u2;
531 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
532 ALTER USER u2 IDENTIFIED BY 'abcd';
533 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
534 RENAME USER u2 TO u3;
535 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
536 SET PASSWORD FOR u2 = 'abcd';
537 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
538 REVOKE r1 FROM u2;
539 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
540 REVOKE SELECT ON *.* FROM r1;
541 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
542 DROP ROLE r1;
543 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
544 DROP USER u2;
545 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
546 connection conn_u1;
547 ROLLBACK;
548 connection conn_root_1;
549 CREATE USER u2;
550 CREATE ROLE r1;
551 GRANT SELECT ON *.* TO r1;
552 GRANT r1 TO u2;
553 SET DEFAULT ROLE r1 TO u2;
554 ALTER USER u2 IDENTIFIED BY 'abcd';
555 RENAME USER u2 TO u3;
556 RENAME USER u3 TO u2;
557 SET PASSWORD FOR u2 = 'abcd';
558 REVOKE r1 FROM u2;
559 REVOKE SELECT ON *.* FROM r1;
560 DROP ROLE r1;
561 DROP USER u2;
562 connection default;
563 disconnect conn_root_1;
564 disconnect conn_u1;
565 DROP USER u1;
566 CREATE USER u1 IDENTIFIED BY 'abcd';
567 GRANT SELECT, UPDATE ON *.* TO u1;
568 connect conn_u1, localhost, u1, abcd,,,;
569 SET @@autocommit=0;
570 connect conn_root_1, localhost, root,,,,;
571 SET @@lock_wait_timeout=1;
572 connection conn_u1;
573 SELECT COUNT(*) FROM mysql.proxies_priv WHERE user LIKE 'u1' FOR UPDATE;;
574 COUNT(*)
575 0
576 connection conn_root_1;
577 CREATE USER u2;
578 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
579 CREATE ROLE r1;
580 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
581 GRANT SELECT ON *.* TO r1;
582 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
583 GRANT r1 TO u2;
584 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
585 SET DEFAULT ROLE r1 TO u2;
586 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
587 ALTER USER u2 IDENTIFIED BY 'abcd';
588 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
589 RENAME USER u2 TO u3;
590 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
591 SET PASSWORD FOR u2 = 'abcd';
592 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
593 REVOKE r1 FROM u2;
594 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
595 REVOKE SELECT ON *.* FROM r1;
596 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
597 DROP ROLE r1;
598 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
599 DROP USER u2;
600 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
601 connection conn_u1;
602 ROLLBACK;
603 connection conn_root_1;
604 CREATE USER u2;
605 CREATE ROLE r1;
606 GRANT SELECT ON *.* TO r1;
607 GRANT r1 TO u2;
608 SET DEFAULT ROLE r1 TO u2;
609 ALTER USER u2 IDENTIFIED BY 'abcd';
610 RENAME USER u2 TO u3;
611 RENAME USER u3 TO u2;
612 SET PASSWORD FOR u2 = 'abcd';
613 REVOKE r1 FROM u2;
614 REVOKE SELECT ON *.* FROM r1;
615 DROP ROLE r1;
616 DROP USER u2;
617 connection default;
618 disconnect conn_root_1;
619 disconnect conn_u1;
620 DROP USER u1;
621 # -----------------------------------------------------------------------
622 # Cleanup
623 # Restore initial values
624 SET @@global.transaction_isolation = @global_start_value;
625 SELECT @@global.transaction_isolation;
626 @@global.transaction_isolation
627 REPEATABLE-READ
628 SET @@session.transaction_isolation = @session_start_value;
629 SELECT @@session.transaction_isolation;
630 @@session.transaction_isolation
631 REPEATABLE-READ