sqlite-src-3350500/test/analyze8.test

6 #    May you do good and not evil.
16 set testdir [file dirname $argv0]
24 set testprefix analyze8
26 proc eqp {sql {db db}} {
46   for {set i 0} {$i<1000} {incr i} {
47     if {$i%2==0} {set a $i} {set a [expr {($i%8)*100}]}
48     set b [expr {$i/10}]
49     set c [expr {$i/8}]
50     set c [expr {$c*$c*$c}]
63   eqp {SELECT * FROM t1 WHERE a=100 AND b=55}
66   eqp {SELECT * FROM t1 WHERE a=99 AND b=55}
69   eqp {SELECT * FROM t1 WHERE a=101 AND b=55}
72   eqp {SELECT * FROM t1 WHERE a=100 AND b=56}
75   eqp {SELECT * FROM t1 WHERE a=99 AND b=56}
78   eqp {SELECT * FROM t1 WHERE a=101 AND b=56}
81   eqp {SELECT * FROM t1 WHERE a=100 AND b BETWEEN 50 AND 54}
91 # the planner could get it wrong with an unlucky set of samples. This
101   eqp {SELECT * FROM t1 WHERE b BETWEEN 30 AND 34 AND c BETWEEN 0 AND 100000}
104   eqp {SELECT * FROM t1
108   eqp {SELECT * FROM t1 WHERE a=100 AND c BETWEEN 0 AND 100000}
111   eqp {SELECT * FROM t1