Debian Codegraph @

mysql-test/suite/memcached/t/memc272_2_tables.test

raw
1 source include/not_valgrind.inc;
2 source include/have_memcached_plugin.inc;
3 source include/not_windows.inc;
4
5 --disable_query_log
6 CALL mtr.add_suppression("daemon-memcached-w-batch-size': unsigned");
7 CALL mtr.add_suppression("Could not obtain server's UPN to be used as target service name");
8 CALL mtr.add_suppression("Warning: MySQL is trying to drop");
9 --enable_query_log
10
11 --enable_connect_log
12 SET @transaction_isolation= @@global.transaction_isolation;
13 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
14
15 # Create the memcached tables
16 --disable_query_log
17 source include/memcache_config.inc;
18 --enable_query_log
19
20 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
21 "innodb_only", "innodb_only", "innodb_only");
22
23 INSERT INTO config_options VALUES("separator", "|");
24 INSERT INTO config_options VALUES("table_map_delimiter", ".");
25
26 # describe table for memcache
27 INSERT INTO containers VALUES ("desct1", "test", "t1",
28 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
29 INSERT INTO containers VALUES ("desct2", "test", "t2",
30 "c1", "c2", "c3", "c4", "c5", "PRIMARY");
31
32 USE test;
33
34 --disable_warnings
35 DROP TABLE IF EXISTS t1,t2;
36 --enable_warnings
37 CREATE TABLE t1 (c1 VARCHAR(32),
38 c2 VARCHAR(1024),
39 c21 VARCHAR(1024),
40 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
41 ENGINE = INNODB;
42
43 CREATE TABLE t2 (c1 VARCHAR(32),
44 c2 VARCHAR(1024),
45 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
46 ENGINE = INNODB;
47
48 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
49 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
50 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
51 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
52
53 INSERT INTO t2 VALUES ('D', 'Dortmund', 0, 0, 0);
54 INSERT INTO t2 VALUES ('B', 'Bremen', 0, 0, 0);
55 INSERT INTO t2 VALUES ('C', 'Celle', 0, 0 ,0);
56 INSERT INTO t2 VALUES ('H', 'Hannover', 0, 0, 0);
57
58 # Tables must exist before plugin can be started!
59 --let $memcached_address=127.0.0.1:11272
60 --source ../include/load_daemon_memcached_expecting_success.inc
61
62 --sorted_result
63 SELECT c1,c2,c21 FROM t1;
64 --sorted_result
65 SELECT c1,c2 FROM t2;
66
67 perl;
68 use DBI;
69 use Cache::Memcached;
70 my $memd = new Cache::Memcached {
71 'servers' => [ "127.0.0.1:11272" ],
72 'connect_timeout' => 20,
73 'select_timeout' => 20
74 };
75 print "Here are the memcached results with D,B,H,C of default:\n";
76 $val = $memd->get("D");
77 if ($val) { print "$val\n"; }
78 $val = $memd->get("B");
79 if ($val) { print "$val\n"; }
80 $val = $memd->get("H");
81 if ($val) { print "$val\n"; }
82 $val = $memd->get("C");
83 if ($val) { print "$val\n"; }
84 $memd->disconnect_all;
85 EOF
86
87 perl;
88 use DBI;
89 use Cache::Memcached;
90 my $memd = new Cache::Memcached {
91 'servers' => [ "127.0.0.1:11272" ],
92 'connect_timeout' => 20,
93 'select_timeout' => 20
94 };
95 print "Here are the memcached results with D,B,H,C of t2:\n";
96 $val = $memd->get("\@\@desct2.D");
97 if ($val) { print "$val\n"; }
98 $val = $memd->get("\@\@desct2.B");
99 if ($val) { print "$val\n"; }
100 $val = $memd->get('@@desct2.H');
101 if ($val) { print "$val\n"; }
102 $val = $memd->get('@@desct2.C');
103 $memd->disconnect_all;
104 EOF
105
106 --sorted_result
107 SELECT c1,c2,c21 FROM t1;
108 --sorted_result
109 SELECT c1,c2 FROM t2;
110
111 perl;
112 use DBI;
113 use Cache::Memcached;
114 my $memd = new Cache::Memcached {
115 'servers' => [ "127.0.0.1:11272" ],
116 'connect_timeout' => 20,
117 'select_timeout' => 20
118 };
119 print "Here are the memcached results after set in default:\n";
120 $val = $memd->set("E","Essen|Ost");
121 $val = $memd->get("E");
122 if ($val) { print "$val\n"; }
123 print "Here are the memcached results after set in t2:\n";
124 $val = $memd->set("\@\@desct2.E","Essen");
125 $val = $memd->get("\@\@desct2.E");
126 if ($val) { print "$val\n"; }
127 $memd->disconnect_all;
128 EOF
129
130 --sorted_result
131 SELECT c1,c2,c21 FROM t1;
132 --sorted_result
133 SELECT c1,c2 FROM t2;
134
135 perl;
136 use DBI;
137 use Cache::Memcached;
138 my $memd = new Cache::Memcached {
139 'servers' => [ "127.0.0.1:11272" ],
140 'connect_timeout' => 20,
141 'select_timeout' => 20
142 };
143 print "Here are the memcached results after add:\n";
144 $val = $memd->add("F","Frankfurt|Sachsenhause");
145 $val = $memd->get("F");
146 if ($val) { print "$val\n"; }
147 print "Here are the memcached results after add in t2:\n";
148 $val = $memd->add("\@\@desc2.F","Frankfurt");
149 $val = $memd->get("\@\@desc2.F");
150 if ($val) { print "$val\n"; }
151 $memd->disconnect_all;
152 EOF
153
154 --sorted_result
155 SELECT c1,c2,c21 FROM t1;
156 --sorted_result
157 SELECT c1,c2 FROM t2;
158
159 perl;
160 use DBI;
161 use Cache::Memcached;
162 my $memd = new Cache::Memcached {
163 'servers' => [ "127.0.0.1:11272" ],
164 'connect_timeout' => 20,
165 'select_timeout' => 20
166 };
167 print "Here are the memcached results after replace:\n";
168 $val = $memd->replace("F","Frankfurt a. M.|Sachsenhausen");
169 $val = $memd->get("F");
170 if ($val) { print "$val\n"; }
171 print "Here are the memcached results after replace in t2:\n";
172 $val = $memd->replace("\@\@desc2.F","Frankfurt a. M.");
173 $val = $memd->get("\@\@desc2.F");
174 if ($val) { print "$val\n"; }
175 $memd->disconnect_all;
176 EOF
177
178 --sorted_result
179 SELECT c1,c2,c21 FROM t1;
180 --sorted_result
181 SELECT c1,c2 FROM t2;
182
183 perl;
184 use DBI;
185 use Cache::Memcached;
186 my $memd = new Cache::Memcached {
187 'servers' => [ "127.0.0.1:11272" ],
188 'connect_timeout' => 20,
189 'select_timeout' => 20
190 };
191 print "Here are the memcached results after delete:\n";
192 $val = $memd->delete("F");
193 $val = $memd->get("F");
194 if ($val) { print "$val\n"; }
195 print "Here are the memcached results after delete in t2:\n";
196 $val = $memd->delete("\@\@desc2.F");
197 $val = $memd->get("\@\@desc2.F");
198 if ($val) { print "$val\n"; }
199 $memd->disconnect_all;
200 EOF
201
202 --sorted_result
203 SELECT c1,c2,c21 FROM t1;
204 --sorted_result
205 SELECT c1,c2 FROM t2;
206
207 perl;
208 use DBI;
209 use Cache::Memcached;
210 my $memd = new Cache::Memcached {
211 'servers' => [ "127.0.0.1:11272" ],
212 'connect_timeout' => 20,
213 'select_timeout' => 20
214 };
215 print "Here are the memcached results after add Frankfurt|:\n";
216 $val = $memd->add("F","Frankfurt|");
217 $val = $memd->get("F");
218 if ($val) { print "$val\n"; }
219 print "Here are the memcached results after add |Airport:\n";
220 $val = $memd->add("F","|");
221 $val = $memd->get("F");
222 if ($val) { print "$val\n"; }
223 $memd->disconnect_all;
224 EOF
225
226 --sorted_result
227 SELECT c1,c2,c21 FROM t1;
228 --sorted_result
229 SELECT c1,c2 FROM t2;
230
231 perl;
232 use DBI;
233 use Cache::Memcached;
234 my $memd = new Cache::Memcached {
235 'servers' => [ "127.0.0.1:11272" ],
236 'connect_timeout' => 20,
237 'select_timeout' => 20
238 };
239 print "Here are the memcached results after replace Frankfurt a.M.:\n";
240 $val = $memd->replace("F","Frankfurt a. M.|");
241 $val = $memd->get("F");
242 if ($val) { print "$val\n"; }
243 print "Here are the memcached results after replace Sachsenhausen:\n";
244 $val = $memd->replace("F","|Sachsenhausen");
245 $val = $memd->get("F");
246 if ($val) { print "$val\n"; }
247 $memd->disconnect_all;
248 EOF
249
250 --sorted_result
251 SELECT c1,c2,c21 FROM t1;
252 --sorted_result
253 SELECT c1,c2 FROM t2;
254
255 SET sql_mode='NO_ENGINE_SUBSTITUTION';
256 ALTER TABLE t1 MODIFY c2 int;
257 SET sql_mode=default;
258
259 --sorted_result
260 SELECT c1,c2,c21 FROM t1;
261
262 perl;
263 use DBI;
264 use Cache::Memcached;
265 my $memd = new Cache::Memcached {
266 'servers' => [ "127.0.0.1:11272" ],
267 'connect_timeout' => 20,
268 'select_timeout' => 20
269 };
270 print "Here are the memcached results after add Frankfurt|:\n";
271 $val = $memd->add("F","Frankfurt|");
272 $val = $memd->get("F");
273 if ($val) { print "$val\n"; }
274 print "Here are the memcached results after add |Airport:\n";
275 $val = $memd->add("F","|");
276 $val = $memd->get("F");
277 if ($val) { print "$val\n"; }
278 $memd->disconnect_all;
279 EOF
280
281 --sorted_result
282 SELECT c1,c2,c21 FROM t1;
283
284 perl;
285 use DBI;
286 use Cache::Memcached;
287 my $memd = new Cache::Memcached {
288 'servers' => [ "127.0.0.1:11272" ],
289 'connect_timeout' => 20,
290 'select_timeout' => 20
291 };
292 print "Here are the memcached results after flush_all:\n";
293 $memd->flush_all;
294 $val = $memd->get("F");
295 if ($val) { print "$val\n"; }
296 $memd->disconnect_all;
297 EOF
298
299 --sorted_result
300 SELECT c1,c2,c21 FROM t1;
301
302 DROP TABLE t1,t2;
303
304 UNINSTALL PLUGIN daemon_memcached;
305 DROP DATABASE innodb_memcache;
306
307 SET @@global.transaction_isolation= @transaction_isolation;