Edit File: lowercase_table_qcache.test
-- source include/have_query_cache.inc # # Test of query cache with --lower-case-table-names # set GLOBAL query_cache_size=1355776; --disable_warnings drop database if exists MySQLtesT; --enable_warnings create database MySQLtesT; create table MySQLtesT.t1 (a int); select * from MySQLtesT.t1; show status like "Qcache_queries_in_cache"; drop database mysqltest; show status like "Qcache_queries_in_cache"; use MySQL; disable_result_log; select * from db; enable_result_log; show status like "Qcache_queries_in_cache"; use test; disable_result_log; select * from MySQL.db; enable_result_log; show status like "Qcache_queries_in_cache"; set GLOBAL query_cache_size=0; # End of 4.1 tests
Back to File Manager