~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/insert.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:
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