diff options
| author | unknown <evgen@moonbone.local> | 2005-05-30 03:32:50 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-05-30 03:32:50 +0400 |
| commit | 73c46d05af6e4cb873fb2d6ec47452e69dfc029f (patch) | |
| tree | 12f6115dd7147775118ed3f1eb301b7402817ffe /mysql-test/r/count_distinct.result | |
| parent | 6a7dedf25909719fe5a8c2f98f87e18e6461b705 (diff) | |
| download | mariadb-git-73c46d05af6e4cb873fb2d6ec47452e69dfc029f.tar.gz | |
Fix bug #9593 "The combination of COUNT, DISTINCT and CONCAT seems to lock the
server"
Bug appears only on Windows platform. Freeing memory in
TMP_TABLE_PARAM::cleanup() allocated by new Copy_fields[0] in
setup_copy_fields() results in memory destruction. In test IF used instead
of CONCAT because IF have more stable crash.
sql/sql_select.cc:
Fix bug #9593 The combination of COUNT, DISTINCT and CONCAT seems to lock the server
mysql-test/t/count_distinct.test:
test for bug #9593 The combination of COUNT, DISTINCT and CONCAT seems to lock the server
mysql-test/r/count_distinct.result:
Test for bug #9593 The combination of COUNT, DISTINCT and CONCAT seems to lock the server
Diffstat (limited to 'mysql-test/r/count_distinct.result')
| -rw-r--r-- | mysql-test/r/count_distinct.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/count_distinct.result b/mysql-test/r/count_distinct.result index 1bc1ad6a31e..a21748359b9 100644 --- a/mysql-test/r/count_distinct.result +++ b/mysql-test/r/count_distinct.result @@ -60,3 +60,9 @@ count(distinct a) 1 1 drop table t1; +create table t1 (f1 int, f2 int); +insert into t1 values (0,1),(1,2); +select count(distinct if(f1,3,f2)) from t1; +count(distinct if(f1,3,f2)) +2 +drop table t1; |