Debian Codegraph @

mysql-test/suite/memcached/t/memc269_funcs_1.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 # describe table for memcache
26 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
27 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
28
29 USE test;
30
31 --disable_warnings
32 DROP TABLE IF EXISTS t1;
33 --enable_warnings
34 CREATE TABLE t1 (c1 VARCHAR(32),
35 c2 VARCHAR(1024),
36 c21 VARCHAR(1024),
37 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
38 ENGINE = INNODB;
39
40 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
41 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
42 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
43 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
44
45 # Tables must exist before plugin can be started!
46 --let $memcached_address=127.0.0.1:11269
47 --source ../include/load_daemon_memcached_expecting_success.inc
48
49 --sorted_result
50 SELECT c1,c2,c21 FROM t1;
51
52 perl;
53 use DBI;
54 use Cache::Memcached;
55 my $memd = new Cache::Memcached {
56 'servers' => [ "127.0.0.1:11269" ],
57 'connect_timeout' => 20,
58 'select_timeout' => 20
59 };
60 print "Here are the memcached results with D,B,H,C:\n";
61 $val = $memd->get("D");
62 if ($val) { print "$val\n"; }
63 $val = $memd->get("B");
64 if ($val) { print "$val\n"; }
65 $val = $memd->get("H");
66 if ($val) { print "$val\n"; }
67 $val = $memd->get("C");
68 if ($val) { print "$val\n"; }
69 $memd->disconnect_all;
70 EOF
71
72 --sorted_result
73 SELECT c1,c2,c21,length(c2) as c22,upper(c2) as c23 FROM t1;
74
75 perl;
76 use DBI;
77 use Cache::Memcached;
78 my $memd = new Cache::Memcached {
79 'servers' => [ "127.0.0.1:11269" ],
80 'connect_timeout' => 20,
81 'select_timeout' => 20
82 };
83 print "Here are the memcached results after set:\n";
84 $val = $memd->set("E","Essen|Ost");
85 $val = $memd->get("E");
86 if ($val) { print "$val\n"; }
87 $memd->disconnect_all;
88 EOF
89
90 --sorted_result
91 SELECT c1,c2,c21,length(c2) as c22,upper(c2) as c23 FROM t1;
92
93 perl;
94 use DBI;
95 use Cache::Memcached;
96 my $memd = new Cache::Memcached {
97 'servers' => [ "127.0.0.1:11269" ],
98 'connect_timeout' => 20,
99 'select_timeout' => 20
100 };
101 print "Here are the memcached results after add:\n";
102 $val = $memd->add("F","Frankfurt|Sachsenhause");
103 $val = $memd->get("F");
104 if ($val) { print "$val\n"; }
105 $memd->disconnect_all;
106 EOF
107
108 --sorted_result
109 SELECT c1,c2,c21,length(c2) as c22,upper(c2) as c23 FROM t1;
110
111 perl;
112 use DBI;
113 use Cache::Memcached;
114 my $memd = new Cache::Memcached {
115 'servers' => [ "127.0.0.1:11269" ],
116 'connect_timeout' => 20,
117 'select_timeout' => 20
118 };
119 print "Here are the memcached results after replace:\n";
120 $val = $memd->replace("F","Frankfurt a. M.|Sachsenhausen");
121 $val = $memd->get("F");
122 if ($val) { print "$val\n"; }
123 $memd->disconnect_all;
124 EOF
125
126 --sorted_result
127 SELECT c1,c2,c21,length(c2) as c22,upper(c2) as c23 FROM t1;
128
129 perl;
130 use DBI;
131 use Cache::Memcached;
132 my $memd = new Cache::Memcached {
133 'servers' => [ "127.0.0.1:11269" ],
134 'connect_timeout' => 20,
135 'select_timeout' => 20
136 };
137 print "Here are the memcached results after delete:\n";
138 $val = $memd->delete("F");
139 $val = $memd->get("F");
140 if ($val) { print "$val\n"; }
141 $memd->disconnect_all;
142 EOF
143
144 --sorted_result
145 SELECT c1,c2,c21,length(c2) as c22,upper(c2) as c23 FROM t1;
146
147 perl;
148 use DBI;
149 use Cache::Memcached;
150 my $memd = new Cache::Memcached {
151 'servers' => [ "127.0.0.1:11269" ],
152 'connect_timeout' => 20,
153 'select_timeout' => 20
154 };
155 print "Here are the memcached results after add Frankfurt|:\n";
156 $val = $memd->add("F","Frankfurt|");
157 $val = $memd->get("F");
158 if ($val) { print "$val\n"; }
159 print "Here are the memcached results after add |Airport:\n";
160 $val = $memd->add("F","|");
161 $val = $memd->get("F");
162 if ($val) { print "$val\n"; }
163 $memd->disconnect_all;
164 EOF
165
166 --sorted_result
167 SELECT c1,c2,c21,length(c2) as c22,upper(c2) as c23 FROM t1;
168
169 perl;
170 use DBI;
171 use Cache::Memcached;
172 my $memd = new Cache::Memcached {
173 'servers' => [ "127.0.0.1:11269" ],
174 'connect_timeout' => 20,
175 'select_timeout' => 20
176 };
177 print "Here are the memcached results after replace Frankfurt a.M.:\n";
178 $val = $memd->replace("F","Frankfurt a. M.|");
179 $val = $memd->get("F");
180 if ($val) { print "$val\n"; }
181 print "Here are the memcached results after replace Sachsenhausen:\n";
182 $val = $memd->replace("F","|Sachsenhausen");
183 $val = $memd->get("F");
184 if ($val) { print "$val\n"; }
185 $memd->disconnect_all;
186 EOF
187
188 --sorted_result
189 SELECT c1,c2,c21,length(c2) as c22,upper(c2) as c23 FROM t1;
190
191 SET sql_mode='NO_ENGINE_SUBSTITUTION';
192 ALTER TABLE t1 MODIFY c2 int;
193 SET sql_mode=default;
194
195 --sorted_result
196 SELECT c1,c2,c21 FROM t1;
197
198 perl;
199 use DBI;
200 use Cache::Memcached;
201 my $memd = new Cache::Memcached {
202 'servers' => [ "127.0.0.1:11269" ],
203 'connect_timeout' => 20,
204 'select_timeout' => 20
205 };
206 print "Here are the memcached results after add Frankfurt|:\n";
207 $val = $memd->add("F","Frankfurt|");
208 $val = $memd->get("F");
209 if ($val) { print "$val\n"; }
210 print "Here are the memcached results after add |Airport:\n";
211 $val = $memd->add("F","|");
212 $val = $memd->get("F");
213 if ($val) { print "$val\n"; }
214 $memd->disconnect_all;
215 EOF
216
217 --sorted_result
218 SELECT c1,c2,c21,length(c2) as c22,upper(c2) as c23 FROM t1;
219
220 perl;
221 use DBI;
222 use Cache::Memcached;
223 my $memd = new Cache::Memcached {
224 'servers' => [ "127.0.0.1:11269" ],
225 'connect_timeout' => 20,
226 'select_timeout' => 20
227 };
228 print "Here are the memcached results after flush_all:\n";
229 $memd->flush_all;
230 $val = $memd->get("F");
231 if ($val) { print "$val\n"; }
232 $memd->disconnect_all;
233 EOF
234
235 --sorted_result
236 SELECT c1,c2,c21,length(c2) as c22,upper(c2) as c23 FROM t1;
237
238 perl;
239 use DBI;
240 use Cache::Memcached;
241 my $memd = new Cache::Memcached {
242 'servers' => [ "127.0.0.1:11269" ],
243 'connect_timeout' => 20,
244 'select_timeout' => 20
245 };
246
247 print "Bug#18652854 INNODB MEMCACHED ASSERTION `!CONN_DATA->CRSR_TRX' FAILED.\n ";
248 print "Call flush_all after set and get.\n";
249 $val = $memd->set("E","Essen|Ost");
250 $val = $memd->get("E");
251 $memd->flush_all;
252 $memd->disconnect_all;
253 EOF
254
255 DROP TABLE t1;
256
257 UNINSTALL PLUGIN daemon_memcached;
258 DROP DATABASE innodb_memcache;
259
260 SET @@global.transaction_isolation= @transaction_isolation;