mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
0a5e4a0191
Updated tests: cases with bugs or which cannot be run with the cursor-protocol were excluded with "--disable_cursor_protocol"/"--enable_cursor_protocol" Fix for v.10.5
30 lines
859 B
Text
30 lines
859 B
Text
set @save_query_cache_size=@@global.query_cache_size;
|
|
--source include/default_charset.inc
|
|
--source qc_info_init.inc
|
|
|
|
# test that hits are correctly incremented
|
|
reset query cache;
|
|
--disable_cursor_protocol
|
|
--disable_ps2_protocol
|
|
select * from t1;
|
|
select * from t1;
|
|
--enable_ps2_protocol
|
|
--enable_cursor_protocol
|
|
select hits, statement_text from information_schema.query_cache_info;
|
|
|
|
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;
|
|
|
|
set @@global.query_cache_size=@save_query_cache_size;
|