Debian Codegraph @

mysql-test/suite/memcached/r/memc247_cache_policy.result

raw
1 SET @transaction_isolation= @@global.transaction_isolation;
2 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
3 INSERT INTO cache_policies VALUES("cache_policy", "cache_only",
4 "innodb_only", "innodb_only", "innodb_only");
5 INSERT INTO config_options VALUES("separator", "|");
6 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
7 "c1", "c2", "c3", "c4", "c5", "PRIMARY");
8 USE test;
9 CREATE TABLE t1 (c1 VARCHAR(32),
10 c2 VARCHAR(1024),
11 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
12 ENGINE = INNODB;
13 INSERT INTO t1 VALUES ('D', 'Darmstadt', 0, 0, 0);
14 INSERT INTO t1 VALUES ('B', 'Berlin', 0, 0, 0);
15 INSERT INTO t1 VALUES ('C', 'Cottbus', 0, 0 ,0);
16 INSERT INTO t1 VALUES ('H', 'Hamburg', 0, 0, 0);
17 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
18 Warnings:
19 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
20 SELECT c1,c2 FROM t1;
21 c1 c2
22 B Berlin
23 C Cottbus
24 D Darmstadt
25 H Hamburg
26 ----- Test get (cache_only) -----
27 Here are the memcached results with D,B,H,C:
28 SELECT c1,c2 FROM t1;
29 c1 c2
30 B Berlin
31 C Cottbus
32 D Darmstadt
33 H Hamburg
34 Here are the memcached results with B:
35 SELECT c1,c2 FROM t1;
36 c1 c2
37 B Berlin
38 C Cottbus
39 D Darmstadt
40 H Hamburg
41 Here are the memcached results with D,H:
42 UNINSTALL PLUGIN daemon_memcached;
43 use innodb_memcache;
44 DELETE FROM cache_policies;
45 INSERT INTO cache_policies VALUES("cache_policy", "caching",
46 "innodb_only", "innodb_only", "innodb_only");
47 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
48 Warnings:
49 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
50 ----- Test get (caching) -----
51 Here are the memcached results with D,B,H,C:
52 Darmstadt
53 Berlin
54 Hamburg
55 Cottbus
56 UNINSTALL PLUGIN daemon_memcached;
57 use innodb_memcache;
58 DELETE FROM cache_policies;
59 INSERT INTO cache_policies VALUES("cache_policy", "cache_only",
60 "cache_only", "innodb_only", "innodb_only");
61 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
62 Warnings:
63 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
64 ----- Test insert (cache_only) -----
65 Add E|Essen:
66 Ok.
67 use test;
68 SELECT c1,c2 FROM t1;
69 c1 c2
70 B Berlin
71 C Cottbus
72 D Darmstadt
73 H Hamburg
74 Here are the memcached results with E:
75 Essen
76 Set P|Paris:
77 Ok.
78 Here are the memcached results with P:
79 Paris
80 UNINSTALL PLUGIN daemon_memcached;
81 use innodb_memcache;
82 DELETE FROM cache_policies;
83 INSERT INTO cache_policies VALUES("cache_policy", "caching",
84 "caching", "innodb_only", "innodb_only");
85 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
86 Warnings:
87 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
88 ----- Test insert (caching) -----
89 Add G|Gossen:
90 Ok.
91 use test;
92 SELECT c1,c2 FROM t1;
93 c1 c2
94 B Berlin
95 C Cottbus
96 D Darmstadt
97 G Gossen
98 H Hamburg
99 Here are the memcached results with G:
100 Gossen
101 Delete G|Gossen:
102 Ok.
103 SELECT c1,c2 FROM test.t1;
104 c1 c2
105 B Berlin
106 C Cottbus
107 D Darmstadt
108 H Hamburg
109 Here are the memcached results with G:
110 Gossen
111 UNINSTALL PLUGIN daemon_memcached;
112 use innodb_memcache;
113 DELETE FROM cache_policies;
114 INSERT INTO cache_policies VALUES("cache_policy", "caching",
115 "caching", "cache_only", "innodb_only");
116 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
117 Warnings:
118 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
119 ----- Test delete (cache_only) -----
120 Delete G|Gossen:
121 Error: fail to delete.
122 use test;
123 SELECT c1,c2 FROM t1;
124 c1 c2
125 B Berlin
126 C Cottbus
127 D Darmstadt
128 H Hamburg
129 Here are the memcached results with G:
130 Delete E|Essen:
131 Error: E|Essen doesn't exist.
132 SELECT c1,c2 FROM test.t1;
133 c1 c2
134 B Berlin
135 C Cottbus
136 D Darmstadt
137 H Hamburg
138 Here are the memcached results with E:
139 UNINSTALL PLUGIN daemon_memcached;
140 use innodb_memcache;
141 DELETE FROM cache_policies;
142 INSERT INTO cache_policies VALUES("cache_policy", "caching",
143 "caching", "caching", "innodb_only");
144 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
145 Warnings:
146 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
147 ----- Test delete (caching) -----
148 add G|Gossen:
149 Ok.
150 use test;
151 SELECT c1,c2 FROM t1;
152 c1 c2
153 B Berlin
154 C Cottbus
155 D Darmstadt
156 G Gossen
157 H Hamburg
158 Here are the memcached results with G:
159 Gossen
160 Delete G|Gossen:
161 Ok.
162 SELECT c1,c2 FROM test.t1;
163 c1 c2
164 B Berlin
165 C Cottbus
166 D Darmstadt
167 H Hamburg
168 Here are the memcached results with G:
169 UNINSTALL PLUGIN daemon_memcached;
170 use innodb_memcache;
171 DELETE FROM cache_policies;
172 INSERT INTO cache_policies VALUES("cache_policy", "cache_only",
173 "caching", "cache_only", "cache_only");
174 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
175 Warnings:
176 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
177 ----- Test flush (cache_only) -----
178 add G|Gossen:
179 Ok.
180 use test;
181 SELECT c1,c2 FROM t1;
182 c1 c2
183 B Berlin
184 C Cottbus
185 D Darmstadt
186 G Gossen
187 H Hamburg
188 Here are the memcached results with G:
189 Gossen
190 SELECT c1,c2 FROM test.t1;
191 c1 c2
192 B Berlin
193 C Cottbus
194 D Darmstadt
195 G Gossen
196 H Hamburg
197 Here are the memcached results after flush_all:
198 SELECT c1,c2 FROM test.t1;
199 c1 c2
200 B Berlin
201 C Cottbus
202 D Darmstadt
203 G Gossen
204 H Hamburg
205 Here are the memcached results with G:
206 UNINSTALL PLUGIN daemon_memcached;
207 use innodb_memcache;
208 DELETE FROM cache_policies;
209 INSERT INTO cache_policies VALUES("cache_policy", "caching",
210 "caching", "caching", "caching");
211 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
212 Warnings:
213 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
214 ----- Test flush (cache_only) -----
215 add G|Gossen:
216 Error: fail to add.
217 use test;
218 SELECT c1,c2 FROM t1;
219 c1 c2
220 B Berlin
221 C Cottbus
222 D Darmstadt
223 G Gossen
224 H Hamburg
225 Here are the memcached results with G:
226 Gossen
227 SELECT c1,c2 FROM test.t1;
228 c1 c2
229 B Berlin
230 C Cottbus
231 D Darmstadt
232 G Gossen
233 H Hamburg
234 Here are the memcached results after flush_all:
235 SELECT c1,c2 FROM test.t1;
236 c1 c2
237 Here are the memcached results with G:
238 UNINSTALL PLUGIN daemon_memcached;
239 use innodb_memcache;
240 DELETE FROM cache_policies;
241 INSERT INTO cache_policies VALUES("cache_policy", "caching",
242 "disabled", "disabled", "disabled");
243 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
244 Warnings:
245 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
246 use test;
247 delete from t1;
248 INSERT INTO t1 VALUES ('D', 'Darmstadt', 0, 0, 0);
249 INSERT INTO t1 VALUES ('B', 'Berlin', 0, 0, 0);
250 INSERT INTO t1 VALUES ('C', 'Cottbus', 0, 0 ,0);
251 INSERT INTO t1 VALUES ('H', 'Hamburg', 0, 0, 0);
252 ----- Test all operations disabled -----
253 add G|Gossen:
254 Ok.
255 use test;
256 SELECT c1,c2 FROM t1;
257 c1 c2
258 B Berlin
259 C Cottbus
260 D Darmstadt
261 H Hamburg
262 Here are the memcached results with G:
263 SELECT c1,c2 FROM test.t1;
264 c1 c2
265 B Berlin
266 C Cottbus
267 D Darmstadt
268 H Hamburg
269 Here are the memcached results after flush_all:
270 SELECT c1,c2 FROM test.t1;
271 c1 c2
272 B Berlin
273 C Cottbus
274 D Darmstadt
275 H Hamburg
276 Here are the memcached results with G:
277 UNINSTALL PLUGIN daemon_memcached;
278 use innodb_memcache;
279 DELETE FROM cache_policies;
280 INSERT IGNORE INTO cache_policies VALUES("junk", "junk",
281 "caching", "cache_only", "disabled");
282 Warnings:
283 Warning 1265 Data truncated for column 'get_policy' at row 1
284 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
285 Warnings:
286 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
287 ----- Test with wrong policy name -----
288 add G|Gossen:
289 Ok.
290 use test;
291 SELECT c1,c2 FROM t1;
292 c1 c2
293 B Berlin
294 C Cottbus
295 D Darmstadt
296 G Gossen
297 H Hamburg
298 Here are the memcached results with G:
299 Gossen
300 SELECT c1,c2 FROM test.t1;
301 c1 c2
302 B Berlin
303 C Cottbus
304 D Darmstadt
305 G Gossen
306 H Hamburg
307 Here are the memcached results after flush_all (flush disabled):
308 Gossen
309 SELECT c1,c2 FROM test.t1;
310 c1 c2
311 B Berlin
312 C Cottbus
313 D Darmstadt
314 G Gossen
315 H Hamburg
316 Here are the memcached results with G:
317 Gossen
318 USE test;
319 DROP TABLE t1;
320 UNINSTALL PLUGIN daemon_memcached;
321 DROP DATABASE innodb_memcache;
322 SET @@global.transaction_isolation= @transaction_isolation;