← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/index_merge2.inc

  • Committer: Stewart Smith
  • Date: 2009-03-11 06:37:19 UTC
  • mto: (910.4.19 sparc) (937.2.1 sparc)
  • mto: This revision was merged to the branch mainline in revision 931.
  • Revision ID: stewart@flamingspork.com-20090311063719-v9iqjd00ts6260vv
batch up more INSERTs into transactions to help tests run quicker.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/index_merge2.inc
34
34
 
35
35
--disable_query_log
36
36
let $1=200;
 
37
begin;
37
38
while ($1)
38
39
{
39
40
  eval insert into t1 values (200-$1, $1);
40
41
  dec $1;
41
42
}
 
43
commit;
42
44
--enable_query_log
43
45
 
44
46
# No primary key
80
82
show warnings;
81
83
--disable_query_log
82
84
let $1=30;
 
85
begin;
83
86
while ($1)
84
87
{
85
88
  eval insert into t1 (key1, key2, filler) values ($1/4, $1/8, 'filler-data');
86
89
  dec $1;
87
90
}
 
91
commit;
88
92
--enable_query_log
89
93
explain select pk from t1 where key1 = 1 and key2 = 1;
90
94
select pk from t1 where key2 = 1 and key1 = 1;
159
163
 
160
164
let $1=7;
161
165
set @d=8;
 
166
begin;
162
167
while ($1)
163
168
{
164
169
  eval insert into t1 (key1) select key1+@d from t1;
165
170
  eval set @d=@d*2;
166
171
  dec $1;
167
172
}
 
173
commit;
168
174
 
169
175
alter table t1 add index i2(key2);
170
176
alter table t1 add index i3(key3);