| /sqlite-3.40.0/src/ |
| H A D | delete.c | 141 Expr *pWhere, /* Optional WHERE clause to be added */ in sqlite3MaterializeView() argument 151 pWhere = sqlite3ExprDup(db, pWhere, 0); in sqlite3MaterializeView() 197 sqlite3ExprDelete(pParse->db, pWhere); in sqlite3LimitWhere() 206 return pWhere; in sqlite3LimitWhere() 356 sqlite3TreeViewDelete(pParse->pWith, pTabList, pWhere, in sqlite3DeleteFrom() 363 pWhere = sqlite3LimitWhere( in sqlite3DeleteFrom() 364 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE" in sqlite3DeleteFrom() 419 pWhere, pOrderBy, pLimit, iTabCur in sqlite3DeleteFrom() 432 if( sqlite3ResolveExprNames(&sNC, pWhere) ){ in sqlite3DeleteFrom() 461 && pWhere==0 in sqlite3DeleteFrom() [all …]
|
| H A D | fkey.c | 559 Expr *pWhere = 0; /* WHERE clause to scan with */ in fkScanChildren() local 597 pWhere = sqlite3ExprAnd(pParse, pWhere, pEq); in fkScanChildren() 635 pWhere = sqlite3ExprAnd(pParse, pWhere, pNe); in fkScanChildren() 642 sqlite3ResolveExprNames(&sNameContext, pWhere); in fkScanChildren() 656 sqlite3ExprDelete(db, pWhere); in fkScanChildren() 691 sqlite3ExprDelete(dbMem, pStep->pWhere); in fkTriggerDelete() 1266 pWhere = sqlite3ExprAnd(pParse, pWhere, pEq); in fkActionTrigger() 1336 pWhere, in fkActionTrigger() 1339 pWhere = 0; in fkActionTrigger() 1355 pStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE); in fkActionTrigger() [all …]
|
| H A D | update.c | 26 Expr *pWhere, /* WHERE clause of the UPDATE statement */ 193 Expr *pWhere, /* WHERE clause for query */ in updateFromSelect() argument 223 pWhere2 = sqlite3ExprDup(db, pWhere, 0); in updateFromSelect() 288 Expr *pWhere, /* The WHERE clause. May be null */ in sqlite3Update() argument 399 pWhere = sqlite3LimitWhere( in sqlite3Update() 400 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE" in sqlite3Update() 637 pWhere, pOrderBy, pLimit, iDataCur in sqlite3Update() 647 if( nChangeFrom==0 && sqlite3ResolveExprNames(&sNC, pWhere) ){ in sqlite3Update() 655 pWhere, onError); in sqlite3Update() 1145 sqlite3ExprDelete(db, pWhere); in sqlite3Update() [all …]
|
| H A D | trigger.c | 24 sqlite3ExprDelete(db, pTmp->pWhere); in sqlite3DeleteTriggerStep() 536 Expr *pWhere, /* The WHERE clause */ in sqlite3TriggerUpdateStep() argument 548 pTriggerStep->pWhere = pWhere; in sqlite3TriggerUpdateStep() 551 pWhere = 0; in sqlite3TriggerUpdateStep() 555 pTriggerStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE); in sqlite3TriggerUpdateStep() 561 sqlite3ExprDelete(db, pWhere); in sqlite3TriggerUpdateStep() 574 Expr *pWhere, /* The WHERE clause */ in sqlite3TriggerDeleteStep() argument 584 pTriggerStep->pWhere = pWhere; in sqlite3TriggerDeleteStep() 585 pWhere = 0; in sqlite3TriggerDeleteStep() 587 pTriggerStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE); in sqlite3TriggerDeleteStep() [all …]
|
| H A D | select.c | 155 pNew->pWhere = pWhere; in sqlite3SelectNew() 610 p->pWhere = sqlite3ExprAnd(pParse, p->pWhere, pEq); in sqlite3ProcessJoin() 3899 p->pWhere = substExpr(pSubst, p->pWhere); in substSelect() 4603 pWhere = pSub->pWhere; in flattenSubquery() 4610 pParent->pWhere = sqlite3PExpr(pParse, TK_AND, pWhere, pParent->pWhere); in flattenSubquery() 4612 pParent->pWhere = pWhere; in flattenSubquery() 5087 pWhere = pWhere->pLeft; in pushDownWhereTerms() 6432 Expr *pWhere = pS->pWhere; in havingToWhereExprCb() local 7121 pWhere = p->pWhere; in sqlite3Select() 7400 assert( pWhere==p->pWhere ); in sqlite3Select() [all …]
|
| H A D | treeview.c | 279 if( p->pWhere ) n++; in sqlite3TreeViewSelect() 310 if( p->pWhere ){ in sqlite3TreeViewSelect() 312 sqlite3TreeViewExpr(pView, p->pWhere, 0); in sqlite3TreeViewSelect() 1010 const Expr *pWhere, in sqlite3TreeViewDelete() argument 1021 if( pWhere ) n++; in sqlite3TreeViewDelete() 1036 if( pWhere ){ in sqlite3TreeViewDelete() 1039 sqlite3TreeViewExpr(pView, pWhere, 0); in sqlite3TreeViewDelete() 1137 const Expr *pWhere, in sqlite3TreeViewUpdate() argument 1159 if( pWhere ) n++; in sqlite3TreeViewUpdate() 1178 if( pWhere ){ in sqlite3TreeViewUpdate() [all …]
|
| H A D | upsert.c | 60 Expr *pWhere, /* WHERE clause for the ON CONFLICT UPDATE */ in sqlite3UpsertNew() argument 69 sqlite3ExprDelete(db, pWhere); in sqlite3UpsertNew() 76 pNew->pUpsertWhere = pWhere; in sqlite3UpsertNew()
|
| H A D | walker.c | 133 if( sqlite3WalkExpr(pWalker, p->pWhere) ) return WRC_Abort; in sqlite3WalkSelectExpr()
|
| H A D | where.c | 3223 Expr *pWhere /* The WHERE clause from the partial index */ in whereUsablePartialIndex() argument 3231 while( pWhere->op==TK_AND ){ in whereUsablePartialIndex() 3232 if( !whereUsablePartialIndex(iTab,jointype,pWC,pWhere->pLeft) ) return 0; in whereUsablePartialIndex() 3233 pWhere = pWhere->pRight; in whereUsablePartialIndex() 3241 && sqlite3ExprImpliesExpr(pParse, pExpr, pWhere, iTab) in whereUsablePartialIndex() 5624 Expr *pWhere, /* The WHERE clause */ in sqlite3WhereBegin() argument 5697 pWInfo->pWhere = pWhere; in sqlite3WhereBegin() 5729 sqlite3WhereSplit(&pWInfo->sWC, pWhere, TK_AND); in sqlite3WhereBegin() 5829 sSelect.pWhere = pWhere; in sqlite3WhereBegin()
|
| H A D | alter.c | 1350 if( rc==SQLITE_OK && pStep->pWhere ){ in renameResolveTrigger() 1351 rc = sqlite3ResolveExprNames(&sNC, pStep->pWhere); in renameResolveTrigger() 1356 assert( !pStep->pUpsert || (!pStep->pWhere && !pStep->pExprList) ); in renameResolveTrigger() 1398 sqlite3WalkExpr(pWalker, pStep->pWhere); in renameWalkTrigger()
|
| H A D | whereInt.h | 468 Expr *pWhere; /* The complete WHERE clause */ member
|
| H A D | window.c | 968 Expr *pWhere = p->pWhere; in sqlite3WindowRewrite() local 994 p->pWhere = 0; in sqlite3WindowRewrite() 1070 pParse, pSublist, pSrc, pWhere, pGroupBy, pHaving, pSort, 0, 0 in sqlite3WindowRewrite()
|
| H A D | attach.c | 577 || sqlite3WalkExpr(&pFix->w, pStep->pWhere) in sqlite3FixTriggerStep()
|
| H A D | expr.c | 748 heightOfExpr(p->pWhere, pnHeight); in heightOfSelect() 1731 pNew->pWhere = sqlite3ExprDup(db, p->pWhere, flags); in sqlite3SelectDup() 2599 if( p->pWhere ) return 0; /* Has no WHERE clause */ in isCandidateForInOpt()
|
| H A D | sqliteInt.h | 3354 Expr *pWhere; /* The WHERE clause */ member 3907 Expr *pWhere; /* The WHERE clause for DELETE or UPDATE steps */ member
|
| H A D | whereexpr.c | 943 mask |= sqlite3WhereExprUsage(pMaskSet, pS->pWhere); in exprSelectUsage()
|
| H A D | resolve.c | 1821 if( sqlite3ResolveExprNames(&sNC, p->pWhere) ) return WRC_Abort; in resolveSelectStep()
|
| H A D | wherecode.c | 1358 sqlite3TreeViewExpr(0, pWInfo->pWhere, 0); in sqlite3WhereCodeOneLoopStart()
|
| H A D | insert.c | 2826 if( pSelect->pWhere ){ in xferOptimization()
|