OLD | NEW |
1 # 2011 March 3 | 1 # 2011 March 3 |
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 102 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
113 eqp {SELECT * FROM t201 WHERE z=5} | 113 eqp {SELECT * FROM t201 WHERE z=5} |
114 } {0 0 0 {SEARCH TABLE t201 USING INDEX t201z (z=?)}} | 114 } {0 0 0 {SEARCH TABLE t201 USING INDEX t201z (z=?)}} |
115 do_test analyze6-2.8 { | 115 do_test analyze6-2.8 { |
116 eqp {SELECT * FROM t201 WHERE y=5} | 116 eqp {SELECT * FROM t201 WHERE y=5} |
117 } {0 0 0 {SEARCH TABLE t201 USING INDEX sqlite_autoindex_t201_1 (y=?)}} | 117 } {0 0 0 {SEARCH TABLE t201 USING INDEX sqlite_autoindex_t201_1 (y=?)}} |
118 do_test analyze6-2.9 { | 118 do_test analyze6-2.9 { |
119 eqp {SELECT * FROM t201 WHERE x=5} | 119 eqp {SELECT * FROM t201 WHERE x=5} |
120 } {0 0 0 {SEARCH TABLE t201 USING INTEGER PRIMARY KEY (rowid=?)}} | 120 } {0 0 0 {SEARCH TABLE t201 USING INTEGER PRIMARY KEY (rowid=?)}} |
121 | 121 |
122 finish_test | 122 finish_test |
OLD | NEW |