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