Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
5 --source suite/engines/funcs/t/data1.inc
6 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
7 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
8 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 1;
9 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
10 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
11 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
12 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 1;
13 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
14 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
15 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
16 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 1;
17 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
18 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
22 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
23 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 1;
24 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
25 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
26 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
27 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 1;
28 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
29 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
30 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
31 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 1;
32 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
33 DROP TABLE t1;
34 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
35 --source suite/engines/funcs/t/data1.inc
36 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
37 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
38 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 1;
39 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
40 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
41 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
42 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 1;
43 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
44 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
45 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
46 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 1;
47 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
48 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
52 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
53 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 1;
54 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
55 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
56 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
57 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 1;
58 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
59 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
60 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
61 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 1;
62 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
63 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
67 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
68 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 1;
69 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
70 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
71 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
72 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 1;
73 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
74 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
75 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
76 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 1;
77 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
78 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
82 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
83 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 1;
84 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
85 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
86 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
87 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 1;
88 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
89 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
90 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
91 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 1;
92 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
93 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
97 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
98 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 1;
99 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
100 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
101 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
102 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 1;
103 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
104 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
105 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
106 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 1;
107 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
108 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
112 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
113 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 1;
114 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
115 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
116 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
117 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 1;
118 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
119 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
120 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
121 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 1;
122 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
123 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
127 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
128 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 1;
129 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
130 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
131 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
132 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 1;
133 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
134 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
135 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
136 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 1;
137 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
138 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
142 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
143 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 1;
144 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
145 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
146 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
147 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 1;
148 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
149 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
150 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
151 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 1;
152 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
153 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
157 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
158 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 1;
159 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
160 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
161 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
162 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 1;
163 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
164 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
165 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
166 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 1;
167 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
168 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
172 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
173 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 1;
174 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
175 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
176 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
177 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 1;
178 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
179 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
180 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
181 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 1;
182 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
183 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
187 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
188 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 1;
189 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
190 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
191 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
192 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 1;
193 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
194 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
195 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
196 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 1;
197 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
198 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
202 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
203 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 1;
204 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
205 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
206 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
207 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 1;
208 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
209 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
210 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
211 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 1;
212 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
213 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
217 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
218 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 1;
219 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
220 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
221 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
222 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 1;
223 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
224 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
225 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
226 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 1;
227 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
228 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
232 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
233 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 1;
234 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
235 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
236 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
237 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 1;
238 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
239 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
240 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
241 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 1;
242 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
243 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
247 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
248 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 1;
249 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
250 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
251 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
252 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 1;
253 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
254 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
255 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
256 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 1;
257 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
258 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
262 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
263 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 1;
264 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
265 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
266 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
267 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 1;
268 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
269 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
270 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
271 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 1;
272 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
273 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
277 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
278 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 1;
279 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
280 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
281 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
282 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 1;
283 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
284 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
285 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
286 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 1;
287 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
288 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
292 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
293 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 1;
294 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
295 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
296 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
297 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 1;
298 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
299 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
300 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
301 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 1;
302 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
303 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
307 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
308 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 1;
309 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
310 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
311 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
312 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 1;
313 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
314 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
315 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
316 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 1;
317 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
318 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
322 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
323 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 1;
324 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
325 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
326 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
327 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 1;
328 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
329 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
330 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
331 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 1;
332 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
333 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
337 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
338 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 1;
339 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
340 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
341 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
342 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 1;
343 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
344 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
345 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
346 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 1;
347 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
348 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
352 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
353 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 1;
354 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
355 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
356 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
357 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 1;
358 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
359 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
360 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
361 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 1;
362 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
363 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
367 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
368 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 1;
369 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
370 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
371 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
372 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 1;
373 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
374 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
375 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
376 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 1;
377 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
378 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
382 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
383 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 1;
384 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
385 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
386 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
387 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 1;
388 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
389 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
390 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
391 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 1;
392 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
393 DROP TABLE t1;
394 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
395 --source suite/engines/funcs/t/data1.inc
396 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
397 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
398 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 1;
399 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
400 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
401 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
402 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 1;
403 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
404 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
405 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
406 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 1;
407 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
408 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
412 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
413 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 1;
414 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
415 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
416 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
417 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 1;
418 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
419 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
420 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
421 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 1;
422 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
423 DROP TABLE t1;
424 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
425 --source suite/engines/funcs/t/data1.inc
426 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
427 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
428 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 1;
429 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
430 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
431 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
432 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 1;
433 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
434 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
435 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
436 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 1;
437 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
438 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
442 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
443 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 1;
444 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
445 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
446 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
447 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 1;
448 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
449 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
450 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
451 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 1;
452 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
453 DROP TABLE t1;
454 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
455 --source suite/engines/funcs/t/data1.inc
456 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
457 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
458 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 1;
459 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
460 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
461 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
462 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 1;
463 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
464 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
465 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
466 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 1;
467 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
468 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
472 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
473 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 1;
474 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
475 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
476 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
477 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 1;
478 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
479 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
480 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
481 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 1;
482 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
483 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
487 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
488 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 1;
489 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
490 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
491 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
492 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 1;
493 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
494 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
495 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
496 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 1;
497 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
498 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
502 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
503 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 1;
504 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
505 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
506 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
507 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 1;
508 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
509 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
510 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
511 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 1;
512 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
513 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
517 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
518 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 1;
519 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
520 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
521 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
522 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 1;
523 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
524 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
525 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
526 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 1;
527 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
528 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
532 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
533 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 1;
534 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
535 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
536 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
537 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 1;
538 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
539 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
540 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
541 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 1;
542 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
543 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
547 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
548 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 1;
549 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
550 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
551 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
552 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 1;
553 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
554 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
555 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
556 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 1;
557 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
558 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
562 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
563 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 1;
564 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
565 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
566 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
567 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 1;
568 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
569 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
570 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
571 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 1;
572 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
573 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
577 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
578 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 1;
579 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
580 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
581 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
582 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 1;
583 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
584 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
585 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
586 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 1;
587 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
588 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
592 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
593 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 1;
594 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
595 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
596 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
597 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 1;
598 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
599 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
600 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
601 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 1;
602 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
603 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
607 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
608 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 1;
609 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
610 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
611 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
612 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 1;
613 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
614 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
615 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
616 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 1;
617 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
618 DROP TABLE t1;
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 HAVING COUNT(*) = 1;
622 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 1;
623 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 1;
624 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 1;
625 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
626 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 1;
627 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 1;
628 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 1;
629 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
630 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 1;
631 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 1;
632 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 1;
633 DROP TABLE t1;
634 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
635 --source suite/engines/funcs/t/data1.inc
636 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
637 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
638 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 2;
639 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
640 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
641 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
642 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 2;
643 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
644 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
645 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
646 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 2;
647 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
648 DROP TABLE t1;
649 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
650 --source suite/engines/funcs/t/data1.inc
651 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
652 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
653 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 2;
654 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
655 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
656 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
657 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 2;
658 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
659 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
660 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
661 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 2;
662 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
663 DROP TABLE t1;
664 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
665 --source suite/engines/funcs/t/data1.inc
666 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
667 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
668 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 2;
669 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
670 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
671 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
672 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 2;
673 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
674 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
675 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
676 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 2;
677 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
678 DROP TABLE t1;
679 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
680 --source suite/engines/funcs/t/data1.inc
681 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
682 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
683 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 2;
684 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
685 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
686 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
687 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 2;
688 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
689 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
690 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
691 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 2;
692 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
693 DROP TABLE t1;
694 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
695 --source suite/engines/funcs/t/data1.inc
696 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
697 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
698 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 2;
699 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
700 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
701 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
702 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 2;
703 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
704 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
705 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
706 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 2;
707 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
708 DROP TABLE t1;
709 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
710 --source suite/engines/funcs/t/data1.inc
711 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
712 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
713 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 2;
714 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
715 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
716 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
717 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 2;
718 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
719 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
720 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
721 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 2;
722 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
723 DROP TABLE t1;
724 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
725 --source suite/engines/funcs/t/data1.inc
726 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
727 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
728 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 2;
729 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
730 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
731 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
732 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 2;
733 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
734 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
735 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
736 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 2;
737 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
738 DROP TABLE t1;
739 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
740 --source suite/engines/funcs/t/data1.inc
741 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
742 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
743 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 2;
744 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
745 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
746 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
747 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 2;
748 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
749 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
750 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
751 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 2;
752 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
753 DROP TABLE t1;
754 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
755 --source suite/engines/funcs/t/data1.inc
756 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
757 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
758 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 2;
759 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
760 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
761 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
762 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 2;
763 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
764 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
765 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
766 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 2;
767 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
768 DROP TABLE t1;
769 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
770 --source suite/engines/funcs/t/data1.inc
771 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
772 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
773 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 2;
774 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
775 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
776 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
777 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 2;
778 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
779 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
780 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
781 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 2;
782 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
783 DROP TABLE t1;
784 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
785 --source suite/engines/funcs/t/data1.inc
786 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
787 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
788 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 2;
789 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
790 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
791 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
792 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 2;
793 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
794 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
795 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
796 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 2;
797 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
798 DROP TABLE t1;
799 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
800 --source suite/engines/funcs/t/data1.inc
801 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
802 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
803 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 2;
804 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
805 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
806 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
807 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 2;
808 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
809 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
810 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
811 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 2;
812 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
813 DROP TABLE t1;
814 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
815 --source suite/engines/funcs/t/data1.inc
816 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
817 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
818 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 2;
819 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
820 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
821 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
822 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 2;
823 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
824 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
825 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
826 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 2;
827 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
828 DROP TABLE t1;
829 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
830 --source suite/engines/funcs/t/data1.inc
831 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
832 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
833 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 2;
834 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
835 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
836 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
837 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 2;
838 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
839 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
840 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
841 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 2;
842 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
843 DROP TABLE t1;
844 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
845 --source suite/engines/funcs/t/data1.inc
846 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
847 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
848 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 2;
849 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
850 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
851 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
852 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 2;
853 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
854 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
855 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
856 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 2;
857 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
858 DROP TABLE t1;
859 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
860 --source suite/engines/funcs/t/data1.inc
861 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
862 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
863 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 2;
864 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
865 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
866 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
867 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 2;
868 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
869 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
870 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
871 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 2;
872 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
873 DROP TABLE t1;
874 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
875 --source suite/engines/funcs/t/data1.inc
876 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
877 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
878 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 2;
879 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
880 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
881 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
882 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 2;
883 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
884 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
885 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
886 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 2;
887 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
888 DROP TABLE t1;
889 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
890 --source suite/engines/funcs/t/data1.inc
891 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
892 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
893 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 2;
894 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
895 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
896 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
897 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 2;
898 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
899 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
900 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
901 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 2;
902 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
903 DROP TABLE t1;
904 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
905 --source suite/engines/funcs/t/data1.inc
906 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
907 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
908 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 2;
909 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
910 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
911 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
912 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 2;
913 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
914 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
915 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
916 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 2;
917 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
918 DROP TABLE t1;
919 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
920 --source suite/engines/funcs/t/data1.inc
921 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
922 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
923 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 2;
924 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
925 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
926 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
927 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 2;
928 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
929 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
930 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
931 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 2;
932 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
933 DROP TABLE t1;
934 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
935 --source suite/engines/funcs/t/data1.inc
936 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
937 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
938 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 2;
939 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
940 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
941 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
942 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 2;
943 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
944 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
945 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
946 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 2;
947 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
948 DROP TABLE t1;
949 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
950 --source suite/engines/funcs/t/data1.inc
951 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
952 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
953 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 2;
954 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
955 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
956 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
957 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 2;
958 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
959 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
960 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
961 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 2;
962 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
963 DROP TABLE t1;
964 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
965 --source suite/engines/funcs/t/data1.inc
966 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
967 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
968 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 2;
969 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
970 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
971 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
972 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 2;
973 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
974 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
975 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
976 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 2;
977 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
978 DROP TABLE t1;
979 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
980 --source suite/engines/funcs/t/data1.inc
981 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
982 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
983 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 2;
984 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
985 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
986 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
987 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 2;
988 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
989 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
990 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
991 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 2;
992 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
993 DROP TABLE t1;
994 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
995 --source suite/engines/funcs/t/data1.inc
996 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
997 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
998 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 2;
999 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1000 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1001 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1002 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1003 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1004 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1005 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1006 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1007 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1008 DROP TABLE t1;
1009 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1010 --source suite/engines/funcs/t/data1.inc
1011 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1012 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1013 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 2;
1014 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1015 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1016 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1017 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1018 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1019 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1020 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1021 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1022 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1023 DROP TABLE t1;
1024 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1025 --source suite/engines/funcs/t/data1.inc
1026 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1027 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1028 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 2;
1029 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1030 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1031 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1032 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1033 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1034 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1035 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1036 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1037 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1038 DROP TABLE t1;
1039 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1040 --source suite/engines/funcs/t/data1.inc
1041 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1042 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1043 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 2;
1044 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1045 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1046 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1047 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1048 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1049 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1050 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1051 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1052 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1053 DROP TABLE t1;
1054 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1055 --source suite/engines/funcs/t/data1.inc
1056 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1057 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1058 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 2;
1059 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1060 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1061 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1062 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1063 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1064 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1065 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1066 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1067 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1068 DROP TABLE t1;
1069 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1070 --source suite/engines/funcs/t/data1.inc
1071 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1072 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1073 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 2;
1074 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1075 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1076 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1077 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1078 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1079 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1080 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1081 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1082 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1083 DROP TABLE t1;
1084 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1085 --source suite/engines/funcs/t/data1.inc
1086 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1087 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1088 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 2;
1089 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1090 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1091 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1092 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1093 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1094 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1095 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1096 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1097 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1098 DROP TABLE t1;
1099 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1100 --source suite/engines/funcs/t/data1.inc
1101 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1102 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1103 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 2;
1104 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1105 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1106 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1107 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1108 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1109 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1110 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1111 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1112 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1113 DROP TABLE t1;
1114 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1115 --source suite/engines/funcs/t/data1.inc
1116 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1117 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1118 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 2;
1119 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1120 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1121 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1122 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1123 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1124 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1125 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1126 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1127 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1128 DROP TABLE t1;
1129 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1130 --source suite/engines/funcs/t/data1.inc
1131 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1132 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1133 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 2;
1134 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1135 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1136 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1137 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1138 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1139 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1140 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1141 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1142 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1143 DROP TABLE t1;
1144 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1145 --source suite/engines/funcs/t/data1.inc
1146 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1147 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1148 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 2;
1149 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1150 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1151 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1152 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1153 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1154 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1155 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1156 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1157 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1158 DROP TABLE t1;
1159 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1160 --source suite/engines/funcs/t/data1.inc
1161 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1162 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1163 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 2;
1164 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1165 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1166 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1167 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1168 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1169 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1170 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1171 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1172 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1173 DROP TABLE t1;
1174 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1175 --source suite/engines/funcs/t/data1.inc
1176 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1177 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1178 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 2;
1179 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1180 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1181 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1182 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1183 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1184 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1185 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1186 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1187 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1188 DROP TABLE t1;
1189 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1190 --source suite/engines/funcs/t/data1.inc
1191 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1192 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1193 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 2;
1194 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1195 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1196 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1197 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1198 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1199 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1200 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1201 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1202 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1203 DROP TABLE t1;
1204 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1205 --source suite/engines/funcs/t/data1.inc
1206 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1207 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1208 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 2;
1209 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1210 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1211 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1212 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1213 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1214 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1215 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1216 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1217 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1218 DROP TABLE t1;
1219 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1220 --source suite/engines/funcs/t/data1.inc
1221 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1222 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1223 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 2;
1224 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1225 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1226 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1227 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1228 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1229 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1230 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1231 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1232 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1233 DROP TABLE t1;
1234 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1235 --source suite/engines/funcs/t/data1.inc
1236 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1237 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1238 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 2;
1239 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1240 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1241 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1242 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1243 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1244 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1245 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1246 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1247 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1248 DROP TABLE t1;
1249 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1250 --source suite/engines/funcs/t/data1.inc
1251 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1252 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 2;
1253 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 2;
1254 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 2;
1255 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1256 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 2;
1257 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1258 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 2;
1259 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1260 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 2;
1261 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1262 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 2;
1263 DROP TABLE t1;
1264 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1265 --source suite/engines/funcs/t/data1.inc
1266 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1267 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1268 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 3;
1269 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1270 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1271 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1272 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1273 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1274 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1275 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1276 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1277 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1278 DROP TABLE t1;
1279 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1280 --source suite/engines/funcs/t/data1.inc
1281 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1282 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1283 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 3;
1284 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1285 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1286 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1287 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1288 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1289 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1290 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1291 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1292 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1293 DROP TABLE t1;
1294 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1295 --source suite/engines/funcs/t/data1.inc
1296 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1297 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1298 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 3;
1299 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1300 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1301 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1302 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1303 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1304 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1305 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1306 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1307 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1308 DROP TABLE t1;
1309 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1310 --source suite/engines/funcs/t/data1.inc
1311 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1312 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1313 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 3;
1314 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1315 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1316 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1317 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1318 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1319 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1320 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1321 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1322 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1323 DROP TABLE t1;
1324 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1325 --source suite/engines/funcs/t/data1.inc
1326 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1327 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1328 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 3;
1329 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1330 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1331 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1332 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1333 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1334 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1335 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1336 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1337 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1338 DROP TABLE t1;
1339 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1340 --source suite/engines/funcs/t/data1.inc
1341 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1342 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1343 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 3;
1344 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1345 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1346 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1347 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1348 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1349 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1350 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1351 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1352 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1353 DROP TABLE t1;
1354 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1355 --source suite/engines/funcs/t/data1.inc
1356 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1357 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1358 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 3;
1359 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1360 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1361 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1362 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1363 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1364 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1365 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1366 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1367 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1368 DROP TABLE t1;
1369 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
1370 --source suite/engines/funcs/t/data1.inc
1371 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1372 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1373 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 3;
1374 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1375 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1376 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1377 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1378 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1379 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1380 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1381 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1382 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1383 DROP TABLE t1;
1384 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
1385 --source suite/engines/funcs/t/data1.inc
1386 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1387 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1388 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 3;
1389 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1390 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1391 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1392 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1393 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1394 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1395 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1396 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1397 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1398 DROP TABLE t1;
1399 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
1400 --source suite/engines/funcs/t/data1.inc
1401 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1402 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1403 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 3;
1404 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1405 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1406 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1407 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1408 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1409 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1410 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1411 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1412 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1413 DROP TABLE t1;
1414 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
1415 --source suite/engines/funcs/t/data1.inc
1416 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1417 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1418 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 3;
1419 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1420 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1421 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1422 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1423 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1424 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1425 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1426 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1427 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1428 DROP TABLE t1;
1429 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
1430 --source suite/engines/funcs/t/data1.inc
1431 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1432 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1433 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 3;
1434 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1435 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1436 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1437 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1438 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1439 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1440 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1441 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1442 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1443 DROP TABLE t1;
1444 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
1445 --source suite/engines/funcs/t/data1.inc
1446 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1447 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1448 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 3;
1449 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1450 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1451 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1452 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1453 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1454 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1455 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1456 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1457 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1458 DROP TABLE t1;
1459 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
1460 --source suite/engines/funcs/t/data1.inc
1461 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1462 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1463 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 3;
1464 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1465 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1466 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1467 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1468 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1469 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1470 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1471 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1472 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1473 DROP TABLE t1;
1474 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
1475 --source suite/engines/funcs/t/data1.inc
1476 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1477 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1478 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 3;
1479 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1480 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1481 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1482 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1483 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1484 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1485 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1486 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1487 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1488 DROP TABLE t1;
1489 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
1490 --source suite/engines/funcs/t/data1.inc
1491 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1492 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1493 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 3;
1494 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1495 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1496 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1497 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1498 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1499 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1500 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1501 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1502 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1503 DROP TABLE t1;
1504 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
1505 --source suite/engines/funcs/t/data1.inc
1506 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1507 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1508 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 3;
1509 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1510 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1511 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1512 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1513 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1514 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1515 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1516 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1517 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1518 DROP TABLE t1;
1519 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
1520 --source suite/engines/funcs/t/data1.inc
1521 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1522 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1523 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 3;
1524 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1525 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1526 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1527 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1528 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1529 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1530 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1531 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1532 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1533 DROP TABLE t1;
1534 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
1535 --source suite/engines/funcs/t/data1.inc
1536 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1537 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1538 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 3;
1539 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1540 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1541 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1542 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1543 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1544 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1545 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1546 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1547 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1548 DROP TABLE t1;
1549 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
1550 --source suite/engines/funcs/t/data1.inc
1551 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1552 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1553 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 3;
1554 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1555 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1556 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1557 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1558 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1559 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1560 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1561 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1562 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1563 DROP TABLE t1;
1564 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
1565 --source suite/engines/funcs/t/data1.inc
1566 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1567 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1568 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 3;
1569 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1570 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1571 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1572 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1573 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1574 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1575 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1576 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1577 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1578 DROP TABLE t1;
1579 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1580 --source suite/engines/funcs/t/data1.inc
1581 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1582 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1583 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 3;
1584 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1585 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1586 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1587 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1588 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1589 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1590 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1591 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1592 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1593 DROP TABLE t1;
1594 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1595 --source suite/engines/funcs/t/data1.inc
1596 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1597 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1598 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 3;
1599 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1600 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1601 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1602 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1603 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1604 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1605 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1606 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1607 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1608 DROP TABLE t1;
1609 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1610 --source suite/engines/funcs/t/data1.inc
1611 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1612 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1613 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 3;
1614 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1615 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1616 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1617 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1618 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1619 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1620 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1621 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1622 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1623 DROP TABLE t1;
1624 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1625 --source suite/engines/funcs/t/data1.inc
1626 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1627 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1628 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 3;
1629 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1630 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1631 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1632 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1633 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1634 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1635 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1636 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1637 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1638 DROP TABLE t1;
1639 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1640 --source suite/engines/funcs/t/data1.inc
1641 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1642 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1643 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 3;
1644 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1645 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1646 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1647 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1648 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1649 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1650 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1651 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1652 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1653 DROP TABLE t1;
1654 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1655 --source suite/engines/funcs/t/data1.inc
1656 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1657 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1658 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 3;
1659 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1660 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1661 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1662 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1663 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1664 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1665 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1666 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1667 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1668 DROP TABLE t1;
1669 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
1670 --source suite/engines/funcs/t/data1.inc
1671 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1672 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1673 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 3;
1674 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1675 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1676 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1677 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1678 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1679 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1680 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1681 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1682 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1683 DROP TABLE t1;
1684 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1685 --source suite/engines/funcs/t/data1.inc
1686 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1687 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1688 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 3;
1689 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1690 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1691 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1692 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1693 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1694 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1695 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1696 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1697 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1698 DROP TABLE t1;
1699 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1700 --source suite/engines/funcs/t/data1.inc
1701 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1702 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1703 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 3;
1704 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1705 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1706 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1707 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1708 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1709 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1710 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1711 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1712 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1713 DROP TABLE t1;
1714 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1715 --source suite/engines/funcs/t/data1.inc
1716 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1717 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1718 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 3;
1719 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1720 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1721 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1722 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1723 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1724 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1725 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1726 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1727 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1728 DROP TABLE t1;
1729 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1730 --source suite/engines/funcs/t/data1.inc
1731 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1732 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1733 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 3;
1734 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1735 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1736 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1737 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1738 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1739 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1740 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1741 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1742 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1743 DROP TABLE t1;
1744 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1745 --source suite/engines/funcs/t/data1.inc
1746 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1747 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1748 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 3;
1749 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1750 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1751 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1752 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1753 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1754 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1755 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1756 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1757 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1758 DROP TABLE t1;
1759 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1760 --source suite/engines/funcs/t/data1.inc
1761 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1762 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1763 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 3;
1764 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1765 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1766 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1767 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1768 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1769 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1770 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1771 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1772 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1773 DROP TABLE t1;
1774 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
1775 --source suite/engines/funcs/t/data1.inc
1776 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1777 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1778 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 3;
1779 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1780 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1781 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1782 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1783 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1784 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1785 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1786 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1787 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1788 DROP TABLE t1;
1789 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1790 --source suite/engines/funcs/t/data1.inc
1791 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1792 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1793 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 3;
1794 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1795 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1796 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1797 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1798 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1799 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1800 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1801 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1802 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1803 DROP TABLE t1;
1804 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1805 --source suite/engines/funcs/t/data1.inc
1806 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1807 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1808 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 3;
1809 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1810 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1811 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1812 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1813 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1814 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1815 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1816 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1817 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1818 DROP TABLE t1;
1819 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1820 --source suite/engines/funcs/t/data1.inc
1821 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1822 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1823 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 3;
1824 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1825 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1826 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1827 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1828 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1829 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1830 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1831 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1832 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1833 DROP TABLE t1;
1834 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1835 --source suite/engines/funcs/t/data1.inc
1836 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1837 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1838 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 3;
1839 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1840 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1841 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1842 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1843 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1844 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1845 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1846 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1847 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1848 DROP TABLE t1;
1849 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1850 --source suite/engines/funcs/t/data1.inc
1851 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1852 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1853 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 3;
1854 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1855 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1856 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1857 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1858 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1859 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1860 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1861 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1862 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1863 DROP TABLE t1;
1864 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1865 --source suite/engines/funcs/t/data1.inc
1866 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1867 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1868 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 3;
1869 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1870 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1871 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1872 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1873 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1874 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1875 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1876 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1877 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1878 DROP TABLE t1;
1879 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
1880 --source suite/engines/funcs/t/data1.inc
1881 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1882 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 3;
1883 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 3;
1884 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 3;
1885 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1886 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 3;
1887 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1888 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 3;
1889 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1890 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 3;
1891 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1892 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 3;
1893 DROP TABLE t1;
1894 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1895 --source suite/engines/funcs/t/data1.inc
1896 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1897 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1898 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 9;
1899 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
1900 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1901 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1902 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1903 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1904 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1905 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1906 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1907 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1908 DROP TABLE t1;
1909 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1910 --source suite/engines/funcs/t/data1.inc
1911 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1912 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1913 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 9;
1914 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
1915 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1916 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1917 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1918 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1919 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1920 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1921 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1922 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1923 DROP TABLE t1;
1924 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1925 --source suite/engines/funcs/t/data1.inc
1926 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1927 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1928 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 9;
1929 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
1930 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1931 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1932 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1933 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1934 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1935 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1936 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1937 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1938 DROP TABLE t1;
1939 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1940 --source suite/engines/funcs/t/data1.inc
1941 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1942 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1943 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 9;
1944 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
1945 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1946 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1947 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1948 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1949 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1950 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1951 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1952 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1953 DROP TABLE t1;
1954 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1955 --source suite/engines/funcs/t/data1.inc
1956 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1957 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1958 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 9;
1959 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
1960 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1961 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1962 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1963 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1964 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1965 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1966 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1967 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1968 DROP TABLE t1;
1969 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1970 --source suite/engines/funcs/t/data1.inc
1971 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1972 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1973 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 9;
1974 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
1975 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1976 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1977 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1978 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1979 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1980 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1981 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1982 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1983 DROP TABLE t1;
1984 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
1985 --source suite/engines/funcs/t/data1.inc
1986 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1987 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
1988 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 9;
1989 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
1990 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1991 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
1992 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1993 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
1994 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1995 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
1996 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1997 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
1998 DROP TABLE t1;
1999 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
2000 --source suite/engines/funcs/t/data1.inc
2001 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2002 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2003 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 9;
2004 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2005 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2006 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2007 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2008 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2009 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2010 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2011 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2012 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2013 DROP TABLE t1;
2014 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
2015 --source suite/engines/funcs/t/data1.inc
2016 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2017 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2018 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 9;
2019 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2020 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2021 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2022 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2023 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2024 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2025 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2026 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2027 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2028 DROP TABLE t1;
2029 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
2030 --source suite/engines/funcs/t/data1.inc
2031 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2032 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2033 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 9;
2034 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2035 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2036 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2037 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2038 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2039 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2040 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2041 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2042 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2043 DROP TABLE t1;
2044 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
2045 --source suite/engines/funcs/t/data1.inc
2046 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2047 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2048 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 9;
2049 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2050 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2051 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2052 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2053 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2054 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2055 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2056 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2057 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2058 DROP TABLE t1;
2059 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
2060 --source suite/engines/funcs/t/data1.inc
2061 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2062 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2063 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 9;
2064 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2065 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2066 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2067 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2068 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2069 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2070 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2071 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2072 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2073 DROP TABLE t1;
2074 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
2075 --source suite/engines/funcs/t/data1.inc
2076 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2077 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2078 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 9;
2079 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2080 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2081 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2082 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2083 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2084 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2085 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2086 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2087 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2088 DROP TABLE t1;
2089 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
2090 --source suite/engines/funcs/t/data1.inc
2091 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2092 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2093 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 9;
2094 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2095 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2096 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2097 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2098 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2099 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2100 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2101 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2102 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2103 DROP TABLE t1;
2104 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
2105 --source suite/engines/funcs/t/data1.inc
2106 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2107 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2108 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 9;
2109 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2110 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2111 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2112 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2113 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2114 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2115 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2116 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2117 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2118 DROP TABLE t1;
2119 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
2120 --source suite/engines/funcs/t/data1.inc
2121 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2122 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2123 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 9;
2124 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2125 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2126 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2127 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2128 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2129 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2130 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2131 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2132 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2133 DROP TABLE t1;
2134 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
2135 --source suite/engines/funcs/t/data1.inc
2136 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2137 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2138 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 9;
2139 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2140 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2141 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2142 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2143 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2144 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2145 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2146 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2147 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2148 DROP TABLE t1;
2149 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
2150 --source suite/engines/funcs/t/data1.inc
2151 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2152 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2153 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 9;
2154 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2155 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2156 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2157 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2158 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2159 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2160 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2161 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2162 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2163 DROP TABLE t1;
2164 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
2165 --source suite/engines/funcs/t/data1.inc
2166 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2167 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2168 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 9;
2169 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2170 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2171 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2172 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2173 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2174 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2175 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2176 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2177 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2178 DROP TABLE t1;
2179 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
2180 --source suite/engines/funcs/t/data1.inc
2181 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2182 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2183 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 9;
2184 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2185 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2186 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2187 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2188 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2189 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2190 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2191 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2192 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2193 DROP TABLE t1;
2194 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
2195 --source suite/engines/funcs/t/data1.inc
2196 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2197 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2198 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 9;
2199 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2200 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2201 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2202 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2203 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2204 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2205 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2206 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2207 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2208 DROP TABLE t1;
2209 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
2210 --source suite/engines/funcs/t/data1.inc
2211 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2212 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2213 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 9;
2214 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2215 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2216 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2217 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2218 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2219 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2220 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2221 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2222 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2223 DROP TABLE t1;
2224 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
2225 --source suite/engines/funcs/t/data1.inc
2226 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2227 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2228 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 9;
2229 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2230 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2231 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2232 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2233 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2234 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2235 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2236 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2237 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2238 DROP TABLE t1;
2239 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
2240 --source suite/engines/funcs/t/data1.inc
2241 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2242 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2243 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 9;
2244 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2245 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2246 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2247 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2248 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2249 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2250 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2251 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2252 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2253 DROP TABLE t1;
2254 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
2255 --source suite/engines/funcs/t/data1.inc
2256 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2257 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2258 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 9;
2259 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2260 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2261 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2262 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2263 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2264 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2265 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2266 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2267 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2268 DROP TABLE t1;
2269 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
2270 --source suite/engines/funcs/t/data1.inc
2271 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2272 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2273 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 9;
2274 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2275 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2276 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2277 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2278 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2279 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2280 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2281 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2282 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2283 DROP TABLE t1;
2284 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
2285 --source suite/engines/funcs/t/data1.inc
2286 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2287 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2288 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 9;
2289 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2290 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2291 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2292 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2293 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2294 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2295 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2296 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2297 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2298 DROP TABLE t1;
2299 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
2300 --source suite/engines/funcs/t/data1.inc
2301 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2302 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2303 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 9;
2304 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2305 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2306 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2307 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2308 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2309 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2310 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2311 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2312 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2313 DROP TABLE t1;
2314 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
2315 --source suite/engines/funcs/t/data1.inc
2316 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2317 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2318 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 9;
2319 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2320 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2321 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2322 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2323 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2324 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2325 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2326 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2327 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2328 DROP TABLE t1;
2329 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
2330 --source suite/engines/funcs/t/data1.inc
2331 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2332 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2333 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 9;
2334 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2335 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2336 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2337 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2338 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2339 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2340 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2341 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2342 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2343 DROP TABLE t1;
2344 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
2345 --source suite/engines/funcs/t/data1.inc
2346 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2347 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2348 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 9;
2349 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2350 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2351 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2352 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2353 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2354 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2355 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2356 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2357 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2358 DROP TABLE t1;
2359 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
2360 --source suite/engines/funcs/t/data1.inc
2361 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2362 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2363 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 9;
2364 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2365 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2366 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2367 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2368 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2369 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2370 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2371 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2372 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2373 DROP TABLE t1;
2374 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
2375 --source suite/engines/funcs/t/data1.inc
2376 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2377 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2378 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 9;
2379 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2380 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2381 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2382 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2383 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2384 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2385 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2386 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2387 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2388 DROP TABLE t1;
2389 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
2390 --source suite/engines/funcs/t/data1.inc
2391 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2392 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2393 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 9;
2394 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2395 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2396 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2397 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2398 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2399 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2400 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2401 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2402 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2403 DROP TABLE t1;
2404 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
2405 --source suite/engines/funcs/t/data1.inc
2406 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2407 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2408 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 9;
2409 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2410 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2411 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2412 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2413 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2414 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2415 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2416 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2417 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2418 DROP TABLE t1;
2419 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
2420 --source suite/engines/funcs/t/data1.inc
2421 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2422 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2423 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1 HAVING COUNT(*) = 9;
2424 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2425 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2426 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2427 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2428 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2429 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2430 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2431 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2432 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='a' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2433 DROP TABLE t1;
2434 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
2435 --source suite/engines/funcs/t/data1.inc
2436 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2437 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2438 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1 HAVING COUNT(*) = 9;
2439 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2440 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2441 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2442 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2443 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2444 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2445 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2446 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2447 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='b' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2448 DROP TABLE t1;
2449 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
2450 --source suite/engines/funcs/t/data1.inc
2451 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2452 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2453 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1 HAVING COUNT(*) = 9;
2454 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2455 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2456 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2457 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2458 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2459 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2460 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2461 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2462 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='c' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2463 DROP TABLE t1;
2464 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
2465 --source suite/engines/funcs/t/data1.inc
2466 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2467 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2468 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1 HAVING COUNT(*) = 9;
2469 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2470 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2471 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2472 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2473 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2474 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2475 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2476 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2477 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='d' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2478 DROP TABLE t1;
2479 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
2480 --source suite/engines/funcs/t/data1.inc
2481 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2482 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2483 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1 HAVING COUNT(*) = 9;
2484 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2485 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2486 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2487 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2488 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2489 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2490 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2491 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2492 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='e' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2493 DROP TABLE t1;
2494 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
2495 --source suite/engines/funcs/t/data1.inc
2496 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2497 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2498 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1 HAVING COUNT(*) = 9;
2499 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2500 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2501 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2502 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2503 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2504 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2505 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2506 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2507 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='f' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2508 DROP TABLE t1;
2509 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
2510 --source suite/engines/funcs/t/data1.inc
2511 SELECT c1 FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2512 SELECT c1,COUNT(*) FROM t1 GROUP BY c1 HAVING COUNT(*) = 9;
2513 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1 HAVING COUNT(*) = 9;
2514 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1 HAVING COUNT(*) = 9;
2515 SELECT c1,c2 FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2516 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2 HAVING COUNT(*) = 9;
2517 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2518 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c1,c2 HAVING COUNT(*) = 9;
2519 SELECT c2,c1 FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2520 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1 HAVING COUNT(*) = 9;
2521 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2522 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1='y' OR c2 = '#C2' GROUP BY c2,c1 HAVING COUNT(*) = 9;
2523 DROP TABLE t1;
2524