← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/heap.test

merge latest from trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/heap.test
284
284
select sql_big_result trim(v),count(c) from t1 group by v limit 10;
285
285
select c,count(*) from t1 group by c limit 10;
286
286
select c,count(t) from t1 group by c limit 10;
287
 
select sql_big_result c,count(t) from t1 group by c limit 10;
288
287
select t,count(*) from t1 group by t limit 10;
289
288
select t,count(t) from t1 group by t limit 10;
290
289
select sql_big_result trim(t),count(t) from t1 group by t limit 10;
396
395
show create table t1;
397
396
drop table t1;
398
397
 
399
 
create table t1 (v varchar(65530), key(v(10)));
 
398
create table t1 (v varchar(16383), key(v(10)));
400
399
show create table t1;
401
 
insert into t1 values(repeat('a',65530));
402
 
select length(v) from t1 where v=repeat('a',65530);
 
400
insert into t1 values(repeat('a',16383));
 
401
select length(v) from t1 where v=repeat('a',16383);
403
402
drop table t1;
404
403
 
405
404
#