summaryrefslogtreecommitdiff
path: root/mysql-test/t/bench_count_distinct.test
diff options
context:
space:
mode:
authorunknown <sasha@mysql.sashanet.com>2001-04-09 18:25:06 -0600
committerunknown <sasha@mysql.sashanet.com>2001-04-09 18:25:06 -0600
commite19e69fbcb944cb19a87b43ab193f6022c8550d0 (patch)
treea8c6b25f1e220ac4f81e8ea33e154890297ca39b /mysql-test/t/bench_count_distinct.test
parent5102766f42aef5398e9c3ef3e702a8a7ef040e64 (diff)
downloadmariadb-git-e19e69fbcb944cb19a87b43ab193f6022c8550d0.tar.gz
added gprof options
added a benchmark test for count(distinct) mysql-test/mysql-test-run.sh: u
Diffstat (limited to 'mysql-test/t/bench_count_distinct.test')
-rw-r--r--mysql-test/t/bench_count_distinct.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/bench_count_distinct.test b/mysql-test/t/bench_count_distinct.test
new file mode 100644
index 00000000000..20d80ff74a1
--- /dev/null
+++ b/mysql-test/t/bench_count_distinct.test
@@ -0,0 +1,12 @@
+drop table if exists t1;
+create table t1(n int not null, key(n));
+let $1=10000;
+while ($1)
+{
+ eval insert into t1 values($1);
+ eval insert into t1 values($1);
+ dec $1;
+}
+
+select count(distinct n) from t1;
+drop table t1;