diff options
Diffstat (limited to 'mysql-test/t/count_distinct2.test')
-rw-r--r-- | mysql-test/t/count_distinct2.test | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/t/count_distinct2.test b/mysql-test/t/count_distinct2.test index 33d4cf54278..a25197d4f5b 100644 --- a/mysql-test/t/count_distinct2.test +++ b/mysql-test/t/count_distinct2.test @@ -47,11 +47,13 @@ drop table t1; # test the converstion from tree to MyISAM create table t1 (n int default NULL); let $1=5000; +disable_query_log; while ($1) { eval insert into t1 values($1); dec $1; } +enable_query_log; flush status; select count(distinct n) from t1; @@ -61,12 +63,13 @@ drop table t1; #test conversion from heap to MyISAM create table t1 (s text); let $1=5000; +disable_query_log; while ($1) { eval insert into t1 values('$1'); dec $1; } - +enable_query_log; flush status; select count(distinct s) from t1; show status like 'Created_tmp_disk_tables'; |