Debian Codegraph @

mysql-test/suite/roles/ip-6401.test

raw
1 #
2 # MDEV-6401 SET ROLE returning ERROR 1959 Invalid role specification for valid role
3 #
4 --source include/not_embedded.inc
5 create role r1;
6 create user foo@'127.0.0.1';
7 grant r1 to foo@'127.0.0.1';
8
9 --connect (con1,127.0.0.1,foo,,)
10 show grants;
11 set role r1;
12 select * from information_schema.enabled_roles;
13
14 connection default;
15 drop user foo@'127.0.0.1';
16 drop role r1;