blob: 81111a9de4a209116e81a7359c8e35efaf88c8a0 [file] [log] [blame]
# 2008 December 23
#
# The author disclaims copyright to this source code. In place of
# a legal notice, here is a blessing:
#
# May you do good and not evil.
# May you find forgiveness for yourself and forgive others.
# May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library. The
# focus of this file is testing the multi-index OR clause optimizer.
set testdir [file dirname $argv0]
source $testdir/tester.tcl
ifcapable !or_opt {
finish_test
return
}
# Evaluate SQL. Return the result set followed by the
# and the number of full-scan steps.
#
proc count_steps {sql} {
set r [db eval $sql]
lappend r scan [db status step] sort [db status sort]
}
proc count_steps_sort {sql} {
set r [lsort -integer [db eval $sql]]
return "$r scan [db status step] sort [db status sort]"
}
# Build some test data
#
do_test where7-1.1 {
execsql {
CREATE TABLE t1(a INTEGER PRIMARY KEY,b,c,d);
INSERT INTO t1 VALUES(1,2,3,4);
INSERT INTO t1 VALUES(2,3,4,5);
INSERT INTO t1 VALUES(3,4,6,8);
INSERT INTO t1 VALUES(4,5,10,15);
INSERT INTO t1 VALUES(5,10,100,1000);
CREATE INDEX t1b ON t1(b);
CREATE INDEX t1c ON t1(c);
SELECT * FROM t1;
}
} {1 2 3 4 2 3 4 5 3 4 6 8 4 5 10 15 5 10 100 1000}
do_execsql_test where7-1.1.1 {
CREATE TABLE t(a);
CREATE INDEX ta ON t(a);
INSERT INTO t(a) VALUES(1),(2);
SELECT * FROM t ORDER BY a;
SELECT * FROM t WHERE a<2 OR a<3 ORDER BY a;
PRAGMA count_changes=ON;
DELETE FROM t WHERE a<2 OR a<3;
SELECT * FROM t;
PRAGMA count_changes=OFF;
DROP TABLE t;
} {1 2 1 2 2}
do_test where7-1.2 {
count_steps {
SELECT a FROM t1 WHERE b=3 OR c=6 ORDER BY a
}
} {2 3 scan 0 sort 1}
do_test where7-1.3 {
count_steps {
SELECT a FROM t1 WHERE b=3 OR +c=6 ORDER BY a
}
} {2 3 scan 4 sort 0}
do_test where7-1.4 {
count_steps {
SELECT a FROM t1 WHERE +b=3 OR c=6 ORDER BY 1
}
} {2 3 scan 4 sort 0}
do_test where7-1.5 {
count_steps {
SELECT a FROM t1 WHERE 3=b OR c=6 ORDER BY rowid
}
} {2 3 scan 0 sort 1}
do_test where7-1.6 {
count_steps {
SELECT a FROM t1 WHERE (3=b OR c=6) AND +a>0 ORDER BY a
}
} {2 3 scan 0 sort 1}
do_test where7-1.7 {
count_steps {
SELECT a FROM t1 WHERE (b=3 OR c>10)
}
} {2 5 scan 0 sort 0}
do_test where7-1.8 {
count_steps {
SELECT a FROM t1 WHERE (b=3 OR c>=10)
}
} {2 4 5 scan 0 sort 0}
do_test where7-1.9 {
count_steps {
SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4)
}
} {2 4 5 scan 0 sort 0}
do_test where7-1.10 {
count_steps {
SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4 OR b>10)
}
} {2 4 5 scan 0 sort 0}
do_test where7-1.11 {
count_steps {
SELECT a FROM t1 WHERE (d=5 AND b=3) OR c==100 ORDER BY a;
}
} {2 5 scan 0 sort 1}
do_test where7-1.12 {
count_steps {
SELECT a FROM t1 WHERE (b BETWEEN 2 AND 4) OR c=100 ORDER BY a
}
} {1 2 3 5 scan 0 sort 1}
do_test where7-1.13 {
count_steps {
SELECT a FROM t1 WHERE (b BETWEEN 0 AND 2) OR (c BETWEEN 9 AND 999)
ORDER BY +a DESC
}
} {5 4 1 scan 0 sort 1}
do_test where7-1.14 {
count_steps {
SELECT a FROM t1 WHERE (d=8 OR c=6 OR b=4) AND +a>0
}
} {3 scan 4 sort 0}
do_test where7-1.15 {
count_steps {
SELECT a FROM t1 WHERE +a>=0 AND (d=8 OR c=6 OR b=4)
}
} {3 scan 4 sort 0}
do_test where7-1.20 {
set sql "SELECT a FROM t1 WHERE a=11 OR b=11"
for {set i 12} {$i<400} {incr i} {
append sql " OR a=$i OR b=$i"
}
append sql " ORDER BY a"
count_steps $sql
} {scan 0 sort 1}
do_test where7-1.21 {
set sql "SELECT a FROM t1 WHERE b=11 OR c=11"
for {set i 12} {$i<400} {incr i} {
append sql " OR b=$i OR c=$i"
}
append sql " ORDER BY a"
count_steps $sql
} {5 scan 0 sort 1}
do_test where7-1.22 {
set sql "SELECT a FROM t1 WHERE (b=11 OR c=11"
for {set i 12} {$i<400} {incr i} {
append sql " OR b=$i OR c=$i"
}
append sql ") AND d>=0 AND d<9999 ORDER BY a"
count_steps $sql
} {5 scan 0 sort 1}
do_test where7-1.23 {
set sql "SELECT a FROM t1 WHERE (b=11 OR c=11"
for {set i 12} {$i<400} {incr i} {
append sql " OR (b=$i AND d!=0) OR (c=$i AND d IS NOT NULL)"
}
append sql ") AND d>=0 AND d<9999 ORDER BY a"
count_steps $sql
} {5 scan 0 sort 1}
do_test where7-1.31 {
set sql "SELECT a FROM t1 WHERE (a=11 AND b=11)"
for {set i 12} {$i<400} {incr i} {
append sql " OR (a=$i AND b=$i)"
}
append sql " ORDER BY a"
count_steps $sql
} {scan 0 sort 1}
do_test where7-1.32 {
set sql "SELECT a FROM t1 WHERE (b=11 AND c=11)"
for {set i 12} {$i<400} {incr i} {
append sql " OR (b=$i AND c=$i)"
}
append sql " ORDER BY a"
count_steps $sql
} {scan 0 sort 1}
do_test where7-2.1 {
db eval {
CREATE TABLE t2(a INTEGER PRIMARY KEY,b,c,d,e,f TEXT,g);
INSERT INTO t2 VALUES(1,11,1001,1.001,100.1,'bcdefghij','yxwvuts');
INSERT INTO t2 VALUES(2,22,1001,2.002,100.1,'cdefghijk','yxwvuts');
INSERT INTO t2 VALUES(3,33,1001,3.0029999999999997,100.1,'defghijkl','xwvutsr');
INSERT INTO t2 VALUES(4,44,2002,4.004,200.2,'efghijklm','xwvutsr');
INSERT INTO t2 VALUES(5,55,2002,5.004999999999999,200.2,'fghijklmn','xwvutsr');
INSERT INTO t2 VALUES(6,66,2002,6.005999999999999,200.2,'ghijklmno','xwvutsr');
INSERT INTO t2 VALUES(7,77,3003,7.007,300.29999999999995,'hijklmnop','xwvutsr');
INSERT INTO t2 VALUES(8,88,3003,8.008,300.29999999999995,'ijklmnopq','wvutsrq');
INSERT INTO t2 VALUES(9,99,3003,9.008999999999999,300.29999999999995,'jklmnopqr','wvutsrq');
INSERT INTO t2 VALUES(10,110,4004,10.009999999999998,400.4,'klmnopqrs','wvutsrq');
INSERT INTO t2 VALUES(11,121,4004,11.011,400.4,'lmnopqrst','wvutsrq');
INSERT INTO t2 VALUES(12,132,4004,12.011999999999999,400.4,'mnopqrstu','wvutsrq');
INSERT INTO t2 VALUES(13,143,5005,13.012999999999998,500.5,'nopqrstuv','vutsrqp');
INSERT INTO t2 VALUES(14,154,5005,14.014,500.5,'opqrstuvw','vutsrqp');
INSERT INTO t2 VALUES(15,165,5005,15.014999999999999,500.5,'pqrstuvwx','vutsrqp');
INSERT INTO t2 VALUES(16,176,6006,16.016,600.5999999999999,'qrstuvwxy','vutsrqp');
INSERT INTO t2 VALUES(17,187,6006,17.017,600.5999999999999,'rstuvwxyz','vutsrqp');
INSERT INTO t2 VALUES(18,198,6006,18.017999999999997,600.5999999999999,'stuvwxyza','utsrqpo');
INSERT INTO t2 VALUES(19,209,7007,19.019,700.6999999999999,'tuvwxyzab','utsrqpo');
INSERT INTO t2 VALUES(20,220,7007,20.019999999999996,700.6999999999999,'uvwxyzabc','utsrqpo');
INSERT INTO t2 VALUES(21,231,7007,21.020999999999997,700.6999999999999,'vwxyzabcd','utsrqpo');
INSERT INTO t2 VALUES(22,242,8008,22.022,800.8,'wxyzabcde','utsrqpo');
INSERT INTO t2 VALUES(23,253,8008,23.022999999999996,800.8,'xyzabcdef','tsrqpon');
INSERT INTO t2 VALUES(24,264,8008,24.023999999999997,800.8,'yzabcdefg','tsrqpon');
INSERT INTO t2 VALUES(25,275,9009,25.025,900.9,'zabcdefgh','tsrqpon');
INSERT INTO t2 VALUES(26,286,9009,26.025999999999996,900.9,'abcdefghi','tsrqpon');
INSERT INTO t2 VALUES(27,297,9009,27.026999999999997,900.9,'bcdefghij','tsrqpon');
INSERT INTO t2 VALUES(28,308,10010,28.028,1001.0,'cdefghijk','srqponm');
INSERT INTO t2 VALUES(29,319,10010,29.028999999999996,1001.0,'defghijkl','srqponm');
INSERT INTO t2 VALUES(30,330,10010,30.029999999999998,1001.0,'efghijklm','srqponm');
INSERT INTO t2 VALUES(31,341,11011,31.030999999999995,1101.1,'fghijklmn','srqponm');
INSERT INTO t2 VALUES(32,352,11011,32.032,1101.1,'ghijklmno','srqponm');
INSERT INTO t2 VALUES(33,363,11011,33.032999999999994,1101.1,'hijklmnop','rqponml');
INSERT INTO t2 VALUES(34,374,12012,34.034,1201.1999999999998,'ijklmnopq','rqponml');
INSERT INTO t2 VALUES(35,385,12012,35.035,1201.1999999999998,'jklmnopqr','rqponml');
INSERT INTO t2 VALUES(36,396,12012,36.035999999999994,1201.1999999999998,'klmnopqrs','rqponml');
INSERT INTO t2 VALUES(37,407,13013,37.037,1301.3,'lmnopqrst','rqponml');
INSERT INTO t2 VALUES(38,418,13013,38.038,1301.3,'mnopqrstu','qponmlk');
INSERT INTO t2 VALUES(39,429,13013,39.038999999999994,1301.3,'nopqrstuv','qponmlk');
INSERT INTO t2 VALUES(40,440,14014,40.03999999999999,1401.3999999999999,'opqrstuvw','qponmlk');
INSERT INTO t2 VALUES(41,451,14014,41.041,1401.3999999999999,'pqrstuvwx','qponmlk');
INSERT INTO t2 VALUES(42,462,14014,42.041999999999994,1401.3999999999999,'qrstuvwxy','qponmlk');
INSERT INTO t2 VALUES(43,473,15015,43.04299999999999,1501.5,'rstuvwxyz','ponmlkj');
INSERT INTO t2 VALUES(44,484,15015,44.044,1501.5,'stuvwxyza','ponmlkj');
INSERT INTO t2 VALUES(45,495,15015,45.044999999999995,1501.5,'tuvwxyzab','ponmlkj');
INSERT INTO t2 VALUES(46,506,16016,46.04599999999999,1601.6,'uvwxyzabc','ponmlkj');
INSERT INTO t2 VALUES(47,517,16016,47.047,1601.6,'vwxyzabcd','ponmlkj');
INSERT INTO t2 VALUES(48,528,16016,48.047999999999995,1601.6,'wxyzabcde','onmlkji');
INSERT INTO t2 VALUES(49,539,17017,49.04899999999999,1701.6999999999998,'xyzabcdef','onmlkji');
INSERT INTO t2 VALUES(50,550,17017,50.05,1701.6999999999998,'yzabcdefg','onmlkji');
INSERT INTO t2 VALUES(51,561,17017,51.050999999999995,1701.6999999999998,'zabcdefgh','onmlkji');
INSERT INTO t2 VALUES(52,572,18018,52.05199999999999,1801.8,'abcdefghi','onmlkji');
INSERT INTO t2 VALUES(53,583,18018,53.053,1801.8,'bcdefghij','nmlkjih');
INSERT INTO t2 VALUES(54,594,18018,54.053999999999995,1801.8,'cdefghijk','nmlkjih');
INSERT INTO t2 VALUES(55,605,19019,55.05499999999999,1901.8999999999999,'defghijkl','nmlkjih');
INSERT INTO t2 VALUES(56,616,19019,56.056,1901.8999999999999,'efghijklm','nmlkjih');
INSERT INTO t2 VALUES(57,627,19019,57.056999999999995,1901.8999999999999,'fghijklmn','nmlkjih');
INSERT INTO t2 VALUES(58,638,20020,58.05799999999999,2002.0,'ghijklmno','mlkjihg');
INSERT INTO t2 VALUES(59,649,20020,59.05899999999999,2002.0,'hijklmnop','mlkjihg');
INSERT INTO t2 VALUES(60,660,20020,60.059999999999995,2002.0,'ijklmnopq','mlkjihg');
INSERT INTO t2 VALUES(61,671,21021,61.06099999999999,2102.1,'jklmnopqr','mlkjihg');
INSERT INTO t2 VALUES(62,682,21021,62.06199999999999,2102.1,'klmnopqrs','mlkjihg');
INSERT INTO t2 VALUES(63,693,21021,63.062999999999995,2102.1,'lmnopqrst','lkjihgf');
INSERT INTO t2 VALUES(64,704,22022,64.064,2202.2,'mnopqrstu','lkjihgf');
INSERT INTO t2 VALUES(65,715,22022,65.065,2202.2,'nopqrstuv','lkjihgf');
INSERT INTO t2 VALUES(66,726,22022,66.06599999999999,2202.2,'opqrstuvw','lkjihgf');
INSERT INTO t2 VALUES(67,737,23023,67.067,2302.2999999999997,'pqrstuvwx','lkjihgf');
INSERT INTO t2 VALUES(68,748,23023,68.068,2302.2999999999997,'qrstuvwxy','kjihgfe');
INSERT INTO t2 VALUES(69,759,23023,69.06899999999999,2302.2999999999997,'rstuvwxyz','kjihgfe');
INSERT INTO t2 VALUES(70,770,24024,70.07,2402.3999999999996,'stuvwxyza','kjihgfe');
INSERT INTO t2 VALUES(71,781,24024,71.071,2402.3999999999996,'tuvwxyzab','kjihgfe');
INSERT INTO t2 VALUES(72,792,24024,72.07199999999999,2402.3999999999996,'uvwxyzabc','kjihgfe');
INSERT INTO t2 VALUES(73,803,25025,73.073,2502.5,'vwxyzabcd','jihgfed');
INSERT INTO t2 VALUES(74,814,25025,74.074,2502.5,'wxyzabcde','jihgfed');
INSERT INTO t2 VALUES(75,825,25025,75.07499999999999,2502.5,'xyzabcdef','jihgfed');
INSERT INTO t2 VALUES(76,836,26026,76.076,2602.6,'yzabcdefg','jihgfed');
INSERT INTO t2 VALUES(77,847,26026,77.077,2602.6,'zabcdefgh','jihgfed');
INSERT INTO t2 VALUES(78,858,26026,78.07799999999999,2602.6,'abcdefghi','ihgfedc');
INSERT INTO t2 VALUES(79,869,27027,79.079,2702.7,'bcdefghij','ihgfedc');
INSERT INTO t2 VALUES(80,880,27027,80.07999999999998,2702.7,'cdefghijk','ihgfedc');
INSERT INTO t2 VALUES(81,891,27027,81.08099999999999,2702.7,'defghijkl','ihgfedc');
INSERT INTO t2 VALUES(82,902,28028,82.082,2802.7999999999997,'efghijklm','ihgfedc');
INSERT INTO t2 VALUES(83,913,28028,83.08299999999998,2802.7999999999997,'fghijklmn','hgfedcb');
INSERT INTO t2 VALUES(84,924,28028,84.08399999999999,2802.7999999999997,'ghijklmno','hgfedcb');
INSERT INTO t2 VALUES(85,935,29029,85.085,2902.8999999999996,'hijklmnop','hgfedcb');
INSERT INTO t2 VALUES(86,946,29029,86.08599999999998,2902.8999999999996,'ijklmnopq','hgfedcb');
INSERT INTO t2 VALUES(87,957,29029,87.08699999999999,2902.8999999999996,'jklmnopqr','hgfedcb');
INSERT INTO t2 VALUES(88,968,30030,88.088,3003.0,'klmnopqrs','gfedcba');
INSERT INTO t2 VALUES(89,979,30030,89.08899999999998,3003.0,'lmnopqrst','gfedcba');
INSERT INTO t2 VALUES(90,990,30030,90.08999999999999,3003.0,'mnopqrstu','gfedcba');
INSERT INTO t2 VALUES(91,1001,31031,91.091,3103.1,'nopqrstuv','gfedcba');
INSERT INTO t2 VALUES(92,1012,31031,92.09199999999998,3103.1,'opqrstuvw','gfedcba');
INSERT INTO t2 VALUES(93,1023,31031,93.09299999999999,3103.1,'pqrstuvwx','fedcbaz');
INSERT INTO t2 VALUES(94,1034,32032,94.094,3203.2,'qrstuvwxy','fedcbaz');
INSERT INTO t2 VALUES(95,1045,32032,95.09499999999998,3203.2,'rstuvwxyz','fedcbaz');
INSERT INTO t2 VALUES(96,1056,32032,96.09599999999999,3203.2,'stuvwxyza','fedcbaz');
INSERT INTO t2 VALUES(97,1067,33033,97.097,3303.2999999999997,'tuvwxyzab','fedcbaz');
INSERT INTO t2 VALUES(98,1078,33033,98.09799999999998,3303.2999999999997,'uvwxyzabc','edcbazy');
INSERT INTO t2 VALUES(99,1089,33033,99.09899999999999,3303.2999999999997,'vwxyzabcd','edcbazy');
INSERT INTO t2 VALUES(100,1100,34034,100.1,3403.3999999999996,'wxyzabcde','edcbazy');
CREATE INDEX t2b ON t2(b);
CREATE INDEX t2c ON t2(c);
CREATE INDEX t2d ON t2(d);
CREATE INDEX t2e ON t2(e);
CREATE INDEX t2f ON t2(f);
CREATE INDEX t2g ON t2(g);
CREATE TABLE t3(a INTEGER PRIMARY KEY,b,c,d,e,f TEXT,g);
INSERT INTO t3 SELECT * FROM t2;
CREATE INDEX t3b ON t3(b,c);
CREATE INDEX t3c ON t3(c,e);
CREATE INDEX t3d ON t3(d,g);
CREATE INDEX t3e ON t3(e,f,g);
CREATE INDEX t3f ON t3(f,b,d,c);
CREATE INDEX t3g ON t3(g,f);
}
} {}
do_test where7-2.2.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=1070
OR (g='edcbazy' AND f GLOB 'wxyza*')
OR (d>=89.0 AND d<90.0 AND d NOT NULL)
OR ((a BETWEEN 18 AND 20) AND a!=19)
OR (g='qponmlk' AND f GLOB 'nopqr*')
OR (g='fedcbaz' AND f GLOB 'stuvw*')
OR (f GLOB '?hijk*' AND f GLOB 'ghij*')
}
} {6 18 20 32 39 58 84 89 96 100 scan 0 sort 0}
do_test where7-2.2.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=1070
OR (g='edcbazy' AND f GLOB 'wxyza*')
OR (d>=89.0 AND d<90.0 AND d NOT NULL)
OR ((a BETWEEN 18 AND 20) AND a!=19)
OR (g='qponmlk' AND f GLOB 'nopqr*')
OR (g='fedcbaz' AND f GLOB 'stuvw*')
OR (f GLOB '?hijk*' AND f GLOB 'ghij*')
}
} {6 18 20 32 39 58 84 89 96 100 scan 0 sort 0}
do_test where7-2.3.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=47.0 AND d<48.0 AND d NOT NULL)
OR ((a BETWEEN 33 AND 35) AND a!=34)
OR (g='edcbazy' AND f GLOB 'uvwxy*')
OR b=220
OR (d>=70.0 AND d<71.0 AND d NOT NULL)
OR ((a BETWEEN 67 AND 69) AND a!=68)
OR (g='qponmlk' AND f GLOB 'pqrst*')
}
} {20 33 35 41 47 67 69 70 98 scan 0 sort 0}
do_test where7-2.3.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=47.0 AND d<48.0 AND d NOT NULL)
OR ((a BETWEEN 33 AND 35) AND a!=34)
OR (g='edcbazy' AND f GLOB 'uvwxy*')
OR b=220
OR (d>=70.0 AND d<71.0 AND d NOT NULL)
OR ((a BETWEEN 67 AND 69) AND a!=68)
OR (g='qponmlk' AND f GLOB 'pqrst*')
}
} {20 33 35 41 47 67 69 70 98 scan 0 sort 0}
do_test where7-2.4.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=190
OR ((a BETWEEN 49 AND 51) AND a!=50)
OR (g='rqponml' AND f GLOB 'hijkl*')
OR b=407
}
} {33 37 49 51 scan 0 sort 0}
do_test where7-2.4.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=190
OR ((a BETWEEN 49 AND 51) AND a!=50)
OR (g='rqponml' AND f GLOB 'hijkl*')
OR b=407
}
} {33 37 49 51 scan 0 sort 0}
do_test where7-2.5.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (f GLOB '?opqr*' AND f GLOB 'nopq*')
OR b=795
OR b=1103
OR b=583
}
} {13 39 53 65 91 scan 0 sort 0}
do_test where7-2.5.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (f GLOB '?opqr*' AND f GLOB 'nopq*')
OR b=795
OR b=1103
OR b=583
}
} {13 39 53 65 91 scan 0 sort 0}
do_test where7-2.6.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=74
OR a=50
OR (g='hgfedcb' AND f GLOB 'hijkl*')
OR ((a BETWEEN 16 AND 18) AND a!=17)
OR c=21021
OR ((a BETWEEN 82 AND 84) AND a!=83)
}
} {16 18 50 61 62 63 74 82 84 85 scan 0 sort 0}
do_test where7-2.6.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=74
OR a=50
OR (g='hgfedcb' AND f GLOB 'hijkl*')
OR ((a BETWEEN 16 AND 18) AND a!=17)
OR c=21021
OR ((a BETWEEN 82 AND 84) AND a!=83)
}
} {16 18 50 61 62 63 74 82 84 85 scan 0 sort 0}
do_test where7-2.7.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 8 AND 10) AND a!=9)
OR (d>=94.0 AND d<95.0 AND d NOT NULL)
OR ((a BETWEEN 34 AND 36) AND a!=35)
OR c=14014
OR b=828
}
} {8 10 34 36 40 41 42 94 scan 0 sort 0}
do_test where7-2.7.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 8 AND 10) AND a!=9)
OR (d>=94.0 AND d<95.0 AND d NOT NULL)
OR ((a BETWEEN 34 AND 36) AND a!=35)
OR c=14014
OR b=828
}
} {8 10 34 36 40 41 42 94 scan 0 sort 0}
do_test where7-2.8.1 {
count_steps_sort {
SELECT a FROM t2
WHERE 1000000<b
OR b=308
}
} {28 scan 0 sort 0}
do_test where7-2.8.2 {
count_steps_sort {
SELECT a FROM t3
WHERE 1000000<b
OR b=308
}
} {28 scan 0 sort 0}
do_test where7-2.9.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=949
OR ((a BETWEEN 22 AND 24) AND a!=23)
OR a=63
}
} {22 24 63 scan 0 sort 0}
do_test where7-2.9.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=949
OR ((a BETWEEN 22 AND 24) AND a!=23)
OR a=63
}
} {22 24 63 scan 0 sort 0}
do_test where7-2.10.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 49 AND 51) AND a!=50)
OR b=396
OR ((a BETWEEN 68 AND 70) AND a!=69)
}
} {36 49 51 68 70 scan 0 sort 0}
do_test where7-2.10.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 49 AND 51) AND a!=50)
OR b=396
OR ((a BETWEEN 68 AND 70) AND a!=69)
}
} {36 49 51 68 70 scan 0 sort 0}
do_test where7-2.11.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=72.0 AND d<73.0 AND d NOT NULL)
OR (g='jihgfed' AND f GLOB 'wxyza*')
OR c=11011
OR c=20020
OR (d>=18.0 AND d<19.0 AND d NOT NULL)
}
} {18 31 32 33 58 59 60 72 74 scan 0 sort 0}
do_test where7-2.11.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=72.0 AND d<73.0 AND d NOT NULL)
OR (g='jihgfed' AND f GLOB 'wxyza*')
OR c=11011
OR c=20020
OR (d>=18.0 AND d<19.0 AND d NOT NULL)
}
} {18 31 32 33 58 59 60 72 74 scan 0 sort 0}
do_test where7-2.12.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=50.0 AND d<51.0 AND d NOT NULL)
OR (d>=83.0 AND d<84.0 AND d NOT NULL)
OR (g='vutsrqp' AND f GLOB 'rstuv*')
OR b=792
OR a=97
OR (d>=87.0 AND d<88.0 AND d NOT NULL)
OR (d>=81.0 AND d<82.0 AND d NOT NULL)
OR b=916
OR a=69
OR (d>=31.0 AND d<32.0 AND d NOT NULL)
OR c=6006
}
} {16 17 18 31 50 69 72 81 83 87 97 scan 0 sort 0}
do_test where7-2.12.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=50.0 AND d<51.0 AND d NOT NULL)
OR (d>=83.0 AND d<84.0 AND d NOT NULL)
OR (g='vutsrqp' AND f GLOB 'rstuv*')
OR b=792
OR a=97
OR (d>=87.0 AND d<88.0 AND d NOT NULL)
OR (d>=81.0 AND d<82.0 AND d NOT NULL)
OR b=916
OR a=69
OR (d>=31.0 AND d<32.0 AND d NOT NULL)
OR c=6006
}
} {16 17 18 31 50 69 72 81 83 87 97 scan 0 sort 0}
do_test where7-2.13.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 50 AND 52) AND a!=51)
OR c=9009
OR (g='utsrqpo' AND f GLOB 'vwxyz*')
OR b=539
OR b=297
OR (g='wvutsrq' AND f GLOB 'klmno*')
OR (g='vutsrqp' AND f GLOB 'pqrst*')
OR b=957
OR f='xyzabcdef'
OR b=619
}
} {10 15 21 23 25 26 27 49 50 52 75 87 scan 0 sort 0}
do_test where7-2.13.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 50 AND 52) AND a!=51)
OR c=9009
OR (g='utsrqpo' AND f GLOB 'vwxyz*')
OR b=539
OR b=297
OR (g='wvutsrq' AND f GLOB 'klmno*')
OR (g='vutsrqp' AND f GLOB 'pqrst*')
OR b=957
OR f='xyzabcdef'
OR b=619
}
} {10 15 21 23 25 26 27 49 50 52 75 87 scan 0 sort 0}
do_test where7-2.14.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 47 AND 49) AND a!=48)
OR (d>=48.0 AND d<49.0 AND d NOT NULL)
}
} {47 48 49 scan 0 sort 0}
do_test where7-2.14.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 47 AND 49) AND a!=48)
OR (d>=48.0 AND d<49.0 AND d NOT NULL)
}
} {47 48 49 scan 0 sort 0}
do_test where7-2.15.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=20
OR a=67
OR b=58
OR ((a BETWEEN 19 AND 21) AND a!=20)
}
} {19 20 21 67 scan 0 sort 0}
do_test where7-2.15.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=20
OR a=67
OR b=58
OR ((a BETWEEN 19 AND 21) AND a!=20)
}
} {19 20 21 67 scan 0 sort 0}
do_test where7-2.16.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=938
OR (d>=67.0 AND d<68.0 AND d NOT NULL)
OR (g='vutsrqp' AND f GLOB 'rstuv*')
}
} {17 67 scan 0 sort 0}
do_test where7-2.16.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=938
OR (d>=67.0 AND d<68.0 AND d NOT NULL)
OR (g='vutsrqp' AND f GLOB 'rstuv*')
}
} {17 67 scan 0 sort 0}
do_test where7-2.17.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=68.0 AND d<69.0 AND d NOT NULL)
OR f='zabcdefgh'
OR b=308
OR (d>=16.0 AND d<17.0 AND d NOT NULL)
OR (g='srqponm' AND f GLOB 'defgh*')
OR ((a BETWEEN 15 AND 17) AND a!=16)
OR b=443
OR ((a BETWEEN 12 AND 14) AND a!=13)
OR f='uvwxyzabc'
OR (f GLOB '?zabc*' AND f GLOB 'yzab*')
}
} {12 14 15 16 17 20 24 25 28 29 46 50 51 68 72 76 77 98 scan 0 sort 0}
do_test where7-2.17.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=68.0 AND d<69.0 AND d NOT NULL)
OR f='zabcdefgh'
OR b=308
OR (d>=16.0 AND d<17.0 AND d NOT NULL)
OR (g='srqponm' AND f GLOB 'defgh*')
OR ((a BETWEEN 15 AND 17) AND a!=16)
OR b=443
OR ((a BETWEEN 12 AND 14) AND a!=13)
OR f='uvwxyzabc'
OR (f GLOB '?zabc*' AND f GLOB 'yzab*')
}
} {12 14 15 16 17 20 24 25 28 29 46 50 51 68 72 76 77 98 scan 0 sort 0}
do_test where7-2.18.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=46.0 AND d<47.0 AND d NOT NULL)
OR b=762
OR (d>=56.0 AND d<57.0 AND d NOT NULL)
OR a=19
}
} {19 46 56 scan 0 sort 0}
do_test where7-2.18.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=46.0 AND d<47.0 AND d NOT NULL)
OR b=762
OR (d>=56.0 AND d<57.0 AND d NOT NULL)
OR a=19
}
} {19 46 56 scan 0 sort 0}
do_test where7-2.19.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=63.0 AND d<64.0 AND d NOT NULL)
OR a=46
OR (g='yxwvuts' AND f GLOB 'cdefg*')
OR a=73
OR c=20020
OR ((a BETWEEN 2 AND 4) AND a!=3)
OR b=267
OR ((a BETWEEN 68 AND 70) AND a!=69)
OR (g='utsrqpo' AND f GLOB 'uvwxy*')
}
} {2 4 20 46 58 59 60 63 68 70 73 scan 0 sort 0}
do_test where7-2.19.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=63.0 AND d<64.0 AND d NOT NULL)
OR a=46
OR (g='yxwvuts' AND f GLOB 'cdefg*')
OR a=73
OR c=20020
OR ((a BETWEEN 2 AND 4) AND a!=3)
OR b=267
OR ((a BETWEEN 68 AND 70) AND a!=69)
OR (g='utsrqpo' AND f GLOB 'uvwxy*')
}
} {2 4 20 46 58 59 60 63 68 70 73 scan 0 sort 0}
do_test where7-2.20.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 27 AND 29) AND a!=28)
OR (g='gfedcba' AND f GLOB 'nopqr*')
}
} {27 29 91 scan 0 sort 0}
do_test where7-2.20.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 27 AND 29) AND a!=28)
OR (g='gfedcba' AND f GLOB 'nopqr*')
}
} {27 29 91 scan 0 sort 0}
do_test where7-2.21.1 {
count_steps_sort {
SELECT a FROM t2
WHERE c=13013
OR (d>=55.0 AND d<56.0 AND d NOT NULL)
OR (d>=75.0 AND d<76.0 AND d NOT NULL)
OR ((a BETWEEN 87 AND 89) AND a!=88)
OR f='bcdefghij'
OR b=586
OR (g='edcbazy' AND f GLOB 'uvwxy*')
OR ((a BETWEEN 59 AND 61) AND a!=60)
OR (g='mlkjihg' AND f GLOB 'ghijk*')
OR (d>=6.0 AND d<7.0 AND d NOT NULL)
OR a=9
}
} {1 6 9 27 37 38 39 53 55 58 59 61 75 79 87 89 98 scan 0 sort 0}
do_test where7-2.21.2 {
count_steps_sort {
SELECT a FROM t3
WHERE c=13013
OR (d>=55.0 AND d<56.0 AND d NOT NULL)
OR (d>=75.0 AND d<76.0 AND d NOT NULL)
OR ((a BETWEEN 87 AND 89) AND a!=88)
OR f='bcdefghij'
OR b=586
OR (g='edcbazy' AND f GLOB 'uvwxy*')
OR ((a BETWEEN 59 AND 61) AND a!=60)
OR (g='mlkjihg' AND f GLOB 'ghijk*')
OR (d>=6.0 AND d<7.0 AND d NOT NULL)
OR a=9
}
} {1 6 9 27 37 38 39 53 55 58 59 61 75 79 87 89 98 scan 0 sort 0}
do_test where7-2.22.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=399
OR c=28028
OR (d>=82.0 AND d<83.0 AND d NOT NULL)
OR (g='qponmlk' AND f GLOB 'qrstu*')
OR (d>=98.0 AND d<99.0 AND d NOT NULL)
}
} {42 82 83 84 98 scan 0 sort 0}
do_test where7-2.22.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=399
OR c=28028
OR (d>=82.0 AND d<83.0 AND d NOT NULL)
OR (g='qponmlk' AND f GLOB 'qrstu*')
OR (d>=98.0 AND d<99.0 AND d NOT NULL)
}
} {42 82 83 84 98 scan 0 sort 0}
do_test where7-2.23.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='fedcbaz' AND f GLOB 'rstuv*')
OR ((a BETWEEN 96 AND 98) AND a!=97)
OR c=14014
OR c=33033
OR a=89
OR b=770
OR (g='utsrqpo' AND f GLOB 'tuvwx*')
OR a=35
OR (f GLOB '?fghi*' AND f GLOB 'efgh*')
OR b=253
OR c=14014
}
} {4 19 23 30 35 40 41 42 56 70 82 89 95 96 97 98 99 scan 0 sort 0}
do_test where7-2.23.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='fedcbaz' AND f GLOB 'rstuv*')
OR ((a BETWEEN 96 AND 98) AND a!=97)
OR c=14014
OR c=33033
OR a=89
OR b=770
OR (g='utsrqpo' AND f GLOB 'tuvwx*')
OR a=35
OR (f GLOB '?fghi*' AND f GLOB 'efgh*')
OR b=253
OR c=14014
}
} {4 19 23 30 35 40 41 42 56 70 82 89 95 96 97 98 99 scan 0 sort 0}
do_test where7-2.24.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='utsrqpo' AND f GLOB 'vwxyz*')
OR ((a BETWEEN 32 AND 34) AND a!=33)
OR b=330
OR (g='xwvutsr' AND f GLOB 'ghijk*')
OR a=16
}
} {6 16 21 30 32 34 scan 0 sort 0}
do_test where7-2.24.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='utsrqpo' AND f GLOB 'vwxyz*')
OR ((a BETWEEN 32 AND 34) AND a!=33)
OR b=330
OR (g='xwvutsr' AND f GLOB 'ghijk*')
OR a=16
}
} {6 16 21 30 32 34 scan 0 sort 0}
do_test where7-2.25.1 {
count_steps_sort {
SELECT a FROM t2
WHERE c=5005
OR (d>=2.0 AND d<3.0 AND d NOT NULL)
OR ((a BETWEEN 36 AND 38) AND a!=37)
OR (g='ponmlkj' AND f GLOB 'vwxyz*')
}
} {2 13 14 15 36 38 47 scan 0 sort 0}
do_test where7-2.25.2 {
count_steps_sort {
SELECT a FROM t3
WHERE c=5005
OR (d>=2.0 AND d<3.0 AND d NOT NULL)
OR ((a BETWEEN 36 AND 38) AND a!=37)
OR (g='ponmlkj' AND f GLOB 'vwxyz*')
}
} {2 13 14 15 36 38 47 scan 0 sort 0}
do_test where7-2.26.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=30.0 AND d<31.0 AND d NOT NULL)
OR (g='mlkjihg' AND f GLOB 'ghijk*')
OR ((a BETWEEN 64 AND 66) AND a!=65)
OR (g='kjihgfe' AND f GLOB 'qrstu*')
OR a=33
}
} {30 33 58 64 66 68 scan 0 sort 0}
do_test where7-2.26.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=30.0 AND d<31.0 AND d NOT NULL)
OR (g='mlkjihg' AND f GLOB 'ghijk*')
OR ((a BETWEEN 64 AND 66) AND a!=65)
OR (g='kjihgfe' AND f GLOB 'qrstu*')
OR a=33
}
} {30 33 58 64 66 68 scan 0 sort 0}
do_test where7-2.27.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=1026
OR b=410
}
} { scan 0 sort 0}
do_test where7-2.27.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=1026
OR b=410
}
} { scan 0 sort 0}
do_test where7-2.28.1 {
count_steps_sort {
SELECT a FROM t2
WHERE c=18018
OR a=94
OR (f GLOB '?qrst*' AND f GLOB 'pqrs*')
OR (g='tsrqpon' AND f GLOB 'abcde*')
OR b=1012
OR a=3
OR d>1e10
OR b=905
OR b=1089
}
} {3 15 26 41 52 53 54 67 92 93 94 99 scan 0 sort 0}
do_test where7-2.28.2 {
count_steps_sort {
SELECT a FROM t3
WHERE c=18018
OR a=94
OR (f GLOB '?qrst*' AND f GLOB 'pqrs*')
OR (g='tsrqpon' AND f GLOB 'abcde*')
OR b=1012
OR a=3
OR d>1e10
OR b=905
OR b=1089
}
} {3 15 26 41 52 53 54 67 92 93 94 99 scan 0 sort 0}
do_test where7-2.29.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=100
OR c=11011
OR b=297
OR a=63
OR (g='hgfedcb' AND f GLOB 'ghijk*')
OR a=76
OR b=1026
OR a=26
OR (f GLOB '?zabc*' AND f GLOB 'yzab*')
OR c=30030
}
} {24 26 27 31 32 33 50 63 76 84 88 89 90 100 scan 0 sort 0}
do_test where7-2.29.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=100
OR c=11011
OR b=297
OR a=63
OR (g='hgfedcb' AND f GLOB 'ghijk*')
OR a=76
OR b=1026
OR a=26
OR (f GLOB '?zabc*' AND f GLOB 'yzab*')
OR c=30030
}
} {24 26 27 31 32 33 50 63 76 84 88 89 90 100 scan 0 sort 0}
do_test where7-2.30.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=561
OR b=1070
OR a=59
OR b=715
OR (f GLOB '?yzab*' AND f GLOB 'xyza*')
}
} {23 49 51 59 65 75 scan 0 sort 0}
do_test where7-2.30.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=561
OR b=1070
OR a=59
OR b=715
OR (f GLOB '?yzab*' AND f GLOB 'xyza*')
}
} {23 49 51 59 65 75 scan 0 sort 0}
do_test where7-2.31.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='fedcbaz' AND f GLOB 'rstuv*')
OR b=1056
OR b=1012
OR ((a BETWEEN 57 AND 59) AND a!=58)
OR ((a BETWEEN 67 AND 69) AND a!=68)
OR (d>=19.0 AND d<20.0 AND d NOT NULL)
OR (f GLOB '?bcde*' AND f GLOB 'abcd*')
}
} {19 26 52 57 59 67 69 78 92 95 96 scan 0 sort 0}
do_test where7-2.31.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='fedcbaz' AND f GLOB 'rstuv*')
OR b=1056
OR b=1012
OR ((a BETWEEN 57 AND 59) AND a!=58)
OR ((a BETWEEN 67 AND 69) AND a!=68)
OR (d>=19.0 AND d<20.0 AND d NOT NULL)
OR (f GLOB '?bcde*' AND f GLOB 'abcd*')
}
} {19 26 52 57 59 67 69 78 92 95 96 scan 0 sort 0}
do_test where7-2.32.1 {
count_steps_sort {
SELECT a FROM t2
WHERE f='rstuvwxyz'
OR (g='jihgfed' AND f GLOB 'wxyza*')
OR ((a BETWEEN 90 AND 92) AND a!=91)
OR (d>=98.0 AND d<99.0 AND d NOT NULL)
}
} {17 43 69 74 90 92 95 98 scan 0 sort 0}
do_test where7-2.32.2 {
count_steps_sort {
SELECT a FROM t3
WHERE f='rstuvwxyz'
OR (g='jihgfed' AND f GLOB 'wxyza*')
OR ((a BETWEEN 90 AND 92) AND a!=91)
OR (d>=98.0 AND d<99.0 AND d NOT NULL)
}
} {17 43 69 74 90 92 95 98 scan 0 sort 0}
do_test where7-2.33.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (f GLOB '?stuv*' AND f GLOB 'rstu*')
OR c=12012
OR a=18
OR (g='jihgfed' AND f GLOB 'yzabc*')
OR (f GLOB '?bcde*' AND f GLOB 'abcd*')
OR (f GLOB '?klmn*' AND f GLOB 'jklm*')
OR (f GLOB '?qrst*' AND f GLOB 'pqrs*')
}
} {9 15 17 18 26 34 35 36 41 43 52 61 67 69 76 78 87 93 95 scan 0 sort 0}
do_test where7-2.33.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (f GLOB '?stuv*' AND f GLOB 'rstu*')
OR c=12012
OR a=18
OR (g='jihgfed' AND f GLOB 'yzabc*')
OR (f GLOB '?bcde*' AND f GLOB 'abcd*')
OR (f GLOB '?klmn*' AND f GLOB 'jklm*')
OR (f GLOB '?qrst*' AND f GLOB 'pqrs*')
}
} {9 15 17 18 26 34 35 36 41 43 52 61 67 69 76 78 87 93 95 scan 0 sort 0}
do_test where7-2.34.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=77
OR (d>=58.0 AND d<59.0 AND d NOT NULL)
}
} {58 77 scan 0 sort 0}
do_test where7-2.34.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=77
OR (d>=58.0 AND d<59.0 AND d NOT NULL)
}
} {58 77 scan 0 sort 0}
do_test where7-2.35.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=498
OR (d>=27.0 AND d<28.0 AND d NOT NULL)
OR (d>=88.0 AND d<89.0 AND d NOT NULL)
OR ((a BETWEEN 67 AND 69) AND a!=68)
OR ((a BETWEEN 67 AND 69) AND a!=68)
OR c=33033
OR b=11
OR (g='wvutsrq' AND f GLOB 'lmnop*')
OR ((a BETWEEN 7 AND 9) AND a!=8)
}
} {1 7 9 11 27 67 69 88 97 98 99 scan 0 sort 0}
do_test where7-2.35.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=498
OR (d>=27.0 AND d<28.0 AND d NOT NULL)
OR (d>=88.0 AND d<89.0 AND d NOT NULL)
OR ((a BETWEEN 67 AND 69) AND a!=68)
OR ((a BETWEEN 67 AND 69) AND a!=68)
OR c=33033
OR b=11
OR (g='wvutsrq' AND f GLOB 'lmnop*')
OR ((a BETWEEN 7 AND 9) AND a!=8)
}
} {1 7 9 11 27 67 69 88 97 98 99 scan 0 sort 0}
do_test where7-2.36.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=6.0 AND d<7.0 AND d NOT NULL)
OR ((a BETWEEN 58 AND 60) AND a!=59)
}
} {6 58 60 scan 0 sort 0}
do_test where7-2.36.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=6.0 AND d<7.0 AND d NOT NULL)
OR ((a BETWEEN 58 AND 60) AND a!=59)
}
} {6 58 60 scan 0 sort 0}
do_test where7-2.37.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=1059
OR (d>=43.0 AND d<44.0 AND d NOT NULL)
OR c=4004
OR b=806
}
} {10 11 12 43 scan 0 sort 0}
do_test where7-2.37.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=1059
OR (d>=43.0 AND d<44.0 AND d NOT NULL)
OR c=4004
OR b=806
}
} {10 11 12 43 scan 0 sort 0}
do_test where7-2.38.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=165
OR b=201
OR (g='edcbazy' AND f GLOB 'vwxyz*')
OR a=32
}
} {15 32 99 scan 0 sort 0}
do_test where7-2.38.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=165
OR b=201
OR (g='edcbazy' AND f GLOB 'vwxyz*')
OR a=32
}
} {15 32 99 scan 0 sort 0}
do_test where7-2.39.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='kjihgfe' AND f GLOB 'rstuv*')
OR (f GLOB '?xyza*' AND f GLOB 'wxyz*')
}
} {22 48 69 74 100 scan 0 sort 0}
do_test where7-2.39.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='kjihgfe' AND f GLOB 'rstuv*')
OR (f GLOB '?xyza*' AND f GLOB 'wxyz*')
}
} {22 48 69 74 100 scan 0 sort 0}
do_test where7-2.40.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=352
OR b=278
OR ((a BETWEEN 90 AND 92) AND a!=91)
OR ((a BETWEEN 28 AND 30) AND a!=29)
OR b=660
OR a=18
OR a=34
OR b=132
OR (g='gfedcba' AND f GLOB 'lmnop*')
OR (f GLOB '?defg*' AND f GLOB 'cdef*')
OR c=18018
}
} {2 12 18 28 30 32 34 52 53 54 60 80 89 90 92 scan 0 sort 0}
do_test where7-2.40.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=352
OR b=278
OR ((a BETWEEN 90 AND 92) AND a!=91)
OR ((a BETWEEN 28 AND 30) AND a!=29)
OR b=660
OR a=18
OR a=34
OR b=132
OR (g='gfedcba' AND f GLOB 'lmnop*')
OR (f GLOB '?defg*' AND f GLOB 'cdef*')
OR c=18018
}
} {2 12 18 28 30 32 34 52 53 54 60 80 89 90 92 scan 0 sort 0}
do_test where7-2.41.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=73.0 AND d<74.0 AND d NOT NULL)
OR ((a BETWEEN 5 AND 7) AND a!=6)
}
} {5 7 73 scan 0 sort 0}
do_test where7-2.41.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=73.0 AND d<74.0 AND d NOT NULL)
OR ((a BETWEEN 5 AND 7) AND a!=6)
}
} {5 7 73 scan 0 sort 0}
do_test where7-2.42.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (f GLOB '?efgh*' AND f GLOB 'defg*')
OR (d>=14.0 AND d<15.0 AND d NOT NULL)
OR (g='hgfedcb' AND f GLOB 'fghij*')
OR b=297
OR b=113
OR b=176
OR (g='utsrqpo' AND f GLOB 'vwxyz*')
OR (d>=75.0 AND d<76.0 AND d NOT NULL)
OR a=67
OR c=26026
}
} {3 14 16 21 27 29 55 67 75 76 77 78 81 83 scan 0 sort 0}
do_test where7-2.42.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (f GLOB '?efgh*' AND f GLOB 'defg*')
OR (d>=14.0 AND d<15.0 AND d NOT NULL)
OR (g='hgfedcb' AND f GLOB 'fghij*')
OR b=297
OR b=113
OR b=176
OR (g='utsrqpo' AND f GLOB 'vwxyz*')
OR (d>=75.0 AND d<76.0 AND d NOT NULL)
OR a=67
OR c=26026
}
} {3 14 16 21 27 29 55 67 75 76 77 78 81 83 scan 0 sort 0}
do_test where7-2.43.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=78.0 AND d<79.0 AND d NOT NULL)
OR ((a BETWEEN 4 AND 6) AND a!=5)
OR a=83
OR b=44
OR b=1023
OR ((a BETWEEN 11 AND 13) AND a!=12)
OR b=1023
OR f='ijklmnopq'
}
} {4 6 8 11 13 34 60 78 83 86 93 scan 0 sort 0}
do_test where7-2.43.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=78.0 AND d<79.0 AND d NOT NULL)
OR ((a BETWEEN 4 AND 6) AND a!=5)
OR a=83
OR b=44
OR b=1023
OR ((a BETWEEN 11 AND 13) AND a!=12)
OR b=1023
OR f='ijklmnopq'
}
} {4 6 8 11 13 34 60 78 83 86 93 scan 0 sort 0}
do_test where7-2.44.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=42.0 AND d<43.0 AND d NOT NULL)
OR b=935
OR ((a BETWEEN 32 AND 34) AND a!=33)
OR b=487
OR b=619
OR (g='qponmlk' AND f GLOB 'nopqr*')
OR (g='vutsrqp' AND f GLOB 'rstuv*')
}
} {17 32 34 39 42 85 scan 0 sort 0}
do_test where7-2.44.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=42.0 AND d<43.0 AND d NOT NULL)
OR b=935
OR ((a BETWEEN 32 AND 34) AND a!=33)
OR b=487
OR b=619
OR (g='qponmlk' AND f GLOB 'nopqr*')
OR (g='vutsrqp' AND f GLOB 'rstuv*')
}
} {17 32 34 39 42 85 scan 0 sort 0}
do_test where7-2.45.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=68.0 AND d<69.0 AND d NOT NULL)
OR (d>=94.0 AND d<95.0 AND d NOT NULL)
OR b=938
OR b=641
OR c=17017
OR a=82
OR (d>=65.0 AND d<66.0 AND d NOT NULL)
OR (g='rqponml' AND f GLOB 'lmnop*')
OR ((a BETWEEN 56 AND 58) AND a!=57)
OR (d>=39.0 AND d<40.0 AND d NOT NULL)
}
} {37 39 49 50 51 56 58 65 68 82 94 scan 0 sort 0}
do_test where7-2.45.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=68.0 AND d<69.0 AND d NOT NULL)
OR (d>=94.0 AND d<95.0 AND d NOT NULL)
OR b=938
OR b=641
OR c=17017
OR a=82
OR (d>=65.0 AND d<66.0 AND d NOT NULL)
OR (g='rqponml' AND f GLOB 'lmnop*')
OR ((a BETWEEN 56 AND 58) AND a!=57)
OR (d>=39.0 AND d<40.0 AND d NOT NULL)
}
} {37 39 49 50 51 56 58 65 68 82 94 scan 0 sort 0}
do_test where7-2.46.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='ihgfedc' AND f GLOB 'bcdef*')
OR c=22022
}
} {64 65 66 79 scan 0 sort 0}
do_test where7-2.46.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='ihgfedc' AND f GLOB 'bcdef*')
OR c=22022
}
} {64 65 66 79 scan 0 sort 0}
do_test where7-2.47.1 {
count_steps_sort {
SELECT a FROM t2
WHERE c=7007
OR b=91
OR b=212
OR (g='lkjihgf' AND f GLOB 'nopqr*')
OR c=28028
OR (d>=83.0 AND d<84.0 AND d NOT NULL)
}
} {19 20 21 65 82 83 84 scan 0 sort 0}
do_test where7-2.47.2 {
count_steps_sort {
SELECT a FROM t3
WHERE c=7007
OR b=91
OR b=212
OR (g='lkjihgf' AND f GLOB 'nopqr*')
OR c=28028
OR (d>=83.0 AND d<84.0 AND d NOT NULL)
}
} {19 20 21 65 82 83 84 scan 0 sort 0}
do_test where7-2.48.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=12.0 AND d<13.0 AND d NOT NULL)
OR a=51
OR ((a BETWEEN 28 AND 30) AND a!=29)
}
} {12 28 30 51 scan 0 sort 0}
do_test where7-2.48.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=12.0 AND d<13.0 AND d NOT NULL)
OR a=51
OR ((a BETWEEN 28 AND 30) AND a!=29)
}
} {12 28 30 51 scan 0 sort 0}
do_test where7-2.49.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='wvutsrq' AND f GLOB 'mnopq*')
OR (g='wvutsrq' AND f GLOB 'jklmn*')
OR (g='tsrqpon' AND f GLOB 'xyzab*')
OR ((a BETWEEN 0 AND 2) AND a!=1)
OR c=4004
OR b=322
OR c=13013
OR a=6
}
} {2 6 9 10 11 12 23 37 38 39 scan 0 sort 0}
do_test where7-2.49.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='wvutsrq' AND f GLOB 'mnopq*')
OR (g='wvutsrq' AND f GLOB 'jklmn*')
OR (g='tsrqpon' AND f GLOB 'xyzab*')
OR ((a BETWEEN 0 AND 2) AND a!=1)
OR c=4004
OR b=322
OR c=13013
OR a=6
}
} {2 6 9 10 11 12 23 37 38 39 scan 0 sort 0}
do_test where7-2.50.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=297
OR b=143
OR a=46
OR b=660
OR (d>=41.0 AND d<42.0 AND d NOT NULL)
OR (f GLOB '?yzab*' AND f GLOB 'xyza*')
OR (g='vutsrqp' AND f GLOB 'rstuv*')
OR b=355
OR a=93
OR b=297
}
} {13 17 23 27 41 46 49 60 75 93 scan 0 sort 0}
do_test where7-2.50.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=297
OR b=143
OR a=46
OR b=660
OR (d>=41.0 AND d<42.0 AND d NOT NULL)
OR (f GLOB '?yzab*' AND f GLOB 'xyza*')
OR (g='vutsrqp' AND f GLOB 'rstuv*')
OR b=355
OR a=93
OR b=297
}
} {13 17 23 27 41 46 49 60 75 93 scan 0 sort 0}
do_test where7-2.51.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=190
OR a=62
OR (g='edcbazy' AND f GLOB 'vwxyz*')
}
} {62 99 scan 0 sort 0}
do_test where7-2.51.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=190
OR a=62
OR (g='edcbazy' AND f GLOB 'vwxyz*')
}
} {62 99 scan 0 sort 0}
do_test where7-2.52.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=1089
OR b=102
OR a=6
OR b=608
}
} {6 99 scan 0 sort 0}
do_test where7-2.52.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=1089
OR b=102
OR a=6
OR b=608
}
} {6 99 scan 0 sort 0}
do_test where7-2.53.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=473
OR b=1100
OR (d>=53.0 AND d<54.0 AND d NOT NULL)
OR (d>=15.0 AND d<16.0 AND d NOT NULL)
OR a=20
OR b=1089
OR b=330
OR b=124
OR ((a BETWEEN 56 AND 58) AND a!=57)
}
} {15 20 30 43 53 56 58 99 100 scan 0 sort 0}
do_test where7-2.53.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=473
OR b=1100
OR (d>=53.0 AND d<54.0 AND d NOT NULL)
OR (d>=15.0 AND d<16.0 AND d NOT NULL)
OR a=20
OR b=1089
OR b=330
OR b=124
OR ((a BETWEEN 56 AND 58) AND a!=57)
}
} {15 20 30 43 53 56 58 99 100 scan 0 sort 0}
do_test where7-2.54.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 68 AND 70) AND a!=69)
OR b=223
OR a=12
OR b=1048
OR b=256
OR a=72
OR c>=34035
OR (g='rqponml' AND f GLOB 'jklmn*')
OR b=674
OR a=22
}
} {12 22 35 68 70 72 scan 0 sort 0}
do_test where7-2.54.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 68 AND 70) AND a!=69)
OR b=223
OR a=12
OR b=1048
OR b=256
OR a=72
OR c>=34035
OR (g='rqponml' AND f GLOB 'jklmn*')
OR b=674
OR a=22
}
} {12 22 35 68 70 72 scan 0 sort 0}
do_test where7-2.55.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 76 AND 78) AND a!=77)
OR (d>=24.0 AND d<25.0 AND d NOT NULL)
OR f='yzabcdefg'
OR c=14014
OR a=1
OR a=9
OR b=960
}
} {1 9 24 40 41 42 50 76 78 scan 0 sort 0}
do_test where7-2.55.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 76 AND 78) AND a!=77)
OR (d>=24.0 AND d<25.0 AND d NOT NULL)
OR f='yzabcdefg'
OR c=14014
OR a=1
OR a=9
OR b=960
}
} {1 9 24 40 41 42 50 76 78 scan 0 sort 0}
do_test where7-2.56.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='utsrqpo' AND f GLOB 'tuvwx*')
OR ((a BETWEEN 96 AND 98) AND a!=97)
OR (g='onmlkji' AND f GLOB 'xyzab*')
}
} {19 49 96 98 scan 0 sort 0}
do_test where7-2.56.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='utsrqpo' AND f GLOB 'tuvwx*')
OR ((a BETWEEN 96 AND 98) AND a!=97)
OR (g='onmlkji' AND f GLOB 'xyzab*')
}
} {19 49 96 98 scan 0 sort 0}
do_test where7-2.57.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=748
OR (d>=20.0 AND d<21.0 AND d NOT NULL)
OR (g='lkjihgf' AND f GLOB 'pqrst*')
OR (d>=9.0 AND d<10.0 AND d NOT NULL)
OR b=630
}
} {9 20 67 68 scan 0 sort 0}
do_test where7-2.57.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=748
OR (d>=20.0 AND d<21.0 AND d NOT NULL)
OR (g='lkjihgf' AND f GLOB 'pqrst*')
OR (d>=9.0 AND d<10.0 AND d NOT NULL)
OR b=630
}
} {9 20 67 68 scan 0 sort 0}
do_test where7-2.58.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=223
OR b=267
OR a=40
OR ((a BETWEEN 55 AND 57) AND a!=56)
OR c<=10
OR ((a BETWEEN 69 AND 71) AND a!=70)
OR b=528
}
} {40 48 55 57 69 71 scan 0 sort 0}
do_test where7-2.58.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=223
OR b=267
OR a=40
OR ((a BETWEEN 55 AND 57) AND a!=56)
OR c<=10
OR ((a BETWEEN 69 AND 71) AND a!=70)
OR b=528
}
} {40 48 55 57 69 71 scan 0 sort 0}
do_test where7-2.59.1 {
count_steps_sort {
SELECT a FROM t2
WHERE f='rstuvwxyz'
OR a=41
OR b=462
OR a=68
OR a=84
OR a=69
}
} {17 41 42 43 68 69 84 95 scan 0 sort 0}
do_test where7-2.59.2 {
count_steps_sort {
SELECT a FROM t3
WHERE f='rstuvwxyz'
OR a=41
OR b=462
OR a=68
OR a=84
OR a=69
}
} {17 41 42 43 68 69 84 95 scan 0 sort 0}
do_test where7-2.60.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=979
OR ((a BETWEEN 3 AND 5) AND a!=4)
OR (g='vutsrqp' AND f GLOB 'nopqr*')
}
} {3 5 13 89 scan 0 sort 0}
do_test where7-2.60.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=979
OR ((a BETWEEN 3 AND 5) AND a!=4)
OR (g='vutsrqp' AND f GLOB 'nopqr*')
}
} {3 5 13 89 scan 0 sort 0}
do_test where7-2.61.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=9.0 AND d<10.0 AND d NOT NULL)
OR a=8
OR a=62
OR b=726
OR (d>=10.0 AND d<11.0 AND d NOT NULL)
OR ((a BETWEEN 50 AND 52) AND a!=51)
OR (g='vutsrqp' AND f GLOB 'opqrs*')
OR ((a BETWEEN 59 AND 61) AND a!=60)
}
} {8 9 10 14 50 52 59 61 62 66 scan 0 sort 0}
do_test where7-2.61.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=9.0 AND d<10.0 AND d NOT NULL)
OR a=8
OR a=62
OR b=726
OR (d>=10.0 AND d<11.0 AND d NOT NULL)
OR ((a BETWEEN 50 AND 52) AND a!=51)
OR (g='vutsrqp' AND f GLOB 'opqrs*')
OR ((a BETWEEN 59 AND 61) AND a!=60)
}
} {8 9 10 14 50 52 59 61 62 66 scan 0 sort 0}
do_test where7-2.62.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=495
OR ((a BETWEEN 18 AND 20) AND a!=19)
OR b=924
OR c=11011
OR (f GLOB '?wxyz*' AND f GLOB 'vwxy*')
OR b=231
OR b=872
OR (g='jihgfed' AND f GLOB 'yzabc*')
}
} {18 20 21 31 32 33 45 47 73 76 84 99 scan 0 sort 0}
do_test where7-2.62.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=495
OR ((a BETWEEN 18 AND 20) AND a!=19)
OR b=924
OR c=11011
OR (f GLOB '?wxyz*' AND f GLOB 'vwxy*')
OR b=231
OR b=872
OR (g='jihgfed' AND f GLOB 'yzabc*')
}
} {18 20 21 31 32 33 45 47 73 76 84 99 scan 0 sort 0}
do_test where7-2.63.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=24
OR b=473
OR (g='hgfedcb' AND f GLOB 'ijklm*')
OR (g='fedcbaz' AND f GLOB 'stuvw*')
OR b=509
OR b=924
OR (d>=21.0 AND d<22.0 AND d NOT NULL)
}
} {21 24 43 84 86 96 scan 0 sort 0}
do_test where7-2.63.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=24
OR b=473
OR (g='hgfedcb' AND f GLOB 'ijklm*')
OR (g='fedcbaz' AND f GLOB 'stuvw*')
OR b=509
OR b=924
OR (d>=21.0 AND d<22.0 AND d NOT NULL)
}
} {21 24 43 84 86 96 scan 0 sort 0}
do_test where7-2.64.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=93.0 AND d<94.0 AND d NOT NULL)
OR (f GLOB '?jklm*' AND f GLOB 'ijkl*')
OR (f GLOB '?defg*' AND f GLOB 'cdef*')
OR (g='edcbazy' AND f GLOB 'wxyza*')
OR b=363
OR (g='xwvutsr' AND f GLOB 'fghij*')
OR ((a BETWEEN 23 AND 25) AND a!=24)
OR ((a BETWEEN 56 AND 58) AND a!=57)
}
} {2 5 8 23 25 28 33 34 54 56 58 60 80 86 93 100 scan 0 sort 0}
do_test where7-2.64.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=93.0 AND d<94.0 AND d NOT NULL)
OR (f GLOB '?jklm*' AND f GLOB 'ijkl*')
OR (f GLOB '?defg*' AND f GLOB 'cdef*')
OR (g='edcbazy' AND f GLOB 'wxyza*')
OR b=363
OR (g='xwvutsr' AND f GLOB 'fghij*')
OR ((a BETWEEN 23 AND 25) AND a!=24)
OR ((a BETWEEN 56 AND 58) AND a!=57)
}
} {2 5 8 23 25 28 33 34 54 56 58 60 80 86 93 100 scan 0 sort 0}
do_test where7-2.65.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=42
OR e IS NULL
OR b=495
OR 1000000<b
OR (f GLOB '?vwxy*' AND f GLOB 'uvwx*')
OR a=45
OR (g='kjihgfe' AND f GLOB 'rstuv*')
OR a=85
OR (d>=65.0 AND d<66.0 AND d NOT NULL)
}
} {20 42 45 46 65 69 72 85 98 scan 0 sort 0}
do_test where7-2.65.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=42
OR e IS NULL
OR b=495
OR 1000000<b
OR (f GLOB '?vwxy*' AND f GLOB 'uvwx*')
OR a=45
OR (g='kjihgfe' AND f GLOB 'rstuv*')
OR a=85
OR (d>=65.0 AND d<66.0 AND d NOT NULL)
}
} {20 42 45 46 65 69 72 85 98 scan 0 sort 0}
do_test where7-2.66.1 {
count_steps_sort {
SELECT a FROM t2
WHERE c=17017
OR f='ijklmnopq'
OR a=39
}
} {8 34 39 49 50 51 60 86 scan 0 sort 0}
do_test where7-2.66.2 {
count_steps_sort {
SELECT a FROM t3
WHERE c=17017
OR f='ijklmnopq'
OR a=39
}
} {8 34 39 49 50 51 60 86 scan 0 sort 0}
do_test where7-2.67.1 {
count_steps_sort {
SELECT a FROM t2
WHERE c>=34035
OR ((a BETWEEN 96 AND 98) AND a!=97)
OR (g='utsrqpo' AND f GLOB 'tuvwx*')
OR (g='edcbazy' AND f GLOB 'wxyza*')
OR (f GLOB '?mnop*' AND f GLOB 'lmno*')
OR (d>=27.0 AND d<28.0 AND d NOT NULL)
OR a=91
}
} {11 19 27 37 63 89 91 96 98 100 scan 0 sort 0}
do_test where7-2.67.2 {
count_steps_sort {
SELECT a FROM t3
WHERE c>=34035
OR ((a BETWEEN 96 AND 98) AND a!=97)
OR (g='utsrqpo' AND f GLOB 'tuvwx*')
OR (g='edcbazy' AND f GLOB 'wxyza*')
OR (f GLOB '?mnop*' AND f GLOB 'lmno*')
OR (d>=27.0 AND d<28.0 AND d NOT NULL)
OR a=91
}
} {11 19 27 37 63 89 91 96 98 100 scan 0 sort 0}
do_test where7-2.68.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='gfedcba' AND f GLOB 'nopqr*')
OR (d>=28.0 AND d<29.0 AND d NOT NULL)
OR (f GLOB '?klmn*' AND f GLOB 'jklm*')
OR b=649
OR b=231
OR (d>=48.0 AND d<49.0 AND d NOT NULL)
OR (d>=29.0 AND d<30.0 AND d NOT NULL)
OR b=58
}
} {9 21 28 29 35 48 59 61 87 91 scan 0 sort 0}
do_test where7-2.68.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='gfedcba' AND f GLOB 'nopqr*')
OR (d>=28.0 AND d<29.0 AND d NOT NULL)
OR (f GLOB '?klmn*' AND f GLOB 'jklm*')
OR b=649
OR b=231
OR (d>=48.0 AND d<49.0 AND d NOT NULL)
OR (d>=29.0 AND d<30.0 AND d NOT NULL)
OR b=58
}
} {9 21 28 29 35 48 59 61 87 91 scan 0 sort 0}
do_test where7-2.69.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=979
OR (d>=78.0 AND d<79.0 AND d NOT NULL)
}
} {78 89 scan 0 sort 0}
do_test where7-2.69.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=979
OR (d>=78.0 AND d<79.0 AND d NOT NULL)
}
} {78 89 scan 0 sort 0}
do_test where7-2.70.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=825
OR b=1004
OR ((a BETWEEN 60 AND 62) AND a!=61)
OR ((a BETWEEN 56 AND 58) AND a!=57)
}
} {56 58 60 62 75 scan 0 sort 0}
do_test where7-2.70.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=825
OR b=1004
OR ((a BETWEEN 60 AND 62) AND a!=61)
OR ((a BETWEEN 56 AND 58) AND a!=57)
}
} {56 58 60 62 75 scan 0 sort 0}
do_test where7-2.71.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=65
OR (g='nmlkjih' AND f GLOB 'fghij*')
OR c=22022
OR (f GLOB '?ghij*' AND f GLOB 'fghi*')
OR b=671
OR (g='onmlkji' AND f GLOB 'zabcd*')
OR a=91
OR (d>=98.0 AND d<99.0 AND d NOT NULL)
OR ((a BETWEEN 47 AND 49) AND a!=48)
OR b=1004
OR b=960
}
} {5 31 47 49 51 57 61 64 65 66 83 91 98 scan 0 sort 0}
do_test where7-2.71.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=65
OR (g='nmlkjih' AND f GLOB 'fghij*')
OR c=22022
OR (f GLOB '?ghij*' AND f GLOB 'fghi*')
OR b=671
OR (g='onmlkji' AND f GLOB 'zabcd*')
OR a=91
OR (d>=98.0 AND d<99.0 AND d NOT NULL)
OR ((a BETWEEN 47 AND 49) AND a!=48)
OR b=1004
OR b=960
}
} {5 31 47 49 51 57 61 64 65 66 83 91 98 scan 0 sort 0}
do_test where7-2.72.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=762
OR (d>=93.0 AND d<94.0 AND d NOT NULL)
OR ((a BETWEEN 56 AND 58) AND a!=57)
}
} {56 58 93 scan 0 sort 0}
do_test where7-2.72.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=762
OR (d>=93.0 AND d<94.0 AND d NOT NULL)
OR ((a BETWEEN 56 AND 58) AND a!=57)
}
} {56 58 93 scan 0 sort 0}
do_test where7-2.73.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=11.0 AND d<12.0 AND d NOT NULL)
OR a=14
OR (g='hgfedcb' AND f GLOB 'hijkl*')
OR (d>=54.0 AND d<55.0 AND d NOT NULL)
OR (d>=23.0 AND d<24.0 AND d NOT NULL)
OR b=212
OR (d>=78.0 AND d<79.0 AND d NOT NULL)
}
} {11 14 23 54 78 85 scan 0 sort 0}
do_test where7-2.73.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=11.0 AND d<12.0 AND d NOT NULL)
OR a=14
OR (g='hgfedcb' AND f GLOB 'hijkl*')
OR (d>=54.0 AND d<55.0 AND d NOT NULL)
OR (d>=23.0 AND d<24.0 AND d NOT NULL)
OR b=212
OR (d>=78.0 AND d<79.0 AND d NOT NULL)
}
} {11 14 23 54 78 85 scan 0 sort 0}
do_test where7-2.74.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='ihgfedc' AND f GLOB 'bcdef*')
OR b=168
OR b=25
OR (d>=89.0 AND d<90.0 AND d NOT NULL)
OR (g='lkjihgf' AND f GLOB 'opqrs*')
}
} {66 79 89 scan 0 sort 0}
do_test where7-2.74.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='ihgfedc' AND f GLOB 'bcdef*')
OR b=168
OR b=25
OR (d>=89.0 AND d<90.0 AND d NOT NULL)
OR (g='lkjihgf' AND f GLOB 'opqrs*')
}
} {66 79 89 scan 0 sort 0}
do_test where7-2.75.1 {
count_steps_sort {
SELECT a FROM t2
WHERE c=28028
OR f='jklmnopqr'
OR b=1015
}
} {9 35 61 82 83 84 87 scan 0 sort 0}
do_test where7-2.75.2 {
count_steps_sort {
SELECT a FROM t3
WHERE c=28028
OR f='jklmnopqr'
OR b=1015
}
} {9 35 61 82 83 84 87 scan 0 sort 0}
do_test where7-2.76.1 {
count_steps_sort {
SELECT a FROM t2
WHERE c=31031
OR (d>=100.0 AND d<101.0 AND d NOT NULL)
OR ((a BETWEEN 87 AND 89) AND a!=88)
OR (f GLOB '?qrst*' AND f GLOB 'pqrs*')
OR a=49
OR (d>=56.0 AND d<57.0 AND d NOT NULL)
OR (g='mlkjihg' AND f GLOB 'klmno*')
}
} {15 41 49 56 62 67 87 89 91 92 93 100 scan 0 sort 0}
do_test where7-2.76.2 {
count_steps_sort {
SELECT a FROM t3
WHERE c=31031
OR (d>=100.0 AND d<101.0 AND d NOT NULL)
OR ((a BETWEEN 87 AND 89) AND a!=88)
OR (f GLOB '?qrst*' AND f GLOB 'pqrs*')
OR a=49
OR (d>=56.0 AND d<57.0 AND d NOT NULL)
OR (g='mlkjihg' AND f GLOB 'klmno*')
}
} {15 41 49 56 62 67 87 89 91 92 93 100 scan 0 sort 0}
do_test where7-2.77.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=80
OR ((a BETWEEN 4 AND 6) AND a!=5)
OR (d>=29.0 AND d<30.0 AND d NOT NULL)
OR (d>=25.0 AND d<26.0 AND d NOT NULL)
OR b=971
OR a=60
}
} {4 6 25 29 60 80 scan 0 sort 0}
do_test where7-2.77.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=80
OR ((a BETWEEN 4 AND 6) AND a!=5)
OR (d>=29.0 AND d<30.0 AND d NOT NULL)
OR (d>=25.0 AND d<26.0 AND d NOT NULL)
OR b=971
OR a=60
}
} {4 6 25 29 60 80 scan 0 sort 0}
do_test where7-2.78.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (d>=85.0 AND d<86.0 AND d NOT NULL)
OR (g='gfedcba' AND f GLOB 'lmnop*')
OR ((a BETWEEN 30 AND 32) AND a!=31)
OR b=1089
OR (d>=43.0 AND d<44.0 AND d NOT NULL)
}
} {30 32 43 85 89 99 scan 0 sort 0}
do_test where7-2.78.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (d>=85.0 AND d<86.0 AND d NOT NULL)
OR (g='gfedcba' AND f GLOB 'lmnop*')
OR ((a BETWEEN 30 AND 32) AND a!=31)
OR b=1089
OR (d>=43.0 AND d<44.0 AND d NOT NULL)
}
} {30 32 43 85 89 99 scan 0 sort 0}
do_test where7-2.79.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=399
OR ((a BETWEEN 9 AND 11) AND a!=10)
OR (g='gfedcba' AND f GLOB 'mnopq*')
OR (g='nmlkjih' AND f GLOB 'fghij*')
OR a=10
OR b=1026
}
} {9 10 11 57 90 scan 0 sort 0}
do_test where7-2.79.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=399
OR ((a BETWEEN 9 AND 11) AND a!=10)
OR (g='gfedcba' AND f GLOB 'mnopq*')
OR (g='nmlkjih' AND f GLOB 'fghij*')
OR a=10
OR b=1026
}
} {9 10 11 57 90 scan 0 sort 0}
do_test where7-2.80.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='jihgfed' AND f GLOB 'yzabc*')
OR b=465
OR (g='ponmlkj' AND f GLOB 'rstuv*')
OR (g='lkjihgf' AND f GLOB 'nopqr*')
OR (g='xwvutsr' AND f GLOB 'fghij*')
}
} {5 43 65 76 scan 0 sort 0}
do_test where7-2.80.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='jihgfed' AND f GLOB 'yzabc*')
OR b=465
OR (g='ponmlkj' AND f GLOB 'rstuv*')
OR (g='lkjihgf' AND f GLOB 'nopqr*')
OR (g='xwvutsr' AND f GLOB 'fghij*')
}
} {5 43 65 76 scan 0 sort 0}
do_test where7-2.81.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=25
OR b=792
OR (f GLOB '?uvwx*' AND f GLOB 'tuvw*')
}
} {19 25 45 71 72 97 scan 0 sort 0}
do_test where7-2.81.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=25
OR b=792
OR (f GLOB '?uvwx*' AND f GLOB 'tuvw*')
}
} {19 25 45 71 72 97 scan 0 sort 0}
do_test where7-2.82.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=979
OR (d>=8.0 AND d<9.0 AND d NOT NULL)
OR a=13
OR a=15
OR ((a BETWEEN 6 AND 8) AND a!=7)
OR (g='utsrqpo' AND f GLOB 'vwxyz*')
OR a=27
OR ((a BETWEEN 98 AND 100) AND a!=99)
OR (g='lkjihgf' AND f GLOB 'pqrst*')
OR a=32
OR a=39
}
} {6 8 13 15 21 27 32 39 67 89 98 100 scan 0 sort 0}
do_test where7-2.82.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=979
OR (d>=8.0 AND d<9.0 AND d NOT NULL)
OR a=13
OR a=15
OR ((a BETWEEN 6 AND 8) AND a!=7)
OR (g='utsrqpo' AND f GLOB 'vwxyz*')
OR a=27
OR ((a BETWEEN 98 AND 100) AND a!=99)
OR (g='lkjihgf' AND f GLOB 'pqrst*')
OR a=32
OR a=39
}
} {6 8 13 15 21 27 32 39 67 89 98 100 scan 0 sort 0}
do_test where7-2.83.1 {
count_steps_sort {
SELECT a FROM t2
WHERE f='hijklmnop'
OR (g='utsrqpo' AND f GLOB 'vwxyz*')
OR ((a BETWEEN 31 AND 33) AND a!=32)
OR (g='mlkjihg' AND f GLOB 'ghijk*')
OR (d>=1.0 AND d<2.0 AND d NOT NULL)
OR ((a BETWEEN 77 AND 79) AND a!=78)
OR b=528
OR c=30030
OR (g='qponmlk' AND f GLOB 'qrstu*')
}
} {1 7 21 31 33 42 48 58 59 77 79 85 88 89 90 scan 0 sort 0}
do_test where7-2.83.2 {
count_steps_sort {
SELECT a FROM t3
WHERE f='hijklmnop'
OR (g='utsrqpo' AND f GLOB 'vwxyz*')
OR ((a BETWEEN 31 AND 33) AND a!=32)
OR (g='mlkjihg' AND f GLOB 'ghijk*')
OR (d>=1.0 AND d<2.0 AND d NOT NULL)
OR ((a BETWEEN 77 AND 79) AND a!=78)
OR b=528
OR c=30030
OR (g='qponmlk' AND f GLOB 'qrstu*')
}
} {1 7 21 31 33 42 48 58 59 77 79 85 88 89 90 scan 0 sort 0}
do_test where7-2.84.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=69
OR e IS NULL
OR b=352
OR 1000000<b
OR b=289
}
} {32 scan 0 sort 0}
do_test where7-2.84.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=69
OR e IS NULL
OR b=352
OR 1000000<b
OR b=289
}
} {32 scan 0 sort 0}
do_test where7-2.85.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='lkjihgf' AND f GLOB 'pqrst*')
OR b=748
OR b=696
OR (g='ponmlkj' AND f GLOB 'rstuv*')
OR (f GLOB '?fghi*' AND f GLOB 'efgh*')
}
} {4 30 43 56 67 68 82 scan 0 sort 0}
do_test where7-2.85.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='lkjihgf' AND f GLOB 'pqrst*')
OR b=748
OR b=696
OR (g='ponmlkj' AND f GLOB 'rstuv*')
OR (f GLOB '?fghi*' AND f GLOB 'efgh*')
}
} {4 30 43 56 67 68 82 scan 0 sort 0}
do_test where7-2.86.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 71 AND 73) AND a!=72)
OR (g='qponmlk' AND f GLOB 'opqrs*')
OR a=87
OR a=80
OR (g='kjihgfe' AND f GLOB 'qrstu*')
OR b=784
OR a=49
OR ((a BETWEEN 34 AND 36) AND a!=35)
}
} {34 36 40 49 68 71 73 80 87 scan 0 sort 0}
do_test where7-2.86.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 71 AND 73) AND a!=72)
OR (g='qponmlk' AND f GLOB 'opqrs*')
OR a=87
OR a=80
OR (g='kjihgfe' AND f GLOB 'qrstu*')
OR b=784
OR a=49
OR ((a BETWEEN 34 AND 36) AND a!=35)
}
} {34 36 40 49 68 71 73 80 87 scan 0 sort 0}
do_test where7-2.87.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 14 AND 16) AND a!=15)
OR (g='wvutsrq' AND f GLOB 'jklmn*')
OR (g='wvutsrq' AND f GLOB 'ijklm*')
OR (g='hgfedcb' AND f GLOB 'ijklm*')
OR c=1001
OR (g='hgfedcb' AND f GLOB 'hijkl*')
OR (d>=16.0 AND d<17.0 AND d NOT NULL)
OR (g='ihgfedc' AND f GLOB 'abcde*')
OR c=33033
}
} {1 2 3 8 9 14 16 78 85 86 97 98 99 scan 0 sort 0}
do_test where7-2.87.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 14 AND 16) AND a!=15)
OR (g='wvutsrq' AND f GLOB 'jklmn*')
OR (g='wvutsrq' AND f GLOB 'ijklm*')
OR (g='hgfedcb' AND f GLOB 'ijklm*')
OR c=1001
OR (g='hgfedcb' AND f GLOB 'hijkl*')
OR (d>=16.0 AND d<17.0 AND d NOT NULL)
OR (g='ihgfedc' AND f GLOB 'abcde*')
OR c=33033
}
} {1 2 3 8 9 14 16 78 85 86 97 98 99 scan 0 sort 0}
do_test where7-2.88.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=311
OR b=1103
OR b=88
}
} {8 scan 0 sort 0}
do_test where7-2.88.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=311
OR b=1103
OR b=88
}
} {8 scan 0 sort 0}
do_test where7-2.89.1 {
count_steps_sort {
SELECT a FROM t2
WHERE ((a BETWEEN 65 AND 67) AND a!=66)
OR ((a BETWEEN 26 AND 28) AND a!=27)
OR c=5005
OR b=1045
OR c=8008
OR f='bcdefghij'
}
} {1 13 14 15 22 23 24 26 27 28 53 65 67 79 95 scan 0 sort 0}
do_test where7-2.89.2 {
count_steps_sort {
SELECT a FROM t3
WHERE ((a BETWEEN 65 AND 67) AND a!=66)
OR ((a BETWEEN 26 AND 28) AND a!=27)
OR c=5005
OR b=1045
OR c=8008
OR f='bcdefghij'
}
} {1 13 14 15 22 23 24 26 27 28 53 65 67 79 95 scan 0 sort 0}
do_test where7-2.90.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=66
OR b=553
OR a=64
OR (d>=93.0 AND d<94.0 AND d NOT NULL)
OR (g='vutsrqp' AND f GLOB 'rstuv*')
OR a=62
OR b=1081
OR b=770
OR b=762
OR b=803
OR (g='srqponm' AND f GLOB 'efghi*')
}
} {6 17 30 62 64 70 73 93 scan 0 sort 0}
do_test where7-2.90.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=66
OR b=553
OR a=64
OR (d>=93.0 AND d<94.0 AND d NOT NULL)
OR (g='vutsrqp' AND f GLOB 'rstuv*')
OR a=62
OR b=1081
OR b=770
OR b=762
OR b=803
OR (g='srqponm' AND f GLOB 'efghi*')
}
} {6 17 30 62 64 70 73 93 scan 0 sort 0}
do_test where7-2.91.1 {
count_steps_sort {
SELECT a FROM t2
WHERE (g='wvutsrq' AND f GLOB 'klmno*')
OR (f GLOB '?uvwx*' AND f GLOB 'tuvw*')
OR c=17017
OR b=168
OR ((a BETWEEN 77 AND 79) AND a!=78)
}
} {10 19 45 49 50 51 71 77 79 97 scan 0 sort 0}
do_test where7-2.91.2 {
count_steps_sort {
SELECT a FROM t3
WHERE (g='wvutsrq' AND f GLOB 'klmno*')
OR (f GLOB '?uvwx*' AND f GLOB 'tuvw*')
OR c=17017
OR b=168
OR ((a BETWEEN 77 AND 79) AND a!=78)
}
} {10 19 45 49 50 51 71 77 79 97 scan 0 sort 0}
do_test where7-2.92.1 {
count_steps_sort {
SELECT a FROM t2
WHERE c=34034
OR (d>=68.0 AND d<69.0 AND d NOT NULL)
OR a=44
OR (g='tsrqpon' AND f GLOB 'xyzab*')
OR (d>=12.0 AND d<13.0 AND d NOT NULL)
OR c=31031
OR (g='ihgfedc' AND f GLOB 'abcde*')
OR b=619
OR (f GLOB '?efgh*' AND f GLOB 'defg*')
OR ((a BETWEEN 29 AND 31) AND a!=30)
}
} {3 12 23 29 31 44 55 68 78 81 91 92 93 100 scan 0 sort 0}
do_test where7-2.92.2 {
count_steps_sort {
SELECT a FROM t3
WHERE c=34034
OR (d>=68.0 AND d<69.0 AND d NOT NULL)
OR a=44
OR (g='tsrqpon' AND f GLOB 'xyzab*')
OR (d>=12.0 AND d<13.0 AND d NOT NULL)
OR c=31031
OR (g='ihgfedc' AND f GLOB 'abcde*')
OR b=619
OR (f GLOB '?efgh*' AND f GLOB 'defg*')
OR ((a BETWEEN 29 AND 31) AND a!=30)
}
} {3 12 23 29 31 44 55 68 78 81 91 92 93 100 scan 0 sort 0}
do_test where7-2.93.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=48
OR c=15015
OR ((a BETWEEN 65 AND 67) AND a!=66)
OR ((a BETWEEN 97 AND 99) AND a!=98)
OR (d>=44.0 AND d<45.0 AND d NOT NULL)
OR b=110
OR f='klmnopqrs'
OR (g='fedcbaz' AND f GLOB 'qrstu*')
OR (g='onmlkji' AND f GLOB 'abcde*')
OR b=674
OR (g='fedcbaz' AND f GLOB 'stuvw*')
}
} {10 36 43 44 45 48 52 62 65 67 88 94 96 97 99 scan 0 sort 0}
do_test where7-2.93.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=48
OR c=15015
OR ((a BETWEEN 65 AND 67) AND a!=66)
OR ((a BETWEEN 97 AND 99) AND a!=98)
OR (d>=44.0 AND d<45.0 AND d NOT NULL)
OR b=110
OR f='klmnopqrs'
OR (g='fedcbaz' AND f GLOB 'qrstu*')
OR (g='onmlkji' AND f GLOB 'abcde*')
OR b=674
OR (g='fedcbaz' AND f GLOB 'stuvw*')
}
} {10 36 43 44 45 48 52 62 65 67 88 94 96 97 99 scan 0 sort 0}
do_test where7-2.94.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=72
OR b=913
OR (d>=28.0 AND d<29.0 AND d NOT NULL)
OR b=121
OR (d>=2.0 AND d<3.0 AND d NOT NULL)
}
} {2 11 28 72 83 scan 0 sort 0}
do_test where7-2.94.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=72
OR b=913
OR (d>=28.0 AND d<29.0 AND d NOT NULL)
OR b=121
OR (d>=2.0 AND d<3.0 AND d NOT NULL)
}
} {2 11 28 72 83 scan 0 sort 0}
do_test where7-2.95.1 {
count_steps_sort {
SELECT a FROM t2
WHERE a=18
OR b=286
OR b=1015
OR a=49
OR b=264
}
} {18 24 26 49 scan 0 sort 0}
do_test where7-2.95.2 {
count_steps_sort {
SELECT a FROM t3
WHERE a=18
OR b=286
OR b=1015
OR a=49
OR b=264
}
} {18 24 26 49 scan 0 sort 0}
do_test where7-2.96.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=69
OR a=11
OR c=1001
OR ((a BETWEEN 54 AND 56) AND a!=55)
OR a=57
OR ((a BETWEEN 48 AND 50) AND a!=49)
}
} {1 2 3 11 48 50 54 56 57 scan 0 sort 0}
do_test where7-2.96.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=69
OR a=11
OR c=1001
OR ((a BETWEEN 54 AND 56) AND a!=55)
OR a=57
OR ((a BETWEEN 48 AND 50) AND a!=49)
}
} {1 2 3 11 48 50 54 56 57 scan 0 sort 0}
do_test where7-2.97.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=231
OR (g='hgfedcb' AND f GLOB 'ghijk*')
}
} {21 84 scan 0 sort 0}
do_test where7-2.97.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=231
OR (g='hgfedcb' AND f GLOB 'ghijk*')
}
} {21 84 scan 0 sort 0}
do_test where7-2.98.1 {
count_steps_sort {
SELECT a FROM t2
WHERE b=25
OR (d>=23.0 AND d<24.0 AND d NOT NULL)
OR ((a BETWEEN 81 AND 83) AND a!=82)
OR (d>=17.0 AND d<18.0 AND d NOT NULL)
OR ((a BETWEEN 3 AND 5) AND a!=4)
OR b=289
OR ((a BETWEEN 85 AND 87) AND a!=86)
}
} {3 5 17 23 81 83 85 87 scan 0 sort 0}
do_test where7-2.98.2 {
count_steps_sort {
SELECT a FROM t3
WHERE b=25
OR (d>=23.0 AND d<24.0 AND d NOT NULL)
OR ((a BETWEEN 81 AND 83) AND a!=82)
OR (d>=17.0 AND d<18.0 AND d NOT NULL)
OR ((a BETWEEN 3 AND 5) AND a!=4)
OR b=289
OR ((a BETWEEN 85 AND 87) AND a!=86)
}