diff options
| author | monty@hundin.mysql.fi <> | 2001-10-08 05:36:35 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2001-10-08 05:36:35 +0300 |
| commit | 938a8dc2ef15eb0878c9a71f2f60ae521084494a (patch) | |
| tree | 87a4027a65ad98a422987c566b6d394464e95623 /mysql-test/t/count_distinct2.test | |
| parent | 0c81c7ea07b8f28746fef96409eafb6995c5d7c9 (diff) | |
| parent | 88aff4bf851e8f0d67cc7cd860d445e0fb234717 (diff) | |
| download | mariadb-git-938a8dc2ef15eb0878c9a71f2f60ae521084494a.tar.gz | |
merge
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 a25197d4f5b..d1bea7614c8 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; disable_query_log; |