Lines Matching refs:j
91 int i, j; in explainIndexRange() local
101 j = i; in explainIndexRange()
103 explainAppendTerm(pStr, pIndex, pLoop->u.btree.nBtm, j, i, ">"); in explainIndexRange()
107 explainAppendTerm(pStr, pIndex, pLoop->u.btree.nTop, j, i, "<"); in explainIndexRange()
775 int j; /* Loop counter */ in codeAllEqualityTerms() local
804 j = sqlite3VdbeAddOp0(v, OP_Goto); in codeAllEqualityTerms()
810 sqlite3VdbeJumpHere(v, j); in codeAllEqualityTerms()
811 for(j=0; j<nSkip; j++){ in codeAllEqualityTerms()
812 sqlite3VdbeAddOp3(v, OP_Column, iIdxCur, j, regBase+j); in codeAllEqualityTerms()
813 testcase( pIdx->aiColumn[j]==XN_EXPR ); in codeAllEqualityTerms()
814 VdbeComment((v, "%s", explainIndexColumnName(pIdx, j))); in codeAllEqualityTerms()
821 for(j=nSkip; j<nEq; j++){ in codeAllEqualityTerms()
823 pTerm = pLoop->aLTerm[j]; in codeAllEqualityTerms()
829 r1 = codeEqualityTerm(pParse, pTerm, pLevel, j, bRev, regBase+j); in codeAllEqualityTerms()
830 if( r1!=regBase+j ){ in codeAllEqualityTerms()
835 sqlite3VdbeAddOp2(v, OP_Copy, r1, regBase+j); in codeAllEqualityTerms()
839 for(j=nSkip; j<nEq; j++){ in codeAllEqualityTerms()
840 pTerm = pLoop->aLTerm[j]; in codeAllEqualityTerms()
847 if( zAff ) zAff[j] = SQLITE_AFF_BLOB; in codeAllEqualityTerms()
852 sqlite3VdbeAddOp2(v, OP_IsNull, regBase+j, pLevel->addrBrk); in codeAllEqualityTerms()
857 if( sqlite3CompareAffinity(pRight, zAff[j])==SQLITE_AFF_BLOB ){ in codeAllEqualityTerms()
858 zAff[j] = SQLITE_AFF_BLOB; in codeAllEqualityTerms()
860 if( sqlite3ExprNeedsNoAffinityChange(pRight, zAff[j]) ){ in codeAllEqualityTerms()
861 zAff[j] = SQLITE_AFF_BLOB; in codeAllEqualityTerms()
1032 int i, j; in codeCursorHint() local
1091 for(j=0; j<pLoop->nLTerm && pLoop->aLTerm[j]!=pTerm; j++){} in codeCursorHint()
1092 if( j<pLoop->nLTerm ) continue; in codeCursorHint()
1324 int j, k; /* Loop counters */ in sqlite3WhereCodeOneLoopStart() local
1393 for(j=iLevel; j>0; j--){ in sqlite3WhereCodeOneLoopStart()
1394 if( pWInfo->a[j].iLeftJoin ) break; in sqlite3WhereCodeOneLoopStart()
1395 if( pWInfo->a[j].pRJ ) break; in sqlite3WhereCodeOneLoopStart()
1397 addrHalt = pWInfo->a[j].addrBrk; in sqlite3WhereCodeOneLoopStart()
1420 for(j=0; j<nConstraint; j++){ in sqlite3WhereCodeOneLoopStart()
1421 int iTarget = iReg+j+2; in sqlite3WhereCodeOneLoopStart()
1422 pTerm = pLoop->aLTerm[j]; in sqlite3WhereCodeOneLoopStart()
1425 if( SMASKBIT32(j) & pLoop->u.vtab.mHandleIn ){ in sqlite3WhereCodeOneLoopStart()
1431 codeEqualityTerm(pParse, pTerm, pLevel, j, bRev, iTarget); in sqlite3WhereCodeOneLoopStart()
1463 for(j=0; j<nConstraint; j++){ in sqlite3WhereCodeOneLoopStart()
1464 pTerm = pLoop->aLTerm[j]; in sqlite3WhereCodeOneLoopStart()
1465 if( j<16 && (pLoop->u.vtab.omitMask>>j)&1 ){ in sqlite3WhereCodeOneLoopStart()
1470 && (SMASKBIT32(j) & pLoop->u.vtab.mHandleIn)==0 in sqlite3WhereCodeOneLoopStart()
1485 if( (pOp->opcode==OP_Column && pOp->p3==iReg+j+2) in sqlite3WhereCodeOneLoopStart()
1486 || (pOp->opcode==OP_Rowid && pOp->p2==iReg+j+2) in sqlite3WhereCodeOneLoopStart()
1512 pRight->iTable = iReg+j+2; in sqlite3WhereCodeOneLoopStart()
1571 j = 0; in sqlite3WhereCodeOneLoopStart()
1573 if( pLoop->wsFlags & WHERE_BTM_LIMIT ) pStart = pLoop->aLTerm[j++]; in sqlite3WhereCodeOneLoopStart()
1574 if( pLoop->wsFlags & WHERE_TOP_LIMIT ) pEnd = pLoop->aLTerm[j++]; in sqlite3WhereCodeOneLoopStart()
1745 j = nEq; in sqlite3WhereCodeOneLoopStart()
1747 pRangeStart = pLoop->aLTerm[j++]; in sqlite3WhereCodeOneLoopStart()
1754 pRangeEnd = pLoop->aLTerm[j++]; in sqlite3WhereCodeOneLoopStart()
1774 j = pIdx->aiColumn[nEq]; in sqlite3WhereCodeOneLoopStart()
1775 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){ in sqlite3WhereCodeOneLoopStart()
2038 for(j=0; j<pPk->nKeyCol; j++){ in sqlite3WhereCodeOneLoopStart()
2039 k = sqlite3TableColumnToIndex(pIdx, pPk->aiColumn[j]); in sqlite3WhereCodeOneLoopStart()
2040 sqlite3VdbeAddOp3(v, OP_Column, iIdxCur, k, iRowidReg+j); in sqlite3WhereCodeOneLoopStart()
2460 for(pTerm=pWC->a, j=pWC->nTerm; j>0; j--, pTerm++){ in sqlite3WhereCodeOneLoopStart()
2519 pWC->nTerm-j, pTerm, iLoop)); in sqlite3WhereCodeOneLoopStart()
2523 sqlite3WhereTermPrint(pTerm, pWC->nTerm-j); in sqlite3WhereCodeOneLoopStart()
2541 for(pTerm=pWC->a, j=pWC->nBase; j>0; j--, pTerm++){ in sqlite3WhereCodeOneLoopStart()
2553 sqlite3WhereTermPrint(pTerm, pWC->nTerm-j); in sqlite3WhereCodeOneLoopStart()
2651 for(pTerm=pWC->a, j=0; j<pWC->nBase; j++, pTerm++){ in sqlite3WhereCodeOneLoopStart()