summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_gconcat.test
diff options
context:
space:
mode:
authorunknown <igor@rurik.mysql.com>2006-04-21 00:36:20 -0700
committerunknown <igor@rurik.mysql.com>2006-04-21 00:36:20 -0700
commit103fbcee45c0ea5517faf6904ff0b87b15312fbe (patch)
tree12430c67bf33ee7014ca554819c453fb616380b5 /mysql-test/t/func_gconcat.test
parentdb623fa89f9b90b21c00184400a1ca94c361010f (diff)
parentd4f4f5bdaf43b07036d89973ce247fe43009958f (diff)
downloadmariadb-git-103fbcee45c0ea5517faf6904ff0b87b15312fbe.tar.gz
Merge rurik.mysql.com:/home/igor/dev/mysql-4.1-0
into rurik.mysql.com:/home/igor/dev/mysql-5.0-0 mysql-test/r/order_by.result: Auto merged sql/sql_select.cc: Auto merged sql/sql_yacc.yy: Auto merged mysql-test/t/func_gconcat.test: Manual merge mysql-test/t/order_by.test: Manual merge sql/sql_lex.h: Manual merge sql/sql_parse.cc: Manual merge sql/sql_union.cc: Manual merge
Diffstat (limited to 'mysql-test/t/func_gconcat.test')
-rw-r--r--mysql-test/t/func_gconcat.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test
index e2cc3f24d7a..fbfdfa3b5d0 100644
--- a/mysql-test/t/func_gconcat.test
+++ b/mysql-test/t/func_gconcat.test
@@ -398,6 +398,16 @@ select f1, group_concat(f1+1) from t1 group by f1 with rollup;
select count(distinct (f1+1)) from t1 group by f1 with rollup;
drop table t1;
+#
+# Bug#14169 type of group_concat() result changed to blob if tmp_table was used
+#
+create table t1 (f1 int unsigned, f2 varchar(255));
+insert into t1 values (1,repeat('a',255)),(2,repeat('b',255));
+--enable_metadata
+select f2,group_concat(f1) from t1 group by f2;
+--disable_metadata
+drop table t1;
+
# End of 4.1 tests
#