Update sqlite to 3.7.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 {
     SELECT * FROM sqlite_stat1
   }
-} {}
+} {t1 {} 0}
 do_test analyze-1.12 {
   catchsql {
     ANALYZE t1;
   }
 } {0 {}}
 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.
 #
 do_test analyze-2.1 {
   execsql {
     CREATE INDEX t1i1 ON t1(a);
     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.
 #
 do_test analyze-3.1 {
   execsql {
     INSERT INTO t1 VALUES(1,2);
     INSERT INTO t1 VALUES(1,3);
     ANALYZE main.t1;
     SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
@@ skipping 144 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