diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-11-10 14:36:21 +0400 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-11-10 14:36:21 +0400 |
| commit | 0c9bae6e8e194d5a332bcc1f99eb86a0e03e7f7c (patch) | |
| tree | 7b0b07f422d10be9d54a1fc5d6183fab621a1dc0 /mysql-test/t/count_distinct.test | |
| parent | 20c82f5c014e9902f234f925a218895f3b91b154 (diff) | |
| download | mariadb-git-0c9bae6e8e194d5a332bcc1f99eb86a0e03e7f7c.tar.gz | |
A fix (bug #6475: Another server crash in 5.0.2
bug #6515: count(distinct...) crashes the server)
mysql-test/r/count_distinct.result:
A test case (bug #6515: count(distinct...) crashes the server)
mysql-test/r/func_gconcat.result:
A test case (bug #6475: Another server crash in 5.0.2)
mysql-test/t/count_distinct.test:
A test case (bug #6515: count(distinct...) crashes the server)
mysql-test/t/func_gconcat.test:
A test case (bug #6475: Another server crash in 5.0.2)
sql/sql_select.cc:
A fix (bug #6475: Another server crash in 5.0.2
bug #6515: count(distinct...) crashes the server)
In order to prevent repeated setup() call in the JOIN::make_sum_func_list(),
the code was splitted: new setup_sum_funcs() was introduced.
Note: we don't call setup_sum_funcs() in the opt_range.cc:get_best_group_min_max().
Diffstat (limited to 'mysql-test/t/count_distinct.test')
| -rw-r--r-- | mysql-test/t/count_distinct.test | 8 |
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; |