From 2f2607faeffb09d946e09a5f090a24449e73742b Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 7 Apr 2006 13:19:31 +0500 Subject: Fix for bug#18281 group_concat changes charset to binary skip charset aggregation for order columns --- mysql-test/t/func_gconcat.test | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/t/func_gconcat.test') diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index 1b88ed90fa3..aa28c9d5f52 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -414,3 +414,11 @@ select charset(a) from t2; select charset(a) from t3; drop table t1, t2, t3; set names default; + +# +# Bug#18281 group_concat changes charset to binary +# +create table t1 (c1 varchar(10), c2 int); +select charset(group_concat(c1 order by c2)) from t1; +drop table t1; + -- cgit v1.2.1