1
# include/index_merge_2sweeps.inc
3
# 2-sweeps read Index_merge test
6
# $engine_type -- storage engine to be tested
7
# has to be set before sourcing this script.
10
# 2006-08-02 ML test refactored
11
# old name was index_merge_innodb2.test
12
# main code went into include/index_merge_2sweeps.inc
15
--echo #---------------- 2-sweeps read Index merge test 2 -------------------------------
17
eval SET SESSION STORAGE_ENGINE = $engine_type;
20
drop table if exists t1;
39
eval insert into t1 values($1, $1, $1, 'filler-data','filler-data-2');
45
select * from t1 where (key1 >= 2 and key1 <= 10) or (pk >= 4 and pk <=8 );
49
select * from t1 where
50
(pk < 5) or (pk > 10 and pk < 15) or (pk >= 50 and pk < 55 ) or (pk > @maxv-10)
51
or key1=18 or key1=60;
53
select * from t1 where
54
(pk < 5) or (pk > 10 and pk < 15) or (pk >= 50 and pk < 55 ) or (pk > @maxv-10)
55
or key1 < 3 or key1 > @maxv-11;
57
select * from t1 where
58
(pk < 5) or (pk > 10 and pk < 15) or (pk >= 50 and pk < 55 ) or (pk > @maxv-10)
60
(key1 < 5) or (key1 > 10 and key1 < 15) or (key1 >= 50 and key1 < 55 ) or (key1 > @maxv-10);
62
select * from t1 where
63
(pk > 10 and pk < 15) or (pk >= 50 and pk < 55 )
65
(key1 < 5) or (key1 > @maxv-10);