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