Debian Codegraph @

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

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