Lines Matching refs:pWLoop

163146   struct WhereLoop *pWLoop;  /* The selected WhereLoop object */  member
163830     pLoop = pLevel->pWLoop;
163944     if( (pLevel->pWLoop->wsFlags & WHERE_MULTI_OR)==0
163950           v, OP_Explain, addr, pParse->addrExplain, pLevel->pWLoop->rRun
163986   pLoop = pLevel->pWLoop;
164029     WhereLoop *pLoop = pLvl->pWLoop;
164368   WhereLoop *pLoop = pLevel->pWLoop;
164502   assert( pLevel->pWLoop->aLTerm[iEq]==pTerm );
164526   if( (pLevel->pWLoop->wsFlags & WHERE_TRANSCONS)==0
164599   pLoop = pLevel->pWLoop;
164844   WhereLoop *pLoop = pLevel->pWLoop;
165089     WhereLoop *pLoop = pLevel->pWLoop;
165091     if( pLevel->pWLoop->nSkip ) continue;
165180   pLoop = pLevel->pWLoop;
166207           pSubLoop = pSubWInfo->a[0].pWLoop;
166230     assert( pLevel->pWLoop==pLoop );
166540   WhereLoop *pLoop = pLevel->pWLoop;
166556     assert( pWInfo->a[k].pWLoop->iTab == pWInfo->a[k].iFrom );
166558     mAll |= pWInfo->a[k].pWLoop->maskSelf;
168721     if( (pInner->pWLoop->wsFlags & WHERE_COLUMN_IN)!=0 ){
169624   pLoop = pLevel->pWLoop;
169876   WhereLoop *pLoop = pLevel->pWLoop;   /* The loop being coded */
169963       pLoop = pLevel->pWLoop;
174243   WhereLoop *pWLoop;             /* For looping over WhereLoops */  local
174252   for(pWLoop=pWInfo->pLoops; pWLoop; pWLoop=pWLoop->pNextLoop){
174253     assert( pWLoop->maskSelf==MASKBIT(pWLoop->iTab) );
174254     assert( pWLoop->pNextLoop==0 || pWLoop->iTab<=pWLoop->pNextLoop->iTab );
174295       for(pWLoop=pStart; pWLoop; pWLoop=pWLoop->pNextLoop){
174296         if( (aFromTabs[pWLoop->iTab].fg.jointype & (JT_OUTER|JT_CROSS))!=0 ){
174299         if( (pWLoop->prereq & m)!=0        /* pWInfo depends on iFromIdx */
174300          && (pWLoop->maskSelf & mSeen)==0  /* pWInfo not already a dependency */
174301          && (pWLoop->maskSelf & mSelfJoin)==0 /* Not a self-join */
174303           if( aFromTabs[pWLoop->iTab].pSTab==pFactTab->pSTab ){
174307             mSeen |= pWLoop->maskSelf;
174322         for(pWLoop=pWInfo->pLoops; pWLoop; pWLoop=pWLoop->pNextLoop){
174323           pWLoop->rStarDelta = 0;
174333         for(pWLoop=pStart; pWLoop; pWLoop=pWLoop->pNextLoop){
174334           if( mShow & pWLoop->maskSelf ){
174335             SrcItem *pDim = aFromTabs + pWLoop->iTab;
174336             mShow &= ~pWLoop->maskSelf;
174338               pDim->zAlias ? pDim->zAlias: pDim->pSTab->zName, pWLoop->iTab);
174349       for(pWLoop=pStart; pWLoop; pWLoop=pWLoop->pNextLoop){
174350         if( pWLoop->iTab<iFromIdx ) continue;
174351         if( pWLoop->iTab>iFromIdx ) break;
174352         if( pWLoop->rRun>mxRun ) mxRun = pWLoop->rRun;
174358       for(pWLoop=pStart; pWLoop; pWLoop=pWLoop->pNextLoop){
174359         if( (pWLoop->maskSelf & mSeen)==0 ) continue;
174360         if( pWLoop->nLTerm ) continue;
174361         if( pWLoop->rRun<mxRun ){
174364             SrcItem *pDim = aFromTabs + pWLoop->iTab;
174370           pWLoop->rStarDelta = mxRun - pWLoop->rRun;
174372           pWLoop->rRun = mxRun;
174379       for(pWLoop=pWInfo->pLoops; pWLoop; pWLoop=pWLoop->pNextLoop){
174380         if( pWLoop->rStarDelta ){
174381           sqlite3WhereLoopPrint(pWLoop, &pWInfo->sWC);
174439   WhereLoop *pWLoop;        /* One of the WhereLoop objects */  local
174529       for(pWLoop=pWInfo->pLoops; pWLoop; pWLoop=pWLoop->pNextLoop){
174537         if( (pWLoop->prereq & ~pFrom->maskLoop)!=0 ) continue;
174538         if( (pWLoop->maskSelf & pFrom->maskLoop)!=0 ) continue;
174539         if( (pWLoop->wsFlags & WHERE_AUTO_INDEX)!=0 && pFrom->nRow<3 ){
174550         rUnsort = pWLoop->rRun + pFrom->nRow;
174551         if( pWLoop->rSetup ){
174552           rUnsort = sqlite3LogEstAdd(pWLoop->rSetup, rUnsort);
174555         nOut = pFrom->nRow + pWLoop->nOut;
174556         maskNew = pFrom->maskLoop | pWLoop->maskSelf;
174562                        iLoop, pWLoop, &revMask);
174625                   wherePathName(pFrom, iLoop, pWLoop), rCost, nOut, rUnsort,
174644                 wherePathName(pFrom, iLoop, pWLoop), rCost, nOut, rUnsort,
174661                   && whereLoopIsNoBetter(pWLoop, pTo->aLoop[iLoop]) )
174667                   wherePathName(pFrom, iLoop, pWLoop), rCost, nOut, rUnsort,
174685                 wherePathName(pFrom, iLoop, pWLoop), rCost, nOut, rUnsort,
174694         pTo->maskLoop = pFrom->maskLoop | pWLoop->maskSelf;
174701         pTo->aLoop[iLoop] = pWLoop;
174771     pLevel->pWLoop = pWLoop = pFrom->aLoop[iLoop];
174772     pLevel->iFrom = pWLoop->iTab;
174897     WhereLoop *p = pWInfo->a[i].pWLoop;
175009     pWInfo->a[0].pWLoop = pLoop;
175147     pLoop = pWInfo->a[i].pWLoop;
175221     WhereLoop *pLoop = pWInfo->a[i].pWLoop;
175745       sqlite3WhereLoopPrint(pWInfo->a[ii].pWLoop, sWLB.pWC);
175810     int wsFlags = pWInfo->a[0].pWLoop->wsFlags;
175824         pWInfo->a[0].pWLoop->wsFlags = (wsFlags & ~WHERE_IDX_ONLY);
175840     pLoop = pLevel->pWLoop;
176027     wsFlags = pLevel->pWLoop->wsFlags;
176143     pLoop = pLevel->pWLoop;
176313     pLoop = pLevel->pWLoop;