Lines Matching defs:pWhere
19509 Expr *pWhere; /* The WHERE clause */
20048 ** pWhere -> The WHERE clause of the DELETE statement if one is specified.
20053 ** pWhere -> The WHERE clause of the UPDATE statement if one is specified.
20074 Expr *pWhere; /* The WHERE clause for DELETE or UPDATE steps */
32874 if( p->pWhere ) n++;
32905 if( p->pWhere ){
32907 sqlite3TreeViewExpr(pView, p->pWhere, 0);
33620 const Expr *pWhere,
33631 if( pWhere ) n++;
33646 if( pWhere ){
33649 sqlite3TreeViewExpr(pView, pWhere, 0);
33747 const Expr *pWhere,
33769 if( pWhere ) n++;
33788 if( pWhere ){
33791 sqlite3TreeViewExpr(pView, pWhere, 0);
106597 if( sqlite3WalkExpr(pWalker, p->pWhere) ) return WRC_Abort;
108689 if( sqlite3ResolveExprNames(&sNC, p->pWhere) ) return WRC_Abort;
109836 heightOfExpr(p->pWhere, pnHeight);
110955 pNew->pWhere = sqlite3ExprDup(db, p->pWhere, flags);
111980 if( p->pWhere ) return 0; /* Has no WHERE clause */
117521 if( rc==SQLITE_OK && pStep->pWhere ){
117522 rc = sqlite3ResolveExprNames(&sNC, pStep->pWhere);
117527 assert( !pStep->pUpsert || (!pStep->pWhere && !pStep->pExprList) );
117569 sqlite3WalkExpr(pWalker, pStep->pWhere);
121068 || sqlite3WalkExpr(&pFix->w, pStep->pWhere)
127755 ** pWhere argument is an optional WHERE clause that restricts the
127761 Expr *pWhere, /* Optional WHERE clause to be added */
127771 pWhere = sqlite3ExprDup(db, pWhere, 0);
127780 pSel = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, pOrderBy,
127800 Expr *pWhere, /* The WHERE clause. May be null */
127817 sqlite3ExprDelete(pParse->db, pWhere);
127826 return pWhere;
127884 pSelect = sqlite3SelectNew(pParse, pEList, pSelectSrc, pWhere, 0 ,0,
127901 ** pTabList pWhere
127906 Expr *pWhere, /* The WHERE clause. May be null */
127982 sqlite3TreeViewDelete(pParse->pWith, pTabList, pWhere,
127989 pWhere = sqlite3LimitWhere(
127990 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE"
128045 pWhere, pOrderBy, pLimit, iTabCur
128058 if( sqlite3ResolveExprNames(&sNC, pWhere) ){
128087 && pWhere==0
128141 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, 0, 0,0,wcf,iTabCur+1);
128301 sqlite3ExprDelete(db, pWhere);
131967 Expr *pWhere = 0; /* WHERE clause to scan with */
132005 pWhere = sqlite3ExprAnd(pParse, pWhere, pEq);
132043 pWhere = sqlite3ExprAnd(pParse, pWhere, pNe);
132050 sqlite3ResolveExprNames(&sNameContext, pWhere);
132056 pWInfo = sqlite3WhereBegin(pParse, pSrc, pWhere, 0, 0, 0, 0, 0);
132064 sqlite3ExprDelete(db, pWhere);
132099 sqlite3ExprDelete(dbMem, pStep->pWhere);
132647 Expr *pWhere = 0; /* WHERE clause of trigger step */
132682 pWhere = sqlite3ExprAnd(pParse, pWhere, pEq);
132752 pWhere,
132755 pWhere = 0;
132771 pStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
132783 sqlite3ExprDelete(db, pWhere);
135931 if( pSelect->pWhere ){
142979 sqlite3ExprDelete(db, p->pWhere);
143021 Expr *pWhere, /* the WHERE clause */
143050 pNew->pWhere = pWhere;
143509 p->pWhere = sqlite3ExprAnd(pParse, p->pWhere, pEq);
143518 p->pWhere = sqlite3ExprAnd(pParse, p->pWhere, pRight->u3.pOn);
146862 p->pWhere = substExpr(pSubst, p->pWhere);
147234 Expr *pWhere; /* The WHERE clause */
147277 if( pSub->pLimit && p->pWhere ) return 0; /* Restriction (19) */
147581 pWhere = pSub->pWhere;
147582 pSub->pWhere = 0;
147584 sqlite3SetJoinExpr(pWhere, iNewParent, EP_OuterON);
147586 if( pWhere ){
147587 if( pParent->pWhere ){
147588 pParent->pWhere = sqlite3PExpr(pParse, TK_AND, pWhere, pParent->pWhere);
147590 pParent->pWhere = pWhere;
147897 findConstInWhere(&x, p->pWhere);
147906 sqlite3WalkExpr(&w, p->pWhere);
148054 Expr *pWhere, /* The WHERE clause of the outer query */
148062 if( pWhere==0 ) return 0;
148122 while( pWhere->op==TK_AND ){
148123 nChng += pushDownWhereTerms(pParse, pSubq, pWhere->pRight, pSrcList, iSrc);
148124 pWhere = pWhere->pLeft;
148128 if( ExprHasProperty(pWhere, EP_OuterON|EP_InnerON) /* (9a) */
148133 if( pWhere->w.iJoin==pSrcList->a[jj].iCursor ){
148146 && (ExprHasProperty(pWhere,EP_OuterON)==0
148147 || pWhere->w.iJoin!=iCursor)
148151 if( ExprHasProperty(pWhere,EP_OuterON)
148152 && pWhere->w.iJoin!=iCursor
148159 if( ViewCanHaveRowid && (pWhere->op==TK_ISNULL || pWhere->op==TK_NOTNULL) ){
148160 Expr *pLeft = pWhere->pLeft;
148170 if( sqlite3ExprIsSingleTableConstraint(pWhere, pSrcList, iSrc, 1) ){
148175 pNew = sqlite3ExprDup(pParse->db, pWhere, 0);
148195 pSubq->pWhere = sqlite3ExprAnd(pParse, pSubq->pWhere, pNew);
148353 if( p->pWhere
148469 p->pWhere = 0;
149906 Expr *pWhere = pS->pWhere;
149908 pNew = sqlite3ExprAnd(pWalker->pParse, pWhere, pNew);
149909 pS->pWhere = pNew;
150026 if( p->pWhere ) return 0;
150044 if( pSub->pWhere ) return 0; /* No WHERE clause */
150201 Expr *pWhere; /* The WHERE clause. May be NULL */
150342 && sqlite3ExprImpliesNonNullRow(p->pWhere, pItem->iCursor,
150355 unsetJoinExpr(p->pWhere, pItem->iCursor, 0);
150370 unsetJoinExpr(p->pWhere, pI2->iCursor, 1);
150508 if( p->pWhere!=0
150509 && p->pWhere->op==TK_AND
150587 && pushDownWhereTerms(pParse, pSub, p->pWhere, pTabList, i)
150712 pWhere = p->pWhere;
150843 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
150992 assert( pWhere==p->pWhere );
150996 pWhere = p->pWhere;
151086 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, pDistinct,
151417 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pMinMaxOrderBy,
151736 sqlite3ExprDelete(db, pTmp->pWhere);
152253 Expr *pWhere, /* The WHERE clause */
152265 pTriggerStep->pWhere = pWhere;
152268 pWhere = 0;
152272 pTriggerStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
152278 sqlite3ExprDelete(db, pWhere);
152291 Expr *pWhere, /* The WHERE clause */
152301 pTriggerStep->pWhere = pWhere;
152302 pWhere = 0;
152304 pTriggerStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
152308 sqlite3ExprDelete(db, pWhere);
152864 sqlite3ExprDup(db, pStep->pWhere, 0),
152884 sqlite3ExprDup(db, pStep->pWhere, 0), 0, 0
153299 Expr *pWhere, /* WHERE clause of the UPDATE statement */
153426 ** SELECT <other-columns>, pChanges FROM pTabList WHERE pWhere
153429 ** iEph. None of pChanges, pTabList or pWhere are modified or consumed by
153435 ** WHERE pWhere
153466 Expr *pWhere, /* WHERE clause for query */
153496 pWhere2 = sqlite3ExprDup(db, pWhere, 0);
153554 ** onError | pChanges | pWhere
153562 Expr *pWhere, /* The WHERE clause. May be null */
153659 sqlite3TreeViewUpdate(pParse->pWith, pTabList, pChanges, pWhere,
153673 pWhere = sqlite3LimitWhere(
153674 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE"
153911 pWhere, pOrderBy, pLimit, iDataCur
153921 if( nChangeFrom==0 && sqlite3ResolveExprNames(&sNC, pWhere) ){
153929 pWhere, onError);
153974 pParse, iEph, pPk, pChanges, pTabList, pWhere, pOrderBy, pLimit
153997 sqlite3ExprIfFalse(pParse, pWhere, labelBreak, SQLITE_JUMPIFNULL);
154017 && (pWhere==0 || !ExprHasProperty(pWhere, EP_Subquery))
154021 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere,0,0,0,flags,iIdxCur);
154436 sqlite3ExprDelete(db, pWhere);
154459 ** implementation indicates that pWhere may match at most one row.
154482 Expr *pWhere, /* WHERE clause of the UPDATE statement */
154544 updateFromSelect(pParse, ephemTab, pPk, pList, pSrc, pWhere, 0, 0);
154553 pParse, pSrc, pWhere, 0, 0, 0, WHERE_ONEPASS_DESIRED, 0
154704 Expr *pWhere, /* WHERE clause for the ON CONFLICT UPDATE */
154713 sqlite3ExprDelete(db, pWhere);
154720 pNew->pUpsertWhere = pWhere;
157258 Expr *pWhere; /* The complete WHERE clause */
158820 sqlite3TreeViewExpr(0, pWInfo->pWhere, 0);
161184 mask |= sqlite3WhereExprUsage(pMaskSet, pS->pWhere);
165573 Expr *pWhere /* The WHERE clause from the partial index */
165581 while( pWhere->op==TK_AND ){
165582 if( !whereUsablePartialIndex(iTab,jointype,pWC,pWhere->pLeft) ) return 0;
165583 pWhere = pWhere->pRight;
165591 && sqlite3ExprImpliesExpr(pParse, pExpr, pWhere, iTab)
168347 Expr *pWhere, /* The WHERE clause */
168427 pWInfo->pWhere = pWhere;
168459 sqlite3WhereSplit(&pWInfo->sWC, pWhere, TK_AND);
168586 sSelect.pWhere = pWhere;
170316 Expr *pWhere = p->pWhere;
170342 p->pWhere = 0;
170418 pParse, pSublist, pSrc, pWhere, pGroupBy, pHaving, pSort, 0, 0