Debian Codegraph @

mysql-test/suite/plugins/t/qc_info_priv.test

raw
1 set @save_query_cache_size=@@global.query_cache_size;
2 --source include/not_embedded.inc
3 --source qc_info_init.inc
4
5 # try an unprivileged user
6 create user mysqltest;
7 grant select on test.* to mysqltest;
8 connect (conn1,localhost,mysqltest,,);
9 connection conn1;
10 select a from t1;
11 select count(*) from information_schema.query_cache_info;
12 connection default;
13 drop user mysqltest;
14 drop table t1;
15
16 set @@global.query_cache_size=@save_query_cache_size;
17 set global query_cache_type=default;