1193
1193
show status like 'Qcache_free_blocks';
1195
1195
--echo Restore default values.
1196
# Bug#28211 RENAME DATABASE and query cache don't play nicely together
1198
# TODO: enable these tests when RENAME DATABASE is implemented.
1199
# --disable_warnings
1200
# drop database if exists db1;
1201
# drop database if exists db2;
1203
# set GLOBAL query_cache_size=15*1024*1024;
1204
# create database db1;
1206
# create table t1(c1 int)engine=myisam;
1207
# insert into t1(c1) values (1);
1208
# select * from db1.t1 f;
1209
# show status like 'Qcache_queries_in_cache';
1210
# rename schema db1 to db2;
1211
# show status like 'Qcache_queries_in_cache';
1212
# drop database db2;
1213
# set global query_cache_size=default;
1215
# --disable_warnings
1216
# drop database if exists db1;
1217
# drop database if exists db3;
1219
# set GLOBAL query_cache_size=15*1024*1024;
1220
# create database db1;
1221
# create database db3;
1223
# create table t1(c1 int) engine=myisam;
1225
# create table t1(c1 int) engine=myisam;
1227
# insert into t1(c1) values (1);
1229
# select * from db1.t1;
1230
# select c1+1 from db1.t1;
1231
# select * from db3.t1;
1232
# show status like 'Qcache_queries_in_cache';
1233
# rename schema db1 to db2;
1234
# show status like 'Qcache_queries_in_cache';
1235
# drop database db2;
1236
# drop database db3;
1197
drop database if exists db1;
1198
drop database if exists db2;
1200
set GLOBAL query_cache_size=15*1024*1024;
1201
create database db1;
1203
create table t1(c1 int)engine=myisam;
1204
insert into t1(c1) values (1);
1205
select * from db1.t1 f;
1206
show status like 'Qcache_queries_in_cache';
1207
create database db2;
1208
rename table db1.t1 to db2.t2;
1210
show status like 'Qcache_queries_in_cache';
1212
set global query_cache_size=default;
1215
drop database if exists db1;
1216
drop database if exists db3;
1218
set GLOBAL query_cache_size=15*1024*1024;
1219
create database db1;
1220
create database db3;
1222
create table t1(c1 int) engine=myisam;
1224
create table t1(c1 int) engine=myisam;
1226
insert into t1(c1) values (1);
1228
select * from db1.t1;
1229
select c1+1 from db1.t1;
1230
select * from db3.t1;
1231
show status like 'Qcache_queries_in_cache';
1232
create database db2;
1233
rename table db1.t1 to db2.t2;
1235
show status like 'Qcache_queries_in_cache';
1238
1239
set GLOBAL query_cache_type=default;
1239
1240
set GLOBAL query_cache_limit=default;