← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: Brian Aker
  • Date: 2008-10-20 01:46:44 UTC
  • mto: (492.3.21 drizzle-clean-code)
  • mto: This revision was merged to the branch mainline in revision 530.
  • Revision ID: brian@tangent.org-20081020014644-oqwhaf1lhch3yc4c
SQL_BIG_TABLES has been removed.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/select.result
481
481
insert into t3 select * from tmp;
482
482
alter table t3 add t2nr int not null auto_increment primary key first;
483
483
drop table tmp;
484
 
SET SQL_BIG_TABLES=1;
485
484
select distinct concat(fld3," ",fld3) as namn from t2,t3 where t2.fld1=t3.t2nr order by namn limit 10;
486
485
namn
487
486
Abraham Abraham
494
493
analyzable analyzable
495
494
animals animals
496
495
animized animized
497
 
SET SQL_BIG_TABLES=0;
498
496
select distinct concat(fld3," ",fld3) from t2,t3 where t2.fld1=t3.t2nr order by fld3 limit 10;
499
497
concat(fld3," ",fld3)
500
498
Abraham Abraham
531
529
bedlam  1
532
530
bedpost 1
533
531
boasted 1
534
 
SET SQL_BIG_TABLES=1;
535
532
select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;
536
533
fld3    count(*)
537
534
affixed 1
544
541
bedlam  1
545
542
bedpost 1
546
543
boasted 1
547
 
SET SQL_BIG_TABLES=0;
548
544
select distinct fld3,repeat("a",length(fld3)),count(*) from t2 group by companynr,fld3 limit 100,10;
549
545
fld3    repeat("a",length(fld3))        count(*)
550
546
circus  aaaaaa  1