diff options
| author | konstantin@mysql.com <> | 2005-11-18 23:46:04 +0300 |
|---|---|---|
| committer | konstantin@mysql.com <> | 2005-11-18 23:46:04 +0300 |
| commit | a86eaaf5c3a2ca18415e9c16b56fc47683746d83 (patch) | |
| tree | 4162fc5410e652b20a62e19cafca42d6b0e3dfe4 /mysql-test/r/func_gconcat.result | |
| parent | c9ab4d614ed08c104664e4088057d6acb08c5719 (diff) | |
| download | mariadb-git-a86eaaf5c3a2ca18415e9c16b56fc47683746d83.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.
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; |