| 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; |