mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
17 lines
483 B
Text
17 lines
483 B
Text
set @save_query_cache_size=@@global.query_cache_size;
|
|
--source include/not_embedded.inc
|
|
--source qc_info_init.inc
|
|
|
|
# try an unprivileged user
|
|
create user mysqltest;
|
|
grant select on test.* to mysqltest;
|
|
connect (conn1,localhost,mysqltest,,);
|
|
connection conn1;
|
|
select a from t1;
|
|
select count(*) from information_schema.query_cache_info;
|
|
connection default;
|
|
drop user mysqltest;
|
|
drop table t1;
|
|
|
|
set @@global.query_cache_size=@save_query_cache_size;
|
|
set global query_cache_type=default;
|