Import SQLite 3.7.6.3.

third_party/sqlite/src/test/analyze.test

 # 2005 July 22
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 55 matching lines @@
     CREATE INDEX stat1idx ON sqlite_stat1(idx);
   }
 } {1 {table sqlite_stat1 may not be indexed}}
 do_test analyze-1.6.3 {
   catchsql {
     CREATE INDEX main.stat1idx ON SQLite_stat1(idx);
   }
 } {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 {
   catchsql {
     ANALYZE main
   }
 } {0 {}}
 do_test analyze-1.9 {
   execsql {
-    SELECT * FROM sqlite_stat1
+    SELECT * FROM sqlite_stat1 WHERE idx NOT NULL
   }
 } {}
 do_test analyze-1.10 {
   catchsql {
     CREATE TABLE t1(a,b);
     ANALYZE main.t1;
   }
 } {0 {}}
 do_test analyze-1.11 {
   execsql {
@@ skipping 192 matching lines @@
 
 # This test corrupts the database file so it must be the last test
 # in the series.
 #
 do_test analyze-99.1 {
   execsql {
     PRAGMA writable_schema=on;
     UPDATE sqlite_master SET sql='nonsense' WHERE name='sqlite_stat1';
   }
   db close
-  sqlite3 db test.db
+  catch { sqlite3 db test.db }
   catchsql {
     ANALYZE
   }
 } {1 {malformed database schema (sqlite_stat1) - near "nonsense": syntax error}}
 
 
 finish_test