summaryrefslogtreecommitdiff
path: root/mysql-test/suite/plugins/t/qc_info_init.inc
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/plugins/t/qc_info_init.inc')
-rw-r--r--mysql-test/suite/plugins/t/qc_info_init.inc12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/plugins/t/qc_info_init.inc b/mysql-test/suite/plugins/t/qc_info_init.inc
new file mode 100644
index 00000000000..9422bd7f141
--- /dev/null
+++ b/mysql-test/suite/plugins/t/qc_info_init.inc
@@ -0,0 +1,12 @@
+if (`select count(*) = 0 from information_schema.plugins where plugin_name = 'query_cache_info' and plugin_status='active'`)
+{
+ --skip QUERY_CACHE_INFO plugin is not active
+}
+
+set global query_cache_size=1355776;
+
+create table t1 (a int not null);
+insert into t1 values (1),(2),(3);
+select * from t1;
+select statement_schema, statement_text, result_blocks_count, result_blocks_size from information_schema.query_cache_info;
+