diff options
| author | unknown <igor@rurik.mysql.com> | 2005-09-07 18:06:14 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-09-07 18:06:14 -0700 |
| commit | 91cb3d2db91dc62fe4d11d5c49754d60fe49f602 (patch) | |
| tree | 54de540063eec3844b407031fe95cb3b4099d943 /mysql-test/t/func_gconcat.test | |
| parent | 0c51dc75d9a9b6ae52a7df2bceee8c16fbb04a54 (diff) | |
| parent | 7d64ba092da310725f88c3193e48f3cdd14f3bbd (diff) | |
| download | mariadb-git-91cb3d2db91dc62fe4d11d5c49754d60fe49f602.tar.gz | |
Manual merge
mysql-test/r/func_gconcat.result:
Auto merged
mysql-test/t/func_gconcat.test:
Auto merged
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 896c377662b..a519d51e0b5 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -373,4 +373,20 @@ select * from (select group_concat(a) from t1) t2; select group_concat('x') UNION ALL select 1; drop table t1; +# +# Bug #12863 : missing separators after first empty cancatanated elements +# + +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; +SELECT GROUP_CONCAT(a ORDER BY a) FROM t1; + +SELECT GROUP_CONCAT(a) FROM t1 GROUP BY id; +SELECT GROUP_CONCAT(a ORDER BY a) FROM t1 GROUP BY id; + +DROP TABLE t1; + # End of 4.1 tests |