Lines Matching refs:pSub
68098 Mem *pSub = 0; /* Memory cell hold array of subprogs */
68136 pSub = &p->aMem[9];
68137 if( pSub->flags&MEM_Blob ){
68140 nSub = pSub->n/sizeof(Vdbe*);
68141 apSub = (SubProgram **)pSub->z;
68198 if( j==nSub && SQLITE_OK==sqlite3VdbeMemGrow(pSub, nByte, nSub!=0) ){
68199 apSub = (SubProgram **)pSub->z;
68201 pSub->flags |= MEM_Blob;
68202 pSub->n = nSub*sizeof(SubProgram*);
69477 SubProgram *pSub, *pNext;
69482 for(pSub=p->pProgram; pSub; pSub=pNext){
69483 pNext = pSub->pNext;
69484 vdbeFreeOpArray(db, pSub->aOp, pSub->nOp);
69485 sqlite3DbFree(db, pSub);
84671 Select *pSub = p->pSrc->a[0].pSelect;
84673 assert( pSub->pPrior && pSub->pOrderBy==0 );
84674 pSub->pOrderBy = p->pOrderBy;
84768 Select *pSub = p->pSrc->a[0].pSelect;
84769 p->pOrderBy = pSub->pOrderBy;
84770 pSub->pOrderBy = 0;
111974 Select *pSub; /* The inner query or "subquery" */
111994 pSub = pSubitem->pSelect;
111995 assert( pSub!=0 );
112007 pSubSrc = pSub->pSrc;
112014 if( pSub->pLimit && p->pLimit ) return 0; /* Restriction (13) */
112015 if( pSub->pOffset ) return 0; /* Restriction (14) */
112016 if( (p->selFlags & SF_Compound)!=0 && pSub->pLimit ){
112020 if( pSub->selFlags & SF_Distinct ) return 0; /* Restriction (5) */
112021 if( pSub->pLimit && (pSrc->nSrc>1 || isAgg) ){
112027 if( p->pOrderBy && pSub->pOrderBy ){
112030 if( isAgg && pSub->pOrderBy ) return 0; /* Restriction (16) */
112031 if( pSub->pLimit && p->pWhere ) return 0; /* Restriction (19) */
112032 if( pSub->pLimit && (p->selFlags & SF_Distinct)!=0 ){
112035 testcase( pSub->selFlags & SF_Recursive );
112036 testcase( pSub->selFlags & SF_MinMaxAgg );
112037 if( pSub->selFlags & (SF_Recursive|SF_MinMaxAgg) ){
112040 if( (p->selFlags & SF_Recursive) && pSub->pPrior ){
112085 if( pSub->pPrior ){
112086 if( pSub->pOrderBy ){
112092 for(pSub1=pSub; pSub1; pSub1=pSub1->pPrior){
112095 assert( pSub->pSrc!=0 );
112096 assert( pSub->pEList->nExpr==pSub1->pEList->nExpr );
112117 pSub->zSelName, pSub, iFrom));
112158 for(pSub=pSub->pPrior; pSub; pSub=pSub->pPrior){
112170 sqlite3SelectSetName(pNew, pSub->zSelName);
112193 pSub = pSub1 = pSubitem->pSelect;
112238 for(pParent=p; pParent; pParent=pParent->pPrior, pSub=pSub->pPrior){
112241 pSubSrc = pSub->pSrc; /* FROM clause of subquery */
112309 if( pSub->pOrderBy ){
112320 ExprList *pOrderBy = pSub->pOrderBy;
112325 assert( pSub->pPrior==0 );
112327 pSub->pOrderBy = 0;
112329 pWhere = sqlite3ExprDup(db, pSub->pWhere, 0);
112335 sqlite3ExprDup(db, pSub->pHaving, 0));
112337 pParent->pGroupBy = sqlite3ExprListDup(db, pSub->pGroupBy, 0);
112341 substSelect(db, pParent, iParent, pSub->pEList, 0);
112346 pParent->selFlags |= pSub->selFlags & SF_Distinct;
112354 if( pSub->pLimit ){
112355 pParent->pLimit = pSub->pLimit;
112356 pSub->pLimit = 0;
112991 Select *pSub = pFrom->pSelect;
112999 if( pSub==0 || (pSub->selFlags & SF_NestedFrom)==0 ){
113000 pSub = 0;
113014 if( zTName && pSub
113015 && sqlite3MatchSpanName(pSub->pEList->a[j].zSpan, 0, zTName, 0)==0
113068 if( pSub ){
113069 pX->zSpan = sqlite3DbStrDup(db, pSub->pEList->a[j].zSpan);
113502 Select *pSub = pItem->pSelect;
113505 if( pSub==0 ) continue;
113509 if( pTab->nCol!=pSub->pEList->nExpr ){
113511 pTab->nCol, pTab->zName, pSub->pEList->nExpr);
113515 isAggSub = (pSub->selFlags & SF_Aggregate)!=0;
113558 Select *pSub = pItem->pSelect;
113559 if( pSub==0 ) continue;
113587 && pushDownWhereTerms(db, pSub, p->pWhere, pItem->iCursor)
113613 sqlite3Select(pParse, pSub, &dest);
113614 pItem->pTab->nRowLogEst = sqlite3LogEst(pSub->nSelectRow);
113644 sqlite3Select(pParse, pSub, &dest);
113645 pItem->pTab->nRowLogEst = sqlite3LogEst(pSub->nSelectRow);
171548 static void fts5ExprAddChildren(Fts5ExprNode *p, Fts5ExprNode *pSub){
171549 if( p->eType!=FTS5_NOT && pSub->eType==p->eType ){
171550 int nByte = sizeof(Fts5ExprNode*) * pSub->nChild;
171551 memcpy(&p->apChild[p->nChild], pSub->apChild, nByte);
171552 p->nChild += pSub->nChild;
171553 sqlite3_free(pSub);
171555 p->apChild[p->nChild++] = pSub;
177226 const u8 *pSub = pPos;
177227 int nSub = fts5IndexExtractCol(&pSub, nPos, pColset->aiCol[i]);
177229 fts5BufferAppendBlob(&rc, pBuf, nSub, pSub);