← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_gconcat.result

  • Committer: Brian Aker
  • Date: 2011-01-12 06:45:23 UTC
  • mto: (2073.1.4 catalogs)
  • mto: This revision was merged to the branch mainline in revision 2080.
  • Revision ID: brian@tangent.org-20110112064523-rqhptaqbph22qmj1
Remove custom error.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_gconcat.result
191
191
create table t1(id int);
192
192
create table t2(id int);
193
193
insert into t1 values(0),(1);
194
 
select group_concat(t1.id) FROM t1,t2 where t2.id < 2;
 
194
select group_concat(t1.id) FROM t1,t2;
195
195
group_concat(t1.id)
196
196
NULL
197
197
drop table t1;
321
321
CREATE TABLE t2 ( a int );
322
322
INSERT INTO t1 VALUES (1), (2);
323
323
INSERT INTO t2 VALUES (1), (2);
324
 
SELECT GROUP_CONCAT(t1.a*t2.a ORDER BY t2.a) FROM t1, t2 WHERE t1.a < 3 GROUP BY t1.a;
 
324
SELECT GROUP_CONCAT(t1.a*t2.a ORDER BY t2.a) FROM t1, t2 GROUP BY t1.a;
325
325
GROUP_CONCAT(t1.a*t2.a ORDER BY t2.a)
326
326
1,2
327
327
2,4
861
861
FROM
862
862
t1 AS t1,
863
863
t1 AS t2
864
 
WHERE t2.a IS NULL
865
864
GROUP BY 1
866
865
) AS s1;
867
866
d1