← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/bench_count_distinct.result

  • Committer: Package Import Robot
  • Author(s): Otto Kekäläinen
  • Date: 2013-12-22 10:27:05 UTC
  • Revision ID: package-import@ubuntu.com-20131222102705-mndw7s12mz0szrcn
Tags: upstream-5.5.32
Import upstream version 5.5.32

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/bench_count_distinct.result
 
1
drop table if exists t1;
 
2
create table t1(n int not null, key(n)) delay_key_write = 1;
 
3
select count(distinct n) from t1;
 
4
count(distinct n)
 
5
100
 
6
explain extended select count(distinct n) from t1;
 
7
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
 
8
1       SIMPLE  t1      range   NULL    n       4       NULL    10      100.00  Using index for group-by
 
9
Warnings:
 
10
Note    1003    select count(distinct `test`.`t1`.`n`) AS `count(distinct n)` from `test`.`t1`
 
11
drop table t1;