summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_gconcat.test
diff options
context:
space:
mode:
authorunknown <gluh@eagle.intranet.mysql.r18.ru>2006-04-07 13:19:31 +0500
committerunknown <gluh@eagle.intranet.mysql.r18.ru>2006-04-07 13:19:31 +0500
commit2f2607faeffb09d946e09a5f090a24449e73742b (patch)
treec322a074ea323decf45e8227843c0aedefc6e931 /mysql-test/t/func_gconcat.test
parentdb7a88a2f40b9b80262ba2ddf455b90172b0f413 (diff)
downloadmariadb-git-2f2607faeffb09d946e09a5f090a24449e73742b.tar.gz
Fix for bug#18281 group_concat changes charset to binary
skip charset aggregation for order columns
Diffstat (limited to 'mysql-test/t/func_gconcat.test')
-rw-r--r--mysql-test/t/func_gconcat.test8
1 files changed, 8 insertions, 0 deletions
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;
+