innodb/t/innodb_wl6326.test

27   a00 CHAR(255) NOT NULL DEFAULT 'a',
38   a00,
62 INSERT INTO t1 (a00) VALUES ('aa');
63 INSERT INTO t1 (a00) VALUES ('ab');
64 INSERT INTO t1 (a00) VALUES ('ac');
65 INSERT INTO t1 (a00) VALUES ('ad');
66 INSERT INTO t1 (a00) VALUES ('ae');
67 INSERT INTO t1 (a00) VALUES ('af');
68 INSERT INTO t1 (a00) VALUES ('ag');
69 INSERT INTO t1 (a00) VALUES ('ah');
76 INSERT INTO t1 (a00) VALUES ('ai');
77 INSERT INTO t1 (a00) VALUES ('aj');
78 INSERT INTO t1 (a00) VALUES ('ak');
85 INSERT INTO t1 (a00) VALUES ('al');
86 INSERT INTO t1 (a00) VALUES ('am');
87 INSERT INTO t1 (a00) VALUES ('an');
88 INSERT INTO t1 (a00) VALUES ('ao');
89 INSERT INTO t1 (a00) VALUES ('ap');
90 INSERT INTO t1 (a00) VALUES ('aq');
91 INSERT INTO t1 (a00) VALUES ('ar');
98 INSERT INTO t1 (a00) VALUES ('as');
99 INSERT INTO t1 (a00) VALUES ('at');
100 INSERT INTO t1 (a00) VALUES ('au');
101 INSERT INTO t1 (a00) VALUES ('av');
102 INSERT INTO t1 (a00) VALUES ('aw');
103 INSERT INTO t1 (a00) VALUES ('ax');
104 INSERT INTO t1 (a00) VALUES ('ay');
111 INSERT INTO t1 (a00) VALUES ('az');
112 INSERT INTO t1 (a00) VALUES ('ba');
113 INSERT INTO t1 (a00) VALUES ('bb');
114 INSERT INTO t1 (a00) VALUES ('bc');
115 INSERT INTO t1 (a00) VALUES ('bd');
116 INSERT INTO t1 (a00) VALUES ('be');
117 INSERT INTO t1 (a00) VALUES ('bf');
125 INSERT INTO t1 (a00) VALUES ('bg');
126 INSERT INTO t1 (a00) VALUES ('bh');
127 INSERT INTO t1 (a00) VALUES ('bi');
128 INSERT INTO t1 (a00) VALUES ('bj');
129 INSERT INTO t1 (a00) VALUES ('bk');
130 INSERT INTO t1 (a00) VALUES ('bl');
131 INSERT INTO t1 (a00) VALUES ('bm');
138 INSERT INTO t1 (a00) VALUES ('bn');
139 INSERT INTO t1 (a00) VALUES ('bo');
140 INSERT INTO t1 (a00) VALUES ('bp');
141 INSERT INTO t1 (a00) VALUES ('bq');
142 INSERT INTO t1 (a00) VALUES ('br');
143 INSERT INTO t1 (a00) VALUES ('bs');
144 INSERT INTO t1 (a00) VALUES ('bt');
153 INSERT INTO t1 (a00) VALUES ('bu');
154 INSERT INTO t1 (a00) VALUES ('bv');
155 INSERT INTO t1 (a00) VALUES ('bw');
156 INSERT INTO t1 (a00) VALUES ('bx');
157 INSERT INTO t1 (a00) VALUES ('by');
158 INSERT INTO t1 (a00) VALUES ('bz');
159 INSERT INTO t1 (a00) VALUES ('ca');
161 INSERT INTO t1 (a00) VALUES ('cb');
162 INSERT INTO t1 (a00) VALUES ('cc');
163 INSERT INTO t1 (a00) VALUES ('cd');
164 INSERT INTO t1 (a00) VALUES ('ce');
165 INSERT INTO t1 (a00) VALUES ('cf');
166 INSERT INTO t1 (a00) VALUES ('cg');
167 INSERT INTO t1 (a00) VALUES ('ch');
169 INSERT INTO t1 (a00) VALUES ('ci');
170 INSERT INTO t1 (a00) VALUES ('cj');
171 INSERT INTO t1 (a00) VALUES ('ck');
172 INSERT INTO t1 (a00) VALUES ('cl');
173 INSERT INTO t1 (a00) VALUES ('cm');
174 INSERT INTO t1 (a00) VALUES ('cn');
175 INSERT INTO t1 (a00) VALUES ('co');
184 INSERT INTO t1 (a00) VALUES ('cp');
185 INSERT INTO t1 (a00) VALUES ('cq');
186 INSERT INTO t1 (a00) VALUES ('cr');
187 INSERT INTO t1 (a00) VALUES ('cs');
188 INSERT INTO t1 (a00) VALUES ('ct');
189 INSERT INTO t1 (a00) VALUES ('cu');
190 INSERT INTO t1 (a00) VALUES ('cv');
192 INSERT INTO t1 (a00) VALUES ('cw');
193 INSERT INTO t1 (a00) VALUES ('cx');
194 INSERT INTO t1 (a00) VALUES ('cy');
195 INSERT INTO t1 (a00) VALUES ('cz');
196 INSERT INTO t1 (a00) VALUES ('da');
197 INSERT INTO t1 (a00) VALUES ('db');
198 INSERT INTO t1 (a00) VALUES ('dc');
200 INSERT INTO t1 (a00) VALUES ('dd');
201 INSERT INTO t1 (a00) VALUES ('de');
202 INSERT INTO t1 (a00) VALUES ('df');
203 INSERT INTO t1 (a00) VALUES ('dg');
204 INSERT INTO t1 (a00) VALUES ('dh');
205 INSERT INTO t1 (a00) VALUES ('di');
206 INSERT INTO t1 (a00) VALUES ('dj');
208 INSERT INTO t1 (a00) VALUES ('dk');
209 INSERT INTO t1 (a00) VALUES ('dl');
210 INSERT INTO t1 (a00) VALUES ('dm');
211 INSERT INTO t1 (a00) VALUES ('dn');
212 INSERT INTO t1 (a00) VALUES ('do');
213 INSERT INTO t1 (a00) VALUES ('dp');
214 INSERT INTO t1 (a00) VALUES ('dq');
216 INSERT INTO t1 (a00) VALUES ('dr');
217 INSERT INTO t1 (a00) VALUES ('ds');
218 INSERT INTO t1 (a00) VALUES ('dt');
219 INSERT INTO t1 (a00) VALUES ('du');
220 INSERT INTO t1 (a00) VALUES ('dv');
221 INSERT INTO t1 (a00) VALUES ('dw');
222 INSERT INTO t1 (a00) VALUES ('dx');
224 INSERT INTO t1 (a00) VALUES ('dy');
225 INSERT INTO t1 (a00) VALUES ('dz');
226 INSERT INTO t1 (a00) VALUES ('ea');
227 INSERT INTO t1 (a00) VALUES ('eb');
228 INSERT INTO t1 (a00) VALUES ('ec');
229 INSERT INTO t1 (a00) VALUES ('ed');
230 INSERT INTO t1 (a00) VALUES ('ee');
232 INSERT INTO t1 (a00) VALUES ('ef');
233 INSERT INTO t1 (a00) VALUES ('eg');
234 INSERT INTO t1 (a00) VALUES ('eh');
235 INSERT INTO t1 (a00) VALUES ('ei');
236 INSERT INTO t1 (a00) VALUES ('ej');
237 INSERT INTO t1 (a00) VALUES ('ek');
238 INSERT INTO t1 (a00) VALUES ('el');
246 INSERT INTO t1 (a00) VALUES ('em');
247 INSERT INTO t1 (a00) VALUES ('en');
248 INSERT INTO t1 (a00) VALUES ('eo');
249 INSERT INTO t1 (a00) VALUES ('ep');
250 INSERT INTO t1 (a00) VALUES ('eq');
251 INSERT INTO t1 (a00) VALUES ('er');
252 INSERT INTO t1 (a00) VALUES ('es');
254 INSERT INTO t1 (a00) VALUES ('et');
255 INSERT INTO t1 (a00) VALUES ('eu');
256 INSERT INTO t1 (a00) VALUES ('ev');
257 INSERT INTO t1 (a00) VALUES ('ew');
258 INSERT INTO t1 (a00) VALUES ('ex');
259 INSERT INTO t1 (a00) VALUES ('ey');
260 INSERT INTO t1 (a00) VALUES ('ez');
262 INSERT INTO t1 (a00) VALUES ('fa');
263 INSERT INTO t1 (a00) VALUES ('fb');
264 INSERT INTO t1 (a00) VALUES ('fc');
265 INSERT INTO t1 (a00) VALUES ('fd');
266 INSERT INTO t1 (a00) VALUES ('fe');
267 INSERT INTO t1 (a00) VALUES ('ff');
268 INSERT INTO t1 (a00) VALUES ('fg');
270 INSERT INTO t1 (a00) VALUES ('fh');
271 INSERT INTO t1 (a00) VALUES ('fi');
272 INSERT INTO t1 (a00) VALUES ('fj');
273 INSERT INTO t1 (a00) VALUES ('fk');
274 INSERT INTO t1 (a00) VALUES ('fl');
275 INSERT INTO t1 (a00) VALUES ('fm');
276 INSERT INTO t1 (a00) VALUES ('fn');
278 INSERT INTO t1 (a00) VALUES ('fo');
279 INSERT INTO t1 (a00) VALUES ('fp');
280 INSERT INTO t1 (a00) VALUES ('fq');
281 INSERT INTO t1 (a00) VALUES ('fr');
282 INSERT INTO t1 (a00) VALUES ('fs');
283 INSERT INTO t1 (a00) VALUES ('ft');
284 INSERT INTO t1 (a00) VALUES ('fu');
286 INSERT INTO t1 (a00) VALUES ('fv');
287 INSERT INTO t1 (a00) VALUES ('fw');
288 INSERT INTO t1 (a00) VALUES ('fx');
289 INSERT INTO t1 (a00) VALUES ('fy');
290 INSERT INTO t1 (a00) VALUES ('fz');
291 INSERT INTO t1 (a00) VALUES ('ga');
292 INSERT INTO t1 (a00) VALUES ('gb');
294 INSERT INTO t1 (a00) VALUES ('gc');
295 INSERT INTO t1 (a00) VALUES ('gd');
296 INSERT INTO t1 (a00) VALUES ('ge');
297 INSERT INTO t1 (a00) VALUES ('gf');
298 INSERT INTO t1 (a00) VALUES ('gg');
299 INSERT INTO t1 (a00) VALUES ('gh');
324 INSERT INTO t1 (a00) VALUES ('bfa');
330 INSERT INTO t1 (a00) VALUES ('bfb');
335 SELECT a00,a01 FROM t1 WHERE a00 = 'aa';
336 SELECT a00,a01 FROM t1 WHERE a00 = 'aq';
337 # "where a00 = 'co'" is blocked because searching from smaller ('co','a','a',..).
338 SELECT a00,a01 FROM t1 WHERE a00 = 'cp';
339 SELECT a00,a01 FROM t1 WHERE a00 = 'el';
344 SELECT a00,a01 FROM t1 WHERE a00 = 'ar';
350 SELECT a00,a01 FROM t1 WHERE a00 = 'cn';
386 INSERT INTO t1 (a00) VALUES ('coa');
392 INSERT INTO t1 (a00) VALUES ('cob');
401 SELECT a00,a01 FROM t1 WHERE a00 = 'aa';
407 SELECT a00,a01 FROM t1 WHERE a00 = 'el';
441 INSERT INTO t1 (a00) VALUES ('gba');
447 INSERT INTO t1 (a00) VALUES ('gbb');
452 SELECT a00,a01 FROM t1 WHERE a00 = 'aa';
453 SELECT a00,a01 FROM t1 WHERE a00 = 'ek';
458 SELECT a00,a01 FROM t1 WHERE a00 = 'el';
464 SELECT a00,a01 FROM t1 WHERE a00 = 'gb';