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/t/count_distinct.test | |
| 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/t/count_distinct.test')
| -rw-r--r-- | mysql-test/t/count_distinct.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/count_distinct.test b/mysql-test/t/count_distinct.test index 73c6951e78f..be67026e268 100644 --- a/mysql-test/t/count_distinct.test +++ b/mysql-test/t/count_distinct.test @@ -63,3 +63,15 @@ 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; + +# +# Bug #9593 "The combination of COUNT, DISTINCT and CONCAT +# seems to lock the server" +# Bug appears only on Windows system +# + +create table t1 (f1 int, f2 int); +insert into t1 values (0,1),(1,2); +select count(distinct if(f1,3,f2)) from t1; +drop table t1; + |