Index: src/shell.c ================================================================== --- src/shell.c +++ src/shell.c @@ -3607,10 +3607,11 @@ static char **azCompletions = 0; static int iCompletion = 0; char *zRet; if( state==0 ){ sqlite3_free(azCompletions); + sqlite3_exec(globalDb, "PRAGMA page_count", 0, 0, 0); /* Load the schema */ azCompletions = sqlite3_namelist(globalDb, text, -1, 0); iCompletion = 0; } zRet = azCompletions[iCompletion++]; if( zRet==0 ){ @@ -3638,10 +3639,11 @@ if( nLine>sizeof(zBuf)-30 ) return; if( zLine[0]=='.' ) return; for(i=nLine-1; i>=0 && (isalnum(zLine[i]) || zLine[i]=='_'); i--){} if( i==nLine-1 ) return; iStart = i+1; + sqlite3_exec(globalDb, "PRAGMA page_count", 0, 0, 0); /* Load the schema */ az = sqlite3_namelist(globalDb, &zLine[iStart], -1, &n); if( n>0 ){ qsort(az, n, sizeof(az[0]),(int(*)(const void*,const void*))sqlite3_stricmp); memcpy(zBuf, zLine, iStart); for(i=0; az[i]; i++){