<div dir="ltr"><span class="gmail-im" style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">> @@ -1737,8 +1744,10 @@ xferOptimization(Parse * pParse,       /* Parser context */<br>>       if (onError == ON_CONFLICT_ACTION_DEFAULT) {<br>>               if (pDest->iPKey >= 0)<br>>                       onError = pDest->keyConf;<br>> -             if (onError == ON_CONFLICT_ACTION_DEFAULT)<br>> +             if (onError == ON_CONFLICT_ACTION_DEFAULT) {<br>>                       onError = ON_CONFLICT_ACTION_ABORT;<br>> +                     confl_action_default = 1;<br><br></span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Why do you need this variable at all? I mean, DEFAULT always</span><br style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">is an alias to ABORT, isn’t it?</span><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="font-size:12.8px">Yes, it is, but there's a little difference between directly specified ABORT for an</span></div><div><span style="font-size:12.8px">insert stmt (INSERT OR ABORT) and just INSERT without any specified error action</span></div><div><span style="font-size:12.8px">(ABORT specified by the internals). </span><span style="font-size:12.8px">When you directly specify it ABORT is a higher priority</span></div><div><span style="font-size:12.8px">action than in case </span><span style="font-size:12.8px">there's a column with REPLACE error action. Thus we can <span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">even<span> </span></span>insert</span></div><div><span style="font-size:12.8px">not in the empty destination table.</span></div></div>