Debian Codegraph @

mysql-test/suite/memcached/t/memc215_50_cols.test

raw
1 source include/not_valgrind.inc;
2 source include/have_memcached_plugin.inc;
3 source include/not_windows.inc;
4
5 call mtr.add_suppression("Cannot add field ");
6
7 --disable_query_log
8 CALL mtr.add_suppression("daemon-memcached-w-batch-size': unsigned");
9 CALL mtr.add_suppression("Could not obtain server's UPN to be used as target service name");
10 CALL mtr.add_suppression("Warning: MySQL is trying to drop");
11 --enable_query_log
12
13 --enable_connect_log
14 SET @transaction_isolation= @@global.transaction_isolation;
15 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
16
17 # Create the memcached tables
18 --disable_query_log
19 source include/memcache_config.inc;
20 --enable_query_log
21 SET sql_mode='NO_ENGINE_SUBSTITUTION';
22 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
23 "innodb_only", "innodb_only", "innodb_only");
24
25 INSERT INTO config_options VALUES("separator", ",");
26
27 # describe table for memcache
28 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
29 "c1",
30 "c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
31 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
32 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
33 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
34 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249",
35 "c3", "c4", "c5", "PRIMARY");
36
37 # Container's value_columns is 255 bytes, above insertion would be truncated.
38 # The truncation left an invalid column name "c", which will be rejected
39 # by InnoDB memcached configuration
40 SELECT * FROM containers;
41
42 DELETE FROM containers;
43
44 # The 255 character limit of "value_columns" can hold columns up to "c230"
45 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
46 "c1",
47 "c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
48 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
49 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229",
50 "c3", "c4", "c5", "PRIMARY");
51
52 USE test;
53
54 SET innodb_strict_mode=OFF;
55 --disable_warnings
56 CREATE TABLE t1 (c1 VARCHAR(32),
57 c200 VARCHAR(40),
58 c201 VARCHAR(40),
59 c202 VARCHAR(40),
60 c203 VARCHAR(40),
61 c204 VARCHAR(40),
62 c205 VARCHAR(40),
63 c206 VARCHAR(40),
64 c207 VARCHAR(40),
65 c208 VARCHAR(40),
66 c209 VARCHAR(40),
67 c210 VARCHAR(40),
68 c211 VARCHAR(40),
69 c212 VARCHAR(40),
70 c213 VARCHAR(40),
71 c214 VARCHAR(40),
72 c215 VARCHAR(40),
73 c216 VARCHAR(40),
74 c217 VARCHAR(40),
75 c218 VARCHAR(40),
76 c219 VARCHAR(40),
77 c220 VARCHAR(40),
78 c221 VARCHAR(40),
79 c222 VARCHAR(40),
80 c223 VARCHAR(40),
81 c224 VARCHAR(40),
82 c225 VARCHAR(40),
83 c226 VARCHAR(40),
84 c227 VARCHAR(40),
85 c228 VARCHAR(40),
86 c229 VARCHAR(40),
87 c230 VARCHAR(40),
88 c231 VARCHAR(40),
89 c232 VARCHAR(40),
90 c233 VARCHAR(40),
91 c234 VARCHAR(40),
92 c235 VARCHAR(40),
93 c236 VARCHAR(40),
94 c237 VARCHAR(40),
95 c238 VARCHAR(40),
96 c239 VARCHAR(40),
97 c240 VARCHAR(40),
98 c241 VARCHAR(40),
99 c242 VARCHAR(40),
100 c243 VARCHAR(40),
101 c244 VARCHAR(40),
102 c245 VARCHAR(40),
103 c246 VARCHAR(40),
104 c247 VARCHAR(40),
105 c248 VARCHAR(40),
106 c249 VARCHAR(40),
107 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
108 ROW_FORMAT=COMPACT ENGINE = INNODB;
109 --enable_warnings
110
111 INSERT INTO t1 VALUES ('1',
112 'c200','c201','c202','c203','c204','c205','c206','c207','c208','c209',
113 'c210','c211','c212','c213','c214','c215','c216','c217','c218','c219',
114 'c220','c221','c222','c223','c224','c225','c226','c227','c228','c229',
115 'c230','c231','c232','c233','c234','c235','c236','c237','c238','c239',
116 'c240','c241','c242','c243','c244','c245','c246','c247','c248','c249',
117 0, 0, 0);
118 INSERT INTO t1 VALUES ('2',
119 'c200','c201','c202','c203','c204','c205','c206','c207','c208','c209',
120 'c210','c211','c212','c213','c214','c215','c216','c217','c218','c219',
121 'c220','c221','c222','c223','c224','c225','c226','c227','c228','c229',
122 'c230','c231','c232','c233','c234','c235','c236','c237','c238','c239',
123 'c240','c241','c242','c243','c244','c245','c246','c247','c248','c249',
124 0, 0, 0);
125 INSERT INTO t1 VALUES ('3',
126 'c200','c201','c202','c203','c204','c205','c206','c207','c208','c209',
127 'c210','c211','c212','c213','c214','c215','c216','c217','c218','c219',
128 'c220','c221','c222','c223','c224','c225','c226','c227','c228','c229',
129 'c230','c231','c232','c233','c234','c235','c236','c237','c238','c239',
130 'c240','c241','c242','c243','c244','c245','c246','c247','c248','c249',
131 0, 0, 0);
132
133 # Tables must exist before plugin can be started!
134 --let $memcached_address=127.0.0.1:11215
135 --source ../include/load_daemon_memcached_expecting_success.inc
136
137 --sorted_result
138 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
139 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
140 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
141 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
142 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
143 FROM t1;
144
145
146 perl;
147 use DBI;
148 use Cache::Memcached;
149 my $memd = new Cache::Memcached {
150 'servers' => [ "127.0.0.1:11215" ],
151 'connect_timeout' => 20,
152 'select_timeout' => 20
153 };
154 print "Here are the memcached results:\n";
155 $val = $memd->get("1");
156 if ($val) { print "$val\n"; }
157 $val = $memd->get("2");
158 if ($val) { print "$val\n"; }
159 $val = $memd->get("3");
160 if ($val) { print "$val\n"; }
161 $memd->disconnect_all;
162 EOF
163
164 --sorted_result
165 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
166 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
167 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
168 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
169 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
170 FROM t1;
171
172 perl;
173 use DBI;
174 use Cache::Memcached;
175 my $memd = new Cache::Memcached {
176 'servers' => [ "127.0.0.1:11215" ],
177 'connect_timeout' => 20,
178 'select_timeout' => 20
179 };
180 print "Here are the memcached results after set:\n";
181 $val = $memd->set("4","c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,c220,c221,c222,c223,c224,c225,c226,c227,c228,c229");
182 $val = $memd->get("4");
183 if ($val) { print "$val\n"; }
184 $memd->disconnect_all;
185 EOF
186
187 --sorted_result
188 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
189 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
190 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
191 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
192 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
193 FROM t1;
194
195 perl;
196 use DBI;
197 use Cache::Memcached;
198 my $memd = new Cache::Memcached {
199 'servers' => [ "127.0.0.1:11215" ],
200 'connect_timeout' => 20,
201 'select_timeout' => 20
202 };
203 print "Here are the memcached results after set:\n";
204 $val = $memd->set("4","c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
205 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
206 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229"
207 );
208 $val = $memd->get("4");
209 if ($val) { print "$val\n"; }
210 $memd->disconnect_all;
211 EOF
212
213 --sorted_result
214 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
215 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
216 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
217 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
218 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
219 FROM t1;
220
221 perl;
222 use DBI;
223 use Cache::Memcached;
224 my $memd = new Cache::Memcached {
225 'servers' => [ "127.0.0.1:11215" ],
226 'connect_timeout' => 20,
227 'select_timeout' => 20
228 };
229 print "Here are the memcached results after set:\n";
230 $val = $memd->set("4","c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
231 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
232 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
233 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
234 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249"
235 );
236 $val = $memd->get("4");
237 if ($val) { print "$val\n"; }
238 $memd->disconnect_all;
239 EOF
240
241 --sorted_result
242 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
243 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
244 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
245 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
246 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
247 FROM t1;
248
249 DROP TABLE t1;
250 SET sql_mode=default;
251 UNINSTALL PLUGIN daemon_memcached;
252 DROP DATABASE innodb_memcache;
253
254 SET @@global.transaction_isolation= @transaction_isolation;