contrib/sqlite3/sqlite3.c

107963   TriggerStep *pStep;
107985   for(pStep=pNew->step_list; rc==SQLITE_OK && pStep; pStep=pStep->pNext){
107986     if( pStep->pSelect ){
107987       sqlite3SelectPrep(pParse, pStep->pSelect, &sNC);
107990     if( rc==SQLITE_OK && pStep->zTarget ){
107991       SrcList *pSrc = sqlite3TriggerStepSrc(pParse, pStep);
108001             assert( pStep->pFrom->a[i-1].pSelect );
108002             sqlite3SelectPrep(pParse, pStep->pFrom->a[i-1].pSelect, 0);
108014         if( rc==SQLITE_OK && pStep->pWhere ){
108015           rc = sqlite3ResolveExprNames(&sNC, pStep->pWhere);
108018           rc = sqlite3ResolveExprListNames(&sNC, pStep->pExprList);
108020         assert( !pStep->pUpsert || (!pStep->pWhere && !pStep->pExprList) );
108021         if( pStep->pUpsert && rc==SQLITE_OK ){
108022           Upsert *pUpsert = pStep->pUpsert;
108054   TriggerStep *pStep;
108060   for(pStep=pTrigger->step_list; pStep; pStep=pStep->pNext){
108061     sqlite3WalkSelect(pWalker, pStep->pSelect);
108062     sqlite3WalkExpr(pWalker, pStep->pWhere);
108063     sqlite3WalkExprList(pWalker, pStep->pExprList);
108064     if( pStep->pUpsert ){
108065       Upsert *pUpsert = pStep->pUpsert;
108071     if( pStep->pFrom ){
108073       for(i=0; i<pStep->pFrom->nSrc; i++){
108074         sqlite3WalkSelect(pWalker, pStep->pFrom->a[i].pSelect);
108234     TriggerStep *pStep;
108238     for(pStep=sParse.pNewTrigger->step_list; pStep; pStep=pStep->pNext){
108239       if( pStep->zTarget ){
108240         Table *pTarget = sqlite3LocateTable(&sParse, 0, pStep->zTarget, zDb);
108242           if( pStep->pUpsert ){
108243             ExprList *pUpsertSet = pStep->pUpsert->pUpsertSet;
108246           renameColumnIdlistNames(&sParse, &sCtx, pStep->pIdList, zOld);
108247           renameColumnElistNames(&sParse, &sCtx, pStep->pExprList, zOld);
108430         TriggerStep *pStep;
108441             for(pStep=pTrigger->step_list; pStep; pStep=pStep->pNext){
108442               if( pStep->zTarget && 0==sqlite3_stricmp(pStep->zTarget, zOld) ){
108443                 renameTokenFind(&sParse, &sCtx, pStep->zTarget);
111278   TriggerStep *pStep /* The trigger step be fixed to one database */
111280   while( pStep ){
111281     if( sqlite3WalkSelect(&pFix->w, pStep->pSelect)
111282      || sqlite3WalkExpr(&pFix->w, pStep->pWhere)
111283      || sqlite3WalkExprList(&pFix->w, pStep->pExprList)
111284      || sqlite3FixSrcList(pFix, pStep->pFrom)
111289     if( pStep->pUpsert ){
111290       Upsert *pUp = pStep->pUpsert;
111300     pStep = pStep->pNext;
121406     TriggerStep *pStep = p->step_list;
121407     sqlite3ExprDelete(dbMem, pStep->pWhere);
121408     sqlite3ExprListDelete(dbMem, pStep->pExprList);
121409     sqlite3SelectDelete(dbMem, pStep->pSelect);
121926     TriggerStep *pStep = 0;        /* First (only) step of trigger program */
122039         nFrom + 1                 /* Space for pStep->zTarget */
122042       pStep = pTrigger->step_list = (TriggerStep *)&pTrigger[1];
122043       pStep->zTarget = (char *)&pStep[1];
122044       memcpy((char *)pStep->zTarget, zFrom, nFrom);
122046       pStep->pWhere = sqlite3ExprDup(db, pWhere, EXPRDUP_REDUCE);
122047       pStep->pExprList = sqlite3ExprListDup(db, pList, EXPRDUP_REDUCE);
122048       pStep->pSelect = sqlite3SelectDup(db, pSelect, EXPRDUP_REDUCE);
122066     assert( pStep!=0 );
122071         pStep->op = TK_SELECT;
122075           pStep->op = TK_DELETE;
122080         pStep->op = TK_UPDATE;
122082     pStep->pTrig = pTrigger;
139313 ** Convert the pStep->zTarget string into a SrcList and return a pointer
139324   TriggerStep *pStep   /* The trigger containing the target token */
139328   char *zName = sqlite3DbStrDup(db, pStep->zTarget);
139333     Schema *pSchema = pStep->pTrig->pSchema;
139338     if( pStep->pFrom ){
139339       SrcList *pDup = sqlite3SrcListDup(db, pStep->pFrom, 0);
139482   TriggerStep *pStep;
139489   for(pStep=pStepList; pStep; pStep=pStep->pNext){
139503     pParse->eOrconf = (orconf==OE_Default)?pStep->orconf:(u8)orconf;
139507     if( pStep->zSpan ){
139509                         sqlite3MPrintf(db, "-- %s", pStep->zSpan),
139514     switch( pStep->op ){
139517           sqlite3TriggerStepSrc(pParse, pStep),
139518           sqlite3ExprListDup(db, pStep->pExprList, 0),
139519           sqlite3ExprDup(db, pStep->pWhere, 0),
139527           sqlite3TriggerStepSrc(pParse, pStep),
139528           sqlite3SelectDup(db, pStep->pSelect, 0),
139529           sqlite3IdListDup(db, pStep->pIdList),
139531           sqlite3UpsertDup(db, pStep->pUpsert)
139538           sqlite3TriggerStepSrc(pParse, pStep),
139539           sqlite3ExprDup(db, pStep->pWhere, 0), 0, 0
139544       default: assert( pStep->op==TK_SELECT ); {
139546         Select *pSelect = sqlite3SelectDup(db, pStep->pSelect, 0);