diff options
| author | unknown <wax@kishkin.ru> | 2003-04-02 17:55:53 +0600 |
|---|---|---|
| committer | unknown <wax@kishkin.ru> | 2003-04-02 17:55:53 +0600 |
| commit | 6feda00ddb0253dc38f3b8fdf3e0a149086daf15 (patch) | |
| tree | 02ffd4d545b5209454f2bcf98af4e0c03a52cf3f /mysql-test/t/func_gconcat.test | |
| parent | 0b505fb437eedd1b31c99888247c2259539c095b (diff) | |
| download | mariadb-git-6feda00ddb0253dc38f3b8fdf3e0a149086daf15.tar.gz | |
SCRUM
correct sql_alloc, ORDER BY and NULL value in group_concat
add comments
move test msg_arg
add test on NULL
mysql-test/r/func_gconcat.result:
change work with NULL
mysql-test/t/func_gconcat.test:
add test on NULL
sql/item_sum.cc:
correct sql_alloc, ORDER BY and NULL value
add comments
sql/sql_class.h:
move test msg_arg
Diffstat (limited to 'mysql-test/t/func_gconcat.test')
| -rw-r--r-- | mysql-test/t/func_gconcat.test | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index a122f612bfc..0a95410e842 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -48,7 +48,7 @@ select grp, ROUND(group_concat(a separator "")) from t1 group by grp; # Test NULL values -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"); @@ -59,6 +59,8 @@ 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; # Test warnings |