Lines Matching refs:pWhere

84     sqlite3ExprDelete(db, p->pWhere);  in clearSelect()
126 Expr *pWhere, /* the WHERE clause */ in sqlite3SelectNew() argument
155 pNew->pWhere = pWhere; in sqlite3SelectNew()
610 p->pWhere = sqlite3ExprAnd(pParse, p->pWhere, pEq); in sqlite3ProcessJoin()
619 p->pWhere = sqlite3ExprAnd(pParse, p->pWhere, pRight->u3.pOn); in sqlite3ProcessJoin()
3899 p->pWhere = substExpr(pSubst, p->pWhere); in substSelect()
4242 Expr *pWhere; /* The WHERE clause */ in flattenSubquery() local
4285 if( pSub->pLimit && p->pWhere ) return 0; /* Restriction (19) */ in flattenSubquery()
4603 pWhere = pSub->pWhere; in flattenSubquery()
4604 pSub->pWhere = 0; in flattenSubquery()
4606 sqlite3SetJoinExpr(pWhere, iNewParent, EP_OuterON); in flattenSubquery()
4608 if( pWhere ){ in flattenSubquery()
4609 if( pParent->pWhere ){ in flattenSubquery()
4610 pParent->pWhere = sqlite3PExpr(pParse, TK_AND, pWhere, pParent->pWhere); in flattenSubquery()
4612 pParent->pWhere = pWhere; in flattenSubquery()
4920 findConstInWhere(&x, p->pWhere); in propagateConstants()
4929 sqlite3WalkExpr(&w, p->pWhere); in propagateConstants()
5045 Expr *pWhere, /* The WHERE clause of the outer query */ in pushDownWhereTerms() argument
5050 if( pWhere==0 ) return 0; in pushDownWhereTerms()
5085 while( pWhere->op==TK_AND ){ in pushDownWhereTerms()
5086 nChng += pushDownWhereTerms(pParse, pSubq, pWhere->pRight, pSrc); in pushDownWhereTerms()
5087 pWhere = pWhere->pLeft; in pushDownWhereTerms()
5092 && (ExprHasProperty(pWhere,EP_OuterON)==0 in pushDownWhereTerms()
5093 || pWhere->w.iJoin!=iCursor) in pushDownWhereTerms()
5097 if( ExprHasProperty(pWhere,EP_OuterON) in pushDownWhereTerms()
5098 && pWhere->w.iJoin!=iCursor in pushDownWhereTerms()
5104 if( sqlite3ExprIsTableConstraint(pWhere, pSrc) ){ in pushDownWhereTerms()
5109 pNew = sqlite3ExprDup(pParse->db, pWhere, 0); in pushDownWhereTerms()
5129 pSubq->pWhere = sqlite3ExprAnd(pParse, pSubq->pWhere, pNew); in pushDownWhereTerms()
5215 if( p->pWhere in isSimpleCount()
5331 p->pWhere = 0; in convertCompoundSelectToSubquery()
6432 Expr *pWhere = pS->pWhere; in havingToWhereExprCb() local
6434 pNew = sqlite3ExprAnd(pWalker->pParse, pWhere, pNew); in havingToWhereExprCb()
6435 pS->pWhere = pNew; in havingToWhereExprCb()
6547 if( p->pWhere ) return 0; in countOfViewOptimization()
6561 if( pSub->pWhere ) return 0; /* No WHERE clause */ in countOfViewOptimization()
6656 Expr *pWhere; /* The WHERE clause. May be NULL */ in sqlite3Select() local
6790 && sqlite3ExprImpliesNonNullRow(p->pWhere, pItem->iCursor) in sqlite3Select()
6797 unsetJoinExpr(p->pWhere, pItem->iCursor, in sqlite3Select()
6919 if( p->pWhere!=0 in sqlite3Select()
6920 && p->pWhere->op==TK_AND in sqlite3Select()
7001 && pushDownWhereTerms(pParse, pSub, p->pWhere, pItem) in sqlite3Select()
7121 pWhere = p->pWhere; in sqlite3Select()
7252 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy, in sqlite3Select()
7400 assert( pWhere==p->pWhere ); in sqlite3Select()
7404 pWhere = p->pWhere; in sqlite3Select()
7522 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, pDistinct, in sqlite3Select()
7821 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pMinMaxOrderBy, in sqlite3Select()