Fossil SCM
For the --deanalyze option to rebuild, the stat4 table should be dropped as well.
Commit
4c8a5c98603a90060aa83de7224ab161c978c1b3
Parent
ab4d4dacf78701b…
1 file changed
+2
-1
+2
-1
| --- src/rebuild.c | ||
| +++ src/rebuild.c | ||
| @@ -607,11 +607,12 @@ | ||
| 607 | 607 | db_multi_exec("PRAGMA page_size=%d", newPagesize); |
| 608 | 608 | runVacuum = 1; |
| 609 | 609 | } |
| 610 | 610 | if( runDeanalyze ){ |
| 611 | 611 | db_multi_exec("DROP TABLE IF EXISTS sqlite_stat1;" |
| 612 | - "DROP TABLE IF EXISTS sqlite_stat3;"); | |
| 612 | + "DROP TABLE IF EXISTS sqlite_stat3;" | |
| 613 | + "DROP TABLE IF EXISTS sqlite_stat4;"); | |
| 613 | 614 | } |
| 614 | 615 | if( runAnalyze ){ |
| 615 | 616 | fossil_print("Analyzing the database... "); fflush(stdout); |
| 616 | 617 | db_multi_exec("ANALYZE;"); |
| 617 | 618 | fossil_print("done\n"); |
| 618 | 619 |
| --- src/rebuild.c | |
| +++ src/rebuild.c | |
| @@ -607,11 +607,12 @@ | |
| 607 | db_multi_exec("PRAGMA page_size=%d", newPagesize); |
| 608 | runVacuum = 1; |
| 609 | } |
| 610 | if( runDeanalyze ){ |
| 611 | db_multi_exec("DROP TABLE IF EXISTS sqlite_stat1;" |
| 612 | "DROP TABLE IF EXISTS sqlite_stat3;"); |
| 613 | } |
| 614 | if( runAnalyze ){ |
| 615 | fossil_print("Analyzing the database... "); fflush(stdout); |
| 616 | db_multi_exec("ANALYZE;"); |
| 617 | fossil_print("done\n"); |
| 618 |
| --- src/rebuild.c | |
| +++ src/rebuild.c | |
| @@ -607,11 +607,12 @@ | |
| 607 | db_multi_exec("PRAGMA page_size=%d", newPagesize); |
| 608 | runVacuum = 1; |
| 609 | } |
| 610 | if( runDeanalyze ){ |
| 611 | db_multi_exec("DROP TABLE IF EXISTS sqlite_stat1;" |
| 612 | "DROP TABLE IF EXISTS sqlite_stat3;" |
| 613 | "DROP TABLE IF EXISTS sqlite_stat4;"); |
| 614 | } |
| 615 | if( runAnalyze ){ |
| 616 | fossil_print("Analyzing the database... "); fflush(stdout); |
| 617 | db_multi_exec("ANALYZE;"); |
| 618 | fossil_print("done\n"); |
| 619 |