made variable query_cache_min_res_unit from QUERY_CACHE_MIN_RESULT_DATA_SIZE (SCRUM)

mysql-test/r/query_cache.result:
  test of query_cache_min_res_unit
mysql-test/t/query_cache.test:
  test of query_cache_min_res_unit
sql/mysql_priv.h:
  made variable query_cache_min_res_unit from QUERY_CACHE_MIN_RESULT_DATA_SIZE
sql/mysqld.cc:
  made variable query_cache_min_res_unit from QUERY_CACHE_MIN_RESULT_DATA_SIZE
sql/set_var.cc:
  made variable query_cache_min_res_unit from QUERY_CACHE_MIN_RESULT_DATA_SIZE
sql/sql_cache.cc:
  method for parameter changing
sql/sql_cache.h:
  method for parameter changing

1 files changed, 25 insertions, 0 deletions

diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test
index 47ea2d06d0a..f6e32a99523 100644
--- a/mysql-test/t/query_cache.test
+++ b/mysql-test/t/query_cache.test
@@ -343,6 +343,31 @@ drop table t1;
 show status like "Qcache_queries_in_cache";
 
 #
+# Test of min result data unit size changing
+#
+show global variables like "query_cache_min_res_unit";
+set GLOBAL query_cache_min_res_unit=1001;
+show global variables like "query_cache_min_res_unit";
+create table t1 (a int not null);
+insert into t1 values (1),(2),(3);
+create table t2 (a int not null);
+insert into t2 values (1),(2),(3);
+select * from t1;
+select * from t1;
+select * from t2;
+select * from t2;
+show status like "Qcache_hits";
+show status like "Qcache_queries_in_cache";
+drop table t1;
+select a from t2;
+select a from t2;
+show status like "Qcache_hits";
+show status like "Qcache_queries_in_cache";
+drop table t2;
+set GLOBAL query_cache_min_res_unit=default;
+show global variables like "query_cache_min_res_unit";
+
+#
 # Test of query cache resizing
 #
 set GLOBAL query_cache_size=1000;