Lines Matching refs:b3

1001   CREATE TABLE b3(a COLLATE nocase, b COLLATE binary);
1002   INSERT INTO b3 VALUES('abc', 'abc');
1003   INSERT INTO b3 VALUES('aBC', 'aBC');
1004   INSERT INTO b3 VALUES('Def', 'Def');
1005   INSERT INTO b3 VALUES('dEF', 'dEF');
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(*)"
1062   12.2  "SELECT max(a) FROM b3 GROUP BY max(b)"
1063   12.3  "SELECT group_concat(a) FROM b3 GROUP BY a, max(b)"