1#
2# Test of count(distinct ..)
3#
4
5--disable_warnings
6drop table if exists t1;
7--enable_warnings
8create table t1(n int not null, key(n)) delay_key_write = 1;
9let $1=100;
10--disable_query_log
11begin;
12while ($1)
13{
14 eval insert into t1 values($1);
15 eval insert into t1 values($1);
16 dec $1;
17}
18commit;
19--enable_query_log
20select count(distinct n) from t1;
21explain extended select count(distinct n) from t1;
22drop table t1;
23
24# End of 4.1 tests
25