| 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 |