~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/count_distinct3.result

  • Committer: Lee
  • Date: 2008-10-30 22:02:01 UTC
  • mto: (572.1.2 devel)
  • mto: This revision was merged to the branch mainline in revision 573.
  • Revision ID: lbieber@lbieber-desktop-20081030220201-elb6qprbzpn7c5a4
add my name to the AUTHORS file

Show diffs side-by-side

added added

removed removed

Lines of Context:
2
2
CREATE TABLE t1 (id INTEGER, grp int, id_rev INTEGER);
3
3
SELECT COUNT(*) FROM t1;
4
4
COUNT(*)
5
 
13000
 
5
4181000
6
6
SELECT COUNT(DISTINCT id) FROM t1 GROUP BY grp;
7
7
DROP TABLE t1;
8
8
set @@read_buffer_size=default;