Debian Codegraph @

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