Lines Matching refs:pIdx
2807 Index *pIdx; /* Iterator variable */ in sqlite3FindInIndex() local
2839 for(pIdx=pTab->pIndex; pIdx && eType==0; pIdx=pIdx->pNext){ in sqlite3FindInIndex()
2842 if( pIdx->nColumn<nExpr ) continue; in sqlite3FindInIndex()
2843 if( pIdx->pPartIdxWhere!=0 ) continue; in sqlite3FindInIndex()
2846 testcase( pIdx->nColumn==BMS-2 ); in sqlite3FindInIndex()
2847 testcase( pIdx->nColumn==BMS-1 ); in sqlite3FindInIndex()
2848 if( pIdx->nColumn>=BMS-1 ) continue; in sqlite3FindInIndex()
2850 if( pIdx->nKeyCol>nExpr in sqlite3FindInIndex()
2851 ||(pIdx->nColumn>nExpr && !IsUniqueIndex(pIdx)) in sqlite3FindInIndex()
2866 if( pIdx->aiColumn[j]!=pRhs->iColumn ) continue; in sqlite3FindInIndex()
2867 assert( pIdx->azColl[j] ); in sqlite3FindInIndex()
2868 if( pReq!=0 && sqlite3StrICmp(pReq->zName, pIdx->azColl[j])!=0 ){ in sqlite3FindInIndex()
2885 "USING INDEX %s FOR IN-OPERATOR",pIdx->zName)); in sqlite3FindInIndex()
2886 sqlite3VdbeAddOp3(v, OP_OpenRead, iTab, pIdx->tnum, iDb); in sqlite3FindInIndex()
2887 sqlite3VdbeSetP4KeyInfo(pParse, pIdx); in sqlite3FindInIndex()
2888 VdbeComment((v, "%s", pIdx->zName)); in sqlite3FindInIndex()
2890 eType = IN_INDEX_INDEX_ASC + pIdx->aSortOrder[0]; in sqlite3FindInIndex()
3731 Index *pIdx, /* The index whose column is to be loaded */ in sqlite3ExprCodeLoadIndexColumn() argument
3736 i16 iTabCol = pIdx->aiColumn[iIdxCol]; in sqlite3ExprCodeLoadIndexColumn()
3738 assert( pIdx->aColExpr ); in sqlite3ExprCodeLoadIndexColumn()
3739 assert( pIdx->aColExpr->nExpr>iIdxCol ); in sqlite3ExprCodeLoadIndexColumn()
3741 sqlite3ExprCodeCopy(pParse, pIdx->aColExpr->a[iIdxCol].pExpr, regOut); in sqlite3ExprCodeLoadIndexColumn()
3744 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pIdx->pTable, iTabCur, in sqlite3ExprCodeLoadIndexColumn()
5987 Index *pIdx; /* The index to be tested for coverage */ member
5999 && sqlite3TableColumnToIndex(pWalker->u.pIdxCover->pIdx, pExpr->iColumn)<0 in exprIdxCover()
6020 Index *pIdx /* The index that might be used for coverage */ in sqlite3ExprCoveredByIndex() argument
6026 xcov.pIdx = pIdx; in sqlite3ExprCoveredByIndex()