Debian Codegraph @

mysql-test/suite/memcached/t/memc273_5_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 INSERT INTO containers VALUES ("desct3", "test", "t3",
32 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
33 INSERT INTO containers VALUES ("desct4", "test", "t4",
34 "c1", "c2,c21,c22", "c3", "c4", "c5", "PRIMARY");
35 INSERT INTO containers VALUES ("desct5", "test", "t5",
36 "c1", "c2,c21,c22,c23", "c3", "c4", "c5", "PRIMARY");
37
38 USE test;
39
40 --disable_warnings
41 DROP TABLE IF EXISTS t1,t2;
42 --enable_warnings
43 CREATE TABLE t1 (c1 VARCHAR(32),
44 c2 VARCHAR(1024),
45 c21 VARCHAR(1024),
46 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
47 ENGINE = INNODB;
48
49 CREATE TABLE t2 (c1 VARCHAR(32),
50 c2 VARCHAR(1024),
51 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
52 ENGINE = INNODB;
53
54 CREATE TABLE t3 (c1 VARCHAR(32),
55 c2 VARCHAR(1024),
56 c21 VARCHAR(1024),
57 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
58 ENGINE = INNODB;
59
60 CREATE TABLE t4 (c1 VARCHAR(32),
61 c2 VARCHAR(1024),
62 c21 VARCHAR(1024),
63 c22 VARCHAR(1024),
64 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
65 ENGINE = INNODB;
66
67 CREATE TABLE t5 (c1 VARCHAR(32),
68 c2 VARCHAR(1024),
69 c21 VARCHAR(1024),
70 c22 VARCHAR(1024),
71 c23 VARCHAR(1024),
72 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
73 ENGINE = INNODB;
74
75 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
76 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
77 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
78 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
79
80 INSERT INTO t2 VALUES ('D', 'Dortmund', 0, 0, 0);
81 INSERT INTO t2 VALUES ('B', 'Bremen', 0, 0, 0);
82 INSERT INTO t2 VALUES ('C', 'Celle', 0, 0 ,0);
83 INSERT INTO t2 VALUES ('H', 'Hannover', 0, 0, 0);
84
85 INSERT INTO t3 VALUES ('D', 'Detmold', 'City', 0, 0, 0);
86 INSERT INTO t3 VALUES ('B', 'Bonn', 'Mitte', 0, 0, 0);
87 INSERT INTO t3 VALUES ('A', 'Aachen', 'West', 0, 0 ,0);
88 INSERT INTO t3 VALUES ('H', 'Hameln', 'Nord', 0, 0, 0);
89
90 INSERT INTO t4 VALUES ('Z', 'Zossen', 'City', '12345', 0, 0, 0);
91 INSERT INTO t4 VALUES ('B', 'Brandenburg', 'Mitte', '23456', 0, 0, 0);
92 INSERT INTO t4 VALUES ('M', 'Muenchen', 'West', '34567', 0, 0 ,0);
93 INSERT INTO t4 VALUES ('H', 'Husum', 'Nord', '45678', 0, 0, 0);
94
95 INSERT INTO t5 VALUES ('D', 'Duesseldorf', 'City', '98765', 'Hafen', 0, 0, 0);
96 INSERT INTO t5 VALUES ('O', 'Oldenburg', 'Mitte', '87654', 'Deich', 0, 0, 0);
97 INSERT INTO t5 VALUES ('K', 'Koeln', 'West', '76543', 'Rhein', 0, 0 ,0);
98 INSERT INTO t5 VALUES ('S', 'Stuttgart', 'Nord', '65432', 'Fernsehturm', 0, 0, 0);
99
100 # Tables must exist before plugin can be started!
101 --let $memcached_address=127.0.0.1:11273
102 --source ../include/load_daemon_memcached_expecting_success.inc
103
104 --sorted_result
105 SELECT c1,c2,c21 FROM t1;
106 --sorted_result
107 SELECT c1,c2 FROM t2;
108 --sorted_result
109 SELECT c1,c2,c21 FROM t3;
110 --sorted_result
111 SELECT c1,c2,c21,c22 FROM t4;
112 --sorted_result
113 SELECT c1,c2,c21,c22,c23 FROM t5;
114
115
116 perl;
117 use DBI;
118 use Cache::Memcached;
119 my $memd = new Cache::Memcached {
120 'servers' => [ "127.0.0.1:11273" ],
121 'connect_timeout' => 20,
122 'select_timeout' => 20
123 };
124 print "Here are the memcached results with D,B,H,C of default:\n";
125 $val = $memd->get("D");
126 if ($val) { print "$val\n"; }
127 $val = $memd->get("B");
128 if ($val) { print "$val\n"; }
129 $val = $memd->get("H");
130 if ($val) { print "$val\n"; }
131 $val = $memd->get("C");
132 if ($val) { print "$val\n"; }
133 $memd->disconnect_all;
134 EOF
135
136 perl;
137 use DBI;
138 use Cache::Memcached;
139 my $memd = new Cache::Memcached {
140 'servers' => [ "127.0.0.1:11273" ],
141 'connect_timeout' => 20,
142 'select_timeout' => 20
143 };
144 print "Here are the memcached results with D,B,H,C of t1:\n";
145 $val = $memd->get('@@desct1.D');
146 if ($val) { print "$val\n"; }
147 $val = $memd->get("\@\@desct1.B");
148 if ($val) { print "$val\n"; }
149 $val = $memd->get('@@desct1.'.'H');
150 if ($val) { print "$val\n"; }
151 $val = $memd->get('@@desct1.C');
152 if ($val) { print "$val\n"; }
153 print "Here are the memcached results with D,B,H,C of t2:\n";
154 $val = $memd->get("\@\@desct2");
155 $val = $memd->get("D");
156 if ($val) { print "$val\n"; }
157 $val = $memd->get('@@desct2.B');
158 if ($val) { print "$val\n"; }
159 $val = $memd->get('H');
160 if ($val) { print "$val\n"; }
161 $val = $memd->get('C');
162 if ($val) { print "$val\n"; }
163 print "Here are the memcached results with D,B,H,A of t3:\n";
164 $val = $memd->get("\@\@desct3.D");
165 if ($val) { print "$val\n"; }
166 $val = $memd->get('@@desct3.B');
167 if ($val) { print "$val\n"; }
168 $val = $memd->get('@@desct3.H');
169 if ($val) { print "$val\n"; }
170 $val = $memd->get('@@desct3.A');
171 if ($val) { print "$val\n"; }
172 print "Here are the memcached results with D,O,K,S of t5:\n";
173 $val = $memd->get("\@\@desct5.D");
174 if ($val) { print "$val\n"; }
175 $val = $memd->get('@@desct5.O');
176 if ($val) { print "$val\n"; }
177 $val = $memd->get('@@desct5.K');
178 if ($val) { print "$val\n"; }
179 $val = $memd->get('@@desct5.S');
180 if ($val) { print "$val\n"; }
181 print "Here are the memcached results with Z,B,H,M of t4:\n";
182 $val = $memd->get("\@\@desct4.Z");
183 if ($val) { print "$val\n"; }
184 $val = $memd->get('@@desct4.B');
185 if ($val) { print "$val\n"; }
186 $val = $memd->get('@@desct4.H');
187 if ($val) { print "$val\n"; }
188 $val = $memd->get('@@desct4.M');
189 if ($val) { print "$val\n"; }
190 print "Here are the memcached results with D,B,H,C of t2:\n";
191 $memd->get("\@\@desct2");
192 $val = $memd->get("D");
193 if ($val) { print "$val\n"; }
194 $val = $memd->get('B');
195 if ($val) { print "$val\n"; }
196 $val = $memd->get('H');
197 if ($val) { print "$val\n"; }
198 $val = $memd->get('C');
199 if ($val) { print "$val\n"; }
200 $memd->disconnect_all;
201 EOF
202
203 --sorted_result
204 SELECT c1,c2,c21 FROM t1;
205 --sorted_result
206 SELECT c1,c2 FROM t2;
207 --sorted_result
208 SELECT c1,c2,c21 FROM t3;
209 --sorted_result
210 SELECT c1,c2,c21,c22 FROM t4;
211 --sorted_result
212 SELECT c1,c2,c21,c22,c23 FROM t5;
213
214 perl;
215 use DBI;
216 use Cache::Memcached;
217 my $memd = new Cache::Memcached {
218 'servers' => [ "127.0.0.1:11273" ],
219 'connect_timeout' => 20,
220 'select_timeout' => 20
221 };
222 print "Here are the memcached results after set in default:\n";
223 $val = $memd->set("E","Essen|Ost");
224 $val = $memd->get("E");
225 if ($val) { print "$val\n"; }
226 print "Here are the memcached results after set in t2:\n";
227 $val = $memd->set("\@\@desct2.E","Essen");
228 $val = $memd->get("\@\@desct2.E");
229 if ($val) { print "$val\n"; }
230 print "Here are the memcached results after set in t5:\n";
231 $val = $memd->get("\@\@desct5");
232 $val = $memd->set("E","Essen|Mitte|111111|Mahlzeit");
233 $val = $memd->get("E");
234 if ($val) { print "$val\n"; }
235 print "Here are the memcached results after set in t3:\n";
236 $val = $memd->set('@@desct3.E',"Essen|Ost");
237 $memd->get('@@desct3');
238 $val = $memd->get("E");
239 if ($val) { print "$val\n"; }
240 print "Here are the memcached results after set in t4:\n";
241 $val = $memd->set('@@desct4.E',"Essen|Mitte|111111");
242 $val = $memd->get('@@desct4.E');
243 if ($val) { print "$val\n"; }
244 print "Here are the memcached results after set in t5:\n";
245 $val = $memd->get("\@\@desct5");
246 $val = $memd->set("\@\@desct5.E","Essen|Aussen|111111|Mahlzeit");
247 $val = $memd->get("\@\@desct5.E");
248 if ($val) { print "$val\n"; }
249 $memd->disconnect_all;
250 EOF
251
252 --sorted_result
253 SELECT c1,c2,c21 FROM t1;
254 --sorted_result
255 SELECT c1,c2 FROM t2;
256 --sorted_result
257 SELECT c1,c2,c21 FROM t3;
258 --sorted_result
259 SELECT c1,c2,c21,c22 FROM t4;
260 --sorted_result
261 SELECT c1,c2,c21,c22,c23 FROM t5;
262
263 DROP TABLE t1,t2,t3,t4,t5;
264
265 UNINSTALL PLUGIN daemon_memcached;
266 DROP DATABASE innodb_memcache;
267
268 SET @@global.transaction_isolation= @transaction_isolation;