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/r/func_gconcat.result | |
| 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/r/func_gconcat.result')
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index 90884dcc596..7987ceca712 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -596,3 +596,18 @@ GROUP_CONCAT(a ORDER BY a) ,x ,z DROP TABLE t1; +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; +charset(a) +latin1 +select charset(a) from t3; +charset(a) +latin1 +latin1 +drop table t1, t2, t3; +set names default; |