Debian Codegraph @

mysql-test/suite/rpl/r/rpl_query_cache.result

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