← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/index_merge1.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_merge1.inc
37
37
 
38
38
let $1=7;
39
39
set @d=8;
 
40
begin;
40
41
while ($1)
41
42
{
42
43
  eval insert into t0 select key1+@d from t0;
43
44
  eval set @d=@d*2;
44
45
  dec $1;
45
46
}
 
47
commit;
46
48
--enable_query_log
47
49
 
48
50
alter table t0 add key2 int not null, add index i2(key2);
356
358
INSERT INTO t1 VALUES ('foo','bar', 'ZZ'),('fuz','baz', 'ZZ');
357
359
 
358
360
--disable_query_log
 
361
begin;
359
362
let $1=9;
360
363
while ($1)
361
364
{
369
372
  eval INSERT INTO t1 SELECT * from t1 WHERE cola <> 'foo';
370
373
  dec $1;
371
374
}
372
 
 
 
375
commit;
373
376
--enable_query_log
374
377
 
375
378
OPTIMIZE TABLE t1;