innodb/t/innodb_wl6326.test

27   a00 CHAR(255) NOT NULL DEFAULT 'a',
38   a00,
63 INSERT INTO t1 (a00) VALUES ('aa');
64 INSERT INTO t1 (a00) VALUES ('ab');
65 INSERT INTO t1 (a00) VALUES ('ac');
66 INSERT INTO t1 (a00) VALUES ('ad');
67 INSERT INTO t1 (a00) VALUES ('ae');
68 INSERT INTO t1 (a00) VALUES ('af');
69 INSERT INTO t1 (a00) VALUES ('ag');
70 INSERT INTO t1 (a00) VALUES ('ah');
79 INSERT INTO t1 (a00) VALUES ('ai');
80 INSERT INTO t1 (a00) VALUES ('aj');
81 INSERT INTO t1 (a00) VALUES ('ak');
90 INSERT INTO t1 (a00) VALUES ('al');
91 INSERT INTO t1 (a00) VALUES ('am');
92 INSERT INTO t1 (a00) VALUES ('an');
93 INSERT INTO t1 (a00) VALUES ('ao');
94 INSERT INTO t1 (a00) VALUES ('ap');
95 INSERT INTO t1 (a00) VALUES ('aq');
96 INSERT INTO t1 (a00) VALUES ('ar');
105 INSERT INTO t1 (a00) VALUES ('as');
106 INSERT INTO t1 (a00) VALUES ('at');
107 INSERT INTO t1 (a00) VALUES ('au');
108 INSERT INTO t1 (a00) VALUES ('av');
109 INSERT INTO t1 (a00) VALUES ('aw');
110 INSERT INTO t1 (a00) VALUES ('ax');
111 INSERT INTO t1 (a00) VALUES ('ay');
120 INSERT INTO t1 (a00) VALUES ('az');
121 INSERT INTO t1 (a00) VALUES ('ba');
122 INSERT INTO t1 (a00) VALUES ('bb');
123 INSERT INTO t1 (a00) VALUES ('bc');
124 INSERT INTO t1 (a00) VALUES ('bd');
125 INSERT INTO t1 (a00) VALUES ('be');
126 INSERT INTO t1 (a00) VALUES ('bf');
135 INSERT INTO t1 (a00) VALUES ('bg');
136 INSERT INTO t1 (a00) VALUES ('bh');
137 INSERT INTO t1 (a00) VALUES ('bi');
138 INSERT INTO t1 (a00) VALUES ('bj');
139 INSERT INTO t1 (a00) VALUES ('bk');
140 INSERT INTO t1 (a00) VALUES ('bl');
141 INSERT INTO t1 (a00) VALUES ('bm');
150 INSERT INTO t1 (a00) VALUES ('bn');
151 INSERT INTO t1 (a00) VALUES ('bo');
152 INSERT INTO t1 (a00) VALUES ('bp');
153 INSERT INTO t1 (a00) VALUES ('bq');
154 INSERT INTO t1 (a00) VALUES ('br');
155 INSERT INTO t1 (a00) VALUES ('bs');
156 INSERT INTO t1 (a00) VALUES ('bt');
166 INSERT INTO t1 (a00) VALUES ('bu');
167 INSERT INTO t1 (a00) VALUES ('bv');
168 INSERT INTO t1 (a00) VALUES ('bw');
169 INSERT INTO t1 (a00) VALUES ('bx');
170 INSERT INTO t1 (a00) VALUES ('by');
171 INSERT INTO t1 (a00) VALUES ('bz');
172 INSERT INTO t1 (a00) VALUES ('ca');
174 INSERT INTO t1 (a00) VALUES ('cb');
175 INSERT INTO t1 (a00) VALUES ('cc');
176 INSERT INTO t1 (a00) VALUES ('cd');
177 INSERT INTO t1 (a00) VALUES ('ce');
178 INSERT INTO t1 (a00) VALUES ('cf');
179 INSERT INTO t1 (a00) VALUES ('cg');
180 INSERT INTO t1 (a00) VALUES ('ch');
182 INSERT INTO t1 (a00) VALUES ('ci');
183 INSERT INTO t1 (a00) VALUES ('cj');
184 INSERT INTO t1 (a00) VALUES ('ck');
185 INSERT INTO t1 (a00) VALUES ('cl');
186 INSERT INTO t1 (a00) VALUES ('cm');
187 INSERT INTO t1 (a00) VALUES ('cn');
188 INSERT INTO t1 (a00) VALUES ('co');
198 INSERT INTO t1 (a00) VALUES ('cp');
199 INSERT INTO t1 (a00) VALUES ('cq');
200 INSERT INTO t1 (a00) VALUES ('cr');
201 INSERT INTO t1 (a00) VALUES ('cs');
202 INSERT INTO t1 (a00) VALUES ('ct');
203 INSERT INTO t1 (a00) VALUES ('cu');
204 INSERT INTO t1 (a00) VALUES ('cv');
206 INSERT INTO t1 (a00) VALUES ('cw');
207 INSERT INTO t1 (a00) VALUES ('cx');
208 INSERT INTO t1 (a00) VALUES ('cy');
209 INSERT INTO t1 (a00) VALUES ('cz');
210 INSERT INTO t1 (a00) VALUES ('da');
211 INSERT INTO t1 (a00) VALUES ('db');
212 INSERT INTO t1 (a00) VALUES ('dc');
214 INSERT INTO t1 (a00) VALUES ('dd');
215 INSERT INTO t1 (a00) VALUES ('de');
216 INSERT INTO t1 (a00) VALUES ('df');
217 INSERT INTO t1 (a00) VALUES ('dg');
218 INSERT INTO t1 (a00) VALUES ('dh');
219 INSERT INTO t1 (a00) VALUES ('di');
220 INSERT INTO t1 (a00) VALUES ('dj');
222 INSERT INTO t1 (a00) VALUES ('dk');
223 INSERT INTO t1 (a00) VALUES ('dl');
224 INSERT INTO t1 (a00) VALUES ('dm');
225 INSERT INTO t1 (a00) VALUES ('dn');
226 INSERT INTO t1 (a00) VALUES ('do');
227 INSERT INTO t1 (a00) VALUES ('dp');
228 INSERT INTO t1 (a00) VALUES ('dq');
230 INSERT INTO t1 (a00) VALUES ('dr');
231 INSERT INTO t1 (a00) VALUES ('ds');
232 INSERT INTO t1 (a00) VALUES ('dt');
233 INSERT INTO t1 (a00) VALUES ('du');
234 INSERT INTO t1 (a00) VALUES ('dv');
235 INSERT INTO t1 (a00) VALUES ('dw');
236 INSERT INTO t1 (a00) VALUES ('dx');
238 INSERT INTO t1 (a00) VALUES ('dy');
239 INSERT INTO t1 (a00) VALUES ('dz');
240 INSERT INTO t1 (a00) VALUES ('ea');
241 INSERT INTO t1 (a00) VALUES ('eb');
242 INSERT INTO t1 (a00) VALUES ('ec');
243 INSERT INTO t1 (a00) VALUES ('ed');
244 INSERT INTO t1 (a00) VALUES ('ee');
246 INSERT INTO t1 (a00) VALUES ('ef');
247 INSERT INTO t1 (a00) VALUES ('eg');
248 INSERT INTO t1 (a00) VALUES ('eh');
249 INSERT INTO t1 (a00) VALUES ('ei');
250 INSERT INTO t1 (a00) VALUES ('ej');
251 INSERT INTO t1 (a00) VALUES ('ek');
252 INSERT INTO t1 (a00) VALUES ('el');
262 INSERT INTO t1 (a00) VALUES ('em');
263 INSERT INTO t1 (a00) VALUES ('en');
264 INSERT INTO t1 (a00) VALUES ('eo');
265 INSERT INTO t1 (a00) VALUES ('ep');
266 INSERT INTO t1 (a00) VALUES ('eq');
267 INSERT INTO t1 (a00) VALUES ('er');
268 INSERT INTO t1 (a00) VALUES ('es');
270 INSERT INTO t1 (a00) VALUES ('et');
271 INSERT INTO t1 (a00) VALUES ('eu');
272 INSERT INTO t1 (a00) VALUES ('ev');
273 INSERT INTO t1 (a00) VALUES ('ew');
274 INSERT INTO t1 (a00) VALUES ('ex');
275 INSERT INTO t1 (a00) VALUES ('ey');
276 INSERT INTO t1 (a00) VALUES ('ez');
278 INSERT INTO t1 (a00) VALUES ('fa');
279 INSERT INTO t1 (a00) VALUES ('fb');
280 INSERT INTO t1 (a00) VALUES ('fc');
281 INSERT INTO t1 (a00) VALUES ('fd');
282 INSERT INTO t1 (a00) VALUES ('fe');
283 INSERT INTO t1 (a00) VALUES ('ff');
284 INSERT INTO t1 (a00) VALUES ('fg');
286 INSERT INTO t1 (a00) VALUES ('fh');
287 INSERT INTO t1 (a00) VALUES ('fi');
288 INSERT INTO t1 (a00) VALUES ('fj');
289 INSERT INTO t1 (a00) VALUES ('fk');
290 INSERT INTO t1 (a00) VALUES ('fl');
291 INSERT INTO t1 (a00) VALUES ('fm');
292 INSERT INTO t1 (a00) VALUES ('fn');
294 INSERT INTO t1 (a00) VALUES ('fo');
295 INSERT INTO t1 (a00) VALUES ('fp');
296 INSERT INTO t1 (a00) VALUES ('fq');
297 INSERT INTO t1 (a00) VALUES ('fr');
298 INSERT INTO t1 (a00) VALUES ('fs');
299 INSERT INTO t1 (a00) VALUES ('ft');
300 INSERT INTO t1 (a00) VALUES ('fu');
302 INSERT INTO t1 (a00) VALUES ('fv');
303 INSERT INTO t1 (a00) VALUES ('fw');
304 INSERT INTO t1 (a00) VALUES ('fx');
305 INSERT INTO t1 (a00) VALUES ('fy');
306 INSERT INTO t1 (a00) VALUES ('fz');
307 INSERT INTO t1 (a00) VALUES ('ga');
308 INSERT INTO t1 (a00) VALUES ('gb');
310 INSERT INTO t1 (a00) VALUES ('gc');
311 INSERT INTO t1 (a00) VALUES ('gd');
312 INSERT INTO t1 (a00) VALUES ('ge');
313 INSERT INTO t1 (a00) VALUES ('gf');
314 INSERT INTO t1 (a00) VALUES ('gg');
315 INSERT INTO t1 (a00) VALUES ('gh');
337 INSERT INTO t1 (a00) VALUES ('bfa');
343 INSERT INTO t1 (a00) VALUES ('bfb');
348 SELECT a00,a01 FROM t1 WHERE a00 = 'aa';
349 SELECT a00,a01 FROM t1 WHERE a00 = 'aq';
350 # "where a00 = 'co'" is blocked because searching from smaller ('co','a','a',..).
351 SELECT a00,a01 FROM t1 WHERE a00 = 'cp';
352 SELECT a00,a01 FROM t1 WHERE a00 = 'el';
357 SELECT a00,a01 FROM t1 WHERE a00 = 'ar';
363 SELECT a00,a01 FROM t1 WHERE a00 = 'cn';
399 INSERT INTO t1 (a00) VALUES ('coa');
405 INSERT INTO t1 (a00) VALUES ('cob');
414 SELECT a00,a01 FROM t1 WHERE a00 = 'aa';
420 SELECT a00,a01 FROM t1 WHERE a00 = 'el';
454 INSERT INTO t1 (a00) VALUES ('gba');
460 INSERT INTO t1 (a00) VALUES ('gbb');
465 SELECT a00,a01 FROM t1 WHERE a00 = 'aa';
466 SELECT a00,a01 FROM t1 WHERE a00 = 'ek';
471 SELECT a00,a01 FROM t1 WHERE a00 = 'el';
477 SELECT a00,a01 FROM t1 WHERE a00 = 'gb';