Debian Codegraph @

mysql-test/suite/engines/funcs/t/se_string_groupby_statements.inc

raw
1 --sorted_result
2 SELECT c1 FROM t1 GROUP BY c1;
3 --sorted_result
4 SELECT c1,COUNT(*) FROM t1 GROUP BY c1;
5 --sorted_result
6 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1=@value GROUP BY c1;
7 --sorted_result
8 SELECT c1,COUNT(*),MAX(c3) FROM t1 WHERE c1=@value OR c2 = '#C2' GROUP BY c1;
9 --sorted_result
10 SELECT c1,c2 FROM t1 GROUP BY c1,c2;
11 --sorted_result
12 SELECT c1,c2,COUNT(*) FROM t1 GROUP BY c1,c2;
13 --sorted_result
14 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1=@value GROUP BY c1,c2;
15 --sorted_result
16 SELECT c1,c2,COUNT(*),MAX(c3) FROM t1 WHERE c1=@value OR c2 = '#C2' GROUP BY c1,c2;
17 --sorted_result
18 SELECT c2,c1 FROM t1 GROUP BY c2,c1;
19 --sorted_result
20 SELECT c2,c1,COUNT(*) FROM t1 GROUP BY c2,c1;
21 --sorted_result
22 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1=@value GROUP BY c2,c1;
23 --sorted_result
24 SELECT c2,c1,COUNT(*),MAX(c3) FROM t1 WHERE c1=@value OR c2 = '#C2' GROUP BY c2,c1;