~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/union.result

  • Committer: Brian Aker
  • Date: 2010-04-21 05:33:07 UTC
  • mfrom: (1487.1.1 fix-myisam)
  • Revision ID: brian@gaz-20100421053307-5nkzdz1l2q73t1ej
Merge in heap != myisam

Show diffs side-by-side

added added

removed removed

Lines of Context:
783
783
insert into t1 select * from t2;
784
784
insert into t2 select * from t1;
785
785
set local tmp_table_size=1024;
786
 
select count(*) from (select * from t1 union all select * from t2 order by 1) b;
 
786
select SQL_BIG_RESULT count(*) from (select SQL_BIG_RESULT * from t1 union all select * from t2 order by 1) b;
787
787
count(*)
788
788
21
789
789
select count(*) from t1;