[sql] Import SQLite 3.17.0.

third_party/sqlite/src/ext/fts3/tool/fts3view.c

 /*
 ** This program is a debugging and analysis utility that displays
 ** information about an FTS3 or FTS4 index.
 **
 ** Link this program against the SQLite3 amalgamation with the
 ** SQLITE_ENABLE_FTS4 compile-time option.  Then run it as:
 **
 **    fts3view DATABASE
 **
 ** to get a list of all FTS3/4 tables in DATABASE, or do
@@ skipping 380 matching lines @@
            "       count(distinct idx)"
            "  FROM (SELECT length(a.block) AS len, idx"
            "          FROM '%q_segments' a JOIN '%q_segdir' b"
            "         WHERE (a.blockid BETWEEN b.start_block"
                                        " AND b.leaves_end_block)"
            "           AND (b.level%%1024)==%d)",
            pgsz-45, zTab, zTab, i);
     if( sqlite3_step(pStmt)==SQLITE_ROW
      && (nLeaf = sqlite3_column_int(pStmt, 0))>0
     ){
+      sqlite3_int64 sz;
       nIdx = sqlite3_column_int(pStmt, 5);
-      sqlite3_int64 sz;
       printf("For level %d:\n", i);
       printf("  Number of indexes...................... %9d\n", nIdx);
       printf("  Number of leaf segments................ %9d\n", nLeaf);
       if( nIdx>1 ){
         printf("  Average leaf segments per index........ %11.1f\n",
                (double)nLeaf/(double)nIdx);
       }
       printf("  Total size of all leaf segments........ %9lld\n",
              (sz = sqlite3_column_int64(pStmt, 1)));
       printf("  Average size of leaf segments.......... %11.1f\n",
@@ skipping 453 matching lines @@
     showSegmentStats(db, zTab);
   }else if( strcmp(zCmd,"stat")==0 ){
     showStat(db, zTab);
   }else if( strcmp(zCmd,"vocabulary")==0 ){
     showVocabulary(db, zTab);
   }else{
     usage(argv[0]);
   }
   return 0; 
 }