Debian Codegraph @

mysql-test/suite/roles/flush_roles-17898.test

raw
1 source include/not_embedded.inc;
2 #
3 # MDEV-17898 FLUSH PRIVILEGES crashes server with segfault
4 #
5 use mysql;
6 insert db (db,user,select_priv) values ('foo','dwr_foo','Y'), ('bar','dwr_bar','Y');
7 insert roles_mapping (user,role) values ('dwr_qux_dev','dwr_foo'),('dwr_qux_dev','dwr_bar');
8 insert global_priv values ('','dwr_foo','{"is_role":true}'), ('','dwr_bar','{"is_role":true}'),
9 ('','dwr_qux_dev','{"access":16384,"is_role":true}');
10 flush privileges;
11 drop role dwr_foo;
12 drop role dwr_bar;
13 drop role dwr_qux_dev;
14 use test;
15
16 #
17 # MDEV-18298 Crashes server with segfault during role grants
18 #
19 create table db_copy as select * from mysql.db;
20 delete from mysql.db;
21 flush privileges;
22
23 create user u1@localhost;
24 create role r1;
25 create role r2;
26 grant r1 to u1@localhost;
27 grant select on test.* to r2;
28 grant select on m_.* to r2;
29 grant r2 to r1;
30 show grants for u1@localhost;
31 show grants for r1;
32 drop user u1@localhost;
33 drop role r1, r2;
34
35 insert mysql.db select * from db_copy;
36 flush privileges;
37 drop table db_copy;