Debian Codegraph @

mysql-test/suite/perfschema/r/grant.result

raw
1 create user a@localhost;
2 connect a,localhost,a;
3 select * from performance_schema.global_status where variable_name='b';
4 VARIABLE_NAME VARIABLE_VALUE
5 connection default;
6 disconnect a;
7 drop user a@localhost;
8 #
9 # MDEV-35384 Table performance_schema.session_status and other two tables are not shown in information_schema.tables for normal users
10 #
11 create user foo@localhost;
12 connect foo,localhost,foo;
13 select table_schema,engine from information_schema.tables where table_name='session_status';
14 table_schema engine
15 information_schema MEMORY
16 performance_schema PERFORMANCE_SCHEMA
17 select count(*) > 0 as 'table is readable' from performance_schema.session_status;
18 table is readable
19 1
20 connection default;
21 disconnect foo;
22 drop user foo@localhost;
23 # End of 10.6 tests