Lines Matching refs:count
89 SELECT count(*) FROM t1 %JOIN% t2 ON (t1.a=t2.a)
92 SELECT count(*) FROM t1 %JOIN% t2 USING (a)
95 SELECT count(*) FROM t1 %JOIN% t2
98 SELECT count(*) FROM t1, t2 ON (t1.a=t2.a) USING (a)
101 SELECT count(*) FROM t1, t2 USING (a) ON (t1.a=t2.a)
155 0002.1 "SELECT 1, 2, 3 GROUP BY 2 HAVING count(*)=1" {1 2 3}
156 0002.2 "SELECT 1, 2, 3 GROUP BY 2 HAVING count(*)>1" {}
159 1002.1 "SELECT DISTINCT 1, 2, 3 GROUP BY 2 HAVING count(*)=1" {1 2 3}
160 1002.2 "SELECT DISTINCT 1, 2, 3 GROUP BY 2 HAVING count(*)>1" {}
163 2002.1 "SELECT ALL 1, 2, 3 GROUP BY 2 HAVING count(*)=1" {1 2 3}
164 2002.2 "SELECT ALL 1, 2, 3 GROUP BY 2 HAVING count(*)>1" {}
166 0101.1 "SELECT count(*), max(a) FROM t1 GROUP BY b" {1 a 1 c 1 b}
167 0102.1 "SELECT count(*), max(a) FROM t1 GROUP BY b HAVING count(*)=1" {
170 0102.2 "SELECT count(*), max(a) FROM t1 GROUP BY b HAVING count(*)=2" {}
172 1101.1 "SELECT DISTINCT count(*), max(a) FROM t1 GROUP BY b" {1 a 1 c 1 b}
173 1102.1 "SELECT DISTINCT count(*), max(a) FROM t1
174 GROUP BY b HAVING count(*)=1" {
177 1102.2 "SELECT DISTINCT count(*), max(a) FROM t1
178 GROUP BY b HAVING count(*)=2" {}
180 2101.1 "SELECT ALL count(*), max(a) FROM t1 GROUP BY b" {1 a 1 c 1 b}
181 2102.1 "SELECT ALL count(*), max(a) FROM t1
182 GROUP BY b HAVING count(*)=1" {
185 2102.2 "SELECT ALL count(*), max(a) FROM t1
186 GROUP BY b HAVING count(*)=2" {}
189 0012.1 "SELECT 1, 2, 3 WHERE 0 GROUP BY 2 HAVING count(*)=1" {}
190 0012.2 "SELECT 1, 2, 3 WHERE 0 GROUP BY 2 HAVING count(*)>1" {}
193 1012.1 "SELECT DISTINCT 1, 2, 3 WHERE 1 GROUP BY 2 HAVING count(*)=1"
195 1012.2 "SELECT DISTINCT 1, 2, 3 WHERE NULL GROUP BY 2 HAVING count(*)>1" {}
198 2012.1 "SELECT ALL 1, 2, 3 WHERE 0 GROUP BY 2 HAVING count(*)=1" {}
199 2012.2 "SELECT ALL 1, 2, 3 WHERE 'abc' GROUP BY 2 HAVING count(*)>1" {}
201 0111.1 "SELECT count(*), max(a) FROM t1 WHERE a='a' GROUP BY b" {1 a}
202 0112.1 "SELECT count(*), max(a) FROM t1
203 WHERE a='c' GROUP BY b HAVING count(*)=1" {1 c}
204 0112.2 "SELECT count(*), max(a) FROM t1
205 WHERE 0 GROUP BY b HAVING count(*)=2" {}
206 1111.1 "SELECT DISTINCT count(*), max(a) FROM t1 WHERE a<'c' GROUP BY b"
208 1112.1 "SELECT DISTINCT count(*), max(a) FROM t1 WHERE a>'a'
209 GROUP BY b HAVING count(*)=1" {
212 1112.2 "SELECT DISTINCT count(*), max(a) FROM t1 WHERE 0
213 GROUP BY b HAVING count(*)=2" {}
215 2111.1 "SELECT ALL count(*), max(a) FROM t1 WHERE b>'one' GROUP BY b"
217 2112.1 "SELECT ALL count(*), max(a) FROM t1 WHERE a!='b'
218 GROUP BY b HAVING count(*)=1" {
221 2112.2 "SELECT ALL count(*), max(a) FROM t1
222 WHERE 0 GROUP BY b HAVING count(*)=2" {}
328 4 "SELECT count(*)" {1}
329 5 "SELECT count(*) WHERE 0" {0}
330 6 "SELECT count(*) WHERE 1" {1}
353 2 "SELECT count(*), count(x), count(y) FROM xx" {3 2 3}
471 SELECT count(*) FROM x1 %JOIN% x2
479 SELECT count(*) FROM x2 %JOIN% x3
487 SELECT count(*) FROM x3 %JOIN% x1
495 SELECT count(*) FROM x3 %JOIN% x3
640 1a "SELECT count(*) FROM t7 JOIN t8 ON (t7.a=t8.a)" {1}
641 1b "SELECT count(*) FROM t7 LEFT JOIN t8 ON (t7.a=t8.a)" {2}
642 2a "SELECT count(*) FROM t7 JOIN t8 USING (a)" {1}
643 2b "SELECT count(*) FROM t7 LEFT JOIN t8 USING (a)" {2}
802 6 "SELECT count(*), * FROM z1" {6 51.65 -59.58 belfries}
830 2.4 "SELECT count(*), *" {no tables specified}
905 1 "SELECT count(a), max(a), count(b), max(b) FROM z1" {5 63 5 born}
906 2 "SELECT count(*), max(1)" {1 1}
940 1 "SELECT one, two, count(*) FROM a1" {1 1 4}
941 2 "SELECT one, two, count(*) FROM a1 WHERE one<3" {1 1 2}
942 3 "SELECT one, two, count(*) FROM a1 WHERE one>3" {4 10 1}
943 4 "SELECT *, count(*) FROM a1 JOIN a2" {1 1 1 1 16}
954 1 "SELECT one, two, count(*) FROM a1 WHERE 0" {{} {} 0}
966 8.1 "SELECT count(*) FROM a1"
967 8.2 "SELECT count(*) FROM a1 WHERE 0"
968 8.3 "SELECT count(*) FROM a1 WHERE 1"
1041 2 "SELECT count(*) FROM b2 GROUP BY CASE WHEN y<4 THEN NULL ELSE 0 END" {4 1}
1049 1 "SELECT count(*) FROM b3 GROUP BY b" {1 1 1 1}
1050 2 "SELECT count(*) FROM b3 GROUP BY a" {2 2}
1051 3 "SELECT count(*) FROM b3 GROUP BY +b" {1 1 1 1}
1052 4 "SELECT count(*) FROM b3 GROUP BY +a" {2 2}
1053 5 "SELECT count(*) FROM b3 GROUP BY b||''" {1 1 1 1}
1054 6 "SELECT count(*) FROM b3 GROUP BY a||''" {1 1 1 1}
1061 12.1 "SELECT * FROM b3 GROUP BY count(*)"
1122 1.1 "SELECT up FROM c1 GROUP BY up HAVING count(*)>3" {x}
1144 5 "SELECT count(*), round(avg(i),2) FROM c1, c2 ON (i=down) GROUP BY j%2"
1160 5 "SELECT count(*), i, k FROM c2 NATURAL JOIN c3 GROUP BY substr(k, 1, 1)"
1173 do_select_tests e_select.4.16 -count {
1319 2 "SELECT count(*) FROM j1 ORDER BY 1 UNION ALL SELECT max(e) FROM j2"
1321 3 "SELECT count(*), * FROM j1 ORDER BY 1,2,3 UNION ALL SELECT *,* FROM j2"
1332 8 "SELECT count(*) FROM j1 ORDER BY 1 UNION SELECT max(e) FROM j2"
1334 9 "SELECT count(*), * FROM j1 ORDER BY 1,2,3 UNION SELECT *,* FROM j2"
1345 14 "SELECT count(*) FROM j1 ORDER BY 1 EXCEPT SELECT max(e) FROM j2"
1347 15 "SELECT count(*), * FROM j1 ORDER BY 1,2,3 EXCEPT SELECT *,* FROM j2"
1358 20 "SELECT count(*) FROM j1 ORDER BY 1 INTERSECT SELECT max(e) FROM j2"
1360 21 "SELECT count(*), * FROM j1 ORDER BY 1,2,3 INTERSECT SELECT *,* FROM j2"
1379 2 "SELECT count(*) FROM j1 UNION ALL SELECT max(e) FROM j2 ORDER BY 1"
1380 3 "SELECT count(*), * FROM j1 UNION ALL SELECT *,* FROM j2 ORDER BY 1,2,3"
1386 8 "SELECT count(*) FROM j1 UNION SELECT max(e) FROM j2 ORDER BY 1"
1388 9 "SELECT count(*), * FROM j1 UNION SELECT *,* FROM j2 ORDER BY 1,2,3"
1394 14 "SELECT count(*) FROM j1 EXCEPT SELECT max(e) FROM j2 ORDER BY 1"
1395 15 "SELECT count(*), * FROM j1 EXCEPT SELECT *,* FROM j2 ORDER BY 1,2,3"
1401 20 "SELECT count(*) FROM j1 INTERSECT SELECT max(e) FROM j2 ORDER BY 1"
1402 21 "SELECT count(*), * FROM j1 INTERSECT SELECT *,* FROM j2 ORDER BY 1,2,3"
1412 52 "SELECT count(*) FROM j1 UNION ALL VALUES(11) ORDER BY 1"
1413 53 "SELECT count(*) FROM j1 UNION ALL VALUES(11) LIMIT 1"
1447 3 {SELECT count(*) FROM q1 UNION ALL SELECT min(e) FROM q2}
1465 3 {SELECT count(*) FROM q1 UNION SELECT min(e) FROM q2}
2069 3 { SELECT b FROM f1 ORDER BY a LIMIT (SELECT count(*) FROM f1)/2 - 14 }
2090 2 { SELECT count(*) FROM f1 GROUP BY a/5 ORDER BY 1 LIMIT 10 } {2 4 5 5 5 5}