diff options
| author | unknown <evgen@moonbone.local> | 2007-07-19 21:40:12 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2007-07-19 21:40:12 +0400 |
| commit | d0020607b324cb9e5c3f930315a4fb0c4a65239b (patch) | |
| tree | 6a01a32afcc9fdfb0498221cafeed64993631fa7 /mysql-test/t/func_gconcat.test | |
| parent | 248c5e24e91f1d5916fd05cda4339fbfc8600ffe (diff) | |
| parent | 7f6a8164846da34a822e8f844d6ec9e1da3af412 (diff) | |
| download | mariadb-git-d0020607b324cb9e5c3f930315a4fb0c4a65239b.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into moonbone.local:/mnt/gentoo64/work/29850-bug-5.0-opt-mysql
Diffstat (limited to 'mysql-test/t/func_gconcat.test')
| -rw-r--r-- | mysql-test/t/func_gconcat.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index 767df5ae233..ff3ba951870 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -551,4 +551,15 @@ SELECT LENGTH( GROUP_CONCAT( a ) ) FROM t3 WHERE b = 3; SET group_concat_max_len= DEFAULT; DROP TABLE t1, t2, t3; +# +# Bug#29850: Wrong charset of the GROUP_CONCAT result when the select employs +# a temporary table. +# +set names latin1; +create table t1 (id int, name varchar(20)) DEFAULT CHARSET=utf8; +insert into t1 (id, name) values (1, "óra"); +insert into t1 (id, name) values (2, "óra"); +select b.id, group_concat(b.name) from t1 a, t1 b group by b.id; +drop table t1; + --echo End of 5.0 tests |