Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(97)

Unified Diff: third_party/sqlite/src/test/misc7.test

Issue 6990047: Import SQLite 3.7.6.3. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src
Patch Set: Created 9 years, 7 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
« no previous file with comments | « third_party/sqlite/src/test/misc5.test ('k') | third_party/sqlite/src/test/multiplex.test » ('j') | no next file with comments »
Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
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
« no previous file with comments | « third_party/sqlite/src/test/misc5.test ('k') | third_party/sqlite/src/test/multiplex.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698