Debian Codegraph @

mysql-test/suite/rpl/t/rpl_query_cache.test

raw
1 -- source include/have_binlog_format_row.inc
2 -- source include/have_innodb.inc
3 -- source include/master-slave.inc
4
5 --connection slave
6 SET @qtype= @@global.query_cache_type;
7 SET GLOBAL query_cache_type= ON;
8 SET query_cache_type= ON;
9
10 --connection master
11 create table t1 (i int) engine=innodb;
12 insert into t1 set i=1;
13
14 --sync_slave_with_master
15 select * from t1;
16 --connection master
17 insert into t1 set i=2;
18
19 --sync_slave_with_master
20 select * from t1;
21 select sql_no_cache * from t1;
22
23 --connection master
24 DROP TABLE t1;
25 --sync_slave_with_master
26 SET GLOBAL query_cache_type= @qtype;
27 --source include/rpl_end.inc