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