Import SQLite 3.10.2.

third_party/sqlite/src/test/wordcount.c

 /*
 ** This C program extracts all "words" from an input document and adds them
 ** to an SQLite database.  A "word" is any contiguous sequence of alphabetic
 ** characters.  All digits, punctuation, and whitespace characters are 
 ** word separators.  The database stores a single entry for each distinct
 ** word together with a count of the number of occurrences of that word.
 ** A fresh database is created automatically on each run.
 **
 **     wordcount DATABASE INPUTFILE
 **
@@ skipping 62 matching lines @@
 **
 **    gcc -I. -DSQLITE_THREADSAFE=0 -DSQLITE_OMIT_LOAD_EXTENSION \
 **        wordcount.c sqlite3.c
 */
 #include <stdio.h>
 #include <string.h>
 #include <ctype.h>
 #include <stdlib.h>
 #include <stdarg.h>
 #include "sqlite3.h"
+#define ISALPHA(X) isalpha((unsigned char)(X))
 
 /* Return the current wall-clock time */
 static sqlite3_int64 realTime(void){
   static sqlite3_vfs *clockVfs = 0;
   sqlite3_int64 t;
   if( clockVfs==0 ) clockVfs = sqlite3_vfs_find(0);
   if( clockVfs->iVersion>=1 && clockVfs->xCurrentTimeInt64!=0 ){
     clockVfs->xCurrentTimeInt64(clockVfs, &t);
   }else{
     double r;
@@ skipping 292 matching lines @@
     rc = sqlite3_prepare_v2(db,
           "DELETE FROM wordcount WHERE word=?1",
           -1, &pDelete, 0);
     if( rc ) fatal_error("Could not prepare the DELETE statement: %s\n",
                          sqlite3_errmsg(db));
   }
 
   /* Process the input file */
   while( fgets(zInput, sizeof(zInput), in) ){
     for(i=0; zInput[i]; i++){
-      if( !isalpha(zInput[i]) ) continue;
-      for(j=i+1; isalpha(zInput[j]); j++){}
+      if( !ISALPHA(zInput[i]) ) continue;
+      for(j=i+1; ISALPHA(zInput[j]); j++){}
 
       /* Found a new word at zInput[i] that is j-i bytes long. 
       ** Process it into the wordcount table.  */
       if( iMode==MODE_DELETE ){
         sqlite3_bind_text(pDelete, 1, zInput+i, j-i, SQLITE_STATIC);
         if( sqlite3_step(pDelete)!=SQLITE_DONE ){
           fatal_error("DELETE failed: %s\n", sqlite3_errmsg(db));
         }
         sqlite3_reset(pDelete);
       }else if( iMode==MODE_SELECT ){
@@ skipping 129 matching lines @@
     printf("-- Scratch Overflow Bytes:      %d (max %d)\n", iCur,iHiwtr);
     sqlite3_status(SQLITE_STATUS_MALLOC_SIZE, &iCur, &iHiwtr, 0);
     printf("-- Largest Allocation:          %d bytes\n",iHiwtr);
     sqlite3_status(SQLITE_STATUS_PAGECACHE_SIZE, &iCur, &iHiwtr, 0);
     printf("-- Largest Pcache Allocation:   %d bytes\n",iHiwtr);
     sqlite3_status(SQLITE_STATUS_SCRATCH_SIZE, &iCur, &iHiwtr, 0);
     printf("-- Largest Scratch Allocation:  %d bytes\n", iHiwtr);
   }
   return 0;
 }