OLD | NEW |
1 # 2008 December 23 | 1 # 2008 December 23 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 72 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
83 count_steps { | 83 count_steps { |
84 SELECT a FROM t1 WHERE (b=3 OR c>=10) | 84 SELECT a FROM t1 WHERE (b=3 OR c>=10) |
85 } | 85 } |
86 } {2 4 5 scan 0 sort 0} | 86 } {2 4 5 scan 0 sort 0} |
87 do_test where7-1.9 { | 87 do_test where7-1.9 { |
88 count_steps { | 88 count_steps { |
89 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4) | 89 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4) |
90 } | 90 } |
91 } {2 4 5 scan 0 sort 0} | 91 } {2 4 5 scan 0 sort 0} |
92 do_test where7-1.10 { | 92 do_test where7-1.10 { |
93 breakpoint | |
94 count_steps { | 93 count_steps { |
95 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4 OR b>10) | 94 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4 OR b>10) |
96 } | 95 } |
97 } {2 4 5 scan 0 sort 0} | 96 } {2 4 5 scan 0 sort 0} |
98 breakpoint | |
99 do_test where7-1.11 { | 97 do_test where7-1.11 { |
100 count_steps { | 98 count_steps { |
101 SELECT a FROM t1 WHERE (d=5 AND b=3) OR c==100 ORDER BY a; | 99 SELECT a FROM t1 WHERE (d=5 AND b=3) OR c==100 ORDER BY a; |
102 } | 100 } |
103 } {2 5 scan 0 sort 1} | 101 } {2 5 scan 0 sort 1} |
104 do_test where7-1.12 { | 102 do_test where7-1.12 { |
105 count_steps { | 103 count_steps { |
106 SELECT a FROM t1 WHERE (b BETWEEN 2 AND 4) OR c=100 ORDER BY a | 104 SELECT a FROM t1 WHERE (b BETWEEN 2 AND 4) OR c=100 ORDER BY a |
107 } | 105 } |
108 } {1 2 3 5 scan 0 sort 1} | 106 } {1 2 3 5 scan 0 sort 1} |
109 do_test where7-1.13.1 { | 107 do_test where7-1.13 { |
110 count_steps { | |
111 SELECT a FROM t1 WHERE (b BETWEEN 0 AND 2) OR (c BETWEEN 9 AND 999) | |
112 ORDER BY a DESC | |
113 } | |
114 } {5 4 1 scan 4 sort 0} | |
115 do_test where7-1.13.2 { | |
116 count_steps { | 108 count_steps { |
117 SELECT a FROM t1 WHERE (b BETWEEN 0 AND 2) OR (c BETWEEN 9 AND 999) | 109 SELECT a FROM t1 WHERE (b BETWEEN 0 AND 2) OR (c BETWEEN 9 AND 999) |
118 ORDER BY +a DESC | 110 ORDER BY +a DESC |
119 } | 111 } |
120 } {5 4 1 scan 0 sort 1} | 112 } {5 4 1 scan 0 sort 1} |
121 | 113 |
122 do_test where7-1.14 { | 114 do_test where7-1.14 { |
123 count_steps { | 115 count_steps { |
124 SELECT a FROM t1 WHERE (d=8 OR c=6 OR b=4) AND +a>0 | 116 SELECT a FROM t1 WHERE (d=8 OR c=6 OR b=4) AND +a>0 |
125 } | 117 } |
(...skipping 23177 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
23303 OR a=23 | 23295 OR a=23 |
23304 OR (f GLOB '?defg*' AND f GLOB 'cdef*') | 23296 OR (f GLOB '?defg*' AND f GLOB 'cdef*') |
23305 OR d<0.0 | 23297 OR d<0.0 |
23306 OR (d>=22.0 AND d<23.0 AND d NOT NULL) | 23298 OR (d>=22.0 AND d<23.0 AND d NOT NULL) |
23307 OR a=91 | 23299 OR a=91 |
23308 } | 23300 } |
23309 } {2 22 23 28 54 80 91 scan 0 sort 0} | 23301 } {2 22 23 28 54 80 91 scan 0 sort 0} |
23310 finish_test | 23302 finish_test |
23311 | 23303 |
23312 finish_test | 23304 finish_test |
OLD | NEW |