Debian Codegraph @

mysql-test/suite/information_schema/t/applicable_roles_debug.test

raw
1 --source include/have_debug.inc
2 --source include/have_debug_sync.inc
3 --source include/no_protocol.inc
4
5 --echo #
6 --echo # Make sure a warning is raised when acl cache lock acquire fails.
7 --echo #
8
9 CREATE USER u1 IDENTIFIED BY 'foo';
10 CREATE ROLE r1;
11 GRANT r1 to u1;
12 GRANT SELECT ON test.* TO u1;
13
14 SET GLOBAL DEBUG='+d,simulate_acl_cache_lock_failure';
15 connect(con1, localhost, u1, foo, test);
16 SET ROLE ALL;
17 SELECT * FROM INFORMATION_SCHEMA.ENABLED_ROLES;
18 connection default;
19 disconnect con1;
20
21 SET GLOBAL mandatory_roles = 'r1';
22 SELECT * FROM INFORMATION_SCHEMA.APPLICABLE_ROLES ORDER BY GRANTEE, ROLE_NAME;
23 SET GLOBAL mandatory_roles=default;
24 SET GLOBAL DEBUG=default;
25 DROP USER u1;
26 DROP ROLE r1;