Lines Matching defs:pWhere
11697 Expr *pWhere; /* The WHERE clause */
12107 * pWhere -> The WHERE clause of the DELETE statement if one is specified.
12112 * pWhere -> The WHERE clause of the UPDATE statement if one is specified.
12125 Expr *pWhere; /* The WHERE clause for DELETE or UPDATE steps */
76692 if( sqlite3WalkExpr(pWalker, p->pWhere) ) return WRC_Abort;
78014 if( sqlite3ResolveExprNames(&sNC, p->pWhere) ) return WRC_Abort;
78567 heightOfExpr(p->pWhere, pnHeight);
79281 pNew->pWhere = sqlite3ExprDup(db, p->pWhere, flags);
79682 if( p->pWhere ) return 0; /* Has no WHERE clause */
85755 if( sqlite3FixExpr(pFix, pSelect->pWhere) ){
85828 if( sqlite3FixExpr(pFix, pStep->pWhere) ){
90918 ** pWhere argument is an optional WHERE clause that restricts the
90924 Expr *pWhere, /* Optional WHERE clause to be added */
90932 pWhere = sqlite3ExprDup(db, pWhere, 0);
90941 pSel = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, 0, 0, 0, 0);
90960 Expr *pWhere, /* The WHERE clause. May be null */
90986 return pWhere;
91012 pSelect = sqlite3SelectNew(pParse,pEList,pSelectSrc,pWhere,0,0,
91033 sqlite3ExprDelete(pParse->db, pWhere);
91047 ** pTabList pWhere
91052 Expr *pWhere /* The WHERE clause. May be null */
91167 sqlite3MaterializeView(pParse, pTab, pWhere, iTabCur);
91177 if( sqlite3ResolveExprNames(&sNC, pWhere) ){
91194 if( rcauth==SQLITE_OK && pWhere==0 && !pTrigger && !IsVirtual(pTab)
91232 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, 0, 0,
91385 sqlite3ExprDelete(db, pWhere);
93965 Expr *pWhere = 0; /* WHERE clause to scan with */
94003 pWhere = sqlite3ExprAnd(db, pWhere, pEq);
94038 pWhere = sqlite3ExprAnd(db, pWhere, pNe);
94045 sqlite3ResolveExprNames(&sNameContext, pWhere);
94051 pWInfo = sqlite3WhereBegin(pParse, pSrc, pWhere, 0, 0, 0, 0);
94061 sqlite3ExprDelete(db, pWhere);
94097 sqlite3ExprDelete(dbMem, pStep->pWhere);
94550 Expr *pWhere = 0; /* WHERE clause of trigger step */
94586 pWhere = sqlite3ExprAnd(db, pWhere, pEq);
94646 pWhere,
94649 pWhere = 0;
94667 pStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
94679 sqlite3ExprDelete(db, pWhere);
96593 if( pSelect->pWhere ){
101502 sqlite3ExprDelete(db, p->pWhere);
101532 Expr *pWhere, /* the WHERE clause */
101556 pNew->pWhere = pWhere;
101844 isOuter, &p->pWhere);
101862 p->pWhere = sqlite3ExprAnd(pParse->db, p->pWhere, pRight->pOn);
101891 isOuter, &p->pWhere);
104484 p->pWhere = substExpr(db, p->pWhere, iTable, pEList);
104642 Expr *pWhere; /* The WHERE clause */
104683 if( pSub->pLimit && p->pWhere ) return 0; /* Restriction (19) */
104961 if( pSub->pWhere ){
104962 pWhere = sqlite3ExprDup(db, pSub->pWhere, 0);
104964 pWhere = 0;
104968 pParent->pHaving = pParent->pWhere;
104969 pParent->pWhere = pWhere;
104976 pParent->pWhere = substExpr(db, pParent->pWhere, iParent, pSub->pEList);
104977 pParent->pWhere = sqlite3ExprAnd(db, pParent->pWhere, pWhere);
105063 if( p->pWhere || p->pEList->nExpr!=1
105160 p->pWhere = 0;
105985 Expr *pWhere; /* The WHERE clause. May be NULL */
106151 pWhere = p->pWhere;
106248 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
106405 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, 0,
106700 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pMinMax,0,flag,0);
106807 if( p->pWhere ){
106809 sqlite3ExplainExpr(pVdbe, p->pWhere);
107082 sqlite3ExprDelete(db, pTmp->pWhere);
107487 Expr *pWhere, /* The WHERE clause */
107495 pTriggerStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
107499 sqlite3ExprDelete(db, pWhere);
107511 Expr *pWhere /* The WHERE clause */
107517 pTriggerStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
107520 sqlite3ExprDelete(db, pWhere);
107795 sqlite3ExprDup(db, pStep->pWhere, 0),
107812 sqlite3ExprDup(db, pStep->pWhere, 0)
108210 Expr *pWhere, /* WHERE clause of the UPDATE statement */
108271 * onError pTabList pChanges pWhere
108277 Expr *pWhere, /* The WHERE clause. May be null */
108488 pWhere, onError);
108489 pWhere = 0;
108518 sqlite3MaterializeView(pParse, pTab, pWhere, iDataCur);
108525 if( sqlite3ResolveExprNames(&sNC, pWhere) ){
108534 pParse, pTabList, pWhere, 0, 0, WHERE_ONEPASS_DESIRED, iIdxCur
108563 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, 0, 0,
108851 sqlite3ExprDelete(db, pWhere);
108891 Expr *pWhere, /* WHERE clause of the UPDATE statement */
108923 pSelect = sqlite3SelectNew(pParse, pEList, pSrc, pWhere, 0, 0, 0, 0, 0, 0);
111234 mask |= exprTableUsage(pMaskSet, pS->pWhere);
115449 static int whereUsablePartialIndex(int iTab, WhereClause *pWC, Expr *pWhere){
115453 if( sqlite3ExprImpliesExpr(pTerm->pExpr, pWhere, iTab) ) return 1;
116855 Expr *pWhere, /* The WHERE clause */
116944 whereSplit(&pWInfo->sWC, pWhere, TK_AND);
