OLD | NEW |
1 # 2013-11-13 | 1 # 2013-11-13 |
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 256 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
267 EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE b=1; | 267 EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE b=1; |
268 } {/ANY.a. AND b=/} | 268 } {/ANY.a. AND b=/} |
269 do_execsql_test skipscan1-6.3 { | 269 do_execsql_test skipscan1-6.3 { |
270 -- Two distinct values for the skip-scan column again. Skip-scan is not used. | 270 -- Two distinct values for the skip-scan column again. Skip-scan is not used. |
271 UPDATE sqlite_stat1 SET stat='500000 125000 62500'; | 271 UPDATE sqlite_stat1 SET stat='500000 125000 62500'; |
272 ANALYZE sqlite_master; | 272 ANALYZE sqlite_master; |
273 EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE b=1; | 273 EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE b=1; |
274 } {~/ANY/} | 274 } {~/ANY/} |
275 | 275 |
276 finish_test | 276 finish_test |
OLD | NEW |