contrib/sqlite3/sqlite3.c

19144  *              them to. See sqlite3Update() documentation of "pChanges"
121878 ** If the current operation is an UPDATE, then the pChanges parameter is
121880 ** DELETE, pChanges is passed a NULL pointer.
121908   ExprList *pChanges              /* Change-list for UPDATE, NULL for DELETE */
121913   int iAction = (pChanges!=0);    /* 1 for UPDATE, 0 for DELETE */
121969       if( pChanges ){
121981       if( action!=OE_Restrict && (action!=OE_Cascade || pChanges) ){
122074         if( !pChanges ){
122086     pTrigger->op = (pChanges ? TK_UPDATE : TK_DELETE);
122099   ExprList *pChanges,             /* Change-list for UPDATE, NULL for DELETE */
122112         Trigger *pAct = fkActionTrigger(pParse, pTab, pFKey, pChanges);
139246 ** least one of the columns in pChanges is being modified.
139252   ExprList *pChanges,     /* Columns that change in an UPDATE statement */
139279       if( p->op==op && checkColumnOverlap(p->pColumns, pChanges) ){
139783 ** parameter pChanges is passed the list of columns being modified.
139822   ExprList *pChanges,  /* Changes list for any UPDATE OF triggers */
139833   assert( (op==TK_UPDATE)==(pChanges!=0) );
139852      && checkColumnOverlap(p->pColumns, pChanges)
139891   ExprList *pChanges,  /* Changes list for any UPDATE OF triggers */
139897   const int op = pChanges ? TK_UPDATE : TK_DELETE;
139905      && checkColumnOverlap(p->pColumns,pChanges)
139948   ExprList *pChanges,  /* The columns to change in the UPDATE statement */
139950   int *aXRef,          /* Mapping from columns of pTab to entries in pChanges */
140074 **   SELECT <other-columns>, pChanges FROM pTabList WHERE pWhere
140077 ** iEph. None of pChanges, pTabList or pWhere are modified or consumed by
140082 **   SELECT <other-columns>, pChanges FROM pTabList
140112   ExprList *pChanges,             /* List of expressions to return */
140177   if( ALWAYS(pChanges) ){
140178     for(i=0; i<pChanges->nExpr; i++){
140180           sqlite3ExprDup(db, pChanges->a[i].pExpr, 0)
140198 **           onError   |      pChanges         |                pWhere
140205   ExprList *pChanges,    /* Things to be changed */
140226   int *aXRef = 0;        /* aXRef[i] is the index in pChanges->a[] of the
140234   int iRowidExpr = -1;   /* Index of "rowid=" (or IPK) assignment in pChanges */
140258   int nChangeFrom = 0;   /* If there is a FROM, pChanges->nExpr, else 0 */
140285   pTrigger = sqlite3TriggersExist(pParse, pTab, TK_UPDATE, pChanges, &tmask);
140302   nChangeFrom = (pTabList->nSrc>1) ? pChanges->nExpr : 0;
140369   ** for each column to be updated in the pChanges array.  For each
140374   for(i=0; i<pChanges->nExpr; i++){
140377     if( nChangeFrom==0 && sqlite3ResolveExprNames(&sNC, pChanges->a[i].pExpr) ){
140381       if( sqlite3StrICmp(pTab->aCol[j].zName, pChanges->a[i].zEName)==0 ){
140384           pRowidExpr = pChanges->a[i].pExpr;
140404       if( pPk==0 && sqlite3IsRowid(pChanges->a[i].zEName) ){
140407         pRowidExpr = pChanges->a[i].pExpr;
140410         sqlite3ErrorMsg(pParse, "no such column: %s", pChanges->a[i].zEName);
140557     updateVirtualTable(pParse, pTabList, pTab, pChanges, pRowidExpr, aXRef,
140603             pParse, iEph, pPk, pChanges, pTabList, pWhere, pOrderBy, pLimit
140793         pTrigger, pChanges, 0, TRIGGER_BEFORE|TRIGGER_AFTER, pTab, onError
140827       pParse, pTrigger, pChanges, 1, TRIGGER_BEFORE, pTab, onError
140842           sqlite3ExprCode(pParse, pChanges->a[j].pExpr, k);
140872     sqlite3CodeRowTrigger(pParse, pTrigger, TK_UPDATE, pChanges,
140995       sqlite3FkActions(pParse, pTab, pChanges, regOldRowid, aXRef, chngKey);
141005   sqlite3CodeRowTrigger(pParse, pTrigger, TK_UPDATE, pChanges,
141044   sqlite3ExprListDelete(db, pChanges);
141088   ExprList *pChanges,  /* The columns to change in the UPDATE statement */
141090   int *aXRef,          /* Mapping from columns of pTab to entries in pChanges */
141134         pRow = sqlite3ExprDup(db, pChanges->a[aXRef[iPk]].pExpr, 0);
141144           sqlite3ExprDup(db, pChanges->a[aXRef[i]].pExpr, 0)
141166         sqlite3ExprCode(pParse, pChanges->a[aXRef[i]].pExpr, regArg+2+i);