From 8b7ca8c75b8e2e06a5baab91af8a6391ae57addd Mon Sep 17 00:00:00 2001
From: drh <drh@noemail.net>
Date: Fri, 26 Aug 2011 18:28:17 +0000
Subject: [PATCH] Veryquick and min.rc tests now passing.

FossilOrigin-Name: a7e18468825622e518b2266a8724bdab99938b36
---
 manifest          | 14 +++++++-------
 manifest.uuid     |  2 +-
 src/build.c       |  7 +------
 test/analyze.test | 14 +++++++-------
 4 files changed, 16 insertions(+), 21 deletions(-)

diff --git a/manifest b/manifest
index d6a89c6e94..d37f7d1dd6 100644
--- a/manifest
+++ b/manifest
@@ -1,5 +1,5 @@
-C Merge\sthe\sbranch-3.7.2\schanges\sinto\sthe\sstat3-3.7.2\ssubbranch.\s\sAlso\sfix\nsome\stest\sscript\sissues.
-D 2011-08-26T18:04:52.302
+C Veryquick\sand\smin.rc\stests\snow\spassing.
+D 2011-08-26T18:28:17.095
 F Makefile.arm-wince-mingw32ce-gcc d6df77f1f48d690bd73162294bbba7f59507c72f
 F Makefile.in 543f91f24cd7fee774ecc0a61c19704c0c3e78fd
 F Makefile.linux-gcc 91d710bdc4998cb015f39edf3cb314ec4f4d7e23
@@ -116,7 +116,7 @@ F src/btmutex.c 96a12f50f7a17475155971a241d85ec5171573ff
 F src/btree.c 40c7a36152403d8e7266f99ef157a661c7ab9691
 F src/btree.h 2d1a83ad509047e8cc314fda7e054f99ff52414d
 F src/btreeInt.h c424f2f131cc61ddf130f9bd736b3df12c8a51f0
-F src/build.c 556c5918354ff1102e286fa0f7c032e18bdc2640
+F src/build.c 90685b71dfb606dba062271297959eb499e18a17
 F src/callback.c da3c38d0ef5d7f04fae371e519bda61aa9cb1704
 F src/complete.c dc1d136c0feee03c2f7550bafc0d29075e36deac
 F src/ctime.c c4eeabe49bb1422efd04b4ca474c0bd8063f8379
@@ -239,7 +239,7 @@ F test/alter2.test 52096b711afe5f219e575c6db7a70f7a35df4f63
 F test/alter3.test 25b95a136708f22b87184fa6a4309eea03d65153
 F test/alter4.test 9386ffd1e9c7245f43eca412b2058d747509cc1f
 F test/altermalloc.test e81ac9657ed25c6c5bb09bebfa5a047cd8e4acfc
-F test/analyze.test 2b2e06e06e575a431a0c3caa9e1511bdcdcc78ff
+F test/analyze.test f8ab7d15858b4093b06caf5e57e2a5ff7104bdae
 F test/analyze2.test ea3df826879dd672031b27c6a845afc3a39f27d9
 F test/analyze3.test 9be0af5e23b711559e8f78c42a6c04de956cba9b
 F test/analyze5.test 713354664c5ff1853ab2cbcb740f0cf5cb7c802e
@@ -853,7 +853,7 @@ F tool/speedtest2.tcl ee2149167303ba8e95af97873c575c3e0fab58ff
 F tool/speedtest8.c 2902c46588c40b55661e471d7a86e4dd71a18224
 F tool/speedtest8inst1.c 293327bc76823f473684d589a8160bde1f52c14e
 F tool/vdbe-compress.tcl d70ea6d8a19e3571d7ab8c9b75cba86d1173ff0f
-P 01cc4ff6af56a3dd08013862027bf8b91314986d 41b5f86971ed9d7ddca31bd9b43d0a41f03f002b
-R cea0fc29368023c16e8c038f08376226
+P a42db19d52b679e5f3ce6970883903816e75a4e4
+R 665754cf660cbecaba167a23a44d91dd
 U drh
-Z 9d73d77c74a70edc1459c3063eaeecaf
+Z 68aaf0288cba84ca9c2643399ac9c8cc
diff --git a/manifest.uuid b/manifest.uuid
index 5cb84948ca..5d6cfad357 100644
--- a/manifest.uuid
+++ b/manifest.uuid
@@ -1 +1 @@
-a42db19d52b679e5f3ce6970883903816e75a4e4
\ No newline at end of file
+a7e18468825622e518b2266a8724bdab99938b36
\ No newline at end of file
diff --git a/src/build.c b/src/build.c
index 926e28802d..aed5570e33 100644
--- a/src/build.c
+++ b/src/build.c
@@ -2937,12 +2937,7 @@ void sqlite3DropIndex(Parse *pParse, SrcList *pName, int ifExists){
        db->aDb[iDb].zName, SCHEMA_TABLE(iDb),
        pIndex->zName
     );
-    if( sqlite3FindTable(db, "sqlite_stat1", db->aDb[iDb].zName) ){
-      sqlite3NestedParse(pParse,
-        "DELETE FROM %Q.sqlite_stat1 WHERE idx=%Q",
-        db->aDb[iDb].zName, pIndex->zName
-      );
-    }
+    sqlite3ClearStatTables(pParse, iDb, "idx", pIndex->zName);
     sqlite3ChangeCookie(pParse, iDb);
     destroyRootPage(pParse, pIndex->tnum, iDb);
     sqlite3VdbeAddOp4(v, OP_DropIndex, iDb, 0, 0, pIndex->zName, 0);
diff --git a/test/analyze.test b/test/analyze.test
index d61d8b8c0c..362702a9c2 100644
--- a/test/analyze.test
+++ b/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.
-- 
2.47.2