2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
5
--source suite/engines/funcs/t/data1.inc
6
SELECT c1 FROM t1 GROUP BY c1;
7
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
8
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1;
9
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1;
10
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
11
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
12
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2;
13
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2;
14
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
15
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
16
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1;
17
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1;
19
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
20
--source suite/engines/funcs/t/data1.inc
21
SELECT c1 FROM t1 GROUP BY c1;
22
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
23
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1;
24
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1;
25
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
26
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
27
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2;
28
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2;
29
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
30
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
31
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1;
32
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1;
34
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
35
--source suite/engines/funcs/t/data1.inc
36
SELECT c1 FROM t1 GROUP BY c1;
37
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
38
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1;
39
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1;
40
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
41
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
42
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2;
43
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2;
44
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
45
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
46
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1;
47
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1;
49
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
50
--source suite/engines/funcs/t/data1.inc
51
SELECT c1 FROM t1 GROUP BY c1;
52
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
53
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1;
54
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1;
55
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
56
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
57
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2;
58
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2;
59
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
60
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
61
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1;
62
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1;
64
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
65
--source suite/engines/funcs/t/data1.inc
66
SELECT c1 FROM t1 GROUP BY c1;
67
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
68
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1;
69
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1;
70
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
71
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
72
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2;
73
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2;
74
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
75
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
76
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1;
77
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1;
79
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
80
--source suite/engines/funcs/t/data1.inc
81
SELECT c1 FROM t1 GROUP BY c1;
82
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
83
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1;
84
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1;
85
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
86
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
87
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2;
88
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2;
89
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
90
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
91
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1;
92
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1;
94
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
95
--source suite/engines/funcs/t/data1.inc
96
SELECT c1 FROM t1 GROUP BY c1;
97
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
98
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1;
99
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1;
100
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
101
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
102
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2;
103
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2;
104
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
105
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
106
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1;
107
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1;
109
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
110
--source suite/engines/funcs/t/data1.inc
111
SELECT c1 FROM t1 GROUP BY c1;
112
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
113
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1;
114
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1;
115
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
116
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
117
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2;
118
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2;
119
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
120
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
121
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1;
122
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1;
124
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
125
--source suite/engines/funcs/t/data1.inc
126
SELECT c1 FROM t1 GROUP BY c1;
127
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
128
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1;
129
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1;
130
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
131
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
132
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2;
133
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2;
134
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
135
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
136
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1;
137
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1;
139
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
140
--source suite/engines/funcs/t/data1.inc
141
SELECT c1 FROM t1 GROUP BY c1;
142
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
143
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1;
144
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1;
145
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
146
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
147
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2;
148
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2;
149
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
150
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
151
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1;
152
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1;
154
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
155
--source suite/engines/funcs/t/data1.inc
156
SELECT c1 FROM t1 GROUP BY c1;
157
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
158
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1;
159
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1;
160
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
161
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
162
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2;
163
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2;
164
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
165
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
166
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1;
167
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1;
169
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
170
--source suite/engines/funcs/t/data1.inc
171
SELECT c1 FROM t1 GROUP BY c1;
172
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
173
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1;
174
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1;
175
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
176
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
177
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2;
178
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2;
179
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
180
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
181
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1;
182
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1;
184
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
185
--source suite/engines/funcs/t/data1.inc
186
SELECT c1 FROM t1 GROUP BY c1;
187
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
188
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1;
189
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1;
190
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
191
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
192
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2;
193
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2;
194
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
195
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
196
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1;
197
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1;
199
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
200
--source suite/engines/funcs/t/data1.inc
201
SELECT c1 FROM t1 GROUP BY c1;
202
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
203
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1;
204
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1;
205
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
206
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
207
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2;
208
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2;
209
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
210
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
211
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1;
212
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1;
214
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
215
--source suite/engines/funcs/t/data1.inc
216
SELECT c1 FROM t1 GROUP BY c1;
217
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
218
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1;
219
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1;
220
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
221
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
222
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2;
223
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2;
224
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
225
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
226
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1;
227
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1;
229
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
230
--source suite/engines/funcs/t/data1.inc
231
SELECT c1 FROM t1 GROUP BY c1;
232
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
233
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1;
234
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1;
235
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
236
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
237
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2;
238
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2;
239
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
240
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
241
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1;
242
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1;
244
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
245
--source suite/engines/funcs/t/data1.inc
246
SELECT c1 FROM t1 GROUP BY c1;
247
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
248
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1;
249
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1;
250
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
251
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
252
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2;
253
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2;
254
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
255
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
256
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1;
257
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1;
259
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
260
--source suite/engines/funcs/t/data1.inc
261
SELECT c1 FROM t1 GROUP BY c1;
262
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
263
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1;
264
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1;
265
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
266
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
267
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2;
268
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2;
269
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
270
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
271
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1;
272
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1;
274
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
275
--source suite/engines/funcs/t/data1.inc
276
SELECT c1 FROM t1 GROUP BY c1;
277
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
278
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1;
279
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1;
280
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
281
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
282
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2;
283
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2;
284
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
285
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
286
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1;
287
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1;
289
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
290
--source suite/engines/funcs/t/data1.inc
291
SELECT c1 FROM t1 GROUP BY c1;
292
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
293
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1;
294
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1;
295
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
296
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
297
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2;
298
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2;
299
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
300
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
301
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1;
302
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1;
304
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
305
--source suite/engines/funcs/t/data1.inc
306
SELECT c1 FROM t1 GROUP BY c1;
307
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
308
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1;
309
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1;
310
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
311
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
312
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2;
313
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2;
314
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
315
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
316
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1;
317
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1;
319
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
320
--source suite/engines/funcs/t/data1.inc
321
SELECT c1 FROM t1 GROUP BY c1;
322
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
323
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1;
324
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1;
325
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
326
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
327
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2;
328
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2;
329
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
330
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
331
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1;
332
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1;
334
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
335
--source suite/engines/funcs/t/data1.inc
336
SELECT c1 FROM t1 GROUP BY c1;
337
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
338
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1;
339
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1;
340
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
341
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
342
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2;
343
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2;
344
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
345
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
346
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1;
347
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1;
349
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
350
--source suite/engines/funcs/t/data1.inc
351
SELECT c1 FROM t1 GROUP BY c1;
352
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
353
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1;
354
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1;
355
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
356
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
357
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2;
358
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2;
359
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
360
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
361
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1;
362
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1;
364
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
365
--source suite/engines/funcs/t/data1.inc
366
SELECT c1 FROM t1 GROUP BY c1;
367
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
368
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1;
369
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1;
370
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
371
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
372
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2;
373
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2;
374
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
375
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
376
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1;
377
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1;
379
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
380
--source suite/engines/funcs/t/data1.inc
381
SELECT c1 FROM t1 GROUP BY c1;
382
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
383
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1;
384
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1;
385
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
386
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
387
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2;
388
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2;
389
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
390
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
391
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1;
392
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1;
394
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
395
--source suite/engines/funcs/t/data1.inc
396
SELECT c1 FROM t1 GROUP BY c1;
397
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
398
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1;
399
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1;
400
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
401
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
402
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2;
403
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2;
404
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
405
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
406
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1;
407
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1;
409
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
410
--source suite/engines/funcs/t/data1.inc
411
SELECT c1 FROM t1 GROUP BY c1;
412
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
413
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1;
414
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1;
415
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
416
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
417
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2;
418
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2;
419
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
420
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
421
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1;
422
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1;
424
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
425
--source suite/engines/funcs/t/data1.inc
426
SELECT c1 FROM t1 GROUP BY c1;
427
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
428
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1;
429
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1;
430
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
431
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
432
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2;
433
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2;
434
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
435
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
436
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1;
437
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1;
439
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
440
--source suite/engines/funcs/t/data1.inc
441
SELECT c1 FROM t1 GROUP BY c1;
442
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
443
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1;
444
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1;
445
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
446
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
447
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2;
448
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2;
449
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
450
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
451
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1;
452
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1;
454
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
455
--source suite/engines/funcs/t/data1.inc
456
SELECT c1 FROM t1 GROUP BY c1;
457
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
458
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1;
459
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1;
460
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
461
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
462
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2;
463
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2;
464
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
465
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
466
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1;
467
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1;
469
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
470
--source suite/engines/funcs/t/data1.inc
471
SELECT c1 FROM t1 GROUP BY c1;
472
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
473
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1;
474
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1;
475
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
476
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
477
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2;
478
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2;
479
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
480
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
481
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1;
482
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1;
484
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
485
--source suite/engines/funcs/t/data1.inc
486
SELECT c1 FROM t1 GROUP BY c1;
487
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
488
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1;
489
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1;
490
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
491
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
492
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2;
493
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2;
494
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
495
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
496
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1;
497
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1;
499
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
500
--source suite/engines/funcs/t/data1.inc
501
SELECT c1 FROM t1 GROUP BY c1;
502
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
503
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1;
504
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1;
505
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
506
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
507
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2;
508
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2;
509
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
510
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
511
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1;
512
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1;
514
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
515
--source suite/engines/funcs/t/data1.inc
516
SELECT c1 FROM t1 GROUP BY c1;
517
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
518
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1;
519
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1;
520
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
521
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
522
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2;
523
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2;
524
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
525
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
526
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1;
527
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1;
529
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
530
--source suite/engines/funcs/t/data1.inc
531
SELECT c1 FROM t1 GROUP BY c1;
532
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
533
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1;
534
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1;
535
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
536
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
537
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2;
538
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2;
539
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
540
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
541
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1;
542
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1;
544
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
545
--source suite/engines/funcs/t/data1.inc
546
SELECT c1 FROM t1 GROUP BY c1;
547
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
548
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1;
549
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1;
550
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
551
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
552
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2;
553
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2;
554
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
555
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
556
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1;
557
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1;
559
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
560
--source suite/engines/funcs/t/data1.inc
561
SELECT c1 FROM t1 GROUP BY c1;
562
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
563
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1;
564
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1;
565
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
566
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
567
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2;
568
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2;
569
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
570
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
571
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1;
572
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1;
574
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
575
--source suite/engines/funcs/t/data1.inc
576
SELECT c1 FROM t1 GROUP BY c1;
577
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
578
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1;
579
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1;
580
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
581
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
582
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2;
583
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2;
584
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
585
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
586
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1;
587
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1;
589
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
590
--source suite/engines/funcs/t/data1.inc
591
SELECT c1 FROM t1 GROUP BY c1;
592
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
593
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1;
594
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1;
595
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
596
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
597
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2;
598
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2;
599
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
600
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
601
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1;
602
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1;
604
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
605
--source suite/engines/funcs/t/data1.inc
606
SELECT c1 FROM t1 GROUP BY c1;
607
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
608
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1;
609
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1;
610
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
611
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
612
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2;
613
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2;
614
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
615
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
616
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1;
617
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1;
619
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
620
--source suite/engines/funcs/t/data1.inc
621
SELECT c1 FROM t1 GROUP BY c1;
622
SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
623
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1;
624
SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1;
625
SELECT c1,c2 FROM t1 GROUP BY c1,c2;
626
SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
627
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2;
628
SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2;
629
SELECT c2,c1 FROM t1 GROUP BY c2,c1;
630
SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
631
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1;
632
SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1;