Debian Codegraph @

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

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