| OLD | NEW |
|---|
| 1 # 2011 April 1 | 1 # 2011 April 1 |
| 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 91 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 102 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE c=123 AND b=123} | 102 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE c=123 AND b=123} |
| 103 } {0 0 0 {SEARCH TABLE t1 USING INDEX t1b (b=?) (~2 rows)}} | 103 } {0 0 0 {SEARCH TABLE t1 USING INDEX t1b (b=?) (~2 rows)}} |
| 104 do_test analyze7-3.5 { | 104 do_test analyze7-3.5 { |
| 105 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE a=123 AND c=123} | 105 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE a=123 AND c=123} |
| 106 } {0 0 0 {SEARCH TABLE t1 USING INDEX t1a (a=?) (~1 rows)}} | 106 } {0 0 0 {SEARCH TABLE t1 USING INDEX t1a (a=?) (~1 rows)}} |
| 107 do_test analyze7-3.6 { | 107 do_test analyze7-3.6 { |
| 108 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE c=123 AND d=123 AND b=123} | 108 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE c=123 AND d=123 AND b=123} |
| 109 } {0 0 0 {SEARCH TABLE t1 USING INDEX t1cd (c=? AND d=?) (~1 rows)}} | 109 } {0 0 0 {SEARCH TABLE t1 USING INDEX t1cd (c=? AND d=?) (~1 rows)}} |
| 110 | 110 |
| 111 finish_test | 111 finish_test |
| OLD | NEW |
|---|
Chromium Code Reviews
Issue 826543003:
[sql] Import reference version of SQLite 3.7.6.3. (Closed)
Base URL: http://chromium.googlesource.com/chromium/src.git@master