mariadb/mysql-test/suite/plugins/t/qc_info.test

17 lines
449 B
Text

--source qc_info_init.inc
drop table t1;
# the query was invalidated
select statement_schema, statement_text, result_blocks_count, result_blocks_size from information_schema.query_cache_info;
set global query_cache_size = 0;
select * from information_schema.query_cache_info;
set global query_cache_size= default;
set global query_cache_type=default;
--error ER_PARSE_ERROR
show query_cache_info;
--error ER_PARSE_ERROR
flush query_cache_info;