← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/global_read_rnd_constraints.test

  • Committer: Andrew Hutchings
  • Date: 2010-11-01 17:26:12 UTC
  • mto: This revision was merged to the branch mainline in revision 1907.
  • Revision ID: andrew@linuxjedi.co.uk-20101101172612-6cz2odleqde02ede
Add test cases for all but read buffer constraint

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/global_read_rnd_constraints.test
 
1
# Setup table for tests
 
2
USE test;
 
3
 
 
4
--source include/setup-global-constraints.inc
 
5
 
 
6
# We appear to need to beef up the table to use the read_rnd buffer at all
 
7
alter table t1 modify charcol1 varchar(255);
 
8
alter table t1 modify charcol2 varchar(255);
 
9
insert into t1 select SQL_BIG_RESULT * from t1;
 
10
insert into t1 select SQL_BIG_RESULT * from t1;
 
11
insert into t1 select SQL_BIG_RESULT * from t1;
 
12
insert into t1 select SQL_BIG_RESULT * from t1;
 
13
insert into t1 select SQL_BIG_RESULT * from t1;
 
14
 
 
15
# Test for read_rnd buffer constraint
 
16
--error 1
 
17
--exec $DRIZZLE_SLAP -q "SELECT SQL_BIG_RESULT * FROM t1 ORDER BY 1" -c100 --iterations=1 --number-of-queries=1000 --create-schema=test