diff options
| author | igor@rurik.mysql.com <> | 2005-09-07 18:06:14 -0700 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2005-09-07 18:06:14 -0700 |
| commit | 80484114d414df70c628f42e5a3d324130a6cef4 (patch) | |
| tree | 54de540063eec3844b407031fe95cb3b4099d943 /mysql-test/r/func_gconcat.result | |
| parent | 052e9262ee2050976354213b30a596ce2b087d45 (diff) | |
| parent | 1e6736b543dd18a2808ed224a4fbed47808d219b (diff) | |
| download | mariadb-git-80484114d414df70c628f42e5a3d324130a6cef4.tar.gz | |
Manual merge
Diffstat (limited to 'mysql-test/r/func_gconcat.result')
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index 1ad412209ad..6461c393d51 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -576,3 +576,23 @@ group_concat('x') NULL 1 drop table t1; +CREATE TABLE t1 (id int, a varchar(9)); +INSERT INTO t1 VALUES +(2, ''), (1, ''), (2, 'x'), (1, 'y'), (3, 'z'), (3, ''); +SELECT GROUP_CONCAT(a) FROM t1; +GROUP_CONCAT(a) +,,x,y,z, +SELECT GROUP_CONCAT(a ORDER BY a) FROM t1; +GROUP_CONCAT(a ORDER BY a) +,,,x,y,z +SELECT GROUP_CONCAT(a) FROM t1 GROUP BY id; +GROUP_CONCAT(a) +,y +,x +z, +SELECT GROUP_CONCAT(a ORDER BY a) FROM t1 GROUP BY id; +GROUP_CONCAT(a ORDER BY a) +,y +,x +,z +DROP TABLE t1; |