← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/common-tests.inc

  • Committer: Monty Taylor
  • Date: 2008-10-20 08:48:34 UTC
  • mfrom: (520.1.22 drizzle)
  • Revision ID: monty@inaugust.com-20081020084834-xpb3w01vkcp55o02
Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/common-tests.inc
1412
1412
 
1413
1413
# big table done
1414
1414
 
1415
 
SET SQL_BIG_TABLES=1;
1416
1415
select distinct concat(fld3," ",fld3) as namn from t2,t3 where t2.fld1=t3.t2nr order by namn limit 10;
1417
 
SET SQL_BIG_TABLES=0;
1418
1416
select distinct concat(fld3," ",fld3) from t2,t3 where t2.fld1=t3.t2nr order by fld3 limit 10;
1419
1417
select distinct fld5 from t2 limit 10;
1420
1418
 
1423
1421
#
1424
1422
 
1425
1423
select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;
1426
 
SET SQL_BIG_TABLES=1; # Force use of MyISAM
1427
1424
select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;
1428
 
SET SQL_BIG_TABLES=0;
1429
1425
select distinct fld3,repeat("a",length(fld3)),count(*) from t2 group by companynr,fld3 limit 100,10;
1430
1426
 
1431
1427
#