Debian Codegraph @

mysql-test/suite/engines/funcs/t/se_string_limit.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
5 --source suite/engines/funcs/t/data1.inc
6 SELECT * FROM t1 LIMIT 1;
7 SELECT * FROM t1 WHERE c1='a' LIMIT 1;
8 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1;
9 DROP TABLE t1;
10 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
11 --source suite/engines/funcs/t/data1.inc
12 SELECT * FROM t1 LIMIT 1;
13 SELECT * FROM t1 WHERE c1='b' LIMIT 1;
14 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1;
15 DROP TABLE t1;
16 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
17 --source suite/engines/funcs/t/data1.inc
18 SELECT * FROM t1 LIMIT 1;
19 SELECT * FROM t1 WHERE c1='c' LIMIT 1;
20 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1;
21 DROP TABLE t1;
22 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
23 --source suite/engines/funcs/t/data1.inc
24 SELECT * FROM t1 LIMIT 1;
25 SELECT * FROM t1 WHERE c1='d' LIMIT 1;
26 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1;
27 DROP TABLE t1;
28 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
29 --source suite/engines/funcs/t/data1.inc
30 SELECT * FROM t1 LIMIT 1;
31 SELECT * FROM t1 WHERE c1='e' LIMIT 1;
32 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1;
33 DROP TABLE t1;
34 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
35 --source suite/engines/funcs/t/data1.inc
36 SELECT * FROM t1 LIMIT 1;
37 SELECT * FROM t1 WHERE c1='f' LIMIT 1;
38 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1;
39 DROP TABLE t1;
40 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
41 --source suite/engines/funcs/t/data1.inc
42 SELECT * FROM t1 LIMIT 1;
43 SELECT * FROM t1 WHERE c1='y' LIMIT 1;
44 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1;
45 DROP TABLE t1;
46 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
47 --source suite/engines/funcs/t/data1.inc
48 SELECT * FROM t1 LIMIT 1;
49 SELECT * FROM t1 WHERE c1='a' LIMIT 1;
50 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1;
51 DROP TABLE t1;
52 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
53 --source suite/engines/funcs/t/data1.inc
54 SELECT * FROM t1 LIMIT 1;
55 SELECT * FROM t1 WHERE c1='b' LIMIT 1;
56 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1;
57 DROP TABLE t1;
58 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
59 --source suite/engines/funcs/t/data1.inc
60 SELECT * FROM t1 LIMIT 1;
61 SELECT * FROM t1 WHERE c1='c' LIMIT 1;
62 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1;
63 DROP TABLE t1;
64 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
65 --source suite/engines/funcs/t/data1.inc
66 SELECT * FROM t1 LIMIT 1;
67 SELECT * FROM t1 WHERE c1='d' LIMIT 1;
68 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1;
69 DROP TABLE t1;
70 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
71 --source suite/engines/funcs/t/data1.inc
72 SELECT * FROM t1 LIMIT 1;
73 SELECT * FROM t1 WHERE c1='e' LIMIT 1;
74 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1;
75 DROP TABLE t1;
76 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
77 --source suite/engines/funcs/t/data1.inc
78 SELECT * FROM t1 LIMIT 1;
79 SELECT * FROM t1 WHERE c1='f' LIMIT 1;
80 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1;
81 DROP TABLE t1;
82 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
83 --source suite/engines/funcs/t/data1.inc
84 SELECT * FROM t1 LIMIT 1;
85 SELECT * FROM t1 WHERE c1='y' LIMIT 1;
86 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1;
87 DROP TABLE t1;
88 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
89 --source suite/engines/funcs/t/data1.inc
90 SELECT * FROM t1 LIMIT 1;
91 SELECT * FROM t1 WHERE c1='a' LIMIT 1;
92 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1;
93 DROP TABLE t1;
94 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
95 --source suite/engines/funcs/t/data1.inc
96 SELECT * FROM t1 LIMIT 1;
97 SELECT * FROM t1 WHERE c1='b' LIMIT 1;
98 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1;
99 DROP TABLE t1;
100 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
101 --source suite/engines/funcs/t/data1.inc
102 SELECT * FROM t1 LIMIT 1;
103 SELECT * FROM t1 WHERE c1='c' LIMIT 1;
104 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1;
105 DROP TABLE t1;
106 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
107 --source suite/engines/funcs/t/data1.inc
108 SELECT * FROM t1 LIMIT 1;
109 SELECT * FROM t1 WHERE c1='d' LIMIT 1;
110 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1;
111 DROP TABLE t1;
112 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
113 --source suite/engines/funcs/t/data1.inc
114 SELECT * FROM t1 LIMIT 1;
115 SELECT * FROM t1 WHERE c1='e' LIMIT 1;
116 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1;
117 DROP TABLE t1;
118 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
119 --source suite/engines/funcs/t/data1.inc
120 SELECT * FROM t1 LIMIT 1;
121 SELECT * FROM t1 WHERE c1='f' LIMIT 1;
122 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1;
123 DROP TABLE t1;
124 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
125 --source suite/engines/funcs/t/data1.inc
126 SELECT * FROM t1 LIMIT 1;
127 SELECT * FROM t1 WHERE c1='y' LIMIT 1;
128 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1;
129 DROP TABLE t1;
130 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
131 --source suite/engines/funcs/t/data1.inc
132 SELECT * FROM t1 LIMIT 1;
133 SELECT * FROM t1 WHERE c1='a' LIMIT 1;
134 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1;
135 DROP TABLE t1;
136 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
137 --source suite/engines/funcs/t/data1.inc
138 SELECT * FROM t1 LIMIT 1;
139 SELECT * FROM t1 WHERE c1='b' LIMIT 1;
140 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1;
141 DROP TABLE t1;
142 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
143 --source suite/engines/funcs/t/data1.inc
144 SELECT * FROM t1 LIMIT 1;
145 SELECT * FROM t1 WHERE c1='c' LIMIT 1;
146 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1;
147 DROP TABLE t1;
148 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
149 --source suite/engines/funcs/t/data1.inc
150 SELECT * FROM t1 LIMIT 1;
151 SELECT * FROM t1 WHERE c1='d' LIMIT 1;
152 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1;
153 DROP TABLE t1;
154 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
155 --source suite/engines/funcs/t/data1.inc
156 SELECT * FROM t1 LIMIT 1;
157 SELECT * FROM t1 WHERE c1='e' LIMIT 1;
158 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1;
159 DROP TABLE t1;
160 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
161 --source suite/engines/funcs/t/data1.inc
162 SELECT * FROM t1 LIMIT 1;
163 SELECT * FROM t1 WHERE c1='f' LIMIT 1;
164 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1;
165 DROP TABLE t1;
166 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
167 --source suite/engines/funcs/t/data1.inc
168 SELECT * FROM t1 LIMIT 1;
169 SELECT * FROM t1 WHERE c1='y' LIMIT 1;
170 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1;
171 DROP TABLE t1;
172 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
173 --source suite/engines/funcs/t/data1.inc
174 SELECT * FROM t1 LIMIT 1;
175 SELECT * FROM t1 WHERE c1='a' LIMIT 1;
176 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1;
177 DROP TABLE t1;
178 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
179 --source suite/engines/funcs/t/data1.inc
180 SELECT * FROM t1 LIMIT 1;
181 SELECT * FROM t1 WHERE c1='b' LIMIT 1;
182 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1;
183 DROP TABLE t1;
184 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
185 --source suite/engines/funcs/t/data1.inc
186 SELECT * FROM t1 LIMIT 1;
187 SELECT * FROM t1 WHERE c1='c' LIMIT 1;
188 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1;
189 DROP TABLE t1;
190 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
191 --source suite/engines/funcs/t/data1.inc
192 SELECT * FROM t1 LIMIT 1;
193 SELECT * FROM t1 WHERE c1='d' LIMIT 1;
194 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1;
195 DROP TABLE t1;
196 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
197 --source suite/engines/funcs/t/data1.inc
198 SELECT * FROM t1 LIMIT 1;
199 SELECT * FROM t1 WHERE c1='e' LIMIT 1;
200 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1;
201 DROP TABLE t1;
202 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
203 --source suite/engines/funcs/t/data1.inc
204 SELECT * FROM t1 LIMIT 1;
205 SELECT * FROM t1 WHERE c1='f' LIMIT 1;
206 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1;
207 DROP TABLE t1;
208 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
209 --source suite/engines/funcs/t/data1.inc
210 SELECT * FROM t1 LIMIT 1;
211 SELECT * FROM t1 WHERE c1='y' LIMIT 1;
212 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1;
213 DROP TABLE t1;
214 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
215 --source suite/engines/funcs/t/data1.inc
216 SELECT * FROM t1 LIMIT 1;
217 SELECT * FROM t1 WHERE c1='a' LIMIT 1;
218 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1;
219 DROP TABLE t1;
220 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
221 --source suite/engines/funcs/t/data1.inc
222 SELECT * FROM t1 LIMIT 1;
223 SELECT * FROM t1 WHERE c1='b' LIMIT 1;
224 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1;
225 DROP TABLE t1;
226 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
227 --source suite/engines/funcs/t/data1.inc
228 SELECT * FROM t1 LIMIT 1;
229 SELECT * FROM t1 WHERE c1='c' LIMIT 1;
230 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1;
231 DROP TABLE t1;
232 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
233 --source suite/engines/funcs/t/data1.inc
234 SELECT * FROM t1 LIMIT 1;
235 SELECT * FROM t1 WHERE c1='d' LIMIT 1;
236 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1;
237 DROP TABLE t1;
238 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
239 --source suite/engines/funcs/t/data1.inc
240 SELECT * FROM t1 LIMIT 1;
241 SELECT * FROM t1 WHERE c1='e' LIMIT 1;
242 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1;
243 DROP TABLE t1;
244 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
245 --source suite/engines/funcs/t/data1.inc
246 SELECT * FROM t1 LIMIT 1;
247 SELECT * FROM t1 WHERE c1='f' LIMIT 1;
248 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1;
249 DROP TABLE t1;
250 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
251 --source suite/engines/funcs/t/data1.inc
252 SELECT * FROM t1 LIMIT 1;
253 SELECT * FROM t1 WHERE c1='y' LIMIT 1;
254 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1;
255 DROP TABLE t1;
256 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
257 --source suite/engines/funcs/t/data1.inc
258 SELECT * FROM t1 LIMIT 5;
259 SELECT * FROM t1 WHERE c1='a' LIMIT 5;
260 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5;
261 DROP TABLE t1;
262 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
263 --source suite/engines/funcs/t/data1.inc
264 SELECT * FROM t1 LIMIT 5;
265 SELECT * FROM t1 WHERE c1='b' LIMIT 5;
266 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5;
267 DROP TABLE t1;
268 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
269 --source suite/engines/funcs/t/data1.inc
270 SELECT * FROM t1 LIMIT 5;
271 SELECT * FROM t1 WHERE c1='c' LIMIT 5;
272 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5;
273 DROP TABLE t1;
274 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
275 --source suite/engines/funcs/t/data1.inc
276 SELECT * FROM t1 LIMIT 5;
277 SELECT * FROM t1 WHERE c1='d' LIMIT 5;
278 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5;
279 DROP TABLE t1;
280 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
281 --source suite/engines/funcs/t/data1.inc
282 SELECT * FROM t1 LIMIT 5;
283 SELECT * FROM t1 WHERE c1='e' LIMIT 5;
284 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5;
285 DROP TABLE t1;
286 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
287 --source suite/engines/funcs/t/data1.inc
288 SELECT * FROM t1 LIMIT 5;
289 SELECT * FROM t1 WHERE c1='f' LIMIT 5;
290 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5;
291 DROP TABLE t1;
292 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
293 --source suite/engines/funcs/t/data1.inc
294 SELECT * FROM t1 LIMIT 5;
295 SELECT * FROM t1 WHERE c1='y' LIMIT 5;
296 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5;
297 DROP TABLE t1;
298 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
299 --source suite/engines/funcs/t/data1.inc
300 SELECT * FROM t1 LIMIT 5;
301 SELECT * FROM t1 WHERE c1='a' LIMIT 5;
302 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5;
303 DROP TABLE t1;
304 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
305 --source suite/engines/funcs/t/data1.inc
306 SELECT * FROM t1 LIMIT 5;
307 SELECT * FROM t1 WHERE c1='b' LIMIT 5;
308 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5;
309 DROP TABLE t1;
310 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
311 --source suite/engines/funcs/t/data1.inc
312 SELECT * FROM t1 LIMIT 5;
313 SELECT * FROM t1 WHERE c1='c' LIMIT 5;
314 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5;
315 DROP TABLE t1;
316 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
317 --source suite/engines/funcs/t/data1.inc
318 SELECT * FROM t1 LIMIT 5;
319 SELECT * FROM t1 WHERE c1='d' LIMIT 5;
320 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5;
321 DROP TABLE t1;
322 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
323 --source suite/engines/funcs/t/data1.inc
324 SELECT * FROM t1 LIMIT 5;
325 SELECT * FROM t1 WHERE c1='e' LIMIT 5;
326 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5;
327 DROP TABLE t1;
328 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
329 --source suite/engines/funcs/t/data1.inc
330 SELECT * FROM t1 LIMIT 5;
331 SELECT * FROM t1 WHERE c1='f' LIMIT 5;
332 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5;
333 DROP TABLE t1;
334 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
335 --source suite/engines/funcs/t/data1.inc
336 SELECT * FROM t1 LIMIT 5;
337 SELECT * FROM t1 WHERE c1='y' LIMIT 5;
338 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5;
339 DROP TABLE t1;
340 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
341 --source suite/engines/funcs/t/data1.inc
342 SELECT * FROM t1 LIMIT 5;
343 SELECT * FROM t1 WHERE c1='a' LIMIT 5;
344 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5;
345 DROP TABLE t1;
346 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
347 --source suite/engines/funcs/t/data1.inc
348 SELECT * FROM t1 LIMIT 5;
349 SELECT * FROM t1 WHERE c1='b' LIMIT 5;
350 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5;
351 DROP TABLE t1;
352 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
353 --source suite/engines/funcs/t/data1.inc
354 SELECT * FROM t1 LIMIT 5;
355 SELECT * FROM t1 WHERE c1='c' LIMIT 5;
356 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5;
357 DROP TABLE t1;
358 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
359 --source suite/engines/funcs/t/data1.inc
360 SELECT * FROM t1 LIMIT 5;
361 SELECT * FROM t1 WHERE c1='d' LIMIT 5;
362 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5;
363 DROP TABLE t1;
364 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
365 --source suite/engines/funcs/t/data1.inc
366 SELECT * FROM t1 LIMIT 5;
367 SELECT * FROM t1 WHERE c1='e' LIMIT 5;
368 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5;
369 DROP TABLE t1;
370 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
371 --source suite/engines/funcs/t/data1.inc
372 SELECT * FROM t1 LIMIT 5;
373 SELECT * FROM t1 WHERE c1='f' LIMIT 5;
374 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5;
375 DROP TABLE t1;
376 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
377 --source suite/engines/funcs/t/data1.inc
378 SELECT * FROM t1 LIMIT 5;
379 SELECT * FROM t1 WHERE c1='y' LIMIT 5;
380 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5;
381 DROP TABLE t1;
382 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
383 --source suite/engines/funcs/t/data1.inc
384 SELECT * FROM t1 LIMIT 5;
385 SELECT * FROM t1 WHERE c1='a' LIMIT 5;
386 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5;
387 DROP TABLE t1;
388 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
389 --source suite/engines/funcs/t/data1.inc
390 SELECT * FROM t1 LIMIT 5;
391 SELECT * FROM t1 WHERE c1='b' LIMIT 5;
392 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5;
393 DROP TABLE t1;
394 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
395 --source suite/engines/funcs/t/data1.inc
396 SELECT * FROM t1 LIMIT 5;
397 SELECT * FROM t1 WHERE c1='c' LIMIT 5;
398 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5;
399 DROP TABLE t1;
400 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
401 --source suite/engines/funcs/t/data1.inc
402 SELECT * FROM t1 LIMIT 5;
403 SELECT * FROM t1 WHERE c1='d' LIMIT 5;
404 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5;
405 DROP TABLE t1;
406 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
407 --source suite/engines/funcs/t/data1.inc
408 SELECT * FROM t1 LIMIT 5;
409 SELECT * FROM t1 WHERE c1='e' LIMIT 5;
410 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5;
411 DROP TABLE t1;
412 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
413 --source suite/engines/funcs/t/data1.inc
414 SELECT * FROM t1 LIMIT 5;
415 SELECT * FROM t1 WHERE c1='f' LIMIT 5;
416 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5;
417 DROP TABLE t1;
418 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
419 --source suite/engines/funcs/t/data1.inc
420 SELECT * FROM t1 LIMIT 5;
421 SELECT * FROM t1 WHERE c1='y' LIMIT 5;
422 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5;
423 DROP TABLE t1;
424 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
425 --source suite/engines/funcs/t/data1.inc
426 SELECT * FROM t1 LIMIT 5;
427 SELECT * FROM t1 WHERE c1='a' LIMIT 5;
428 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5;
429 DROP TABLE t1;
430 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
431 --source suite/engines/funcs/t/data1.inc
432 SELECT * FROM t1 LIMIT 5;
433 SELECT * FROM t1 WHERE c1='b' LIMIT 5;
434 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5;
435 DROP TABLE t1;
436 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
437 --source suite/engines/funcs/t/data1.inc
438 SELECT * FROM t1 LIMIT 5;
439 SELECT * FROM t1 WHERE c1='c' LIMIT 5;
440 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5;
441 DROP TABLE t1;
442 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
443 --source suite/engines/funcs/t/data1.inc
444 SELECT * FROM t1 LIMIT 5;
445 SELECT * FROM t1 WHERE c1='d' LIMIT 5;
446 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5;
447 DROP TABLE t1;
448 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
449 --source suite/engines/funcs/t/data1.inc
450 SELECT * FROM t1 LIMIT 5;
451 SELECT * FROM t1 WHERE c1='e' LIMIT 5;
452 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5;
453 DROP TABLE t1;
454 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
455 --source suite/engines/funcs/t/data1.inc
456 SELECT * FROM t1 LIMIT 5;
457 SELECT * FROM t1 WHERE c1='f' LIMIT 5;
458 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5;
459 DROP TABLE t1;
460 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
461 --source suite/engines/funcs/t/data1.inc
462 SELECT * FROM t1 LIMIT 5;
463 SELECT * FROM t1 WHERE c1='y' LIMIT 5;
464 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5;
465 DROP TABLE t1;
466 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
467 --source suite/engines/funcs/t/data1.inc
468 SELECT * FROM t1 LIMIT 5;
469 SELECT * FROM t1 WHERE c1='a' LIMIT 5;
470 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5;
471 DROP TABLE t1;
472 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
473 --source suite/engines/funcs/t/data1.inc
474 SELECT * FROM t1 LIMIT 5;
475 SELECT * FROM t1 WHERE c1='b' LIMIT 5;
476 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5;
477 DROP TABLE t1;
478 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
479 --source suite/engines/funcs/t/data1.inc
480 SELECT * FROM t1 LIMIT 5;
481 SELECT * FROM t1 WHERE c1='c' LIMIT 5;
482 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5;
483 DROP TABLE t1;
484 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
485 --source suite/engines/funcs/t/data1.inc
486 SELECT * FROM t1 LIMIT 5;
487 SELECT * FROM t1 WHERE c1='d' LIMIT 5;
488 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5;
489 DROP TABLE t1;
490 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
491 --source suite/engines/funcs/t/data1.inc
492 SELECT * FROM t1 LIMIT 5;
493 SELECT * FROM t1 WHERE c1='e' LIMIT 5;
494 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5;
495 DROP TABLE t1;
496 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
497 --source suite/engines/funcs/t/data1.inc
498 SELECT * FROM t1 LIMIT 5;
499 SELECT * FROM t1 WHERE c1='f' LIMIT 5;
500 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5;
501 DROP TABLE t1;
502 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
503 --source suite/engines/funcs/t/data1.inc
504 SELECT * FROM t1 LIMIT 5;
505 SELECT * FROM t1 WHERE c1='y' LIMIT 5;
506 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5;
507 DROP TABLE t1;
508 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
509 --source suite/engines/funcs/t/data1.inc
510 SELECT * FROM t1 LIMIT 100;
511 SELECT * FROM t1 WHERE c1='a' LIMIT 100;
512 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100;
513 DROP TABLE t1;
514 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
515 --source suite/engines/funcs/t/data1.inc
516 SELECT * FROM t1 LIMIT 100;
517 SELECT * FROM t1 WHERE c1='b' LIMIT 100;
518 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100;
519 DROP TABLE t1;
520 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
521 --source suite/engines/funcs/t/data1.inc
522 SELECT * FROM t1 LIMIT 100;
523 SELECT * FROM t1 WHERE c1='c' LIMIT 100;
524 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100;
525 DROP TABLE t1;
526 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
527 --source suite/engines/funcs/t/data1.inc
528 SELECT * FROM t1 LIMIT 100;
529 SELECT * FROM t1 WHERE c1='d' LIMIT 100;
530 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100;
531 DROP TABLE t1;
532 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
533 --source suite/engines/funcs/t/data1.inc
534 SELECT * FROM t1 LIMIT 100;
535 SELECT * FROM t1 WHERE c1='e' LIMIT 100;
536 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100;
537 DROP TABLE t1;
538 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
539 --source suite/engines/funcs/t/data1.inc
540 SELECT * FROM t1 LIMIT 100;
541 SELECT * FROM t1 WHERE c1='f' LIMIT 100;
542 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100;
543 DROP TABLE t1;
544 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
545 --source suite/engines/funcs/t/data1.inc
546 SELECT * FROM t1 LIMIT 100;
547 SELECT * FROM t1 WHERE c1='y' LIMIT 100;
548 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100;
549 DROP TABLE t1;
550 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
551 --source suite/engines/funcs/t/data1.inc
552 SELECT * FROM t1 LIMIT 100;
553 SELECT * FROM t1 WHERE c1='a' LIMIT 100;
554 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100;
555 DROP TABLE t1;
556 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
557 --source suite/engines/funcs/t/data1.inc
558 SELECT * FROM t1 LIMIT 100;
559 SELECT * FROM t1 WHERE c1='b' LIMIT 100;
560 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100;
561 DROP TABLE t1;
562 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
563 --source suite/engines/funcs/t/data1.inc
564 SELECT * FROM t1 LIMIT 100;
565 SELECT * FROM t1 WHERE c1='c' LIMIT 100;
566 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100;
567 DROP TABLE t1;
568 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
569 --source suite/engines/funcs/t/data1.inc
570 SELECT * FROM t1 LIMIT 100;
571 SELECT * FROM t1 WHERE c1='d' LIMIT 100;
572 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100;
573 DROP TABLE t1;
574 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
575 --source suite/engines/funcs/t/data1.inc
576 SELECT * FROM t1 LIMIT 100;
577 SELECT * FROM t1 WHERE c1='e' LIMIT 100;
578 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100;
579 DROP TABLE t1;
580 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
581 --source suite/engines/funcs/t/data1.inc
582 SELECT * FROM t1 LIMIT 100;
583 SELECT * FROM t1 WHERE c1='f' LIMIT 100;
584 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100;
585 DROP TABLE t1;
586 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
587 --source suite/engines/funcs/t/data1.inc
588 SELECT * FROM t1 LIMIT 100;
589 SELECT * FROM t1 WHERE c1='y' LIMIT 100;
590 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100;
591 DROP TABLE t1;
592 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
593 --source suite/engines/funcs/t/data1.inc
594 SELECT * FROM t1 LIMIT 100;
595 SELECT * FROM t1 WHERE c1='a' LIMIT 100;
596 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100;
597 DROP TABLE t1;
598 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
599 --source suite/engines/funcs/t/data1.inc
600 SELECT * FROM t1 LIMIT 100;
601 SELECT * FROM t1 WHERE c1='b' LIMIT 100;
602 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100;
603 DROP TABLE t1;
604 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
605 --source suite/engines/funcs/t/data1.inc
606 SELECT * FROM t1 LIMIT 100;
607 SELECT * FROM t1 WHERE c1='c' LIMIT 100;
608 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100;
609 DROP TABLE t1;
610 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
611 --source suite/engines/funcs/t/data1.inc
612 SELECT * FROM t1 LIMIT 100;
613 SELECT * FROM t1 WHERE c1='d' LIMIT 100;
614 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100;
615 DROP TABLE t1;
616 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
617 --source suite/engines/funcs/t/data1.inc
618 SELECT * FROM t1 LIMIT 100;
619 SELECT * FROM t1 WHERE c1='e' LIMIT 100;
620 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100;
621 DROP TABLE t1;
622 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
623 --source suite/engines/funcs/t/data1.inc
624 SELECT * FROM t1 LIMIT 100;
625 SELECT * FROM t1 WHERE c1='f' LIMIT 100;
626 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100;
627 DROP TABLE t1;
628 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
629 --source suite/engines/funcs/t/data1.inc
630 SELECT * FROM t1 LIMIT 100;
631 SELECT * FROM t1 WHERE c1='y' LIMIT 100;
632 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100;
633 DROP TABLE t1;
634 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
635 --source suite/engines/funcs/t/data1.inc
636 SELECT * FROM t1 LIMIT 100;
637 SELECT * FROM t1 WHERE c1='a' LIMIT 100;
638 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100;
639 DROP TABLE t1;
640 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
641 --source suite/engines/funcs/t/data1.inc
642 SELECT * FROM t1 LIMIT 100;
643 SELECT * FROM t1 WHERE c1='b' LIMIT 100;
644 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100;
645 DROP TABLE t1;
646 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
647 --source suite/engines/funcs/t/data1.inc
648 SELECT * FROM t1 LIMIT 100;
649 SELECT * FROM t1 WHERE c1='c' LIMIT 100;
650 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100;
651 DROP TABLE t1;
652 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
653 --source suite/engines/funcs/t/data1.inc
654 SELECT * FROM t1 LIMIT 100;
655 SELECT * FROM t1 WHERE c1='d' LIMIT 100;
656 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100;
657 DROP TABLE t1;
658 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
659 --source suite/engines/funcs/t/data1.inc
660 SELECT * FROM t1 LIMIT 100;
661 SELECT * FROM t1 WHERE c1='e' LIMIT 100;
662 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100;
663 DROP TABLE t1;
664 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
665 --source suite/engines/funcs/t/data1.inc
666 SELECT * FROM t1 LIMIT 100;
667 SELECT * FROM t1 WHERE c1='f' LIMIT 100;
668 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100;
669 DROP TABLE t1;
670 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
671 --source suite/engines/funcs/t/data1.inc
672 SELECT * FROM t1 LIMIT 100;
673 SELECT * FROM t1 WHERE c1='y' LIMIT 100;
674 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100;
675 DROP TABLE t1;
676 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
677 --source suite/engines/funcs/t/data1.inc
678 SELECT * FROM t1 LIMIT 100;
679 SELECT * FROM t1 WHERE c1='a' LIMIT 100;
680 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100;
681 DROP TABLE t1;
682 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
683 --source suite/engines/funcs/t/data1.inc
684 SELECT * FROM t1 LIMIT 100;
685 SELECT * FROM t1 WHERE c1='b' LIMIT 100;
686 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100;
687 DROP TABLE t1;
688 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
689 --source suite/engines/funcs/t/data1.inc
690 SELECT * FROM t1 LIMIT 100;
691 SELECT * FROM t1 WHERE c1='c' LIMIT 100;
692 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100;
693 DROP TABLE t1;
694 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
695 --source suite/engines/funcs/t/data1.inc
696 SELECT * FROM t1 LIMIT 100;
697 SELECT * FROM t1 WHERE c1='d' LIMIT 100;
698 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100;
699 DROP TABLE t1;
700 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
701 --source suite/engines/funcs/t/data1.inc
702 SELECT * FROM t1 LIMIT 100;
703 SELECT * FROM t1 WHERE c1='e' LIMIT 100;
704 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100;
705 DROP TABLE t1;
706 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
707 --source suite/engines/funcs/t/data1.inc
708 SELECT * FROM t1 LIMIT 100;
709 SELECT * FROM t1 WHERE c1='f' LIMIT 100;
710 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100;
711 DROP TABLE t1;
712 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
713 --source suite/engines/funcs/t/data1.inc
714 SELECT * FROM t1 LIMIT 100;
715 SELECT * FROM t1 WHERE c1='y' LIMIT 100;
716 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100;
717 DROP TABLE t1;
718 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
719 --source suite/engines/funcs/t/data1.inc
720 SELECT * FROM t1 LIMIT 100;
721 SELECT * FROM t1 WHERE c1='a' LIMIT 100;
722 SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100;
723 DROP TABLE t1;
724 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
725 --source suite/engines/funcs/t/data1.inc
726 SELECT * FROM t1 LIMIT 100;
727 SELECT * FROM t1 WHERE c1='b' LIMIT 100;
728 SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100;
729 DROP TABLE t1;
730 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
731 --source suite/engines/funcs/t/data1.inc
732 SELECT * FROM t1 LIMIT 100;
733 SELECT * FROM t1 WHERE c1='c' LIMIT 100;
734 SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100;
735 DROP TABLE t1;
736 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
737 --source suite/engines/funcs/t/data1.inc
738 SELECT * FROM t1 LIMIT 100;
739 SELECT * FROM t1 WHERE c1='d' LIMIT 100;
740 SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100;
741 DROP TABLE t1;
742 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
743 --source suite/engines/funcs/t/data1.inc
744 SELECT * FROM t1 LIMIT 100;
745 SELECT * FROM t1 WHERE c1='e' LIMIT 100;
746 SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100;
747 DROP TABLE t1;
748 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
749 --source suite/engines/funcs/t/data1.inc
750 SELECT * FROM t1 LIMIT 100;
751 SELECT * FROM t1 WHERE c1='f' LIMIT 100;
752 SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100;
753 DROP TABLE t1;
754 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
755 --source suite/engines/funcs/t/data1.inc
756 SELECT * FROM t1 LIMIT 100;
757 SELECT * FROM t1 WHERE c1='y' LIMIT 100;
758 SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100;
759 DROP TABLE t1;
760