Home
last modified time | relevance | path

Searched refs:pIdx (Results 1 – 25 of 29) sorted by relevance

12

/sqlite-3.40.0/src/
H A Danalyze.c1048 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in analyzeOneTable()
1064 nColTest = pIdx->uniqNotNull ? pIdx->nKeyCol-1 : nCol-1; in analyzeOneTable()
1406 Index *pIdx; in sqlite3Analyze() local
1435 analyzeTable(pParse, pIdx->pTable, pIdx); in sqlite3Analyze()
1625 if( pIdx ){
1647 if( !pIdx->aiRowEst || iCol>=pIdx->nKeyCol || pIdx->aiRowEst[iCol+1]==0 ){
1693 return pIdx;
1743 assert( pIdx==0 || pIdx->nSample==0 );
1745 assert( !HasRowid(pIdx->pTable) || pIdx->nColumn==pIdx->nKeyCol+1 );
1798 pSample = &pIdx->aSample[pIdx->nSample];
[all …]
H A Dfkey.c229 for(pIdx=pParent->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3FkLocateIndex()
230 if( pIdx->nKeyCol==nCol && IsUniqueIndex(pIdx) && pIdx->pPartIdxWhere==0 ){ in sqlite3FkLocateIndex()
280 if( !pIdx ){ in sqlite3FkLocateIndex()
290 *ppIdx = pIdx; in sqlite3FkLocateIndex()
359 if( pIdx==0 ){ in fkLookupParent()
565 assert( pIdx==0 || pIdx->pTable==pTab ); in fkScanChildren()
566 assert( pIdx==0 || pIdx->nKeyCol==pFKey->nCol ); in fkScanChildren()
590 iCol = pIdx ? pIdx->aiColumn[i] : -1; in fkScanChildren()
973 assert( pIdx==0 || pIdx->aiColumn[i]>=0 ); in sqlite3FkCheck()
1104 if( pIdx ){ in sqlite3FkOldmask()
[all …]
H A Dupsert.c151 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3UpsertAnalyzeTarget()
153 if( !IsUniqueIndex(pIdx) ) continue; in sqlite3UpsertAnalyzeTarget()
155 if( pIdx->pPartIdxWhere ){ in sqlite3UpsertAnalyzeTarget()
162 nn = pIdx->nKeyCol; in sqlite3UpsertAnalyzeTarget()
166 if( pIdx->aiColumn[ii]==XN_EXPR ){ in sqlite3UpsertAnalyzeTarget()
167 assert( pIdx->aColExpr!=0 ); in sqlite3UpsertAnalyzeTarget()
168 assert( pIdx->aColExpr->nExpr>ii ); in sqlite3UpsertAnalyzeTarget()
169 assert( pIdx->bHasExpr ); in sqlite3UpsertAnalyzeTarget()
195 pUpsert->pUpsertIdx = pIdx; in sqlite3UpsertAnalyzeTarget()
238 && pUpsert->pUpsertIdx!=pIdx in sqlite3UpsertOfIndex()
[all …]
H A Dinsert.c85 pIdx->zColAff = (char *)sqlite3DbMallocRaw(0, pIdx->nColumn+1); in sqlite3IndexAffinityStr()
1055 for(i=0, pIdx=pTab->pIndex; i<nIdx; pIdx=pIdx->pNext, i++){ in sqlite3Insert()
1570 pIter->u.lx.pIdx = pIter->u.lx.pIdx->pNext; in indexIteratorNext()
1929 for(nIdx=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, nIdx++){ in sqlite3GenerateConstraintChecks()
1945 pIdx = pIdx->pNext; in sqlite3GenerateConstraintChecks()
1954 for(jj=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, jj++){ in sqlite3GenerateConstraintChecks()
2160 pIdx; in sqlite3GenerateConstraintChecks()
2576 for(i=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, i++){ in sqlite3CompleteInsertion()
2596 pIdx->uniqNotNull ? pIdx->nKeyCol: pIdx->nColumn); in sqlite3CompleteInsertion()
2653 Index *pIdx; in sqlite3OpenTableAndIndices() local
[all …]
H A Ddelete.c394 for(nIdx=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, nIdx++){ in sqlite3DeleteFrom()
474 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3DeleteFrom()
475 assert( pIdx->pSchema==pTab->pSchema ); in sqlite3DeleteFrom()
896 Index *pIdx; /* Current index */ in sqlite3GenerateRowIndexDelete() local
903 for(i=0, pIdx=pTab->pIndex; pIdx; i++, pIdx=pIdx->pNext){ in sqlite3GenerateRowIndexDelete()
906 if( pIdx==pPk ) continue; in sqlite3GenerateRowIndexDelete()
912 pIdx->uniqNotNull ? pIdx->nKeyCol : pIdx->nColumn); in sqlite3GenerateRowIndexDelete()
915 pPrior = pIdx; in sqlite3GenerateRowIndexDelete()
966 if( pIdx->pPartIdxWhere ){ in sqlite3GenerateIndexKey()
978 nCol = (prefixOnly && pIdx->uniqNotNull) ? pIdx->nKeyCol : pIdx->nColumn; in sqlite3GenerateIndexKey()
[all …]
H A Dpragma.c1298 Index *pIdx; in sqlite3Pragma() local
1310 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3Pragma()
1324 Index *pIdx; in sqlite3Pragma() local
1336 if( pIdx ){ in sqlite3Pragma()
1377 for(pIdx=pTab->pIndex, i=0; pIdx; pIdx=pIdx->pNext, i++){ in sqlite3Pragma()
1711 for(nIdx=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, nIdx++){ cnt++; } in sqlite3Pragma()
1725 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3Pragma()
1775 for(j=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, j++){ in sqlite3Pragma()
1960 for(j=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, j++){ in sqlite3Pragma()
2010 for(j=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, j++){ in sqlite3Pragma()
[all …]
H A Dbuild.c1620 for(pIdx=p->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3AddNotNull()
1962 for(pIdx=p->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3AddCollateType()
2083 i = *pIdx; in identPut()
2193 memcpy(zExtra, pIdx->aSortOrder, pIdx->nColumn); in resizeIndexObject()
2435 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in convertToWithoutRowidTable()
2446 pIdx->nColumn = pIdx->nKeyCol; in convertToWithoutRowidTable()
2462 assert( pIdx->nColumn>=pIdx->nKeyCol+n ); in convertToWithoutRowidTable()
2763 for(pIdx=p->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3EndTable()
3305 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in destroyTable()
4300 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3CreateIndex()
[all …]
H A Dwhere.c454 if( pIdx ){ in whereScanInit()
566 assert( pIdx!=0 ); in indexColumnNotNull()
594 Index *pIdx; in isDistinctRedundant() local
629 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in isDistinctRedundant()
2745 || pIdx->aSortOrder[i+nEq]!=pIdx->aSortOrder[nEq] in whereRangeVectorLen()
3280 pIdx = pWalk->u.pCovIdxCk->pIdx; in whereIsCoveringIndexWalkCallback()
3327 ck.pIdx = pIdx; in whereIsCoveringIndex()
5187 Index *pIdx; in whereShortCut() local
5217 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in whereShortCut()
6287 Index *pIdx; in sqlite3WhereEnd() local
[all …]
H A Dwherecode.c29 i = pIdx->aiColumn[i]; in explainIndexColumnName()
155 Index *pIdx; in sqlite3WhereExplainOneScan() local
785 pIdx = pLoop->u.btree.pIndex; in codeAllEqualityTerms()
786 assert( pIdx!=0 ); in codeAllEqualityTerms()
928 assert( pHint->pIdx!=0 ); in codeCursorHintCheckExpr()
997 }else if( pHint->pIdx!=0 ){ in codeCursorHintFixExpr()
1100 if( sHint.pIdx!=0 ){ in codeCursorHint()
1158 assert( pIdx->aiColumn[pIdx->nColumn-1]==-1 ); in codeDeferredSeek()
1808 if( (nEq<pIdx->nColumn && bRev==(pIdx->aSortOrder[nEq]==SQLITE_SO_ASC)) ){ in sqlite3WhereCodeOneLoopStart()
2080 if( omitTable ) pIdx = 0; in sqlite3WhereCodeOneLoopStart()
[all …]
H A Dupdate.c98 Index *pIdx, /* The index to check */ in indexColumnIsBeingUpdated() argument
103 i16 iIdxCol = pIdx->aiColumn[iCol]; in indexColumnIsBeingUpdated()
109 assert( pIdx->aColExpr!=0 ); in indexColumnIsBeingUpdated()
132 if( pIdx->pPartIdxWhere==0 ) return 0; in indexWhereClauseMightChange()
423 for(nIdx=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, nIdx++){ in sqlite3Update()
424 if( pPk==pIdx ){ in sqlite3Update()
572 for(nAllIdx=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, nAllIdx++){ in sqlite3Update()
574 if( chngKey || hasFK>1 || pIdx==pPk in sqlite3Update()
578 pParse->nMem += pIdx->nColumn; in sqlite3Update()
581 for(i=0; i<pIdx->nKeyCol; i++){ in sqlite3Update()
[all …]
H A Dvdbeblob.c209 Index *pIdx; in sqlite3_blob_open() local
228 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3_blob_open()
230 for(j=0; j<pIdx->nKeyCol; j++){ in sqlite3_blob_open()
232 if( pIdx->aiColumn[j]==iCol || pIdx->aiColumn[j]==XN_EXPR ){ in sqlite3_blob_open()
H A Dalter.c1422 Index *pIdx; in renameParseCleanup() local
1427 while( (pIdx = pParse->pNewIndex)!=0 ){ in renameParseCleanup()
1428 pParse->pNewIndex = pIdx->pNext; in renameParseCleanup()
1429 sqlite3FreeIndex(db, pIdx); in renameParseCleanup()
1479 Index *pIdx; in renameColumnFunc() local
1541 for(pIdx=sParse.pNewTable->pIndex; pIdx; pIdx=pIdx->pNext){ in renameColumnFunc()
1542 sqlite3WalkExprList(&sWalker, pIdx->aColExpr); in renameColumnFunc()
1544 for(pIdx=sParse.pNewIndex; pIdx; pIdx=pIdx->pNext){ in renameColumnFunc()
1545 sqlite3WalkExprList(&sWalker, pIdx->aColExpr); in renameColumnFunc()
H A Dexpr.c2839 for(pIdx=pTab->pIndex; pIdx && eType==0; pIdx=pIdx->pNext){ in sqlite3FindInIndex()
2842 if( pIdx->nColumn<nExpr ) continue; in sqlite3FindInIndex()
2846 testcase( pIdx->nColumn==BMS-2 ); in sqlite3FindInIndex()
2847 testcase( pIdx->nColumn==BMS-1 ); in sqlite3FindInIndex()
2850 if( pIdx->nKeyCol>nExpr in sqlite3FindInIndex()
2851 ||(pIdx->nColumn>nExpr && !IsUniqueIndex(pIdx)) in sqlite3FindInIndex()
2867 assert( pIdx->azColl[j] ); in sqlite3FindInIndex()
3736 i16 iTabCol = pIdx->aiColumn[iIdxCol]; in sqlite3ExprCodeLoadIndexColumn()
3738 assert( pIdx->aColExpr ); in sqlite3ExprCodeLoadIndexColumn()
3739 assert( pIdx->aColExpr->nExpr>iIdxCol ); in sqlite3ExprCodeLoadIndexColumn()
[all …]
H A Dvdbevtab.c223 Index *pIdx = (Index*)sqliteHashData(k); in bytecodevtabColumn() local
224 if( pIdx->tnum==iRoot ){ in bytecodevtabColumn()
225 pCur->zName = pIdx->zName; in bytecodevtabColumn()
H A Dwhereexpr.c981 Index *pIdx; in exprMightBeIndexed2() local
986 for(pIdx=pFrom->a[i].pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in exprMightBeIndexed2()
987 if( pIdx->aColExpr==0 ) continue; in exprMightBeIndexed2()
988 for(i=0; i<pIdx->nKeyCol; i++){ in exprMightBeIndexed2()
989 if( pIdx->aiColumn[i]!=XN_EXPR ) continue; in exprMightBeIndexed2()
990 assert( pIdx->bHasExpr ); in exprMightBeIndexed2()
991 if( sqlite3ExprCompareSkip(pExpr, pIdx->aColExpr->a[i].pExpr, iCur)==0 ){ in exprMightBeIndexed2()
H A Dvdbemem.c1378 Index *pIdx; member
1400 Index *pIdx = p->pIdx; /* Index being probed */ in valueNew() local
1403 int nCol = pIdx->nColumn; /* Number of index columns including rowid */ in valueNew()
1408 pRec->pKeyInfo = sqlite3KeyInfoOfIndex(p->pParse, pIdx); in valueNew()
1815 Index *pIdx, /* Index being probed */ in sqlite3Stat4ProbeSetValue() argument
1830 alloc.pIdx = pIdx; in sqlite3Stat4ProbeSetValue()
1836 u8 aff = sqlite3IndexColumnAffinity(pParse->db, pIdx, iVal+i); in sqlite3Stat4ProbeSetValue()
H A Dvtab.c847 Index *pIdx; in sqlite3_declare_vtab() local
864 pIdx = pNew->pIndex; in sqlite3_declare_vtab()
865 if( pIdx ){ in sqlite3_declare_vtab()
866 assert( pIdx->pNext==0 ); in sqlite3_declare_vtab()
867 pTab->pIndex = pIdx; in sqlite3_declare_vtab()
869 pIdx->pTable = pTab; in sqlite3_declare_vtab()
H A Dselect.c5251 Index *pIdx; in sqlite3IndexedByLookup() local
5255 for(pIdx=pTab->pIndex; in sqlite3IndexedByLookup()
5256 pIdx && sqlite3StrICmp(pIdx->zName, zIndexedBy); in sqlite3IndexedByLookup()
5257 pIdx=pIdx->pNext in sqlite3IndexedByLookup()
5259 if( !pIdx ){ in sqlite3IndexedByLookup()
5265 pFrom->u2.pIBIndex = pIdx; in sqlite3IndexedByLookup()
6392 int bCover = (pIdx!=0 && (HasRowid(pTab) || !IsPrimaryKeyIndex(pIdx))); in explainSimpleCount()
6396 bCover ? pIdx->zName : "" in explainSimpleCount()
7748 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3Select()
7749 if( pIdx->bUnordered==0 in sqlite3Select()
[all …]
H A DwhereInt.h513 Index *pIdx /* Must be compatible with this index, if not NULL */
H A Dvdbeaux.c1473 void sqlite3VdbeSetP4KeyInfo(Parse *pParse, Index *pIdx){ in sqlite3VdbeSetP4KeyInfo() argument
1477 assert( pIdx!=0 ); in sqlite3VdbeSetP4KeyInfo()
1478 pKeyInfo = sqlite3KeyInfoOfIndex(pParse, pIdx); in sqlite3VdbeSetP4KeyInfo()
/sqlite-3.40.0/ext/repair/
H A Dcheckindex.c292 if( pIdx ){ in cidxFreeIndex()
298 sqlite3_free(pIdx); in cidxFreeIndex()
469 CidxIndex *pIdx = 0; in cidxLookupIndex() local
495 pIdx = (CidxIndex*)sqlite3_realloc(pIdx, nByte); in cidxLookupIndex()
524 cidxFreeIndex(pIdx); in cidxLookupIndex()
527 *ppIdx = pIdx; in cidxLookupIndex()
655 assert( pIdx->aCol[i].bDesc==0 || pIdx->aCol[i].bDesc==1 ); in cidxColumnList()
716 CidxIndex *pIdx = 0; in cidxGenerateScanSql() local
738 (pIdx->zWhere ? "WHERE " : ""), (pIdx->zWhere ? pIdx->zWhere : ""), in cidxGenerateScanSql()
760 pIdx->zWhere ? pIdx->zWhere : "", in cidxGenerateScanSql()
[all …]
/sqlite-3.40.0/ext/recover/
H A Ddbdata.c214 for(i=0; i<pIdx->nConstraint; i++){ in dbdataBestIndex()
233 pIdx->aConstraintUsage[iPgno].omit = 1; in dbdataBestIndex()
234 pIdx->estimatedCost = 100; in dbdataBestIndex()
235 pIdx->estimatedRows = 50; in dbdataBestIndex()
237 if( pTab->bPtr==0 && pIdx->nOrderBy && pIdx->aOrderBy[0].desc==0 ){ in dbdataBestIndex()
238 int iCol = pIdx->aOrderBy[0].iColumn; in dbdataBestIndex()
239 if( pIdx->nOrderBy==1 ){ in dbdataBestIndex()
241 }else if( pIdx->nOrderBy==2 && pIdx->aOrderBy[1].desc==0 && iCol==0 ){ in dbdataBestIndex()
242 pIdx->orderByConsumed = (pIdx->aOrderBy[1].iColumn==1); in dbdataBestIndex()
247 pIdx->estimatedCost = 100000000; in dbdataBestIndex()
[all …]
/sqlite-3.40.0/ext/fts5/
H A Dfts5_storage.c378 Fts5Index *pIdx = pCtx->pStorage->pIndex; in fts5StorageInsertCallback() local
384 return sqlite3Fts5IndexWrite(pIdx, pCtx->iCol, pCtx->szCol-1, pToken, nToken); in fts5StorageInsertCallback()
H A Dfts5Int.h727 int sqlite3Fts5ExprFirst(Fts5Expr*, Fts5Index *pIdx, i64 iMin, int bDesc);
H A Dfts5_expr.c1487 int sqlite3Fts5ExprFirst(Fts5Expr *p, Fts5Index *pIdx, i64 iFirst, int bDesc){ in sqlite3Fts5ExprFirst() argument
1491 p->pIndex = pIdx; in sqlite3Fts5ExprFirst()

12