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 |
} |