lib/sqlite/sqlite3.c

10115 ** The Index.onError field determines whether or not the indexed columns
10116 ** must be unique and what to do if they are not.  When Index.onError=OE_None,
10118 ** and the value of Index.onError indicate the which conflict resolution
10129   u8 onError;      /* OE_Abort, OE_Ignore, OE_Replace, or OE_None */
74509          && (!mustBeUnique || (pIdx->nColumn==1 && pIdx->onError!=OE_None))
80129 SQLITE_PRIVATE void sqlite3AddNotNull(Parse *pParse, int onError){
80133   p->aCol[p->nCol-1].notNull = (u8)onError;
80274   int onError,      /* What to do with a uniqueness conflict */
80310     pTab->keyConf = (u8)onError;
80320     p = sqlite3CreateIndex(pParse, 0, 0, 0, pList, onError, 0, 0, sortOrder, 0);
81518   if( pIndex->onError!=OE_None ){
81533   if( pIndex->onError!=OE_None ){
81585   int onError,       /* OE_Abort, OE_Ignore, OE_Replace, or OE_None */
81797   pIndex->onError = (u8)onError;
81890       assert( pIdx->onError!=OE_None );
81892       assert( pIndex->onError!=OE_None );
81904         if( pIdx->onError!=pIndex->onError ){
81912           if( !(pIdx->onError==OE_Default || pIndex->onError==OE_Default) ){
81916           if( pIdx->onError==OE_Default ){
81917             pIdx->onError = pIndex->onError;
81981         onError==OE_None ? "" : " UNIQUE",
82021     if( onError!=OE_Replace || pTab->pIndex==0
82022          || pTab->pIndex->onError==OE_Replace){
82027       while( pOther->pNext && pOther->pNext->onError!=OE_Replace ){
82079   if( pIdx->onError!=OE_None ){
82762 ** error. The onError parameter determines which (if any) of the statement
82765 SQLITE_PRIVATE void sqlite3HaltConstraint(Parse *pParse, int onError, char *p4, int p4type){
82767   if( onError==OE_Abort ){
82770   sqlite3VdbeAddOp4(v, OP_Halt, SQLITE_CONSTRAINT, onError, 0, p4, p4type);
85886     if( pIdx->nColumn==nCol && pIdx->onError!=OE_None ){
87207   int onError,          /* How to handle constraint errors */
87319   int onError           /* How to handle constraint errors */
87432   if( pColumn==0 && xferOptimization(pParse, pTab, pSelect, onError, iDb) ){
87751         pTab, regCols-pTab->nCol-1, onError, endOfLoop);
87852       sqlite3VdbeChangeP5(v, onError==OE_Default ? OE_Abort : onError);
87859           keyColumn>=0, 0, onError, endOfLoop, &isReplace
87877         pTab, regData-2-pTab->nCol, onError, endOfLoop);
88008 ** Or if overrideError==OE_Default, then the pParse->onError parameter
88009 ** is used.  Or if pParse->onError==OE_Default then the onError value
88026   int overrideError,  /* Override onError to this if not OE_Default */
88033   int onError;        /* Conflict resolution strategy */
88054     onError = pTab->aCol[i].notNull;
88055     if( onError==OE_None ) continue;
88057       onError = overrideError;
88058     }else if( onError==OE_Default ){
88059       onError = OE_Abort;
88061     if( onError==OE_Replace && pTab->aCol[i].pDflt==0 ){
88062       onError = OE_Abort;
88064     assert( onError==OE_Rollback || onError==OE_Abort || onError==OE_Fail
88065         || onError==OE_Ignore || onError==OE_Replace );
88066     switch( onError ){
88073                                   SQLITE_CONSTRAINT, onError, regData+i);
88084         assert( onError==OE_Replace );
88100     onError = overrideError!=OE_Default ? overrideError : OE_Abort;
88101     if( onError==OE_Ignore ){
88104       if( onError==OE_Replace ) onError = OE_Abort; /* IMP: R-15569-63625 */
88105       sqlite3HaltConstraint(pParse, onError, 0, 0);
88116     onError = pTab->keyConf;
88118       onError = overrideError;
88119     }else if( onError==OE_Default ){
88120       onError = OE_Abort;
88127     switch( onError ){
88129         onError = OE_Abort;
88136           pParse, onError, "PRIMARY KEY must be unique", P4_STATIC);
88216     onError = pIdx->onError;
88217     if( onError==OE_None ){
88222       onError = overrideError;
88223     }else if( onError==OE_Default ){
88224       onError = OE_Abort;
88227       if( onError==OE_Ignore ) onError = OE_Replace;
88228       else if( onError==OE_Fail ) onError = OE_Abort;
88240     assert( onError==OE_Rollback || onError==OE_Abort || onError==OE_Fail
88241         || onError==OE_Ignore || onError==OE_Replace );
88242     switch( onError ){
88263         sqlite3HaltConstraint(pParse, onError, zErr, 0);
88274         assert( onError==OE_Replace );
88427 **    *   The same onError processing (OE_Abort, OE_Ignore, etc)
88437   if( pDest->onError!=pSrc->onError ){
88491   int onError,          /* How to handle constraint errors */
88521   if( onError==OE_Default ){
88522     onError = OE_Abort;
88524   if( onError!=OE_Abort && onError!=OE_Rollback ){
88603     if( pDestIdx->onError!=OE_None ){
88674         pParse, onError, "PRIMARY KEY must be unique", P4_STATIC);
90904           sqlite3VdbeAddOp2(v, OP_Integer, pIdx->onError!=OE_None, 3);
97915 static const char *onErrorText(int onError){
97916   switch( onError ){
98286   int onError          /* ON CONFLICT strategy */
98346 *            onError   pTabList      pChanges             pWhere
98353   int onError            /* How to handle constraint errors */
98530                        pWhere, onError);
98606     if( onError==OE_Replace ){
98611         if( pIdx->onError==OE_Replace ){
98656         pTrigger, pChanges, 0, TRIGGER_BEFORE|TRIGGER_AFTER, pTab, onError
98684       pParse, pTrigger, pChanges, 1, TRIGGER_BEFORE, pTab, onError
98714         TRIGGER_BEFORE, pTab, regOldRowid, onError, addr);
98742         aRegIdx, (chngRowid?regOldRowid:0), 1, onError, addr, 0);
98781       TRIGGER_AFTER, pTab, regOldRowid, onError, addr);
98863   int onError          /* ON CONFLICT strategy */
98920   sqlite3VdbeChangeP5(v, onError==OE_Default ? OE_Abort : onError);
101893     if( pIdx->onError==OE_None ) continue;
102045   if( pIdx->onError!=OE_None && i==pIdx->nColumn
103257     sPk.onError = OE_Replace;
103408     }else if( pProbe->onError!=OE_None ){