~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/global_read_constraints.result

  • Committer: Brian Aker
  • Date: 2010-11-12 21:22:46 UTC
  • mto: (1932.2.1 trunk)
  • mto: This revision was merged to the branch mainline in revision 1930.
  • Revision ID: brian@tangent.org-20101112212246-jsn2vgxzgesuv9pt
Test for issues on CONCURRENT to be sure it operates in a single
transaction.

Show diffs side-by-side

added added

removed removed

Lines of Context:
28
28
CREATE TABLE t2 SELECT * FROM t1;
29
29
create temporary table t3 (a varchar(255), b varchar(255)) engine=myisam;
30
30
insert into t3 select * from t1;
31
 
select SQL_BIG_RESULT * from t3, (select * from t1) as t4 where t3.a != '';
 
31
select SQL_BIG_RESULT * from t3, (select * from t1) as t4;
32
32
ERROR HY000: Global read memory constraint hit; increase read-buffer-threshold