| Index: third_party/sqlite/src/test/misc7.test
|
| diff --git a/third_party/sqlite/src/test/misc7.test b/third_party/sqlite/src/test/misc7.test
|
| index c08ceefad9c3acf8ea1a7d0454b9f363edf80659..7d2ba6e8527958e48e4b73614234e0905d0a964e 100644
|
| --- a/third_party/sqlite/src/test/misc7.test
|
| +++ b/third_party/sqlite/src/test/misc7.test
|
| @@ -259,24 +259,22 @@ file delete -force test.db-journal
|
| sqlite3 db test.db
|
|
|
| ifcapable explain {
|
| - do_test misc7-14.1 {
|
| - execsql {
|
| - CREATE TABLE abc(a PRIMARY KEY, b, c);
|
| - }
|
| - execsql {
|
| - EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 WHERE rowid = 1;
|
| - }
|
| - } {0 0 {TABLE abc AS t2 USING PRIMARY KEY}}
|
| - do_test misc7-14.2 {
|
| - execsql {
|
| - EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 WHERE a = 1;
|
| - }
|
| - } {0 0 {TABLE abc AS t2 WITH INDEX sqlite_autoindex_abc_1}}
|
| - do_test misc7-14.3 {
|
| - execsql {
|
| - EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 ORDER BY a;
|
| - }
|
| - } {0 0 {TABLE abc AS t2 WITH INDEX sqlite_autoindex_abc_1 ORDER BY}}
|
| + do_execsql_test misc7-14.1 {
|
| + CREATE TABLE abc(a PRIMARY KEY, b, c);
|
| + EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 WHERE rowid = 1;
|
| + } {
|
| + 0 0 0 {SEARCH TABLE abc AS t2 USING INTEGER PRIMARY KEY (rowid=?) (~1 rows)}
|
| + }
|
| + do_execsql_test misc7-14.2 {
|
| + EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 WHERE a = 1;
|
| + } {0 0 0
|
| + {SEARCH TABLE abc AS t2 USING INDEX sqlite_autoindex_abc_1 (a=?) (~1 rows)}
|
| + }
|
| + do_execsql_test misc7-14.3 {
|
| + EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 ORDER BY a;
|
| + } {0 0 0
|
| + {SCAN TABLE abc AS t2 USING INDEX sqlite_autoindex_abc_1 (~1000000 rows)}
|
| + }
|
| }
|
|
|
| db close
|
|
|