contrib/sqlite3/shell.c

7188     const struct sqlite3_index_constraint *pCons = &pIdxInfo->aConstraint[i];
7189     if( pCons->iColumn!=ZIPFILE_F_COLUMN_IDX ) continue;
7190     if( pCons->usable==0 ){
7192     }else if( pCons->op==SQLITE_INDEX_CONSTRAINT_EQ ){
8832       struct sqlite3_index_constraint *pCons = &pIdxInfo->aConstraint[i];
8833       if( pCons->usable
8834        && pCons->iColumn>=0
8835        && p->pTab->aCol[pCons->iColumn].iPk==0
8836        && (pCons->op & opmask)
8842           pNew->iCol = pCons->iColumn;
8843           if( pCons->op==SQLITE_INDEX_CONSTRAINT_EQ ){
9180 ** pCons to the string passed as zIn and returns the result.
9186   IdxConstraint *pCons
9189   IdxColumn *p = &pTab->aCol[pCons->iCol];
9198   if( sqlite3_stricmp(p->zColl, pCons->zColl) ){
9199     if( idxIdentifierRequiresQuotes(pCons->zColl) ){
9200       zRet = idxAppendText(pRc, zRet, " COLLATE %Q", pCons->zColl);
9202       zRet = idxAppendText(pRc, zRet, " COLLATE %s", pCons->zColl);
9206   if( pCons->bDesc ){
9299     IdxConstraint *pCons;
9303     for(pCons=pEq; pCons; pCons=pCons->pLink){
9304       zCols = idxAppendColDefn(&rc, zCols, pTab, pCons);
9306     for(pCons=pTail; pCons; pCons=pCons->pLink){
9307       zCols = idxAppendColDefn(&rc, zCols, pTab, pCons);