Lines Matching refs:pSubq
19752 Subquery *pSubq; /* Description of a subquery */ member
20024 ((X)->u4.pSubq->pSelect->selFlags&SF_NestedFrom)!=0)
32556 Select *pSel = pItem->u4.pSubq->pSelect; in sqlite3_str_vappendf()
33405 sqlite3TreeViewSelect(pView, pItem->u4.pSubq->pSelect, 0); in sqlite3TreeViewSrcList()
107945 && sqlite3WalkSelect(pWalker, pItem->u4.pSubq->pSelect)
108395 assert( pItem->u4.pSubq!=0 );
108396 pSel = pItem->u4.pSubq->pSelect;
109931 assert( p->pSrc->a[0].u4.pSubq!=0 );
109932 pSub = p->pSrc->a[0].u4.pSubq->pSelect;
109948 && (pItem->u4.pSubq->pSelect->selFlags & SF_Resolved)==0
109954 sqlite3ResolveSelectNames(pParse, pItem->u4.pSubq->pSelect, pOuterNC);
110058 pSub = p->pSrc->a[0].u4.pSubq->pSelect;
112233 memcpy(pNewSubq, pOldItem->u4.pSubq, sizeof(*pNewSubq));
112241 pNewItem->u4.pSubq = pNewSubq;
119151 assert( p->u4.pSubq!=0 );
119152 sqlite3SelectPrep(pParse, p->u4.pSubq->pSelect, 0);
119223 assert( pFrom->a[i].u4.pSubq!=0 );
119224 sqlite3WalkSelect(pWalker, pFrom->a[i].u4.pSubq->pSelect);
127919 assert( pItem->u4.pSubq!=0 );
127920 assert( pItem->u4.pSubq->pSelect!=0 );
127921 assert( pItem->u4.pSubq->pSelect->pSrc!=0 );
127922 sqlite3SrcListAssignCursors(pParse, pItem->u4.pSubq->pSelect->pSrc);
127931 SQLITE_PRIVATE void sqlite3SubqueryDelete(sqlite3 *db, Subquery *pSubq){
127932 assert( pSubq!=0 && pSubq->pSelect!=0 );
127933 sqlite3SelectDelete(db, pSubq->pSelect);
127934 sqlite3DbFree(db, pSubq);
127945 pSel = pItem->u4.pSubq->pSelect;
127946 sqlite3DbFree(db, pItem->u4.pSubq);
127947 pItem->u4.pSubq = 0;
127966 assert( !pItem->fg.isSubquery || (pItem->u4.pSubq!=0 &&
127967 pItem->u4.pSubq->pSelect!=0) );
127972 sqlite3SubqueryDelete(db, pItem->u4.pSubq);
128023 p = pItem->u4.pSubq = sqlite3DbMallocRawNN(pParse->db, sizeof(Subquery));
135402 assert( (pItem->fg.isSubquery && pItem->u4.pSubq!=0) || pParse->nErr );
135404 sqlite3VdbeEndCoroutine(pParse->pVdbe, pItem->u4.pSubq->regReturn);
135405 sqlite3VdbeJumpHere(pParse->pVdbe, pItem->u4.pSubq->addrFillSub - 1);
135534 Subquery *pSubq;
135549 pSubq = p->u4.pSubq;
135550 pSubq->addrFillSub = sqlite3VdbeCurrentAddr(v) + 1;
135551 pSubq->regReturn = ++pParse->nMem;
135553 pSubq->regReturn, 0, pSubq->addrFillSub);
135554 sqlite3SelectDestInit(&dest, SRT_Coroutine, pSubq->regReturn);
135567 pSubq->regResult = dest.iSdst;
135579 Subquery *pSubq;
135582 pSubq = p->u4.pSubq;
135583 assert( pSubq!=0 );
135584 assert( pSubq->pSelect!=0 );
135585 assert( pSubq->pSelect->pEList!=0 );
135586 if( pSubq->pSelect->pEList->nExpr!=pRow->nExpr ){
135587 sqlite3SelectWrongNumTermsError(pParse, pSubq->pSelect);
135589 sqlite3ExprCodeExprList(pParse, pRow, pSubq->regResult, 0, 0);
135590 sqlite3VdbeAddOp1(pParse->pVdbe, OP_Yield, pSubq->regReturn);
135936 Subquery *pSubq;
135938 pSubq = pItem->u4.pSubq;
135939 dest.iSDParm = pSubq->regReturn;
135940 regFromSelect = pSubq->regResult;
135941 assert( pSubq->pSelect!=0 );
135942 assert( pSubq->pSelect->pEList!=0 );
135943 nColumn = pSubq->pSelect->pEList->nExpr;
145201 assert( pItem->u4.pSubq!=0 );
145202 assert( pItem->u4.pSubq->pSelect!=0 );
145203 pResults = pItem->u4.pSubq->pSelect->pEList;
146807 pS = pTabList->a[j].u4.pSubq->pSelect;
148864 substSelect(pSubst, pItem->u4.pSubq->pSelect, 1);
148937 for(p=pItem->u4.pSubq->pSelect; p; p=p->pPrior){
149251 pSub = pSubitem->u4.pSubq->pSelect;
149949 static int pushDownWindowCheck(Parse *pParse, Select *pSubq, Expr *pExpr){
149950 assert( pSubq->pWin->pPartition );
149951 assert( (pSubq->selFlags & SF_MultiPart)==0 );
149952 assert( pSubq->pPrior==0 );
149953 return sqlite3ExprIsConstantOrGroupBy(pParse, pExpr, pSubq->pWin->pPartition);
150069 Select *pSubq, /* The subquery whose WHERE clause is to be augmented */
150079 if( pSubq->selFlags & (SF_Recursive|SF_MultiPart) ){
150086 if( pSubq->pPrior ){
150089 for(pSel=pSubq; pSel; pSel=pSel->pPrior){
150104 for(pSel=pSubq; pSel; pSel=pSel->pPrior){
150118 if( pSubq->pWin && pSubq->pWin->pPartition==0 ) return 0;
150129 for(pX=pSubq; pX; pX=pX->pPrior){
150135 if( pSubq->pLimit!=0 ){
150139 nChng += pushDownWhereTerms(pParse, pSubq, pWhere->pRight, pSrcList, iSrc);
150188 pSubq->selFlags |= SF_PushDown;
150189 while( pSubq ){
150197 x.pEList = pSubq->pEList;
150198 x.pCList = findLeftmostExprlist(pSubq);
150201 if( pSubq->pWin && 0==pushDownWindowCheck(pParse, pSubq, pNew) ){
150208 if( pSubq->selFlags & SF_Aggregate ){
150209 pSubq->pHaving = sqlite3ExprAnd(pParse, pSubq->pHaving, pNew);
150211 pSubq->pWhere = sqlite3ExprAnd(pParse, pSubq->pWhere, pNew);
150213 pSubq = pSubq->pPrior;
150243 pSub = pItem->u4.pSubq->pSelect;
150678 assert( pFrom->fg.isSubquery && pFrom->u4.pSubq );
150679 pSel = pFrom->u4.pSubq->pSelect;
150812 assert( pFrom->u4.pSubq!=0 );
150813 pSel = pFrom->u4.pSubq->pSelect;
150941 assert( pFrom->fg.isSubquery && pFrom->u4.pSubq!=0 );
150942 pSel = pFrom->u4.pSubq->pSelect;
151000 sqlite3WalkSelect(pWalker, pFrom->u4.pSubq->pSelect);
151101 assert( pFrom->fg.isSubquery && pFrom->u4.pSubq );
151102 assert( pFrom->u4.pSubq->pSelect!=0 );
151103 pNestedFrom = pFrom->u4.pSubq->pSelect->pEList;
151346 Select *pSel = pFrom->u4.pSubq->pSelect;
151999 pSel = pThis->u4.pSubq->pSelect;
152012 pS1 = pItem->u4.pSubq->pSelect;
152080 pSub = pFrom->u4.pSubq->pSelect;
152150 && (p1->u4.pSubq->pSelect->selFlags & SF_NestedFrom)!=0
152151 && sameSrcAlias(p0, p1->u4.pSubq->pSelect->pSrc)
152402 Select *pSub = pItem->fg.isSubquery ? pItem->u4.pSubq->pSelect : 0;
152628 Subquery *pSubq;
152669 pSubq = pItem->u4.pSubq;
152670 assert( pSubq!=0 );
152671 pSub = pSubq->pSelect;
152674 if( pSubq->addrFillSub!=0 ) continue;
152701 assert( pSubq->pSelect && (pSub->selFlags & SF_PushDown)!=0 );
152734 pSubq->regReturn = ++pParse->nMem;
152735 sqlite3VdbeAddOp3(v, OP_InitCoroutine, pSubq->regReturn, 0, addrTop);
152737 pSubq->addrFillSub = addrTop;
152738 sqlite3SelectDestInit(&dest, SRT_Coroutine, pSubq->regReturn);
152743 pSubq->regResult = dest.iSdst;
152744 sqlite3VdbeEndCoroutine(v, pSubq->regReturn);
152765 pPriorSubq = pPrior->u4.pSubq;
152783 pSubq->regReturn = ++pParse->nMem;
152785 pSubq->addrFillSub = topAddr+1;
152802 sqlite3VdbeAddOp2(v, OP_Return, pSubq->regReturn, topAddr+1);
152809 pCteUse->addrM9e = pSubq->addrFillSub;
152810 pCteUse->regRtn = pSubq->regReturn;
159965 addr = pSrclist->a[pLvl->iFrom].u4.pSubq->addrFillSub;
161153 Subquery *pSubq;
161154 assert( pTabItem->fg.isSubquery && pTabItem->u4.pSubq!=0 );
161155 pSubq = pTabItem->u4.pSubq;
161156 regYield = pSubq->regReturn;
161157 sqlite3VdbeAddOp3(v, OP_InitCoroutine, regYield, 0, pSubq->addrFillSub);
162469 Subquery *pSubq;
162470 assert( pRight->fg.isSubquery && pRight->u4.pSubq!=0 );
162471 pSubq = pRight->u4.pSubq;
162472 assert( pSubq->pSelect!=0 && pSubq->pSelect->pEList!=0 );
162474 v, OP_Null, 0, pSubq->regResult,
162475 pSubq->regResult + pSubq->pSelect->pEList->nExpr-1
163533 mask |= exprSelectUsage(pMaskSet, pSrc->a[i].u4.pSubq->pSelect);
165661 Subquery *pSubq;
165663 pSubq = pSrc->u4.pSubq;
165664 assert( pSubq!=0 );
165665 regYield = pSubq->regReturn;
165667 sqlite3VdbeAddOp3(v, OP_InitCoroutine, regYield, 0, pSubq->addrFillSub);
165692 assert( pSrc->fg.isSubquery && pSrc->u4.pSubq!=0 );
165697 pSrc->u4.pSubq->regResult, pLevel->iIdxCur);
168541 pNew->u.btree.pOrderBy = pSrc->u4.pSubq->pSelect->pOrderBy;
171035 || pItem->u4.pSubq->pSelect->pOrderBy==0
171727 Subquery *pSubq;
171730 pSubq = pSrc->u4.pSubq;
171736 sqlite3VdbeAddOp2(v, OP_Gosub, pSubq->regReturn, pSubq->addrFillSub);
171953 n = pSrc->u4.pSubq->regResult;
172008 assert( pTabItem->u4.pSubq->regResult>=0 );
172010 pTabItem->u4.pSubq->regResult, 0);
173551 nEphExpr = pSelect->pSrc->a[0].u4.pSubq->pSelect->pEList->nExpr;
179433 pNew->u4.pSubq = pOld->u4.pSubq;
179434 pOld->u4.pSubq = 0;
179436 assert( pNew->u4.pSubq!=0 && pNew->u4.pSubq->pSelect!=0 );
179437 if( (pNew->u4.pSubq->pSelect->selFlags & SF_NestedFrom)!=0 ){