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