summaryrefslogtreecommitdiff
path: root/mysql-test/t/count_distinct2.test
diff options
context:
space:
mode:
authorunknown <monty@hundin.mysql.fi>2001-10-08 05:36:35 +0300
committerunknown <monty@hundin.mysql.fi>2001-10-08 05:36:35 +0300
commit515c747dcfcca8d04a509496c5864f302d6d76be (patch)
tree87a4027a65ad98a422987c566b6d394464e95623 /mysql-test/t/count_distinct2.test
parent41972bea9234345ed36ea92d40c0b0cf3ec315b0 (diff)
parentcef1d752497f81229788e56abaf7fa62c1ab31a9 (diff)
downloadmariadb-git-515c747dcfcca8d04a509496c5864f302d6d76be.tar.gz
merge
BitKeeper/etc/ignore: auto-union acinclude.m4: Auto merged Docs/manual.texi: Auto merged include/my_sys.h: Auto merged include/mysql.h: Auto merged libmysqld/libmysqld.c: Auto merged mysql-test/mysql-test-run.sh: Auto merged mysql-test/t/count_distinct2.test: Auto merged mysql-test/t/flush.test: Auto merged mysql-test/t/rpl000017.test: Auto merged libmysql/libmysql.c: Auto merged mysys/Makefile.am: Auto merged sql/Makefile.am: Auto merged sql/handler.cc: Auto merged sql/item_func.cc: Auto merged sql/mysql_priv.h: Auto merged sql/mysqld.cc: Auto merged libmysqld/Makefile.am: Added back md5.c
Diffstat (limited to 'mysql-test/t/count_distinct2.test')
-rw-r--r--mysql-test/t/count_distinct2.test4
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;