<div dir="ltr">Diff for the fixed patch:<br><br><div>diff --git a/src/box/sql/insert.c b/src/box/sql/insert.c</div><div>index ae8dafb..87e1bad 100644</div><div>--- a/src/box/sql/insert.c</div><div>+++ b/src/box/sql/insert.c</div><div>@@ -1645,6 +1645,9 @@ 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 == 2 && pSrc->idxType != 2)</div><div>+<span style="white-space:pre">        </span>    || (pDest->idxType != 2 && pSrc->idxType == 2))</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>@@ -1711,16 +1714,21 @@ xferOptimization(Parse * pParse,<span style="white-space:pre">     </span>/* Parser context */</div><div> <span style="white-space:pre">        </span>ExprList *pEList;<span style="white-space:pre">    </span>/* The result set of the SELECT */</div><div> <span style="white-space:pre">  </span>Table *pSrc;<span style="white-space:pre">         </span>/* The table in the FROM clause of SELECT */</div><div> <span style="white-space:pre">        </span>Index *pSrcIdx, *pDestIdx;<span style="white-space:pre">   </span>/* Source and destination indices */</div><div>+<span style="white-space:pre"> </span>/* Source and destination indices */</div><div>+<span style="white-space:pre"> </span>struct index *src_idx, *dest_idx;</div><div> <span style="white-space:pre">   </span>struct SrcList_item *pItem;<span style="white-space:pre">  </span>/* An element of pSelect->pSrc */</div><div> <span style="white-space:pre">        </span>int i;<span style="white-space:pre">                       </span>/* Loop counter */</div><div> <span style="white-space:pre">  </span>int iSrc, iDest;<span style="white-space:pre">     </span>/* Cursors from source and destination */</div><div> <span style="white-space:pre">   </span>int addr1;<span style="white-space:pre">           </span>/* Loop addresses */</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>/* Number of memory cell for cursors */</div><div>+<span style="white-space:pre">      </span>int space_ptr_reg;</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>/* Space pointer for pDest and pSrc */</div><div>+<span style="white-space:pre">       </span>struct space *space;</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>@@ -1830,9 +1838,6 @@ xferOptimization(Parse * pParse,<span style="white-space:pre">  </span>/* Parser context */</div><div> <span style="white-space:pre">                </span>}</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>@@ -1875,58 +1880,51 @@ 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>-<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>/* The xfer optimization is unable to test</div><div>+<span style="white-space:pre">   </span> * uniqueness while we have a unique</div><div>+<span style="white-space:pre"> </span> * PRIMARY KEY in any existing table.</div><div>+<span style="white-space:pre">        </span> * This is the reason we can 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> * 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>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>+</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 = space_by_id(SQLITE_PAGENO_TO_SPACEID(pSrc->tnum));</div><div>+<span style="white-space:pre">        </span>if((src_idx = space_index(space, 0 /* PK */)) == 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 *) 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>+<span style="white-space:pre">  </span>space = space_by_id(SQLITE_PAGENO_TO_SPACEID(pDest->tnum));</div><div>+<span style="white-space:pre">       </span>if((dest_idx = space_index(space, 0 /* PK */)) == 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 *) 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..0824c67</div><div>--- /dev/null</div><div>+++ b/test/sql-tap/gh-3307-xfer-optimization-issue.test.lua</div><div>@@ -0,0 +1,155 @@</div><div>+#!/usr/bin/env tarantool</div><div>+test = require("sqltester")</div><div>+test:plan(12)</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:finish_test()</div><div><br></div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><br></div></blockquote></div></div>