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

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

Issue 5626002: Update sqlite to 3.7.3. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src/third_party/sqlite/src
Patch Set: Remove misc change. Created 10 years 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/alter4.test ('k') | third_party/sqlite/src/test/analyze2.test » ('j') | no next file with comments »
Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
Index: third_party/sqlite/src/test/analyze.test
diff --git a/third_party/sqlite/src/test/analyze.test b/third_party/sqlite/src/test/analyze.test
index 867cf0f6bafbbd312f8f7bded3442379c23887f9..177936c2248bca4bb4b4c98ac5f66866687046ad 100644
--- a/third_party/sqlite/src/test/analyze.test
+++ b/third_party/sqlite/src/test/analyze.test
@@ -73,7 +73,7 @@ do_test analyze-1.6.3 {
} {1 {table sqlite_stat1 may not be indexed}}
do_test analyze-1.7 {
execsql {
- SELECT * FROM sqlite_stat1
+ SELECT * FROM sqlite_stat1 WHERE idx NOT NULL
}
} {}
do_test analyze-1.8 {
@@ -83,7 +83,7 @@ do_test analyze-1.8 {
} {0 {}}
do_test analyze-1.9 {
execsql {
- SELECT * FROM sqlite_stat1
+ SELECT * FROM sqlite_stat1 WHERE idx NOT NULL
}
} {}
do_test analyze-1.10 {
@@ -96,7 +96,7 @@ do_test analyze-1.11 {
execsql {
SELECT * FROM sqlite_stat1
}
-} {}
+} {t1 {} 0}
do_test analyze-1.12 {
catchsql {
ANALYZE t1;
@@ -106,7 +106,7 @@ do_test analyze-1.13 {
execsql {
SELECT * FROM sqlite_stat1
}
-} {}
+} {t1 {} 0}
# Create some indices that can be analyzed. But do not yet add
# data. Without data in the tables, no analysis is done.
@@ -117,21 +117,21 @@ do_test analyze-2.1 {
ANALYZE main.t1;
SELECT * FROM sqlite_stat1 ORDER BY idx;
}
-} {}
+} {t1 {} 0}
do_test analyze-2.2 {
execsql {
CREATE INDEX t1i2 ON t1(b);
ANALYZE t1;
SELECT * FROM sqlite_stat1 ORDER BY idx;
}
-} {}
+} {t1 {} 0}
do_test analyze-2.3 {
execsql {
CREATE INDEX t1i3 ON t1(a,b);
ANALYZE main;
SELECT * FROM sqlite_stat1 ORDER BY idx;
}
-} {}
+} {t1 {} 0}
# Start adding data to the table. Verify that the analysis
# is done correctly.
@@ -296,7 +296,7 @@ do_test analyze-99.1 {
UPDATE sqlite_master SET sql='nonsense' WHERE name='sqlite_stat1';
}
db close
- sqlite3 db test.db
+ catch { sqlite3 db test.db }
catchsql {
ANALYZE
}
« no previous file with comments | « third_party/sqlite/src/test/alter4.test ('k') | third_party/sqlite/src/test/analyze2.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698