Debian Codegraph @

mysql-test/suite/memcached/r/memc277_default_table.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", "innodb_only",
4 "innodb_only", "innodb_only", "innodb_only");
5 INSERT INTO config_options VALUES("separator", "|");
6 INSERT INTO config_options VALUES("table_map_delimiter", ".");
7 INSERT INTO containers VALUES ("desct1", "test", "t1",
8 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
9 INSERT INTO containers VALUES ("desct2", "test", "t2",
10 "c1", "c2", "c3", "c4", "c5", "PRIMARY");
11 INSERT INTO containers VALUES ("default", "test", "t3",
12 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
13 INSERT INTO containers VALUES ("desct4", "test", "t4",
14 "c1", "c2,c21,c22", "c3", "c4", "c5", "PRIMARY");
15 INSERT INTO containers VALUES ("desct5", "test", "t5",
16 "c1", "c2,c21,c22,c23", "c3", "c4", "c5", "PRIMARY");
17 USE test;
18 DROP TABLE IF EXISTS t1,t2;
19 CREATE TABLE t1 (c1 VARCHAR(32),
20 c2 VARCHAR(1024),
21 c21 VARCHAR(1024),
22 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
23 ENGINE = INNODB;
24 CREATE TABLE t2 (c1 VARCHAR(32),
25 c2 VARCHAR(1024),
26 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
27 ENGINE = INNODB;
28 CREATE TABLE t3 (c1 VARCHAR(32),
29 c2 VARCHAR(1024),
30 c21 VARCHAR(1024),
31 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
32 ENGINE = INNODB;
33 CREATE TABLE t4 (c1 VARCHAR(32),
34 c2 VARCHAR(1024),
35 c21 VARCHAR(1024),
36 c22 VARCHAR(1024),
37 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
38 ENGINE = INNODB;
39 CREATE TABLE t5 (c1 VARCHAR(32),
40 c2 VARCHAR(1024),
41 c21 VARCHAR(1024),
42 c22 VARCHAR(1024),
43 c23 VARCHAR(1024),
44 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
45 ENGINE = INNODB;
46 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
47 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
48 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
49 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
50 INSERT INTO t2 VALUES ('D', 'Dortmund', 0, 0, 0);
51 INSERT INTO t2 VALUES ('B', 'Bremen', 0, 0, 0);
52 INSERT INTO t2 VALUES ('C', 'Celle', 0, 0 ,0);
53 INSERT INTO t2 VALUES ('H', 'Hannover', 0, 0, 0);
54 INSERT INTO t3 VALUES ('D', 'Detmold', 'City', 0, 0, 0);
55 INSERT INTO t3 VALUES ('B', 'Bonn', 'Mitte', 0, 0, 0);
56 INSERT INTO t3 VALUES ('A', 'Aachen', 'West', 0, 0 ,0);
57 INSERT INTO t3 VALUES ('H', 'Hameln', 'Nord', 0, 0, 0);
58 INSERT INTO t4 VALUES ('Z', 'Zossen', 'City', '12345', 0, 0, 0);
59 INSERT INTO t4 VALUES ('B', 'Brandenburg', 'Mitte', '23456', 0, 0, 0);
60 INSERT INTO t4 VALUES ('M', 'Muenchen', 'West', '34567', 0, 0 ,0);
61 INSERT INTO t4 VALUES ('H', 'Husum', 'Nord', '45678', 0, 0, 0);
62 INSERT INTO t5 VALUES ('D', 'Duesseldorf', 'City', '98765', 'Hafen', 0, 0, 0);
63 INSERT INTO t5 VALUES ('O', 'Oldenburg', 'Mitte', '87654', 'Deich', 0, 0, 0);
64 INSERT INTO t5 VALUES ('K', 'Koeln', 'West', '76543', 'Rhein', 0, 0 ,0);
65 INSERT INTO t5 VALUES ('S', 'Stuttgart', 'Nord', '65432', 'Fernsehturm', 0, 0, 0);
66 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
67 Warnings:
68 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
69 SELECT c1,c2,c21 FROM t1;
70 c1 c2 c21
71 B Berlin Mitte
72 C Cottbus West
73 D Darmstadt City
74 H Hamburg Norderstedt
75 SELECT c1,c2 FROM t2;
76 c1 c2
77 B Bremen
78 C Celle
79 D Dortmund
80 H Hannover
81 SELECT c1,c2,c21 FROM t3;
82 c1 c2 c21
83 A Aachen West
84 B Bonn Mitte
85 D Detmold City
86 H Hameln Nord
87 SELECT c1,c2,c21,c22 FROM t4;
88 c1 c2 c21 c22
89 B Brandenburg Mitte 23456
90 H Husum Nord 45678
91 M Muenchen West 34567
92 Z Zossen City 12345
93 SELECT c1,c2,c21,c22,c23 FROM t5;
94 c1 c2 c21 c22 c23
95 D Duesseldorf City 98765 Hafen
96 K Koeln West 76543 Rhein
97 O Oldenburg Mitte 87654 Deich
98 S Stuttgart Nord 65432 Fernsehturm
99 Here are the memcached results with D,B,A,H of default:
100 Detmold|City
101 Bonn|Mitte
102 Aachen|West
103 Hameln|Nord
104 Here are the memcached results with D,B,H,C of t1:
105 Darmstadt|City
106 Berlin|Mitte
107 Hamburg|Norderstedt
108 Cottbus|West
109 Here are the memcached results with D,B,H,C of t2:
110 Dortmund
111 Bremen
112 Hannover
113 Celle
114 Here are the memcached results with D,B,H,A of t3:
115 Here are the memcached results with D,O,K,S of t5:
116 Duesseldorf|City|98765|Hafen
117 Oldenburg|Mitte|87654|Deich
118 Koeln|West|76543|Rhein
119 Stuttgart|Nord|65432|Fernsehturm
120 Here are the memcached results with Z,B,H,M of t4:
121 Zossen|City|12345
122 Brandenburg|Mitte|23456
123 Husum|Nord|45678
124 Muenchen|West|34567
125 Here are the memcached results with D,B,H,C of t2:
126 Dortmund
127 Bremen
128 Hannover
129 Celle
130 SELECT c1,c2,c21 FROM t1;
131 c1 c2 c21
132 B Berlin Mitte
133 C Cottbus West
134 D Darmstadt City
135 H Hamburg Norderstedt
136 SELECT c1,c2 FROM t2;
137 c1 c2
138 B Bremen
139 C Celle
140 D Dortmund
141 H Hannover
142 SELECT c1,c2,c21 FROM t3;
143 c1 c2 c21
144 A Aachen West
145 B Bonn Mitte
146 D Detmold City
147 H Hameln Nord
148 SELECT c1,c2,c21,c22 FROM t4;
149 c1 c2 c21 c22
150 B Brandenburg Mitte 23456
151 H Husum Nord 45678
152 M Muenchen West 34567
153 Z Zossen City 12345
154 SELECT c1,c2,c21,c22,c23 FROM t5;
155 c1 c2 c21 c22 c23
156 D Duesseldorf City 98765 Hafen
157 K Koeln West 76543 Rhein
158 O Oldenburg Mitte 87654 Deich
159 S Stuttgart Nord 65432 Fernsehturm
160 Here are the memcached results after set in default:
161 Essen|Ost
162 Here are the memcached results after set in t2:
163 Essen
164 Here are the memcached results after set in t5:
165 Essen|Mitte|111111|Mahlzeit
166 Here are the memcached results after set in t3:
167 Essen|Mitte|111111|Mahlzeit
168 Here are the memcached results after set in t4:
169 Essen|Mitte|111111
170 Here are the memcached results after set in t5:
171 Essen|Aussen|111111|Mahlzeit
172 SELECT c1,c2,c21 FROM t1;
173 c1 c2 c21
174 B Berlin Mitte
175 C Cottbus West
176 D Darmstadt City
177 H Hamburg Norderstedt
178 SELECT c1,c2 FROM t2;
179 c1 c2
180 B Bremen
181 C Celle
182 D Dortmund
183 E Essen
184 H Hannover
185 SELECT c1,c2,c21 FROM t3;
186 c1 c2 c21
187 A Aachen West
188 B Bonn Mitte
189 D Detmold City
190 E Essen Ost
191 H Hameln Nord
192 SELECT c1,c2,c21,c22 FROM t4;
193 c1 c2 c21 c22
194 B Brandenburg Mitte 23456
195 E Essen Mitte 111111
196 H Husum Nord 45678
197 M Muenchen West 34567
198 Z Zossen City 12345
199 SELECT c1,c2,c21,c22,c23 FROM t5;
200 c1 c2 c21 c22 c23
201 D Duesseldorf City 98765 Hafen
202 E Essen Aussen 111111 Mahlzeit
203 K Koeln West 76543 Rhein
204 O Oldenburg Mitte 87654 Deich
205 S Stuttgart Nord 65432 Fernsehturm
206 UNINSTALL PLUGIN daemon_memcached;
207 UPDATE innodb_memcache.containers SET name='desct3' WHERE name='default';
208 UPDATE innodb_memcache.containers SET name='default' WHERE name='desct4';
209 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
210 Warnings:
211 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
212 SELECT c1,c2,c21 FROM t1;
213 c1 c2 c21
214 B Berlin Mitte
215 C Cottbus West
216 D Darmstadt City
217 H Hamburg Norderstedt
218 SELECT c1,c2 FROM t2;
219 c1 c2
220 B Bremen
221 C Celle
222 D Dortmund
223 E Essen
224 H Hannover
225 SELECT c1,c2,c21 FROM t3;
226 c1 c2 c21
227 A Aachen West
228 B Bonn Mitte
229 D Detmold City
230 E Essen Ost
231 H Hameln Nord
232 SELECT c1,c2,c21,c22 FROM t4;
233 c1 c2 c21 c22
234 B Brandenburg Mitte 23456
235 E Essen Mitte 111111
236 H Husum Nord 45678
237 M Muenchen West 34567
238 Z Zossen City 12345
239 SELECT c1,c2,c21,c22,c23 FROM t5;
240 c1 c2 c21 c22 c23
241 D Duesseldorf City 98765 Hafen
242 E Essen Aussen 111111 Mahlzeit
243 K Koeln West 76543 Rhein
244 O Oldenburg Mitte 87654 Deich
245 S Stuttgart Nord 65432 Fernsehturm
246 Here are the memcached results after set in default:
247 Essen|Ausserhalb|222222
248 Here are the memcached results after set in t5:
249 Essen|Bahnhof|222222|Gut
250 Here are the memcached results after set in t3:
251 Essen|West
252 SELECT c1,c2,c21 FROM t1;
253 c1 c2 c21
254 B Berlin Mitte
255 C Cottbus West
256 D Darmstadt City
257 H Hamburg Norderstedt
258 SELECT c1,c2,c21 FROM t3;
259 c1 c2 c21
260 A Aachen West
261 B Bonn Mitte
262 D Detmold City
263 E Essen West
264 H Hameln Nord
265 SELECT c1,c2,c21,c22 FROM t4;
266 c1 c2 c21 c22
267 B Brandenburg Mitte 23456
268 E Essen Ausserhalb 222222
269 H Husum Nord 45678
270 M Muenchen West 34567
271 Z Zossen City 12345
272 SELECT c1,c2,c21,c22,c23 FROM t5;
273 c1 c2 c21 c22 c23
274 D Duesseldorf City 98765 Hafen
275 E Essen Bahnhof 222222 Gut
276 K Koeln West 76543 Rhein
277 O Oldenburg Mitte 87654 Deich
278 S Stuttgart Nord 65432 Fernsehturm
279 UNINSTALL PLUGIN daemon_memcached;
280 UPDATE innodb_memcache.containers SET name='default' WHERE name='desct3';
281 ERROR 23000: Duplicate entry 'default' for key 'containers.PRIMARY'
282 DELETE FROM innodb_memcache.containers WHERE name='default';
283 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
284 Warnings:
285 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
286 SELECT c1,c2,c21 FROM t1;
287 c1 c2 c21
288 B Berlin Mitte
289 C Cottbus West
290 D Darmstadt City
291 H Hamburg Norderstedt
292 SELECT c1,c2 FROM t2;
293 c1 c2
294 B Bremen
295 C Celle
296 D Dortmund
297 E Essen
298 H Hannover
299 SELECT c1,c2,c21 FROM t3;
300 c1 c2 c21
301 A Aachen West
302 B Bonn Mitte
303 D Detmold City
304 E Essen West
305 H Hameln Nord
306 SELECT c1,c2,c21,c22 FROM t4;
307 c1 c2 c21 c22
308 B Brandenburg Mitte 23456
309 E Essen Ausserhalb 222222
310 H Husum Nord 45678
311 M Muenchen West 34567
312 Z Zossen City 12345
313 SELECT c1,c2,c21,c22,c23 FROM t5;
314 c1 c2 c21 c22 c23
315 D Duesseldorf City 98765 Hafen
316 E Essen Bahnhof 222222 Gut
317 K Koeln West 76543 Rhein
318 O Oldenburg Mitte 87654 Deich
319 S Stuttgart Nord 65432 Fernsehturm
320 Here are the memcached results after set in default:
321 Essen|Nord
322 Here are the memcached results after set in t4:
323 Essen|Nord
324 SELECT c1,c2,c21 FROM t1;
325 c1 c2 c21
326 B Berlin Mitte
327 C Cottbus West
328 D Darmstadt City
329 E Essen Nord
330 H Hamburg Norderstedt
331 SELECT c1,c2,c21 FROM t3;
332 c1 c2 c21
333 A Aachen West
334 B Bonn Mitte
335 D Detmold City
336 E Essen West
337 H Hameln Nord
338 SELECT c1,c2,c21,c22 FROM t4;
339 c1 c2 c21 c22
340 B Brandenburg Mitte 23456
341 E Essen Ausserhalb 222222
342 H Husum Nord 45678
343 M Muenchen West 34567
344 Z Zossen City 12345
345 UNINSTALL PLUGIN daemon_memcached;
346 DELETE FROM innodb_memcache.containers WHERE name='desct1';
347 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
348 Warnings:
349 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
350 SELECT c1,c2,c21 FROM t1;
351 c1 c2 c21
352 B Berlin Mitte
353 C Cottbus West
354 D Darmstadt City
355 E Essen Nord
356 H Hamburg Norderstedt
357 SELECT c1,c2 FROM t2;
358 c1 c2
359 B Bremen
360 C Celle
361 D Dortmund
362 E Essen
363 H Hannover
364 SELECT c1,c2,c21 FROM t3;
365 c1 c2 c21
366 A Aachen West
367 B Bonn Mitte
368 D Detmold City
369 E Essen West
370 H Hameln Nord
371 SELECT c1,c2,c21,c22 FROM t4;
372 c1 c2 c21 c22
373 B Brandenburg Mitte 23456
374 E Essen Ausserhalb 222222
375 H Husum Nord 45678
376 M Muenchen West 34567
377 Z Zossen City 12345
378 SELECT c1,c2,c21,c22,c23 FROM t5;
379 c1 c2 c21 c22 c23
380 D Duesseldorf City 98765 Hafen
381 E Essen Bahnhof 222222 Gut
382 K Koeln West 76543 Rhein
383 O Oldenburg Mitte 87654 Deich
384 S Stuttgart Nord 65432 Fernsehturm
385 Here are the memcached results after set in default:
386 Emden
387 Here are the memcached results after set in t1:
388 Emden
389 SELECT c1,c2,c21 FROM t1;
390 c1 c2 c21
391 B Berlin Mitte
392 C Cottbus West
393 D Darmstadt City
394 E Essen Nord
395 H Hamburg Norderstedt
396 SELECT c1,c2 FROM t2;
397 c1 c2
398 B Bremen
399 C Celle
400 D Dortmund
401 E Emden
402 H Hannover
403 DROP TABLE t1,t2,t3,t4,t5;
404 UNINSTALL PLUGIN daemon_memcached;
405 DROP DATABASE innodb_memcache;
406 SET @@global.transaction_isolation= @transaction_isolation;