Debian Codegraph @

mysql-test/suite/perfschema/t/grant.test

raw
1 --source include/not_embedded.inc
2 --source include/have_perfschema.inc
3 #
4 # MDEV-22884 Assertion `grant_table || grant_table_role' failed on perfschema
5 #
6 create user a@localhost;
7 connect a,localhost,a;
8 select * from performance_schema.global_status where variable_name='b';
9 connection default;
10 disconnect a;
11 drop user a@localhost;
12
13 --echo #
14 --echo # MDEV-35384 Table performance_schema.session_status and other two tables are not shown in information_schema.tables for normal users
15 --echo #
16 create user foo@localhost;
17 connect foo,localhost,foo;
18 sorted_result;
19 select table_schema,engine from information_schema.tables where table_name='session_status';
20 select count(*) > 0 as 'table is readable' from performance_schema.session_status;
21 connection default;
22 disconnect foo;
23 drop user foo@localhost;
24
25 --echo # End of 10.6 tests