Debian Codegraph @

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

raw
1 --source include/no_valgrind_without_big.inc
2
3 --disable_warnings
4 DROP TABLE IF EXISTS t1;
5 --enable_warnings
6
7 --echo #------------------------------
8 --echo # Test CHAR 'a'
9 --echo #------------------------------
10 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
11 --source suite/engines/funcs/t/data1.inc
12 set @value := 'a';
13 --source suite/engines/funcs/t/se_string_groupby_statements.inc
14 DROP TABLE t1;
15
16 --echo #------------------------------
17 --echo # Test CHAR 'b'
18 --echo #------------------------------
19 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
20 --source suite/engines/funcs/t/data1.inc
21 set @value := 'b';
22 --source suite/engines/funcs/t/se_string_groupby_statements.inc
23 DROP TABLE t1;
24
25 --echo #------------------------------
26 --echo # Test CHAR 'c'
27 --echo #------------------------------
28 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
29 --source suite/engines/funcs/t/data1.inc
30 set @value := 'c';
31 --source suite/engines/funcs/t/se_string_groupby_statements.inc
32 DROP TABLE t1;
33
34 --echo #------------------------------
35 --echo # Test CHAR 'd'
36 --echo #------------------------------
37 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
38 --source suite/engines/funcs/t/data1.inc
39 set @value := 'd';
40 --source suite/engines/funcs/t/se_string_groupby_statements.inc
41 DROP TABLE t1;
42
43 --echo #------------------------------
44 --echo # Test CHAR 'e'
45 --echo #------------------------------
46 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
47 --source suite/engines/funcs/t/data1.inc
48 set @value := 'e';
49 --source suite/engines/funcs/t/se_string_groupby_statements.inc
50 DROP TABLE t1;
51
52 --echo #------------------------------
53 --echo # Test CHAR 'f'
54 --echo #------------------------------
55 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
56 --source suite/engines/funcs/t/data1.inc
57 set @value := 'f';
58 --source suite/engines/funcs/t/se_string_groupby_statements.inc
59 DROP TABLE t1;
60
61 --echo #------------------------------
62 --echo # Test CHAR 'y'
63 --echo #------------------------------
64 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
65 --source suite/engines/funcs/t/data1.inc
66 set @value := 'y';
67 --source suite/engines/funcs/t/se_string_groupby_statements.inc
68 DROP TABLE t1;
69
70 --echo #------------------------------
71 --echo # Test VARCHAR 'a'
72 --echo #------------------------------
73 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
74 --source suite/engines/funcs/t/data1.inc
75 set @value := 'a';
76 --source suite/engines/funcs/t/se_string_groupby_statements.inc
77 DROP TABLE t1;
78
79 --echo #------------------------------
80 --echo # Test VARCHAR 'b'
81 --echo #------------------------------
82 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
83 --source suite/engines/funcs/t/data1.inc
84 set @value := 'b';
85 --source suite/engines/funcs/t/se_string_groupby_statements.inc
86 DROP TABLE t1;
87
88 --echo #------------------------------
89 --echo # Test VARCHAR 'c'
90 --echo #------------------------------
91 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
92 --source suite/engines/funcs/t/data1.inc
93 set @value := 'c';
94 --source suite/engines/funcs/t/se_string_groupby_statements.inc
95 DROP TABLE t1;
96
97 --echo #------------------------------
98 --echo # Test VARCHAR 'd'
99 --echo #------------------------------
100 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
101 --source suite/engines/funcs/t/data1.inc
102 set @value := 'd';
103 --source suite/engines/funcs/t/se_string_groupby_statements.inc
104 DROP TABLE t1;
105
106 --echo #------------------------------
107 --echo # Test VARCHAR 'e'
108 --echo #------------------------------
109 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
110 --source suite/engines/funcs/t/data1.inc
111 set @value := 'e';
112 --source suite/engines/funcs/t/se_string_groupby_statements.inc
113 DROP TABLE t1;
114
115 --echo #------------------------------
116 --echo # Test VARCHAR 'f'
117 --echo #------------------------------
118 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
119 --source suite/engines/funcs/t/data1.inc
120 set @value := 'f';
121 --source suite/engines/funcs/t/se_string_groupby_statements.inc
122 DROP TABLE t1;
123
124 --echo #------------------------------
125 --echo # Test VARCHAR 'y'
126 --echo #------------------------------
127 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
128 --source suite/engines/funcs/t/data1.inc
129 set @value := 'y';
130 --source suite/engines/funcs/t/se_string_groupby_statements.inc
131 DROP TABLE t1;
132
133 --echo #------------------------------
134 --echo # Test BINARY 'a'
135 --echo #------------------------------
136 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
137 --source suite/engines/funcs/t/data1.inc
138 set @value := 'a';
139 --source suite/engines/funcs/t/se_string_groupby_statements.inc
140 DROP TABLE t1;
141
142 --echo #------------------------------
143 --echo # Test BINARY 'b'
144 --echo #------------------------------
145 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
146 --source suite/engines/funcs/t/data1.inc
147 set @value := 'b';
148 --source suite/engines/funcs/t/se_string_groupby_statements.inc
149 DROP TABLE t1;
150
151 --echo #------------------------------
152 --echo # Test BINARY 'c'
153 --echo #------------------------------
154 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
155 --source suite/engines/funcs/t/data1.inc
156 set @value := 'c';
157 --source suite/engines/funcs/t/se_string_groupby_statements.inc
158 DROP TABLE t1;
159
160 --echo #------------------------------
161 --echo # Test BINARY 'd'
162 --echo #------------------------------
163 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
164 --source suite/engines/funcs/t/data1.inc
165 set @value := 'd';
166 --source suite/engines/funcs/t/se_string_groupby_statements.inc
167 DROP TABLE t1;
168
169 --echo #------------------------------
170 --echo # Test BINARY 'e'
171 --echo #------------------------------
172 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
173 --source suite/engines/funcs/t/data1.inc
174 set @value := 'e';
175 --source suite/engines/funcs/t/se_string_groupby_statements.inc
176 DROP TABLE t1;
177
178 --echo #------------------------------
179 --echo # Test BINARY 'f'
180 --echo #------------------------------
181 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
182 --source suite/engines/funcs/t/data1.inc
183 set @value := 'f';
184 --source suite/engines/funcs/t/se_string_groupby_statements.inc
185 DROP TABLE t1;
186
187 --echo #------------------------------
188 --echo # Test BINARY 'y'
189 --echo #------------------------------
190 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
191 --source suite/engines/funcs/t/data1.inc
192 set @value := 'y';
193 --source suite/engines/funcs/t/se_string_groupby_statements.inc
194 DROP TABLE t1;
195
196 --echo #------------------------------
197 --echo # Test VARBINARY 'a'
198 --echo #------------------------------
199 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
200 --source suite/engines/funcs/t/data1.inc
201 set @value := 'a';
202 --source suite/engines/funcs/t/se_string_groupby_statements.inc
203 DROP TABLE t1;
204
205 --echo #------------------------------
206 --echo # Test VARBINARY 'b'
207 --echo #------------------------------
208 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
209 --source suite/engines/funcs/t/data1.inc
210 set @value := 'b';
211 --source suite/engines/funcs/t/se_string_groupby_statements.inc
212 DROP TABLE t1;
213
214 --echo #------------------------------
215 --echo # Test VARBINARY 'c'
216 --echo #------------------------------
217 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
218 --source suite/engines/funcs/t/data1.inc
219 set @value := 'c';
220 --source suite/engines/funcs/t/se_string_groupby_statements.inc
221 DROP TABLE t1;
222
223 --echo #------------------------------
224 --echo # Test VARBINARY 'd'
225 --echo #------------------------------
226 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
227 --source suite/engines/funcs/t/data1.inc
228 set @value := 'd';
229 --source suite/engines/funcs/t/se_string_groupby_statements.inc
230 DROP TABLE t1;
231
232 --echo #------------------------------
233 --echo # Test VARBINARY 'e'
234 --echo #------------------------------
235 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
236 --source suite/engines/funcs/t/data1.inc
237 set @value := 'e';
238 --source suite/engines/funcs/t/se_string_groupby_statements.inc
239 DROP TABLE t1;
240
241 --echo #------------------------------
242 --echo # Test VARBINARY 'f'
243 --echo #------------------------------
244 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
245 --source suite/engines/funcs/t/data1.inc
246 set @value := 'f';
247 --source suite/engines/funcs/t/se_string_groupby_statements.inc
248 DROP TABLE t1;
249
250 --echo #------------------------------
251 --echo # Test VARBINARY 'y'
252 --echo #------------------------------
253 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
254 --source suite/engines/funcs/t/data1.inc
255 set @value := 'y';
256 --source suite/engines/funcs/t/se_string_groupby_statements.inc
257 DROP TABLE t1;
258
259 --echo #------------------------------
260 --echo # Test BLOB 'a'
261 --echo #------------------------------
262 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
263 --source suite/engines/funcs/t/data1.inc
264 set @value := 'a';
265 --source suite/engines/funcs/t/se_string_groupby_statements.inc
266 DROP TABLE t1;
267
268 --echo #------------------------------
269 --echo # Test BLOB 'b'
270 --echo #------------------------------
271 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
272 --source suite/engines/funcs/t/data1.inc
273 set @value := 'b';
274 --source suite/engines/funcs/t/se_string_groupby_statements.inc
275 DROP TABLE t1;
276
277 --echo #------------------------------
278 --echo # Test BLOB 'c'
279 --echo #------------------------------
280 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
281 --source suite/engines/funcs/t/data1.inc
282 set @value := 'c';
283 --source suite/engines/funcs/t/se_string_groupby_statements.inc
284 DROP TABLE t1;
285
286 --echo #------------------------------
287 --echo # Test BLOB 'd'
288 --echo #------------------------------
289 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
290 --source suite/engines/funcs/t/data1.inc
291 set @value := 'd';
292 --source suite/engines/funcs/t/se_string_groupby_statements.inc
293 DROP TABLE t1;
294
295 --echo #------------------------------
296 --echo # Test BLOB 'e'
297 --echo #------------------------------
298 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
299 --source suite/engines/funcs/t/data1.inc
300 set @value := 'e';
301 --source suite/engines/funcs/t/se_string_groupby_statements.inc
302 DROP TABLE t1;
303
304 --echo #------------------------------
305 --echo # Test BLOB 'f'
306 --echo #------------------------------
307 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
308 --source suite/engines/funcs/t/data1.inc
309 set @value := 'f';
310 --source suite/engines/funcs/t/se_string_groupby_statements.inc
311 DROP TABLE t1;
312
313 --echo #------------------------------
314 --echo # Test BLOB 'y'
315 --echo #------------------------------
316 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
317 --source suite/engines/funcs/t/data1.inc
318 set @value := 'y';
319 --source suite/engines/funcs/t/se_string_groupby_statements.inc
320 DROP TABLE t1;
321
322 --echo #------------------------------
323 --echo # Test TEXT 'a'
324 --echo #------------------------------
325 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
326 --source suite/engines/funcs/t/data1.inc
327 set @value := 'a';
328 --source suite/engines/funcs/t/se_string_groupby_statements.inc
329 DROP TABLE t1;
330
331 --echo #------------------------------
332 --echo # Test TEXT 'b'
333 --echo #------------------------------
334 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
335 --source suite/engines/funcs/t/data1.inc
336 set @value := 'b';
337 --source suite/engines/funcs/t/se_string_groupby_statements.inc
338 DROP TABLE t1;
339
340 --echo #------------------------------
341 --echo # Test TEXT 'c'
342 --echo #------------------------------
343 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
344 --source suite/engines/funcs/t/data1.inc
345 set @value := 'c';
346 --source suite/engines/funcs/t/se_string_groupby_statements.inc
347 DROP TABLE t1;
348
349 --echo #------------------------------
350 --echo # Test TEXT 'd'
351 --echo #------------------------------
352 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
353 --source suite/engines/funcs/t/data1.inc
354 set @value := 'd';
355 --source suite/engines/funcs/t/se_string_groupby_statements.inc
356 DROP TABLE t1;
357
358 --echo #------------------------------
359 --echo # Test TEXT 'e'
360 --echo #------------------------------
361 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
362 --source suite/engines/funcs/t/data1.inc
363 set @value := 'e';
364 --source suite/engines/funcs/t/se_string_groupby_statements.inc
365 DROP TABLE t1;
366
367 --echo #------------------------------
368 --echo # Test TEXT 'f'
369 --echo #------------------------------
370 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
371 --source suite/engines/funcs/t/data1.inc
372 set @value := 'f';
373 --source suite/engines/funcs/t/se_string_groupby_statements.inc
374 DROP TABLE t1;
375
376 --echo #------------------------------
377 --echo # Test TEXT 'y'
378 --echo #------------------------------
379 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
380 --source suite/engines/funcs/t/data1.inc
381 set @value := 'e';
382 --source suite/engines/funcs/t/se_string_groupby_statements.inc
383 DROP TABLE t1;
384