~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/insert.result

  • 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:
77
77
count(*)
78
78
500
79
79
insert into  t2 select t1.* from t1, t2 t, t3 where  t1.id1 = t.id2 and t.id2 = t3.id3;
 
80
ERROR HY000: Temporary table too large, rerun with SQL_BIG_RESULT.
 
81
insert into  t2 select SQL_BIG_RESULT t1.* from t1, t2 t, t3 where  t1.id1 = t.id2 and t.id2 = t3.id3;
80
82
select count(*) from t2;
81
83
count(*)
82
84
25500