Debian Codegraph @

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

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