Debian Codegraph @

mysql-test/suite/memcached/t/memc276_1_table.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 ("desct11", "test", "t1",
28 "c1", "c2,c21,c22,c23,c24,c25,c26,c27", "c3", "c4", "c5",
29 "PRIMARY");
30 INSERT INTO containers VALUES ("desct12", "test", "t1",
31 "c2", "c1, c2", "c3", "c4", "c5", "i12");
32 INSERT INTO containers VALUES ("desct13", "test", "t1",
33 "c2", "c1,c21", "c3", "c4", "c5", "i12");
34 INSERT INTO containers VALUES ("desct14", "test", "t1",
35 "c21", "c1,c23,c22", "c3", "c4", "c5", "i14");
36 INSERT INTO containers VALUES ("desct15", "test", "t1",
37 "c23", "c1,c21,c22,c24", "c3", "c4", "c5", "i15");
38 INSERT INTO containers VALUES ("desct16", "test", "t1",
39 "c25", "c23,c24,c27,c1", "c3", "c4", "c5", "i16");
40 INSERT INTO containers VALUES ("desct17", "test", "t1",
41 "c26", "c2, c1", "c3", "c4", "c5", "i17");
42
43 USE test;
44
45 --disable_warnings
46 DROP TABLE IF EXISTS t1,t2;
47 --enable_warnings
48 CREATE TABLE t1 (c1 VARCHAR(32),
49 c2 VARCHAR(512),
50 c21 VARCHAR(767),
51 c22 VARCHAR(512),
52 c23 VARCHAR(128),
53 c24 VARCHAR(24),
54 c25 VARCHAR(512),
55 c26 VARCHAR(128),
56 c27 VARCHAR(128),
57 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
58 ENGINE = INNODB;
59
60 INSERT INTO t1 VALUES ('D','Duesseldorf','City','98765','Hafen','1','A','a','Z',0,0,0);
61 INSERT INTO t1 VALUES ('O','Oldenburg','Mitte','87654','Deich','2','B','b','Y',0,0,0);
62 INSERT INTO t1 VALUES ('K','Koeln','West','76543','Rhein','3','C','c','X',0,0,0);
63 INSERT INTO t1 VALUES ('S','Stuttgart','Nord','65432','Fernsehturm','4','D','d','U',0,0,0);
64
65 CREATE UNIQUE INDEX i12 ON t1(c2);
66 CREATE UNIQUE INDEX i14 ON t1(c21);
67 CREATE UNIQUE INDEX i15 ON t1(c23);
68 CREATE UNIQUE INDEX i16 ON t1(c25);
69 CREATE UNIQUE INDEX i17 ON t1(c26);
70
71 # Tables must exist before plugin can be started!
72 --let $memcached_address=127.0.0.1:11276
73 --source ../include/load_daemon_memcached_expecting_success.inc
74
75 --sorted_result
76 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
77
78 perl;
79 use DBI;
80 use Cache::Memcached;
81 my $memd = new Cache::Memcached {
82 'servers' => [ "127.0.0.1:11276" ],
83 'connect_timeout' => 20,
84 'select_timeout' => 20
85 };
86 print "Here are the memcached results with D,O,K,S of default:\n";
87 $val = $memd->get("D");
88 if ($val) { print "$val\n"; }
89 $val = $memd->get("O");
90 if ($val) { print "$val\n"; }
91 $val = $memd->get("K");
92 if ($val) { print "$val\n"; }
93 $val = $memd->get("S");
94 if ($val) { print "$val\n"; }
95 $memd->disconnect_all;
96 EOF
97
98 perl;
99 use DBI;
100 use Cache::Memcached;
101 my $memd = new Cache::Memcached {
102 'servers' => [ "127.0.0.1:11276" ],
103 'connect_timeout' => 20,
104 'select_timeout' => 20
105 };
106 print "Here are the memcached results with c1 of desct11:\n";
107 $val = $memd->get('@@desct11.D');
108 if ($val) { print "$val\n"; }
109 $val = $memd->get("\@\@desct11.O");
110 if ($val) { print "$val\n"; }
111 $val = $memd->get('@@desct11.'.'K');
112 if ($val) { print "$val\n"; }
113 $val = $memd->get('@@desct11.S');
114 if ($val) { print "$val\n"; }
115 print "Here are the memcached results with c2 of desct13:\n";
116 $val = $memd->get('@@desct13');
117 print "$val\n";
118 $val = $memd->get('Duesseldorf');
119 if ($val) { print "$val\n"; }
120 $val = $memd->get("Oldenburg");
121 if ($val) { print "$val\n"; }
122 $val = $memd->get('Koeln');
123 if ($val) { print "$val\n"; }
124 $val = $memd->get('Stuttgart');
125 if ($val) { print "$val\n"; }
126 print "Here are the memcached results with c2 of desct12:\n";
127 $val = $memd->get('@@desct12');
128 print "$val\n";
129 $val = $memd->get('Duesseldorf');
130 if ($val) { print "$val\n"; }
131 $val = $memd->get("Oldenburg");
132 if ($val) { print "$val\n"; }
133 $val = $memd->get('@@desct12.Koeln');
134 if ($val) { print "$val\n"; }
135 $val = $memd->get('Stuttgart');
136 if ($val) { print "$val\n"; }
137 print "Here are the memcached results with c2,c21,c22 of desct14:\n";
138 $val = $memd->get('@@desct14.City');
139 if ($val) { print "$val\n"; }
140 $val = $memd->get("\@\@desct14.Mitte");
141 if ($val) { print "$val\n"; }
142 $val = $memd->get('@@desct14.West');
143 if ($val) { print "$val\n"; }
144 $val = $memd->get('@@desct14.Nord');
145 if ($val) { print "$val\n"; }
146 print "Here are the memcached results with c2,c21,c22,c23 of desct15:\n";
147 $val = $memd->get('@@desct15.Hafen');
148 if ($val) { print "$val\n"; }
149 $val = $memd->get("\@\@desct15.Deich");
150 if ($val) { print "$val\n"; }
151 $val = $memd->get('@@desct15.Rhein');
152 if ($val) { print "$val\n"; }
153 $val = $memd->get('@@desct15.Fernsehturm');
154 if ($val) { print "$val\n"; }
155 print "Here are the memcached results with c23,c24,c25,c26 of desct16:\n";
156 $val = $memd->get('@@desct16.A');
157 if ($val) { print "$val\n"; }
158 $val = $memd->get("\@\@desct16.C");
159 if ($val) { print "$val\n"; }
160 $val = $memd->get('@@desct16.D');
161 if ($val) { print "$val\n"; }
162 $val = $memd->get('@@desct16.B');
163 if ($val) { print "$val\n"; }
164 print "Here are the memcached results with c26 of desct17:\n";
165 $val = $memd->get('@@desct17.c');
166 if ($val) { print "$val\n"; }
167 $val = $memd->get("\@\@desct17.b");
168 if ($val) { print "$val\n"; }
169 $val = $memd->get('@@desct17.a');
170 if ($val) { print "$val\n"; }
171 $val = $memd->get('@@desct17.d');
172 if ($val) { print "$val\n"; }
173 $memd->disconnect_all;
174 EOF
175
176 --sorted_result
177 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
178
179 perl;
180 use DBI;
181 use Cache::Memcached;
182 my $memd = new Cache::Memcached {
183 'servers' => [ "127.0.0.1:11276" ],
184 'connect_timeout' => 20,
185 'select_timeout' => 20
186 };
187 print "Here are the memcached results after set in desct12:\n";
188 $val = $memd->get("\@\@desct12");
189 $val = $memd->set("Essen","E|Essen");
190 $val= $memd->get("Essen");
191 if ($val) { print "$val\n"; }
192 $memd->disconnect_all;
193 EOF
194
195 --sorted_result
196 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
197
198 perl;
199 use DBI;
200 use Cache::Memcached;
201 my $memd = new Cache::Memcached {
202 'servers' => [ "127.0.0.1:11276" ],
203 'connect_timeout' => 20,
204 'select_timeout' => 20
205 };
206 print "Here are the memcached results after set in desct13:\n";
207 $val = $memd->set("\@\@desct13.Essen","E|Neustadt");
208 $val = $memd->get("\@\@desct13.Essen");
209 if ($val) { print "$val\n"; }
210 $memd->disconnect_all;
211 EOF
212
213 --sorted_result
214 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
215
216 perl;
217 use DBI;
218 use Cache::Memcached;
219 my $memd = new Cache::Memcached {
220 'servers' => [ "127.0.0.1:11276" ],
221 'connect_timeout' => 20,
222 'select_timeout' => 20
223 };
224 print "Here are the memcached results after set in desct14:\n";
225 $val = $memd->set("\@\@desct14.Altstadt","E|Hafen|111111");
226 $val = $memd->get("\@\@desct14.Altstadt");
227 if ($val) { print "$val\n"; }
228 $memd->disconnect_all;
229 EOF
230
231 --sorted_result
232 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
233
234 perl;
235 use DBI;
236 use Cache::Memcached;
237 my $memd = new Cache::Memcached {
238 'servers' => [ "127.0.0.1:11276" ],
239 'connect_timeout' => 20,
240 'select_timeout' => 20
241 };
242 print "Here are the memcached results after set in desct15:\n";
243 $val = $memd->set('@@desct15.Mahl',"E|Mitte|111111|E");
244 $val = $memd->get("\@\@desct15.Mahl");
245 if ($val) { print "$val\n"; }
246 $memd->disconnect_all;
247 EOF
248
249 --sorted_result
250 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
251
252 perl;
253 use DBI;
254 use Cache::Memcached;
255 my $memd = new Cache::Memcached {
256 'servers' => [ "127.0.0.1:11276" ],
257 'connect_timeout' => 20,
258 'select_timeout' => 20
259 };
260 print "Here are the memcached results after set in desct16:\n";
261 $val = $memd->set('@@desct16.E',"Mahlzeit|111111|T|E");
262 $val = $memd->get("\@\@desct16.E");
263 if ($val) { print "$val\n"; }
264 $memd->disconnect_all;
265 EOF
266
267 --sorted_result
268 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
269
270 perl;
271 use DBI;
272 use Cache::Memcached;
273 my $memd = new Cache::Memcached {
274 'servers' => [ "127.0.0.1:11276" ],
275 'connect_timeout' => 20,
276 'select_timeout' => 20
277 };
278 print "Here are the memcached results after set in desct17:\n";
279 $val = $memd->set("\@\@desct17.e","Essen|E");
280 $val = $memd->get("\@\@desct17.e");
281 if ($val) { print "$val\n"; }
282 $memd->disconnect_all;
283 EOF
284
285 --sorted_result
286 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
287
288 DROP TABLE t1;
289
290 UNINSTALL PLUGIN daemon_memcached;
291 DROP DATABASE innodb_memcache;
292
293 SET @@global.transaction_isolation= @transaction_isolation;