← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_gconcat.test

  • Committer: Brian Aker
  • Date: 2009-01-08 22:38:15 UTC
  • Revision ID: brian@tangent.org-20090108223815-i7p6uaajqxapge8a
func_timestamp now working.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_gconcat.test
69
69
 
70
70
# Test errors
71
71
 
72
 
--error ER_INVALID_GROUP_FUNC_USE
 
72
--error 1111
73
73
select group_concat(sum(c)) from t1 group by grp;
74
 
--error ER_BAD_FIELD_ERROR
 
74
--error 1054
75
75
select grp,group_concat(c order by 2) from t1 group by grp;
76
76
 
77
77
drop table t1;
272
272
select collation(a) from t1;
273
273
select collation(group_concat(a)) from t1;
274
274
create table t2 select group_concat(a) as a from t1;
275
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
276
275
show create table t2;
277
276
select collation(group_concat(a,b)) from t1;
278
277
drop table t1;
451
450
  x text not null,
452
451
  y integer not null
453
452
);
454
 
insert into t1 values (repeat('a', 1022), 0), (repeat( 0xc3b7, 4), 0);
 
453
insert into t1 values (repeat('a', 1022), 0), (repeat(_utf8 0xc3b7, 4), 0);
455
454
let $1= 10;
456
455
while ($1)
457
456
{