index_merge_bdb.test 1.12 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
#
# 2-sweeps read Index_merge test
#
-- source include/have_bdb.inc

--disable_warnings
drop table if exists t1;
--enable_warnings

create table t1 (
  pk int primary key,
  key1 int,
  key2 int,  
  filler char(200),
  filler2 char(200),  
  index(key1),
pem@mysql.comhem.se's avatar
pem@mysql.comhem.se committed
17
  index(key2)
18
) engine=bdb;
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52


--disable_query_log
let $1=1000;
while ($1)
{
  eval insert into t1 values($1, $1, $1, 'filler-data','filler-data-2');
  dec $1;
}
--enable_query_log

select * from t1 where (key1 >= 2 and key1 <= 10) or (pk >= 4 and pk <=8 );

set @maxv=1000;

select * from t1 where 
  (pk < 5) or (pk > 10 and pk < 15) or (pk >= 50 and pk < 55 ) or (pk > @maxv-10) 
  or key1=18 or key1=60;

select * from t1 where 
  (pk < 5) or (pk > 10 and pk < 15) or (pk >= 50 and pk < 55 ) or (pk > @maxv-10) 
  or key1 < 3 or key1 > @maxv-11;

select * from t1 where 
  (pk < 5) or (pk > 10 and pk < 15) or (pk >= 50 and pk < 55 ) or (pk > @maxv-10) 
  or
  (key1 < 5) or (key1 > 10 and key1 < 15) or (key1 >= 50 and key1 < 55 ) or (key1 > @maxv-10);

select * from t1 where 
  (pk > 10 and pk < 15) or (pk >= 50 and pk < 55 )
  or
  (key1 < 5) or (key1 > @maxv-10);

drop table t1;