Debian Codegraph @

mysql-test/suite/memcached/t/memc224_index_2.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
25 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
26 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
27
28 CREATE USER mysqltest1@localhost;
29 connect (mysqltest1,localhost,mysqltest1,,);
30 connection mysqltest1;
31 USE test;
32
33 --disable_warnings
34 DROP TABLE IF EXISTS t1;
35 --enable_warnings
36 CREATE TABLE t1 (c1 VARCHAR(32),
37 c11 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 INSERT INTO t1 VALUES ('D','D', 'Darmstadt', 'City', 0, 0, 0);
44 INSERT INTO t1 VALUES ('B','B', 'Berlin', 'Mitte', 0, 0, 0);
45 INSERT INTO t1 VALUES ('C','C', 'Cottbus', 'West', 0, 0 ,0);
46 INSERT INTO t1 VALUES ('H','H', 'Hamburg', 'Norderstedt', 0, 0, 0);
47
48 connection default;
49
50 --let $memcached_address=127.0.0.1:11224
51 --source ../include/load_daemon_memcached_expecting_success.inc
52
53 connection mysqltest1;
54 USE test;
55 --sorted_result
56 SELECT c1,c11,c2,c21 FROM t1;
57
58 perl;
59 use DBI;
60 use Cache::Memcached;
61 my $memd = new Cache::Memcached {
62 'servers' => [ "127.0.0.1:11224" ],
63 'connect_timeout' => 20,
64 'select_timeout' => 20
65 };
66 print "Here are the memcached results with D,B,H,C:\n";
67 $val = $memd->get("D");
68 if ($val) { print "$val\n"; }
69 $val = $memd->get("B");
70 if ($val) { print "$val\n"; }
71 $val = $memd->get("H");
72 if ($val) { print "$val\n"; }
73 $val = $memd->get("C");
74 if ($val) { print "$val\n"; }
75 $memd->disconnect_all;
76 EOF
77
78 --sorted_result
79 SELECT c1,c11,c2,c21 FROM t1;
80
81 perl;
82 use DBI;
83 use Cache::Memcached;
84 my $memd = new Cache::Memcached {
85 'servers' => [ "127.0.0.1:11224" ],
86 'connect_timeout' => 20,
87 'select_timeout' => 20
88 };
89 print "Here are the memcached results after set:\n";
90 $val = $memd->set("E","Essen|Ost");
91 $val = $memd->get("E");
92 if ($val) { print "$val\n"; }
93 $memd->disconnect_all;
94 EOF
95
96 --sorted_result
97 SELECT c1,c11,c2,c21 FROM t1;
98
99 perl;
100 use DBI;
101 use Cache::Memcached;
102 my $memd = new Cache::Memcached {
103 'servers' => [ "127.0.0.1:11224" ],
104 'connect_timeout' => 20,
105 'select_timeout' => 20
106 };
107 print "Here are the memcached results after add:\n";
108 $val = $memd->add("F","Frankfurt|Sachsenhause");
109 $val = $memd->get("F");
110 if ($val) { print "$val\n"; }
111 $memd->disconnect_all;
112 EOF
113
114 --sorted_result
115 SELECT c1,c11,c2,c21 FROM t1;
116
117 perl;
118 use DBI;
119 use Cache::Memcached;
120 my $memd = new Cache::Memcached {
121 'servers' => [ "127.0.0.1:11224" ],
122 'connect_timeout' => 20,
123 'select_timeout' => 20
124 };
125 print "Here are the memcached results after replace:\n";
126 $val = $memd->replace("F","Frankfurt a. M.|Sachsenhausen");
127 $val = $memd->get("F");
128 if ($val) { print "$val\n"; }
129 $memd->disconnect_all;
130 EOF
131
132 --sorted_result
133 SELECT c1,c11,c2,c21 FROM t1;
134
135 perl;
136 use DBI;
137 use Cache::Memcached;
138 my $memd = new Cache::Memcached {
139 'servers' => [ "127.0.0.1:11224" ],
140 'connect_timeout' => 20,
141 'select_timeout' => 20
142 };
143 print "Here are the memcached results after delete:\n";
144 $val = $memd->delete("F");
145 $val = $memd->get("F");
146 if ($val) { print "$val\n"; }
147 $memd->disconnect_all;
148 EOF
149
150 --sorted_result
151 SELECT c1,c11,c2,c21 FROM t1;
152
153 perl;
154 use DBI;
155 use Cache::Memcached;
156 my $memd = new Cache::Memcached {
157 'servers' => [ "127.0.0.1:11224" ],
158 'connect_timeout' => 20,
159 'select_timeout' => 20
160 };
161 print "Here are the memcached results after add Frankfurt|Airport:\n";
162 $val = $memd->add("F","Frankfurt|Airport");
163 $val = $memd->get("F");
164 if ($val) { print "$val\n"; }
165 $memd->disconnect_all;
166 EOF
167
168 --sorted_result
169 SELECT c1,c11,c2,c21 FROM t1;
170
171 perl;
172 use DBI;
173 use Cache::Memcached;
174 my $memd = new Cache::Memcached {
175 'servers' => [ "127.0.0.1:11224" ],
176 'connect_timeout' => 20,
177 'select_timeout' => 20
178 };
179 print "Here are the memcached results after replace Frankfurt a.M|Sachsenhausen.:\n";
180 $val = $memd->replace("F","Frankfurt a. M.|Sachsenhausen");
181 $val = $memd->get("F");
182 if ($val) { print "$val\n"; }
183 $memd->disconnect_all;
184 EOF
185
186 --sorted_result
187 SELECT c1,c11,c2,c21 FROM t1;
188
189 connection default;
190 # Stop plugin before innodb_memcached configuration
191 UNINSTALL PLUGIN daemon_memcached;
192 # We can never drop primary key
193 ALTER TABLE test.t1 DROP PRIMARY KEY;
194 --let $memcached_address=127.0.0.1:11224
195 --source ../include/load_daemon_memcached_expecting_error.inc
196
197 connection mysqltest1;
198 perl;
199 use DBI;
200 use Cache::Memcached;
201 my $memd = new Cache::Memcached {
202 'servers' => [ "127.0.0.1:11224" ],
203 'connect_timeout' => 20,
204 'select_timeout' => 20
205 };
206 print "Here are the memcached results after set:\n";
207 $val = $memd->set("E","Essen|Ost");
208 $val = $memd->get("E");
209 if ($val) { print "$val\n"; }
210 $val = $memd->get("H");
211 if ($val) { print "$val\n"; }
212 $memd->disconnect_all;
213 EOF
214
215 --sorted_result
216 SELECT c1,c11,c2,c21 FROM t1;
217
218 connection default;
219 # Stop plugin before innodb_memcached configuration
220 UNINSTALL PLUGIN daemon_memcached;
221 ALTER TABLE test.t1 ADD CONSTRAINT PRIMARY KEY (c1);
222 --let $memcached_address=127.0.0.1:11224
223 --source ../include/load_daemon_memcached_expecting_success.inc
224
225 SHOW CREATE TABLE test.t1;
226
227 connection mysqltest1;
228 perl;
229 use DBI;
230 use Cache::Memcached;
231 my $memd = new Cache::Memcached {
232 'servers' => [ "127.0.0.1:11224" ],
233 'connect_timeout' => 20,
234 'select_timeout' => 20
235 };
236 print "Here are the memcached results after set:\n";
237 $val = $memd->set("E","Essen|Ost");
238 $val = $memd->get("E");
239 if ($val) { print "$val\n"; }
240 $val = $memd->add("F","Frankfurt|Sachsenhause");
241 $val = $memd->get("F");
242 if ($val) { print "$val\n"; }
243 $val = $memd->get("H");
244 if ($val) { print "$val\n"; }
245 $memd->disconnect_all;
246 EOF
247
248 --sorted_result
249 SELECT c1,c11,c2,c21 FROM t1;
250
251 # Now switch to column "c11"
252 connection default;
253 # Stop plugin before innodb_memcached configuration
254 UNINSTALL PLUGIN daemon_memcached;
255 ALTER TABLE test.t1 DROP COLUMN c1;
256 # Need to add index on column c11 and also update the innodb_memcache.containers
257 UPDATE innodb_memcache.containers set key_columns = "c11", unique_idx_name_on_key="idx";
258 create unique index idx on test.t1(c11);
259 --let $memcached_address=127.0.0.1:11224
260 --source ../include/load_daemon_memcached_expecting_success.inc
261
262 connection mysqltest1;
263 perl;
264 use DBI;
265 use Cache::Memcached;
266 my $memd = new Cache::Memcached {
267 'servers' => [ "127.0.0.1:11224" ],
268 'connect_timeout' => 20,
269 'select_timeout' => 20
270 };
271 print "Here are the memcached results after add:\n";
272 $val = $memd->set("E","Essen|Ost");
273 $val = $memd->get("E");
274 if ($val) { print "$val\n"; }
275 $val = $memd->add("F","Frankfurt|Sachsenhause");
276 $val = $memd->get("F");
277 if ($val) { print "$val\n"; }
278 $val = $memd->get("H");
279 if ($val) { print "$val\n"; }
280 $memd->disconnect_all;
281 EOF
282
283 --sorted_result
284 SELECT c11,c2,c21 FROM t1;
285
286 DROP TABLE t1;
287 connection default;
288 disconnect mysqltest1;
289
290 UNINSTALL PLUGIN daemon_memcached;
291 DROP DATABASE innodb_memcache;
292 DROP USER mysqltest1@localhost;
293
294 SET @@global.transaction_isolation= @transaction_isolation;