diff options
| author | unknown <wax@kishkin.ru> | 2003-09-04 06:44:16 +0600 |
|---|---|---|
| committer | unknown <wax@kishkin.ru> | 2003-09-04 06:44:16 +0600 |
| commit | d89b2a9f1d23fe6e3cc877c23b3235b0a0782323 (patch) | |
| tree | f747b592a1fd915ad7c9b998d8b413cf98662de5 /mysql-test/r/func_gconcat.result | |
| parent | 6bd423902abadfe53840797df22e64a86f080b5c (diff) | |
| download | mariadb-git-d89b2a9f1d23fe6e3cc877c23b3235b0a0782323.tar.gz | |
BUG
correct bug 1085 (a problem with min/max functions)
add tests of bugs 833,836,1085
mysql-test/r/func_gconcat.result:
add tests of bugs 833, 836, 1085
mysql-test/t/func_gconcat.test:
add tests of bugs #833, 836, 1085
sql/item_sum.cc:
merge
sql/item_sum.h:
correct bug 1085
Diffstat (limited to 'mysql-test/r/func_gconcat.result')
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index a4493e7c95c..5c3c2f10000 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -167,6 +167,11 @@ t2.URL_ID = t1.URL_ID group by REQ_ID; REQ_ID URL 1 X 5 X,X,X +select REQ_ID, Group_Concat(URL) as URL, Min(t1.URL_ID) urll, +Max(t1.URL_ID)
urlg from t1, t2 where t2.URL_ID = t1.URL_ID group by REQ_ID; +REQ_ID URL urll urlg +1 X 4 4 +5 X,X,X 4 5 drop table t1; drop table t2; create table t1 (id int, name varchar(16)); @@ -178,3 +183,16 @@ select distinct ifnull(group_concat(concat(t1.id, ':', t1.name)), 'shortname') a with distinct: cutoff at length of shortname 1:longername,1:evenlongername drop table t1; +create table t1(id int); +create table t2(id int); +insert into t1 values(0),(1); +select group_concat(t1.id) FROM t1,t2; +group_concat(t1.id) +NULL +drop table t1; +drop table t2; +create table t1 (bar varchar(32)); +insert into t1 values('test'),('test2'); +select * from t1 having group_concat(bar)=''; +bar +drop table t1; |