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/r/count_distinct.result | |
| 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/r/count_distinct.result')
| -rw-r--r-- | mysql-test/r/count_distinct.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/count_distinct.result b/mysql-test/r/count_distinct.result index 16460580d6c..1bc1ad6a31e 100644 --- a/mysql-test/r/count_distinct.result +++ b/mysql-test/r/count_distinct.result @@ -53,3 +53,10 @@ select count(distinct f) from t1; count(distinct f) 0 drop table t1; +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; +count(distinct a) +1 +1 +drop table t1; |