Debian Codegraph @

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