~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/union.test

  • Committer: Brian Aker
  • Date: 2010-04-20 18:23:07 UTC
  • mto: This revision was merged to the branch mainline in revision 1502.
  • Revision ID: brian@gaz-20100420182307-jwyhun4vm2dtugyb
There is room for improvement around this. We should be using rows as well
in the future as a metric for disk/memory store. 

Show diffs side-by-side

added added

removed removed

Lines of Context:
457
457
insert into t1 select * from t2;
458
458
insert into t2 select * from t1;
459
459
set local tmp_table_size=1024;
460
 
select count(*) from (select * from t1 union all select * from t2 order by 1) b;
 
460
select SQL_BIG_RESULT count(*) from (select SQL_BIG_RESULT * from t1 union all select * from t2 order by 1) b;
461
461
select count(*) from t1;
462
462
select count(*) from t2;
463
463
drop table t1,t2;