<div dir="ltr">Hello. I considered your remarks and the following changes were made:<br><br><div>diff --git a/src/box/sql/insert.c b/src/box/sql/insert.c</div><div>index ae8dafb..734ff34 100644</div><div>--- a/src/box/sql/insert.c</div><div>+++ b/src/box/sql/insert.c</div><div>@@ -1645,6 +1645,12 @@ xferCompatibleIndex(Index * pDest, Index * pSrc)</div><div> <span style="white-space:pre">  </span>assert(pDest->pTable != pSrc->pTable);</div><div> <span style="white-space:pre">        </span>uint32_t nDestCol = index_column_count(pDest);</div><div> <span style="white-space:pre">      </span>uint32_t nSrcCol = index_column_count(pSrc);</div><div>+<span style="white-space:pre"> </span>/* One of them is PK while the other isn't. */</div><div>+<span style="white-space:pre">   </span>if ((pDest->idxType == SQLITE_IDXTYPE_PRIMARYKEY &&</div><div>+<span style="white-space:pre">       </span>     pSrc->idxType != SQLITE_IDXTYPE_PRIMARYKEY) ||</div><div>+<span style="white-space:pre">    </span>    (pDest->idxType != SQLITE_IDXTYPE_PRIMARYKEY &&</div><div>+<span style="white-space:pre">     </span>     pSrc->idxType == SQLITE_IDXTYPE_PRIMARYKEY))</div><div>+<span style="white-space:pre">              </span>return 0;</div><div> <span style="white-space:pre">   </span>if (nDestCol != nSrcCol) {</div><div> <span style="white-space:pre">          </span>return 0;<span style="white-space:pre">    </span>/* Different number of columns */</div><div> <span style="white-space:pre">   </span>}</div><div>@@ -1718,9 +1724,10 @@ xferOptimization(Parse * pParse,<span style="white-space:pre">      </span>/* Parser context */</div><div> <span style="white-space:pre">        </span>int emptyDestTest = 0;<span style="white-space:pre">       </span>/* Address of test for empty pDest */</div><div> <span style="white-space:pre">       </span>int emptySrcTest = 0;<span style="white-space:pre">        </span>/* Address of test for empty pSrc */</div><div> <span style="white-space:pre">        </span>Vdbe *v;<span style="white-space:pre">             </span>/* The VDBE we are building */</div><div>-<span style="white-space:pre">       </span>int destHasUniqueIdx = 0;<span style="white-space:pre">    </span>/* True if pDest has a UNIQUE index */</div><div> <span style="white-space:pre">      </span>int regData, regTupleid;<span style="white-space:pre">     </span>/* Registers holding data and tupleid */</div><div> <span style="white-space:pre">    </span>struct session *user_session = current_session();</div><div>+<span style="white-space:pre">    </span>int dest_has_replace_action = 0;</div><div>+<span style="white-space:pre">     </span>int confl_action_default = 0;</div><div> </div><div> <span style="white-space:pre">      </span>if (pSelect == NULL)</div><div> <span style="white-space:pre">                </span>return 0;<span style="white-space:pre">    </span>/* Must be of the form  INSERT INTO ... SELECT ... */</div><div>@@ -1737,8 +1744,10 @@ xferOptimization(Parse * pParse,<span style="white-space:pre"> </span>/* Parser context */</div><div> <span style="white-space:pre">        </span>if (onError == ON_CONFLICT_ACTION_DEFAULT) {</div><div> <span style="white-space:pre">                </span>if (pDest->iPKey >= 0)</div><div> <span style="white-space:pre">                        </span>onError = pDest->keyConf;</div><div>-<span style="white-space:pre">         </span>if (onError == ON_CONFLICT_ACTION_DEFAULT)</div><div>+<span style="white-space:pre">           </span>if (onError == ON_CONFLICT_ACTION_DEFAULT) {</div><div> <span style="white-space:pre">                        </span>onError = ON_CONFLICT_ACTION_ABORT;</div><div>+<span style="white-space:pre">                  </span>confl_action_default = 1;</div><div>+<span style="white-space:pre">            </span>}</div><div> <span style="white-space:pre">   </span>}</div><div> <span style="white-space:pre">   </span>assert(pSelect->pSrc);<span style="white-space:pre">    </span>/* allocated even if there is no FROM clause */</div><div> <span style="white-space:pre">     </span>if (pSelect->pSrc->nSrc != 1) {</div><div>@@ -1828,15 +1837,16 @@ xferOptimization(Parse * pParse,<span style="white-space:pre"> </span>/* Parser context */</div><div> <span style="white-space:pre">                                </span>return 0;<span style="white-space:pre">    </span>/* Default values must be the same for all columns */</div><div> <span style="white-space:pre">                       </span>}</div><div> <span style="white-space:pre">           </span>}</div><div>+<span style="white-space:pre">            </span>if (pDestCol->notNull == ON_CONFLICT_ACTION_REPLACE)</div><div>+<span style="white-space:pre">                      </span>dest_has_replace_action = 1;</div><div> <span style="white-space:pre">        </span>}</div><div> <span style="white-space:pre">   </span>for (pDestIdx = pDest->pIndex; pDestIdx; pDestIdx = pDestIdx->pNext) {</div><div>-<span style="white-space:pre">         </span>if (index_is_unique(pDestIdx)) {</div><div>-<span style="white-space:pre">                     </span>destHasUniqueIdx = 1;</div><div>-<span style="white-space:pre">                </span>}</div><div> <span style="white-space:pre">           </span>for (pSrcIdx = pSrc->pIndex; pSrcIdx; pSrcIdx = pSrcIdx->pNext) {</div><div> <span style="white-space:pre">                     </span>if (xferCompatibleIndex(pDestIdx, pSrcIdx))</div><div> <span style="white-space:pre">                         </span>break;</div><div> <span style="white-space:pre">              </span>}</div><div>+<span style="white-space:pre">            </span>if (pDestIdx->onError != ON_CONFLICT_ACTION_REPLACE)</div><div>+<span style="white-space:pre">                      </span>dest_has_replace_action = 1;</div><div> <span style="white-space:pre">                </span>if (pSrcIdx == 0) {</div><div> <span style="white-space:pre">                 </span>return 0;<span style="white-space:pre">    </span>/* pDestIdx has no corresponding index in pSrc */</div><div> <span style="white-space:pre">           </span>}</div><div>@@ -1875,58 +1885,63 @@ xferOptimization(Parse * pParse,<span style="white-space:pre">     </span>/* Parser context */</div><div> <span style="white-space:pre">        </span>regData = sqlite3GetTempReg(pParse);</div><div> <span style="white-space:pre">        </span>regTupleid = sqlite3GetTempReg(pParse);</div><div> <span style="white-space:pre">     </span>sqlite3OpenTable(pParse, iDest, pDest, OP_OpenWrite);</div><div>-<span style="white-space:pre">        </span>assert(destHasUniqueIdx);</div><div>-<span style="white-space:pre">    </span>if ((pDest->iPKey < 0 && pDest->pIndex != 0)<span style="white-space:pre">        </span>/* (1) */</div><div>-<span style="white-space:pre">    </span>    ||destHasUniqueIdx<span style="white-space:pre">     </span>/* (2) */</div><div>-<span style="white-space:pre">    </span>    || (onError != ON_CONFLICT_ACTION_ABORT</div><div>-<span style="white-space:pre">                </span>&& onError != ON_CONFLICT_ACTION_ROLLBACK)<span style="white-space:pre">   </span>/* (3) */</div><div>-<span style="white-space:pre">    </span>    ) {</div><div>-<span style="white-space:pre">            </span>/* In some circumstances, we are able to run the xfer optimization</div><div>-<span style="white-space:pre">           </span> * only if the destination table is initially empty.</div><div>-<span style="white-space:pre">         </span> * This block generates code to make</div><div>-<span style="white-space:pre">         </span> * that determination.</div><div>-<span style="white-space:pre">               </span> *</div><div>-<span style="white-space:pre">           </span> * Conditions under which the destination must be empty:</div><div>-<span style="white-space:pre">             </span> *</div><div>-<span style="white-space:pre">           </span> * (1) There is no INTEGER PRIMARY KEY but there are indices.</div><div>-<span style="white-space:pre">                </span> *</div><div>-<span style="white-space:pre">           </span> * (2) The destination has a unique index.  (The xfer optimization</div><div>-<span style="white-space:pre">          </span> *     is unable to test uniqueness.)</div><div>-<span style="white-space:pre">             </span> *</div><div>-<span style="white-space:pre">           </span> * (3) onError is something other than ON_CONFLICT_ACTION_ABORT and _ROLLBACK.</div><div>-<span style="white-space:pre">               </span> */</div><div>+</div><div>+<span style="white-space:pre">  </span>/* Xfer optimization is unable to correctly insert</div><div>+<span style="white-space:pre">   </span> * data in case there's a conflict action</div><div>+<span style="white-space:pre">        </span> * other than ON_CONFLICT_ACTION_ROLLBACK or there's</div><div>+<span style="white-space:pre">     </span> * ON_CONFLICT_ACTION_DEFAULT which was transformed into</div><div>+<span style="white-space:pre">     </span> * ON_CONFLICT_ACTION_ABORT for insertion while we have a</div><div>+<span style="white-space:pre">    </span> * ON_CONFLICT_ACTION_REPLACE for any of constraints.</div><div>+<span style="white-space:pre">        </span> * This is the reason we want to only run it</div><div>+<span style="white-space:pre"> </span> * if the destination table is initially empty.</div><div>+<span style="white-space:pre">      </span> * That block generates code to make that determination.</div><div>+<span style="white-space:pre">     </span> */</div><div>+</div><div>+<span style="white-space:pre">  </span>if (onError != ON_CONFLICT_ACTION_ROLLBACK ||</div><div>+<span style="white-space:pre">        </span>    (confl_action_default == 1 &&</div><div>+<span style="white-space:pre">  </span>    dest_has_replace_action == 1)) {</div><div> <span style="white-space:pre">              </span>addr1 = sqlite3VdbeAddOp2(v, OP_Rewind, iDest, 0);</div><div> <span style="white-space:pre">          </span>VdbeCoverage(v);</div><div> <span style="white-space:pre">            </span>emptyDestTest = sqlite3VdbeAddOp0(v, OP_Goto);</div><div> <span style="white-space:pre">              </span>sqlite3VdbeJumpHere(v, addr1);</div><div> <span style="white-space:pre">      </span>}</div><div> </div><div>-<span style="white-space:pre">   </span>for (pDestIdx = pDest->pIndex; pDestIdx; pDestIdx = pDestIdx->pNext) {</div><div>-<span style="white-space:pre">         </span>for (pSrcIdx = pSrc->pIndex; ALWAYS(pSrcIdx);</div><div>-<span style="white-space:pre">             </span>     pSrcIdx = pSrcIdx->pNext) {</div><div>-<span style="white-space:pre">                       </span>if (xferCompatibleIndex(pDestIdx, pSrcIdx))</div><div>-<span style="white-space:pre">                          </span>break;</div><div>-<span style="white-space:pre">               </span>}</div><div>-<span style="white-space:pre">            </span>assert(pSrcIdx);</div><div>-<span style="white-space:pre">             </span>emit_open_cursor(pParse, iSrc, pSrcIdx->tnum);</div><div>-<span style="white-space:pre">            </span>sqlite3VdbeSetP4KeyInfo(pParse, pSrcIdx);</div><div>-<span style="white-space:pre">            </span>VdbeComment((v, "%s", pSrcIdx->zName));</div><div>-<span style="white-space:pre">         </span>emit_open_cursor(pParse, iDest, pDestIdx->tnum);</div><div>-<span style="white-space:pre">          </span>sqlite3VdbeSetP4KeyInfo(pParse, pDestIdx);</div><div>-<span style="white-space:pre">           </span>sqlite3VdbeChangeP5(v, OPFLAG_BULKCSR);</div><div>-<span style="white-space:pre">              </span>VdbeComment((v, "%s", pDestIdx->zName));</div><div>-<span style="white-space:pre">                </span>addr1 = sqlite3VdbeAddOp2(v, OP_Rewind, iSrc, 0);</div><div>-<span style="white-space:pre">            </span>VdbeCoverage(v);</div><div>-<span style="white-space:pre">             </span>sqlite3VdbeAddOp2(v, OP_RowData, iSrc, regData);</div><div>-<span style="white-space:pre">             </span>sqlite3VdbeAddOp2(v, OP_IdxInsert, iDest, regData);</div><div>-<span style="white-space:pre">          </span>if (pDestIdx->idxType == SQLITE_IDXTYPE_PRIMARYKEY)</div><div>-<span style="white-space:pre">                       </span>sqlite3VdbeChangeP5(v, OPFLAG_NCHANGE);</div><div>-<span style="white-space:pre">              </span>sqlite3VdbeAddOp2(v, OP_Next, iSrc, addr1 + 1);</div><div>-<span style="white-space:pre">              </span>VdbeCoverage(v);</div><div>-<span style="white-space:pre">             </span>sqlite3VdbeJumpHere(v, addr1);</div><div>-<span style="white-space:pre">               </span>sqlite3VdbeAddOp2(v, OP_Close, iSrc, 0);</div><div>-<span style="white-space:pre">             </span>sqlite3VdbeAddOp2(v, OP_Close, iDest, 0);</div><div>-<span style="white-space:pre">    </span>}</div><div>+<span style="white-space:pre">    </span>int space_ptr_reg = ++pParse->nMem;</div><div>+<span style="white-space:pre">       </span>struct space *src_space =</div><div>+<span style="white-space:pre">            </span>space_by_id(SQLITE_PAGENO_TO_SPACEID(pSrc->tnum));</div><div>+<span style="white-space:pre">        </span>struct space *dest_space =</div><div>+<span style="white-space:pre">           </span>space_by_id(SQLITE_PAGENO_TO_SPACEID(pDest->tnum));</div><div>+<span style="white-space:pre">       </span>struct index *src_idx = space_index(src_space, 0);</div><div>+<span style="white-space:pre">   </span>struct index *dest_idx;</div><div>+</div><div>+<span style="white-space:pre">      </span>pDestIdx = sqlite3PrimaryKeyIndex(pDest);</div><div>+<span style="white-space:pre">    </span>pSrcIdx = sqlite3PrimaryKeyIndex(pSrc);</div><div>+<span style="white-space:pre">      </span>space_ptr_reg = ++pParse->nMem;</div><div>+<span style="white-space:pre">   </span>sqlite3VdbeAddOp4Ptr(v, OP_LoadPtr, 0, space_ptr_reg, 0,</div><div>+<span style="white-space:pre">                     </span>     (void *) src_space);</div><div>+<span style="white-space:pre"> </span>sqlite3VdbeAddOp3(v, OP_OpenWrite, iSrc,</div><div>+<span style="white-space:pre">                     </span>  pSrc->tnum, space_ptr_reg);</div><div>+<span style="white-space:pre">    </span>VdbeComment((v, "%s", src_idx->def->name));</div><div>+</div><div>+<span style="white-space:pre">  </span>if((dest_idx = space_index(dest_space, 0)) == NULL)</div><div>+<span style="white-space:pre">          </span>return 0;</div><div>+<span style="white-space:pre">    </span>space_ptr_reg = ++pParse->nMem;</div><div>+<span style="white-space:pre">   </span>sqlite3VdbeAddOp4Ptr(v, OP_LoadPtr, 0, space_ptr_reg, 0,</div><div>+<span style="white-space:pre">                     </span>     (void *) dest_space);</div><div>+<span style="white-space:pre">        </span>sqlite3VdbeAddOp3(v, OP_OpenWrite, iDest,</div><div>+<span style="white-space:pre">                    </span>  pSrc->tnum, space_ptr_reg);</div><div>+<span style="white-space:pre">    </span>sqlite3VdbeChangeP5(v, OPFLAG_BULKCSR);</div><div>+<span style="white-space:pre">      </span>VdbeComment((v, "%s", dest_idx->def->name));</div><div>+<span style="white-space:pre"> </span>addr1 = sqlite3VdbeAddOp2(v, OP_Rewind, iSrc, 0);</div><div>+<span style="white-space:pre">    </span>VdbeCoverage(v);</div><div>+<span style="white-space:pre">     </span>sqlite3VdbeAddOp2(v, OP_RowData, iSrc, regData);</div><div>+<span style="white-space:pre">     </span>sqlite3VdbeAddOp2(v, OP_IdxInsert, iDest, regData);</div><div>+<span style="white-space:pre">  </span>sqlite3VdbeChangeP5(v, OPFLAG_NCHANGE);</div><div>+<span style="white-space:pre">      </span>sqlite3VdbeAddOp2(v, OP_Next, iSrc, addr1 + 1);</div><div>+<span style="white-space:pre">      </span>VdbeCoverage(v);</div><div>+<span style="white-space:pre">     </span>sqlite3VdbeJumpHere(v, addr1);</div><div>+<span style="white-space:pre">       </span>sqlite3VdbeAddOp2(v, OP_Close, iSrc, 0);</div><div>+<span style="white-space:pre">     </span>sqlite3VdbeAddOp2(v, OP_Close, iDest, 0);</div><div> <span style="white-space:pre">   </span>if (emptySrcTest)</div><div> <span style="white-space:pre">           </span>sqlite3VdbeJumpHere(v, emptySrcTest);</div><div> <span style="white-space:pre">       </span>sqlite3ReleaseTempReg(pParse, regTupleid);</div><div>diff --git a/test/sql-tap/gh-3307-xfer-optimization-issue.test.lua b/test/sql-tap/gh-3307-xfer-optimization-issue.test.lua</div><div>new file mode 100755</div><div>index 0000000..860b4c3</div><div>--- /dev/null</div><div>+++ b/test/sql-tap/gh-3307-xfer-optimization-issue.test.lua</div><div>@@ -0,0 +1,233 @@</div><div>+#!/usr/bin/env tarantool</div><div>+test = require("sqltester")</div><div>+test:plan(18)</div><div>+</div><div>+test:do_catchsql_test(</div><div>+<span style="white-space:pre">    </span>"xfer-optimization-1.1",</div><div>+<span style="white-space:pre">   </span>[[</div><div>+<span style="white-space:pre">           </span>CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER UNIQUE);</div><div>+<span style="white-space:pre">            </span>INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3);</div><div>+<span style="white-space:pre">                </span>CREATE TABLE t2(a INTEGER PRIMARY KEY, b INTEGER UNIQUE);</div><div>+<span style="white-space:pre">            </span>INSERT INTO t2 SELECT * FROM t1;</div><div>+<span style="white-space:pre">     </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.1></div><div>+<span style="white-space:pre">             </span>0</div><div>+<span style="white-space:pre">            </span>-- <xfer-optimization-1.1></div><div>+<span style="white-space:pre">     </span>})</div><div>+</div><div>+test:do_execsql_test(</div><div>+<span style="white-space:pre">      </span>"xfer-oprimization-1.2",</div><div>+<span style="white-space:pre">   </span>[[</div><div>+<span style="white-space:pre">           </span>SELECT * FROM t2;</div><div>+<span style="white-space:pre">    </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-oprimization-1.2></div><div>+<span style="white-space:pre">             </span>1, 1, 2, 2, 3, 3</div><div>+<span style="white-space:pre">             </span>-- <xfer-oprimization-1.2></div><div>+<span style="white-space:pre">     </span>})</div><div>+</div><div>+test:do_catchsql_test(</div><div>+<span style="white-space:pre">     </span>"xfer-optimization-1.3",</div><div>+<span style="white-space:pre">   </span>[[</div><div>+<span style="white-space:pre">           </span>DROP TABLE t1;</div><div>+<span style="white-space:pre">               </span>DROP TABLE t2;</div><div>+<span style="white-space:pre">               </span>CREATE TABLE t1(id INTEGER PRIMARY KEY, b INTEGER);</div><div>+<span style="white-space:pre">          </span>CREATE TABLE t2(id INTEGER PRIMARY KEY, b INTEGER);</div><div>+<span style="white-space:pre">          </span>CREATE INDEX i1 ON t1(b);</div><div>+<span style="white-space:pre">            </span>CREATE INDEX i2 ON t2(b);</div><div>+<span style="white-space:pre">            </span>INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3);</div><div>+<span style="white-space:pre">                </span>INSERT INTO t2 SELECT * FROM t1;</div><div>+<span style="white-space:pre">     </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.3></div><div>+<span style="white-space:pre">             </span>0</div><div>+<span style="white-space:pre">            </span>-- <xfer-optimization-1.3></div><div>+<span style="white-space:pre">     </span>})</div><div>+</div><div>+test:do_execsql_test(</div><div>+<span style="white-space:pre">      </span>"xfer-oprimization-1.4",</div><div>+<span style="white-space:pre">   </span>[[</div><div>+<span style="white-space:pre">           </span>SELECT * FROM t2;</div><div>+<span style="white-space:pre">    </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.4></div><div>+<span style="white-space:pre">             </span>1, 1, 2, 2, 3, 3</div><div>+<span style="white-space:pre">             </span>-- <xfer-optimization-1.4></div><div>+<span style="white-space:pre">     </span>})</div><div>+</div><div>+test:do_catchsql_test(</div><div>+<span style="white-space:pre">     </span>"xfer-optimization-1.5",</div><div>+<span style="white-space:pre">   </span>[[</div><div>+<span style="white-space:pre">           </span>DROP TABLE t1;</div><div>+<span style="white-space:pre">               </span>DROP TABLE t2;</div><div>+<span style="white-space:pre">               </span>CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER, c INTEGER);</div><div>+<span style="white-space:pre">                </span>INSERT INTO t1 VALUES (1, 1, 2), (2, 2, 3), (3, 3, 4);</div><div>+<span style="white-space:pre">               </span>CREATE TABLE t2(a INTEGER PRIMARY KEY, b INTEGER);</div><div>+<span style="white-space:pre">           </span>INSERT INTO t2 SELECT * FROM t1;</div><div>+<span style="white-space:pre">     </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.5></div><div>+<span style="white-space:pre">             </span>1, "table T2 has 2 columns but 3 values were supplied"</div><div>+<span style="white-space:pre">             </span>-- <xfer-optimization-1.5></div><div>+<span style="white-space:pre">     </span>})</div><div>+</div><div>+test:do_execsql_test(</div><div>+<span style="white-space:pre">      </span>"xfer-oprimization-1.6",</div><div>+<span style="white-space:pre">   </span>[[</div><div>+<span style="white-space:pre">           </span>SELECT * FROM t2;</div><div>+<span style="white-space:pre">    </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-oprimization-1.6></div><div>+</div><div>+<span style="white-space:pre">             </span>-- <xfer-oprimization-1.6></div><div>+<span style="white-space:pre">     </span>})</div><div>+</div><div>+test:do_catchsql_test(</div><div>+<span style="white-space:pre">     </span>"xfer-optimization-1.7",</div><div>+<span style="white-space:pre">   </span>[[</div><div>+<span style="white-space:pre">           </span>DROP TABLE t1;</div><div>+<span style="white-space:pre">               </span>DROP TABLE t2;</div><div>+<span style="white-space:pre">               </span>CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER);</div><div>+<span style="white-space:pre">           </span>INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3);</div><div>+<span style="white-space:pre">                </span>CREATE TABLE t2(a INTEGER PRIMARY KEY, b INTEGER);</div><div>+<span style="white-space:pre">           </span>INSERT INTO t2 SELECT * FROM t1;</div><div>+<span style="white-space:pre">     </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.7></div><div>+<span style="white-space:pre">             </span>0</div><div>+<span style="white-space:pre">            </span>-- <xfer-optimization-1.7></div><div>+<span style="white-space:pre">     </span>})</div><div>+</div><div>+test:do_execsql_test(</div><div>+<span style="white-space:pre">      </span>"xfer-oprimization-1.8",</div><div>+<span style="white-space:pre">   </span>[[</div><div>+<span style="white-space:pre">           </span>SELECT * FROM t2;</div><div>+<span style="white-space:pre">    </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-oprimization-1.6></div><div>+<span style="white-space:pre">             </span>1, 1, 2, 2, 3, 3</div><div>+<span style="white-space:pre">             </span>-- <xfer-oprimization-1.6></div><div>+<span style="white-space:pre">     </span>})</div><div>+</div><div>+test:do_catchsql_test(</div><div>+<span style="white-space:pre">     </span>"xfer-optimization-1.9",</div><div>+<span style="white-space:pre">   </span>[[</div><div>+<span style="white-space:pre">           </span>DROP TABLE t1;</div><div>+<span style="white-space:pre">               </span>DROP TABLE t2;</div><div>+<span style="white-space:pre">               </span>CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER);</div><div>+<span style="white-space:pre">           </span>INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 2);</div><div>+<span style="white-space:pre">                </span>CREATE TABLE t2(b INTEGER, a INTEGER PRIMARY KEY);</div><div>+<span style="white-space:pre">           </span>INSERT INTO t2 SELECT * FROM t1;</div><div>+<span style="white-space:pre">     </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.9></div><div>+<span style="white-space:pre">             </span>1, "Duplicate key exists in unique index 'sqlite_autoindex_T2_1' in space 'T2'"</div><div>+<span style="white-space:pre">            </span>-- <xfer-optimization-1.9></div><div>+<span style="white-space:pre">     </span>})</div><div>+</div><div>+test:do_execsql_test(</div><div>+<span style="white-space:pre">      </span>"xfer-oprimization-1.10",</div><div>+<span style="white-space:pre">  </span>[[</div><div>+<span style="white-space:pre">           </span>SELECT * FROM t2;</div><div>+<span style="white-space:pre">    </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-oprimization-1.10></div><div>+</div><div>+<span style="white-space:pre">            </span>-- <xfer-oprimization-1.10></div><div>+<span style="white-space:pre">    </span>})</div><div>+</div><div>+test:do_catchsql_test(</div><div>+<span style="white-space:pre">     </span>"xfer-optimization-1.11",</div><div>+<span style="white-space:pre">  </span>[[</div><div>+<span style="white-space:pre">           </span>DROP TABLE t1;</div><div>+<span style="white-space:pre">               </span>DROP TABLE t2;</div><div>+<span style="white-space:pre">               </span>CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER);</div><div>+<span style="white-space:pre">           </span>INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 2);</div><div>+<span style="white-space:pre">                </span>CREATE TABLE t2(b INTEGER PRIMARY KEY, a INTEGER);</div><div>+<span style="white-space:pre">           </span>INSERT INTO t2 SELECT * FROM t1;</div><div>+<span style="white-space:pre">     </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.11></div><div>+<span style="white-space:pre">            </span>0</div><div>+<span style="white-space:pre">            </span>-- <xfer-optimization-1.11></div><div>+<span style="white-space:pre">    </span>})</div><div>+</div><div>+test:do_execsql_test(</div><div>+<span style="white-space:pre">      </span>"xfer-oprimization-1.12",</div><div>+<span style="white-space:pre">  </span>[[</div><div>+<span style="white-space:pre">           </span>SELECT * FROM t2;</div><div>+<span style="white-space:pre">    </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-oprimization-1.12></div><div>+<span style="white-space:pre">            </span>1, 1, 2, 2, 3, 2</div><div>+<span style="white-space:pre">             </span>-- <xfer-oprimization-1.12></div><div>+<span style="white-space:pre">    </span>})</div><div>+</div><div>+test:do_catchsql_test(</div><div>+<span style="white-space:pre">     </span>"xfer-optimization-1.13",</div><div>+<span style="white-space:pre">  </span>[[</div><div>+<span style="white-space:pre">           </span>DROP TABLE t1;</div><div>+<span style="white-space:pre">               </span>DROP TABLE t2;</div><div>+<span style="white-space:pre">               </span>CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE ON CONFLICT REPLACE);</div><div>+<span style="white-space:pre">                </span>CREATE TABLE t2(a INTEGER PRIMARY KEY, b UNIQUE ON CONFLICT REPLACE);</div><div>+<span style="white-space:pre">                </span>INSERT INTO t1 VALUES (3, 3), (4, 4), (5, 5);</div><div>+<span style="white-space:pre">                </span>INSERT INTO t2 VALUES (1, 1), (2, 2);</div><div>+<span style="white-space:pre">                </span>INSERT INTO t2 SELECT * FROM t1;</div><div>+<span style="white-space:pre">     </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.13></div><div>+<span style="white-space:pre">            </span>0</div><div>+<span style="white-space:pre">            </span>-- <xfer-optimization-1.13></div><div>+<span style="white-space:pre">    </span>})</div><div>+</div><div>+test:do_execsql_test(</div><div>+<span style="white-space:pre">      </span>"xfer-oprimization-1.14",</div><div>+<span style="white-space:pre">  </span>[[</div><div>+<span style="white-space:pre">           </span>SELECT * FROM t2;</div><div>+<span style="white-space:pre">    </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.14></div><div>+<span style="white-space:pre">            </span>1, 1, 2, 2, 3, 3, 4, 4, 5, 5</div><div>+<span style="white-space:pre">         </span>-- <xfer-optimization-1.14></div><div>+<span style="white-space:pre">    </span>})</div><div>+</div><div>+test:do_catchsql_test(</div><div>+<span style="white-space:pre">     </span>"xfer-optimization-1.15",</div><div>+<span style="white-space:pre">  </span>[[</div><div>+<span style="white-space:pre">           </span>DROP TABLE t1;</div><div>+<span style="white-space:pre">               </span>DROP TABLE t2;</div><div>+<span style="white-space:pre">               </span>CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE ON CONFLICT REPLACE);</div><div>+<span style="white-space:pre">                </span>CREATE TABLE t2(a INTEGER PRIMARY KEY, b UNIQUE ON CONFLICT REPLACE);</div><div>+<span style="white-space:pre">                </span>INSERT INTO t1 VALUES (2, 2), (3, 3), (5, 5);</div><div>+<span style="white-space:pre">                </span>INSERT INTO t2 VALUES (1, 1), (4, 4);</div><div>+<span style="white-space:pre">                </span>INSERT OR ROLLBACK INTO t2 SELECT * FROM t1;</div><div>+<span style="white-space:pre"> </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.15></div><div>+<span style="white-space:pre">            </span>0</div><div>+<span style="white-space:pre">            </span>-- <xfer-optimization-1.15></div><div>+<span style="white-space:pre">    </span>})</div><div>+</div><div>+test:do_execsql_test(</div><div>+<span style="white-space:pre">      </span>"xfer-oprimization-1.16",</div><div>+<span style="white-space:pre">  </span>[[</div><div>+<span style="white-space:pre">           </span>SELECT * FROM t2;</div><div>+<span style="white-space:pre">    </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-oprimization-1.16></div><div>+<span style="white-space:pre">            </span>1, 1, 2, 2, 3, 3, 4, 4, 5, 5</div><div>+<span style="white-space:pre">         </span>-- <xfer-oprimization-1.16></div><div>+<span style="white-space:pre">    </span>})</div><div>+</div><div>+test:do_catchsql_test(</div><div>+<span style="white-space:pre">     </span>"xfer-optimization-1.17",</div><div>+<span style="white-space:pre">  </span>[[</div><div>+<span style="white-space:pre">           </span>DROP TABLE t1;</div><div>+<span style="white-space:pre">               </span>DROP TABLE t2;</div><div>+<span style="white-space:pre">               </span>CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE ON CONFLICT REPLACE);</div><div>+<span style="white-space:pre">                </span>CREATE TABLE t2(a INTEGER PRIMARY KEY, b UNIQUE ON CONFLICT REPLACE);</div><div>+<span style="white-space:pre">                </span>INSERT INTO t1 VALUES (1, 2), (3, 3), (5, 5);</div><div>+<span style="white-space:pre">                </span>INSERT INTO t2 VALUES (1, 1), (4, 4);</div><div>+<span style="white-space:pre">                </span>INSERT OR REPLACE INTO t2 SELECT * FROM t1;</div><div>+<span style="white-space:pre">  </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-optimization-1.17></div><div>+<span style="white-space:pre">            </span>0</div><div>+<span style="white-space:pre">            </span>-- <xfer-optimization-1.17></div><div>+<span style="white-space:pre">    </span>})</div><div>+</div><div>+test:do_execsql_test(</div><div>+<span style="white-space:pre">      </span>"xfer-oprimization-1.18",</div><div>+<span style="white-space:pre">  </span>[[</div><div>+<span style="white-space:pre">           </span>SELECT * FROM t2;</div><div>+<span style="white-space:pre">    </span>]], {</div><div>+<span style="white-space:pre">                </span>-- <xfer-oprimization-1.18></div><div>+<span style="white-space:pre">            </span>1, 2, 3, 3, 4, 4, 5, 5</div><div>+<span style="white-space:pre">               </span>-- <xfer-oprimization-1.18></div><div>+<span style="white-space:pre">    </span>})</div><div>+</div><div>+test:finish_test()</div><div><br></div><div><br></div></div>