summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_gconcat.result
diff options
context:
space:
mode:
authorunknown <evgen@sunlight.local>2006-03-30 17:14:55 +0400
committerunknown <evgen@sunlight.local>2006-03-30 17:14:55 +0400
commite0708e2c11b9079fbe85a36fa1790761241b262c (patch)
treef1381200f8493f09eb4e5d618305dc65a91312e0 /mysql-test/r/func_gconcat.result
parentb7f090e402a27b5407e059a019dcefcfec483efd (diff)
parentff4de9050149bd1ab1727d7f226e094ddcdcd355 (diff)
downloadmariadb-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.result15
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');