1-- source include/have_query_cache.inc 2# 3# Test of query cache with --lower-case-table-names 4# 5set @save_query_cache_size=@@query_cache_size; 6set GLOBAL query_cache_size=1355776; 7set GLOBAL query_cache_type=ON; 8set LOCAL query_cache_type=ON; 9 10--disable_warnings 11drop database if exists MySQLtesT; 12--enable_warnings 13 14create database MySQLtesT; 15create table MySQLtesT.t1 (a int); 16select * from MySQLtesT.t1; 17show status like "Qcache_queries_in_cache"; 18drop database mysqltest; 19show status like "Qcache_queries_in_cache"; 20 21use MySQL; 22disable_result_log; 23select * from db; 24enable_result_log; 25show status like "Qcache_queries_in_cache"; 26use test; 27disable_result_log; 28select * from MySQL.db; 29enable_result_log; 30show status like "Qcache_queries_in_cache"; 31 32set GLOBAL query_cache_size=@save_query_cache_size; 33set GLOBAL query_cache_type=default; 34 35# End of 4.1 tests 36