diff options
author | unknown <evgen@sunlight.local> | 2006-03-30 17:14:55 +0400 |
---|---|---|
committer | unknown <evgen@sunlight.local> | 2006-03-30 17:14:55 +0400 |
commit | e0708e2c11b9079fbe85a36fa1790761241b262c (patch) | |
tree | f1381200f8493f09eb4e5d618305dc65a91312e0 /mysql-test/r/func_gconcat.result | |
parent | b7f090e402a27b5407e059a019dcefcfec483efd (diff) | |
parent | ff4de9050149bd1ab1727d7f226e094ddcdcd355 (diff) | |
download | mariadb-git-e0708e2c11b9079fbe85a36fa1790761241b262c.tar.gz |
Manual merge
myisam/mi_search.c:
Auto merged
mysql-test/t/ctype_utf8.test:
Auto merged
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 2a36e6fe17b..f1c9f8b9f76 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -596,6 +596,21 @@ GROUP_CONCAT(a ORDER BY a) ,x ,z DROP TABLE t1; +create table t1(f1 int); +insert into t1 values(1),(2),(3); +select f1, group_concat(f1+1) from t1 group by f1 with rollup; +f1 group_concat(f1+1) +1 2 +2 3 +3 4 +NULL 2,3,4 +select count(distinct (f1+1)) from t1 group by f1 with rollup; +count(distinct (f1+1)) +1 +1 +1 +3 +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'); |