Lines Matching refs:pUpsert
20500 Upsert *pUpsert; /* ON CONFLICT clause information from an upsert */ member
21166 Upsert *pUpsert; /* Upsert clauses on an INSERT */ member
34995 const Upsert *pUpsert, in sqlite3TreeViewUpsert() argument
34998 if( pUpsert==0 ) return; in sqlite3TreeViewUpsert()
35000 while( pUpsert ){ in sqlite3TreeViewUpsert()
35002 sqlite3TreeViewPush(&pView, pUpsert->pNextUpsert!=0 || moreToFollow); in sqlite3TreeViewUpsert()
35004 pUpsert->isDoUpdate ? "UPDATE" : "NOTHING"); in sqlite3TreeViewUpsert()
35005 n = (pUpsert->pUpsertSet!=0) + (pUpsert->pUpsertWhere!=0); in sqlite3TreeViewUpsert()
35006 sqlite3TreeViewExprList(pView, pUpsert->pUpsertTarget, (n--)>0, "TARGET"); in sqlite3TreeViewUpsert()
35007 sqlite3TreeViewExprList(pView, pUpsert->pUpsertSet, (n--)>0, "SET"); in sqlite3TreeViewUpsert()
35008 if( pUpsert->pUpsertWhere ){ in sqlite3TreeViewUpsert()
35010 sqlite3TreeViewExpr(pView, pUpsert->pUpsertWhere, 0); in sqlite3TreeViewUpsert()
35014 pUpsert = pUpsert->pNextUpsert; in sqlite3TreeViewUpsert()
35087 const Upsert *pUpsert, in sqlite3TreeViewInsert() argument
35107 if( pUpsert ) n++; in sqlite3TreeViewInsert()
35132 if( pUpsert ){ in sqlite3TreeViewInsert()
35135 sqlite3TreeViewUpsert(pView, pUpsert, 0); in sqlite3TreeViewInsert()
35158 const Upsert *pUpsert, in sqlite3TreeViewUpdate() argument
35179 if( pUpsert ) n++; in sqlite3TreeViewUpdate()
35210 if( pUpsert ){ in sqlite3TreeViewUpdate()
35213 sqlite3TreeViewUpsert(pView, pUpsert, 0); in sqlite3TreeViewUpdate()
110873 Upsert *pUpsert = pNC->uNC.pUpsert; local
110874 if( pUpsert && sqlite3StrICmp("excluded",zTab)==0 ){
110875 pTab = pUpsert->pUpsertSrc->a[0].pSTab;
110907 pExpr->iTable = pNC->uNC.pUpsert->regData +
121773 assert( !pStep->pUpsert || (!pStep->pWhere && !pStep->pExprList) );
121774 if( pStep->pUpsert && rc==SQLITE_OK ){
121775 Upsert *pUpsert = pStep->pUpsert; local
121776 pUpsert->pUpsertSrc = pSrc;
121777 sNC.uNC.pUpsert = pUpsert;
121779 rc = sqlite3ResolveExprListNames(&sNC, pUpsert->pUpsertTarget);
121781 ExprList *pUpsertSet = pUpsert->pUpsertSet;
121785 rc = sqlite3ResolveExprNames(&sNC, pUpsert->pUpsertWhere);
121788 rc = sqlite3ResolveExprNames(&sNC, pUpsert->pUpsertTargetWhere);
121817 if( pStep->pUpsert ){
121818 Upsert *pUpsert = pStep->pUpsert; local
121819 sqlite3WalkExprList(pWalker, pUpsert->pUpsertTarget);
121820 sqlite3WalkExprList(pWalker, pUpsert->pUpsertSet);
121821 sqlite3WalkExpr(pWalker, pUpsert->pUpsertWhere);
121822 sqlite3WalkExpr(pWalker, pUpsert->pUpsertTargetWhere);
122004 if( pStep->pUpsert ){
122005 ExprList *pUpsertSet = pStep->pUpsert->pUpsertSet;
126043 for(pUp=pStep->pUpsert; pUp; pUp=pUp->pNextUpsert){
139573 Upsert *pUpsert /* ON CONFLICT clauses for upsert, or NULL */ argument
139669 onError, pUpsert, pTrigger);
139962 if( pUpsert ){
139973 if( sqlite3HasExplicitNulls(pParse, pUpsert->pUpsertTarget) ){
139977 pNx = pUpsert;
139984 if( sqlite3UpsertAnalyzeTarget(pParse, pTabList, pNx, pUpsert) ){
140243 regIns, 0, ipkColumn>=0, onError, endOfLoop, &isReplace, 0, pUpsert
140328 sqlite3UpsertDelete(db, pUpsert);
140581 Upsert *pUpsert /* ON CONFLICT clauses, if any. NULL otherwise */ argument
140811 if( pUpsert ){
140812 if( pUpsert->pUpsertTarget==0 ){
140814 assert( pUpsert->pNextUpsert==0 );
140815 if( pUpsert->isDoUpdate==0 ){
140819 pUpsert = 0;
140841 pUpsert->pToFree = sIdxIter.u.ax.aIdx;
140842 for(i=0, pTerm=pUpsert; pTerm; pTerm=pTerm->pNextUpsert){
140926 if( pUpsert ){
140927 pUpsertClause = sqlite3UpsertOfIndex(pUpsert,0);
140935 if( pUpsertClause!=pUpsert ){
141036 sqlite3UpsertDoUpdate(pParse, pUpsert, pTab, 0, iDataCur);
141047 if( pUpsert && pUpsertClause!=pUpsert ){
141073 if( pUpsert ){
141074 pUpsertClause = sqlite3UpsertOfIndex(pUpsert, pIdx);
141075 if( upsertIpkDelay && pUpsertClause==pUpsert ){
141262 sqlite3UpsertDoUpdate(pParse, pUpsert, pTab, pIdx, iIdxCur+ix);
157968 sqlite3UpsertDelete(db, pTmp->pUpsert);
158459 Upsert *pUpsert, /* ON CONFLICT clauses for upsert */ argument
158477 pTriggerStep->pUpsert = pUpsert;
158479 if( pUpsert ){
158480 sqlite3HasExplicitNulls(pParse, pUpsert->pUpsertTarget);
158485 testcase( pUpsert );
158486 sqlite3UpsertDelete(db, pUpsert);
159105 sqlite3UpsertDup(db, pStep->pUpsert)
159797 Upsert *pUpsert /* ON CONFLICT clause, or null */ argument
159891 onError, pOrderBy, pLimit, pUpsert, pTrigger);
159900 assert( nChangeFrom==0 || pUpsert==0 );
159934 if( pUpsert ){
159936 iDataCur = pUpsert->iDataCur;
159937 iIdxCur = pUpsert->iIdxCur;
159957 sNC.uNC.pUpsert = pUpsert;
160168 && pUpsert==0
160185 if( pUpsert==0 ){
160214 if( pUpsert ){
160307 if( pUpsert==0 ){
160644 if( pParse->nested==0 && pParse->pTriggerTab==0 && pUpsert==0 ){
160962 Upsert *pUpsert, /* The ON CONFLICT clauses */ argument
160977 assert( pUpsert!=0 );
160978 assert( pUpsert->pUpsertTarget!=0 );
160987 for(; pUpsert && pUpsert->pUpsertTarget;
160988 pUpsert=pUpsert->pNextUpsert, nClause++){
160989 rc = sqlite3ResolveExprListNames(&sNC, pUpsert->pUpsertTarget);
160991 rc = sqlite3ResolveExprNames(&sNC, pUpsert->pUpsertTargetWhere);
160996 pTarget = pUpsert->pUpsertTarget;
161004 assert( pUpsert->pUpsertIdx==0 );
161026 if( pUpsert->pUpsertTargetWhere==0 ) continue;
161027 if( sqlite3ExprCompare(pParse, pUpsert->pUpsertTargetWhere,
161065 pUpsert->pUpsertIdx = pIdx;
161066 if( sqlite3UpsertOfIndex(pAll,pIdx)!=pUpsert ){
161072 pUpsert->isDup = 1;
161076 if( pUpsert->pUpsertIdx==0 ){
161078 if( nClause==0 && pUpsert->pNextUpsert==0 ){
161096 SQLITE_PRIVATE int sqlite3UpsertNextIsIPK(Upsert *pUpsert){ argument
161098 if( NEVER(pUpsert==0) ) return 0;
161099 pNext = pUpsert->pNextUpsert;
161116 SQLITE_PRIVATE Upsert *sqlite3UpsertOfIndex(Upsert *pUpsert, Index *pIdx){ argument
161118 pUpsert
161119 && pUpsert->pUpsertTarget!=0
161120 && pUpsert->pUpsertIdx!=pIdx
161122 pUpsert = pUpsert->pNextUpsert;
161124 return pUpsert;
161138 Upsert *pUpsert, /* The ON CONFLICT clause for the upsert */ argument
161148 Upsert *pTop = pUpsert;
161151 assert( pUpsert!=0 );
161152 iDataCur = pUpsert->iDataCur;
161153 pUpsert = sqlite3UpsertOfIndex(pTop, pIdx);
161193 sqlite3Update(pParse, pSrc, sqlite3ExprListDup(db,pUpsert->pUpsertSet,0),
161194 sqlite3ExprDup(db,pUpsert->pUpsertWhere,0), OE_Abort, 0, 0, pUpsert);