diff options
Diffstat (limited to 'mysql-test/r/func_gconcat.result')
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 20 |
1 files changed, 13 insertions, 7 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index b17ad8370ce..840e2dc2afb 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -121,7 +121,7 @@ grp ROUND(group_concat(a separator "")) 1 1 2 23 3 456789 -drop table if exists t1; +drop table t1; create table t1 (grp int, c char(10)); insert into t1 values (1,NULL); insert into t1 values (2,"b"); @@ -132,17 +132,23 @@ insert into t1 values (3,"D"); insert into t1 values (3,NULL); insert into t1 values (3,NULL); insert into t1 values (3,"D"); +insert into t1 values (4,""); +insert into t1 values (5,NULL); select grp,group_concat(c order by c) from t1 group by grp; grp group_concat(c order by c) -1 -2 b -3 D D E +1 NULL +2 b +3 D D E +4 +5 NULL set group_concat_max_len = 5; select grp,group_concat(c) from t1 group by grp; grp group_concat(c) -1 -2 b -3 E D +1 NULL +2 b +3 E D D +4 +5 NULL Warnings: Warning 1250 1 line(s) was(were) cut by group_concat() show warnings; |