Lines Matching refs:pWhere
19966 Expr *pWhere; /* The WHERE clause */ member
20542 Expr *pWhere; /* The WHERE clause for DELETE or UPDATE steps */ member
33448 if( p->pWhere ) n++; in sqlite3TreeViewSelect()
33479 if( p->pWhere ){ in sqlite3TreeViewSelect()
33481 sqlite3TreeViewExpr(pView, p->pWhere, 0); in sqlite3TreeViewSelect()
34187 const Expr *pWhere, in sqlite3TreeViewDelete() argument
34198 if( pWhere ) n++; in sqlite3TreeViewDelete()
34213 if( pWhere ){ in sqlite3TreeViewDelete()
34216 sqlite3TreeViewExpr(pView, pWhere, 0); in sqlite3TreeViewDelete()
34314 const Expr *pWhere, in sqlite3TreeViewUpdate() argument
34336 if( pWhere ) n++; in sqlite3TreeViewUpdate()
34355 if( pWhere ){ in sqlite3TreeViewUpdate()
34358 sqlite3TreeViewExpr(pView, pWhere, 0); in sqlite3TreeViewUpdate()
107905 if( sqlite3WalkExpr(pWalker, p->pWhere) ) return WRC_Abort;
110018 if( sqlite3ResolveExprNames(&sNC, p->pWhere) ) return WRC_Abort;
111176 heightOfExpr(p->pWhere, pnHeight);
112303 pNew->pWhere = sqlite3ExprDup(db, p->pWhere, flags);
113344 if( p->pWhere ) return 0; /* Has no WHERE clause */
119161 if( rc==SQLITE_OK && pStep->pWhere ){
119162 rc = sqlite3ResolveExprNames(&sNC, pStep->pWhere);
119167 assert( !pStep->pUpsert || (!pStep->pWhere && !pStep->pExprList) );
119209 sqlite3WalkExpr(pWalker, pStep->pWhere);
122712 || sqlite3WalkExpr(&pFix->w, pStep->pWhere)
129491 Expr *pWhere, /* Optional WHERE clause to be added */
129501 pWhere = sqlite3ExprDup(db, pWhere, 0);
129511 pSel = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, pOrderBy,
129531 Expr *pWhere, /* The WHERE clause. May be null */
129548 sqlite3ExprDelete(pParse->db, pWhere);
129557 return pWhere;
129615 pSelect = sqlite3SelectNew(pParse, pEList, pSelectSrc, pWhere, 0 ,0,
129637 Expr *pWhere, /* The WHERE clause. May be null */
129713 sqlite3TreeViewDelete(pParse->pWith, pTabList, pWhere,
129720 pWhere = sqlite3LimitWhere(
129721 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE"
129776 pWhere, pOrderBy, pLimit, iTabCur
129789 if( sqlite3ResolveExprNames(&sNC, pWhere) ){
129818 && pWhere==0
129872 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, 0, 0,0,wcf,iTabCur+1);
130032 sqlite3ExprDelete(db, pWhere);
133886 Expr *pWhere = 0; /* WHERE clause to scan with */
133924 pWhere = sqlite3ExprAnd(pParse, pWhere, pEq);
133962 pWhere = sqlite3ExprAnd(pParse, pWhere, pNe);
133969 sqlite3ResolveExprNames(&sNameContext, pWhere);
133975 pWInfo = sqlite3WhereBegin(pParse, pSrc, pWhere, 0, 0, 0, 0, 0);
133983 sqlite3ExprDelete(db, pWhere);
134018 sqlite3ExprDelete(dbMem, pStep->pWhere);
134566 Expr *pWhere = 0; /* WHERE clause of trigger step */
134601 pWhere = sqlite3ExprAnd(pParse, pWhere, pEq);
134673 pWhere,
134676 pWhere = 0;
134692 pStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
134704 sqlite3ExprDelete(db, pWhere);
137869 if( pSelect->pWhere ){
144927 sqlite3ExprDelete(db, p->pWhere);
144969 Expr *pWhere, /* the WHERE clause */
144998 pNew->pWhere = pWhere;
145490 p->pWhere = sqlite3ExprAnd(pParse, p->pWhere, pEq);
145499 p->pWhere = sqlite3ExprAnd(pParse, p->pWhere, pRight->u3.pOn);
148859 p->pWhere = substExpr(pSubst, p->pWhere);
149235 Expr *pWhere; /* The WHERE clause */
149279 if( pSub->pLimit && p->pWhere ) return 0; /* Restriction (19) */
149593 pWhere = pSub->pWhere;
149594 pSub->pWhere = 0;
149597 sqlite3SetJoinExpr(pWhere, iNewParent, EP_OuterON);
149599 if( pWhere ){
149600 if( pParent->pWhere ){
149601 pParent->pWhere = sqlite3PExpr(pParse, TK_AND, pWhere, pParent->pWhere);
149603 pParent->pWhere = pWhere;
149912 findConstInWhere(&x, p->pWhere);
149921 sqlite3WalkExpr(&w, p->pWhere);
150070 Expr *pWhere, /* The WHERE clause of the outer query */
150078 if( pWhere==0 ) return 0;
150138 while( pWhere->op==TK_AND ){
150139 nChng += pushDownWhereTerms(pParse, pSubq, pWhere->pRight, pSrcList, iSrc);
150140 pWhere = pWhere->pLeft;
150144 if( ExprHasProperty(pWhere, EP_OuterON|EP_InnerON) /* (9a) */
150149 if( pWhere->w.iJoin==pSrcList->a[jj].iCursor ){
150162 && (ExprHasProperty(pWhere,EP_OuterON)==0
150163 || pWhere->w.iJoin!=iCursor)
150167 if( ExprHasProperty(pWhere,EP_OuterON)
150168 && pWhere->w.iJoin!=iCursor
150175 if( ViewCanHaveRowid && (pWhere->op==TK_ISNULL || pWhere->op==TK_NOTNULL) ){
150176 Expr *pLeft = pWhere->pLeft;
150186 if( sqlite3ExprIsSingleTableConstraint(pWhere, pSrcList, iSrc, 1) ){
150191 pNew = sqlite3ExprDup(pParse->db, pWhere, 0);
150211 pSubq->pWhere = sqlite3ExprAnd(pParse, pSubq->pWhere, pNew);
150369 if( p->pWhere
150489 p->pWhere = 0;
151941 Expr *pWhere = pS->pWhere;
151943 pNew = sqlite3ExprAnd(pWalker->pParse, pWhere, pNew);
151944 pS->pWhere = pNew;
152066 if( p->pWhere ) return 0;
152085 if( pSub->pWhere ) return 0; /* No WHERE clause */
152279 Expr *pWhere; /* The WHERE clause. May be NULL */
152423 && sqlite3ExprImpliesNonNullRow(p->pWhere, pItem->iCursor,
152436 unsetJoinExpr(p->pWhere, pItem->iCursor, 0);
152451 unsetJoinExpr(p->pWhere, pI2->iCursor, 1);
152594 if( p->pWhere!=0
152595 && p->pWhere->op==TK_AND
152692 && pushDownWhereTerms(pParse, pSub, p->pWhere, pTabList, i)
152824 pWhere = p->pWhere;
152964 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
153119 assert( pWhere==p->pWhere );
153123 pWhere = p->pWhere;
153214 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, pDistinct,
153567 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pMinMaxOrderBy,
153887 sqlite3ExprDelete(db, pTmp->pWhere);
154407 Expr *pWhere, /* The WHERE clause */
154419 pTriggerStep->pWhere = pWhere;
154422 pWhere = 0;
154426 pTriggerStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
154432 sqlite3ExprDelete(db, pWhere);
154445 Expr *pWhere, /* The WHERE clause */
154455 pTriggerStep->pWhere = pWhere;
154456 pWhere = 0;
154458 pTriggerStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
154462 sqlite3ExprDelete(db, pWhere);
155024 sqlite3ExprDup(db, pStep->pWhere, 0),
155044 sqlite3ExprDup(db, pStep->pWhere, 0), 0, 0
155461 Expr *pWhere, /* WHERE clause of the UPDATE statement */
155628 Expr *pWhere, /* WHERE clause for query */
155658 pWhere2 = sqlite3ExprDup(db, pWhere, 0);
155724 Expr *pWhere, /* The WHERE clause. May be null */
155821 sqlite3TreeViewUpdate(pParse->pWith, pTabList, pChanges, pWhere,
155835 pWhere = sqlite3LimitWhere(
155836 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE"
156067 pWhere, pOrderBy, pLimit, iDataCur
156077 if( nChangeFrom==0 && sqlite3ResolveExprNames(&sNC, pWhere) ){
156085 pWhere, onError);
156130 pParse, iEph, pPk, pChanges, pTabList, pWhere, pOrderBy, pLimit
156153 sqlite3ExprIfFalse(pParse, pWhere, labelBreak, SQLITE_JUMPIFNULL);
156173 && (pWhere==0 || !ExprHasProperty(pWhere, EP_Subquery))
156177 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere,0,0,0,flags,iIdxCur);
156592 sqlite3ExprDelete(db, pWhere);
156638 Expr *pWhere, /* WHERE clause of the UPDATE statement */
156700 updateFromSelect(pParse, ephemTab, pPk, pList, pSrc, pWhere, 0, 0);
156709 pParse, pSrc, pWhere, 0, 0, 0, WHERE_ONEPASS_DESIRED, 0
156860 Expr *pWhere, /* WHERE clause for the ON CONFLICT UPDATE */
156869 sqlite3ExprDelete(db, pWhere);
156876 pNew->pUpsertWhere = pWhere;
159429 Expr *pWhere; /* The complete WHERE clause */
161109 sqlite3TreeViewExpr(0, pWInfo->pWhere, 0);
163527 mask |= sqlite3WhereExprUsage(pMaskSet, pS->pWhere);
168069 Expr *pWhere /* The WHERE clause from the partial index */
168077 while( pWhere->op==TK_AND ){
168078 if( !whereUsablePartialIndex(iTab,jointype,pWC,pWhere->pLeft) ) return 0;
168079 pWhere = pWhere->pRight;
168086 && sqlite3ExprImpliesExpr(pParse, pExpr, pWhere, iTab)
168087 && !sqlite3ExprImpliesExpr(pParse, pExpr, pWhere, -1)
171133 Expr *pWhere, /* The WHERE clause */
171210 pWInfo->pWhere = pWhere;
171242 sqlite3WhereSplit(&pWInfo->sWC, pWhere, TK_AND);
171369 sSelect.pWhere = pWhere;
173123 Expr *pWhere = p->pWhere;
173149 p->pWhere = 0;
173225 pParse, pSublist, pSrc, pWhere, pGroupBy, pHaving, pSort, 0, 0