Lines Matching refs:pPrior
69 Select *pPrior = p->pPrior; in clearSelect() local
80 p = pPrior; in clearSelect()
140 pNew->pPrior = 0; in sqlite3SelectNew()
1607 while( pSelect->pPrior ) pSelect = pSelect->pPrior; in generateColumnNames()
1835 while( pSelect->pPrior ) pSelect = pSelect->pPrior; in sqlite3ResultSetOfSelect()
1957 if( p->pPrior ){ in multiSelectCollSeq()
1958 pRet = multiSelectCollSeq(pParse, p->pPrior, iCol); in multiSelectCollSeq()
2055 Select *pSetup = p->pPrior; /* The setup query */ in generateWithRecursiveQuery()
2160 p->pPrior = 0; in generateWithRecursiveQuery()
2162 assert( p->pPrior==0 ); in generateWithRecursiveQuery()
2163 p->pPrior = pSetup; in generateWithRecursiveQuery()
2202 Select *pPrior; in multiSelectValues() local
2208 assert( p->op==TK_ALL || (p->op==TK_SELECT && p->pPrior==0) ); in multiSelectValues()
2212 if( p->pPrior==0 ) break; in multiSelectValues()
2213 assert( p->pPrior->pNext==p ); in multiSelectValues()
2214 p = p->pPrior; in multiSelectValues()
2218 pPrior = p->pPrior; in multiSelectValues()
2219 p->pPrior = 0; in multiSelectValues()
2221 p->pPrior = pPrior; in multiSelectValues()
2266 Select *pPrior; /* Another SELECT immediately to our left */ in multiSelect() local
2279 assert( p && p->pPrior ); /* Calling function guarantees this much */ in multiSelect()
2282 pPrior = p->pPrior; in multiSelect()
2284 if( pPrior->pOrderBy ){ in multiSelect()
2290 if( pPrior->pLimit ){ in multiSelect()
2318 assert( p->pEList && pPrior->pEList ); in multiSelect()
2319 assert( p->pEList->nExpr==pPrior->pEList->nExpr ); in multiSelect()
2339 assert( !pPrior->pLimit ); in multiSelect()
2340 pPrior->iLimit = p->iLimit; in multiSelect()
2341 pPrior->iOffset = p->iOffset; in multiSelect()
2342 pPrior->pLimit = p->pLimit; in multiSelect()
2343 pPrior->pOffset = p->pOffset; in multiSelect()
2345 rc = sqlite3Select(pParse, pPrior, &dest); in multiSelect()
2351 p->pPrior = 0; in multiSelect()
2352 p->iLimit = pPrior->iLimit; in multiSelect()
2353 p->iOffset = pPrior->iOffset; in multiSelect()
2365 pDelete = p->pPrior; in multiSelect()
2366 p->pPrior = pPrior; in multiSelect()
2367 p->nSelectRow = sqlite3LogEstAdd(p->nSelectRow, pPrior->nSelectRow); in multiSelect()
2368 if( pPrior->pLimit in multiSelect()
2369 && sqlite3ExprIsInteger(pPrior->pLimit, &nLimit) in multiSelect()
2413 assert( !pPrior->pOrderBy ); in multiSelect()
2416 rc = sqlite3Select(pParse, pPrior, &uniondest); in multiSelect()
2429 p->pPrior = 0; in multiSelect()
2441 pDelete = p->pPrior; in multiSelect()
2442 p->pPrior = pPrior; in multiSelect()
2445 p->nSelectRow = sqlite3LogEstAdd(p->nSelectRow, pPrior->nSelectRow); in multiSelect()
2500 rc = sqlite3Select(pParse, pPrior, &intersectdest); in multiSelect()
2510 p->pPrior = 0; in multiSelect()
2519 pDelete = p->pPrior; in multiSelect()
2520 p->pPrior = pPrior; in multiSelect()
2521 if( p->nSelectRow>pPrior->nSelectRow ) p->nSelectRow = pPrior->nSelectRow; in multiSelect()
2581 for(pLoop=p; pLoop; pLoop=pLoop->pPrior){ in multiSelect()
2855 Select *pPrior; /* Another SELECT immediately to our left */ in multiSelectOrderBy() local
2905 pPrior = p->pPrior; in multiSelectOrderBy()
2906 assert( pPrior->pOrderBy==0 ); in multiSelectOrderBy()
2957 pPrior->pOrderBy = sqlite3ExprListDup(pParse->db, pOrderBy, 0); in multiSelectOrderBy()
2983 p->pPrior = 0; in multiSelectOrderBy()
2984 pPrior->pNext = 0; in multiSelectOrderBy()
2986 if( pPrior->pPrior==0 ){ in multiSelectOrderBy()
2987 sqlite3ResolveOrderGroupBy(pParse, pPrior, pPrior->pOrderBy, "ORDER"); in multiSelectOrderBy()
3019 pPrior->iLimit = regLimitA; in multiSelectOrderBy()
3021 sqlite3Select(pParse, pPrior, &destA); in multiSelectOrderBy()
3071 p->nSelectRow = sqlite3LogEstAdd(p->nSelectRow, pPrior->nSelectRow); in multiSelectOrderBy()
3079 if( p->nSelectRow > pPrior->nSelectRow ) p->nSelectRow = pPrior->nSelectRow; in multiSelectOrderBy()
3139 if( p->pPrior ){ in multiSelectOrderBy()
3140 sqlite3SelectDelete(db, p->pPrior); in multiSelectOrderBy()
3142 p->pPrior = pPrior; in multiSelectOrderBy()
3143 pPrior->pNext = p; in multiSelectOrderBy()
3272 }while( doPrior && (p = p->pPrior)!=0 ); in substSelect()
3442 assert( p->pPrior==0 ); /* Unable to flatten compound queries */ in flattenSubquery()
3494 if( (p->selFlags & SF_Recursive) && pSub->pPrior ){ in flattenSubquery()
3537 if( pSub->pPrior ){ in flattenSubquery()
3544 for(pSub1=pSub; pSub1; pSub1=pSub1->pPrior){ in flattenSubquery()
3550 || (pSub1->pPrior && pSub1->op!=TK_ALL) in flattenSubquery()
3610 for(pSub=pSub->pPrior; pSub; pSub=pSub->pPrior){ in flattenSubquery()
3615 Select *pPrior = p->pPrior; in flattenSubquery() local
3618 p->pPrior = 0; in flattenSubquery()
3629 p->pPrior = pPrior; in flattenSubquery()
3631 pNew->pPrior = pPrior; in flattenSubquery()
3632 if( pPrior ) pPrior->pNext = pNew; in flattenSubquery()
3634 p->pPrior = pNew; in flattenSubquery()
3690 for(pParent=p; pParent; pParent=pParent->pPrior, pSub=pSub->pPrior){ in flattenSubquery()
3771 assert( pSub->pPrior==0 ); in flattenSubquery()
3882 for(pX=pSubq; pX; pX=pX->pPrior){ in pushDownWhereTerms()
3910 pSubq = pSubq->pPrior; in pushDownWhereTerms()
4048 if( p->pPrior==0 ) return WRC_Continue; in convertCompoundSelectToSubquery()
4050 for(pX=p; pX && (pX->op==TK_ALL || pX->op==TK_SELECT); pX=pX->pPrior){} in convertCompoundSelectToSubquery()
4075 p->pPrior = 0; in convertCompoundSelectToSubquery()
4081 assert( pNew->pPrior!=0 ); in convertCompoundSelectToSubquery()
4082 pNew->pPrior->pNext = pNew; in convertCompoundSelectToSubquery()
4243 Select *pPrior = pSel->pPrior; in withExpand() local
4244 assert( pPrior->pWith==0 ); in withExpand()
4245 pPrior->pWith = pSel->pWith; in withExpand()
4246 sqlite3WalkSelect(pWalker, pPrior); in withExpand()
4247 pPrior->pWith = 0; in withExpand()
4253 for(pLeft=pSel; pLeft->pPrior; pLeft=pLeft->pPrior); in withExpand()
4294 if( pParse->pWith && p->pPrior==0 ){ in selectPopWith()
4382 while( pSel->pPrior ){ pSel = pSel->pPrior; } in selectExpander()
4693 while( pSel->pPrior ) pSel = pSel->pPrior; in selectAddSubqueryTypeInfo()
5037 Select *pSub, *pPrior; in countOfViewOptimization() local
5050 if( pSub->pPrior==0 ) return 0; /* Must be a compound subquery */ in countOfViewOptimization()
5052 if( pSub->op!=TK_ALL && pSub->pPrior ) return 0; /* Must be UNION ALL */ in countOfViewOptimization()
5055 pSub = pSub->pPrior; /* Repeat over compound terms */ in countOfViewOptimization()
5069 pPrior = pSub->pPrior; in countOfViewOptimization()
5070 pSub->pPrior = 0; in countOfViewOptimization()
5076 pTerm = pPrior ? sqlite3ExprDup(db, pCount, 0) : pCount; in countOfViewOptimization()
5085 pSub = pPrior; in countOfViewOptimization()
5195 for(i=0; !p->pPrior && i<pTabList->nSrc; i++){ in sqlite3Select()
5231 if( p->pPrior ){ in sqlite3Select()
5362 struct SrcList_item *pPrior; in sqlite3Select() local
5377 pPrior = isSelfJoinView(pTabList, pItem); in sqlite3Select()
5378 if( pPrior ){ in sqlite3Select()
5379 sqlite3VdbeAddOp2(v, OP_OpenDup, pItem->iCursor, pPrior->iCursor); in sqlite3Select()
5380 explainSetInteger(pItem->iSelectId, pPrior->iSelectId); in sqlite3Select()
5381 assert( pPrior->pSelect!=0 ); in sqlite3Select()
5382 pSub->nSelectRow = pPrior->pSelect->nSelectRow; in sqlite3Select()