diff options
| author | unknown <konstantin@mysql.com> | 2005-11-18 23:46:04 +0300 |
|---|---|---|
| committer | unknown <konstantin@mysql.com> | 2005-11-18 23:46:04 +0300 |
| commit | a11caf1e01de600b9212c129903395758dc63378 (patch) | |
| tree | 4162fc5410e652b20a62e19cafca42d6b0e3dfe4 /mysql-test/t/func_gconcat.test | |
| parent | 43262f345a42a15afed16407f1284833701c2f8d (diff) | |
| download | mariadb-git-a11caf1e01de600b9212c129903395758dc63378.tar.gz | |
A test case for Bug#8568 "GROUP_CONCAT returns string, unless in
a UNION in which case returns BLOB". The bug is not present anymore.
mysql-test/r/func_gconcat.result:
Bug#8568: test results
mysql-test/t/func_gconcat.test:
Add a test case for Bug#8568
Diffstat (limited to 'mysql-test/t/func_gconcat.test')
| -rw-r--r-- | mysql-test/t/func_gconcat.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index a519d51e0b5..cd686585dd8 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -390,3 +390,19 @@ SELECT GROUP_CONCAT(a ORDER BY a) FROM t1 GROUP BY id; DROP TABLE t1; # End of 4.1 tests + +# +# Bug#8568 "GROUP_CONCAT returns string, unless in a UNION in which case +# returns BLOB": add a test case, the bug can not be repeated any more. +# + +set names latin1; +create table t1 (a char, b char); +insert into t1 values ('a', 'a'), ('a', 'b'), ('b', 'a'), ('b', 'b'); +create table t2 select group_concat(b) as a from t1 where a = 'a'; +create table t3 (select group_concat(a) as a from t1 where a = 'a') union + (select group_concat(b) as a from t1 where a = 'b'); +select charset(a) from t2; +select charset(a) from t3; +drop table t1, t2, t3; +set names default; |