~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/global_read_constraints.test

  • Committer: Stewart Smith
  • Date: 2011-01-14 05:11:45 UTC
  • mto: (2086.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2087.
  • Revision ID: stewart@flamingspork.com-20110114051145-xiputq4lvmtct377
storage engine docs. add bit about some temp table only engines.

Show diffs side-by-side

added added

removed removed

Lines of Context:
5
5
 
6
6
create temporary table t3 (a varchar(255), b varchar(255)) engine=myisam;
7
7
insert into t3 select * from t1;
8
 
--error ER_OUT_OF_GLOBAL_READMEMORY
9
 
select SQL_BIG_RESULT * from t3, (select * from t1) as t4 where t3.a != '';
 
8
--error 1705
 
9
select SQL_BIG_RESULT * from t3, (select * from t1) as t4;