diff options
Diffstat (limited to 'mysql-test/t/count_distinct2.test')
| -rw-r--r-- | mysql-test/t/count_distinct2.test | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/t/count_distinct2.test b/mysql-test/t/count_distinct2.test index 33d4cf54278..073b83a40b4 100644 --- a/mysql-test/t/count_distinct2.test +++ b/mysql-test/t/count_distinct2.test @@ -1,3 +1,5 @@ +drop table if exists t1; + create table t1(n1 int, n2 int, s char(20), vs varchar(20), t text); insert into t1 values (1,11, 'one','eleven', 'eleven'), (1,11, 'one','eleven', 'eleven'), @@ -44,7 +46,7 @@ select count(distinct n1), count(distinct n2) from t1; select count(distinct n2), n1 from t1 group by n1; drop table t1; -# test the converstion from tree to MyISAM +# test the conversion from tree to MyISAM create table t1 (n int default NULL); let $1=5000; while ($1) |