summaryrefslogtreecommitdiff
path: root/mysql-test/t/count_distinct.test
diff options
context:
space:
mode:
authorram@gw.mysql.r18.ru <>2004-11-10 14:36:21 +0400
committerram@gw.mysql.r18.ru <>2004-11-10 14:36:21 +0400
commit3e8e4d06b6e93ce936957f7704574222f24729c8 (patch)
tree7b0b07f422d10be9d54a1fc5d6183fab621a1dc0 /mysql-test/t/count_distinct.test
parenta3f4bd28ace3b80dcc6c908e7de1b998c52b0e59 (diff)
downloadmariadb-git-3e8e4d06b6e93ce936957f7704574222f24729c8.tar.gz
A fix (bug #6475: Another server crash in 5.0.2
bug #6515: count(distinct...) crashes the server)
Diffstat (limited to 'mysql-test/t/count_distinct.test')
-rw-r--r--mysql-test/t/count_distinct.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/count_distinct.test b/mysql-test/t/count_distinct.test
index 1f0404876cb..73c6951e78f 100644
--- a/mysql-test/t/count_distinct.test
+++ b/mysql-test/t/count_distinct.test
@@ -55,3 +55,11 @@ create table t1 (f int);
select count(distinct f) from t1;
drop table t1;
+#
+# Bug #6515
+#
+
+create table t1 (a char(3), b char(20), primary key (a, b));
+insert into t1 values ('ABW', 'Dutch'), ('ABW', 'English');
+select count(distinct a) from t1 group by b;
+drop table t1;