580   Table *pDest,         /* The table we are inserting into */
2719 static int xferCompatibleIndex(Index *pDest, Index *pSrc){  in xferCompatibleIndex()  argument
2721   assert( pDest && pSrc );  in xferCompatibleIndex()
2722   assert( pDest->pTable!=pSrc->pTable );  in xferCompatibleIndex()
2723   if( pDest->nKeyCol!=pSrc->nKeyCol || pDest->nColumn!=pSrc->nColumn ){  in xferCompatibleIndex()
2726   if( pDest->onError!=pSrc->onError ){  in xferCompatibleIndex()
2730     if( pSrc->aiColumn[i]!=pDest->aiColumn[i] ){  in xferCompatibleIndex()
2734       assert( pSrc->aColExpr!=0 && pDest->aColExpr!=0 );  in xferCompatibleIndex()
2736                              pDest->aColExpr->a[i].pExpr, -1)!=0 ){  in xferCompatibleIndex()
2740     if( pSrc->aSortOrder[i]!=pDest->aSortOrder[i] ){  in xferCompatibleIndex()
2743     if( sqlite3_stricmp(pSrc->azColl[i],pDest->azColl[i])!=0 ){  in xferCompatibleIndex()
2747   if( sqlite3ExprCompare(0, pSrc->pPartIdxWhere, pDest->pPartIdxWhere, -1) ){  in xferCompatibleIndex()
2782   Table *pDest,         /* The table we are inserting into */  in xferOptimization()  argument
2811   if( IsVirtual(pDest) ){  in xferOptimization()
2816     if( pDest->iPKey>=0 ) onError = pDest->keyConf;  in xferOptimization()
2865   if( pSrc->tnum==pDest->tnum && pSrc->pSchema==pDest->pSchema ){  in xferOptimization()
2866     testcase( pSrc!=pDest ); /* Possible due to bad sqlite_schema.rootpage */  in xferOptimization()
2869   if( HasRowid(pDest)!=HasRowid(pSrc) ){  in xferOptimization()
2875   if( pDest->nCol!=pSrc->nCol ){  in xferOptimization()
2878   if( pDest->iPKey!=pSrc->iPKey ){  in xferOptimization()
2881   if( (pDest->tabFlags & TF_Strict)!=0 && (pSrc->tabFlags & TF_Strict)==0 ){  in xferOptimization()
2884   for(i=0; i<pDest->nCol; i++){  in xferOptimization()
2885     Column *pDestCol = &pDest->aCol[i];  in xferOptimization()
2922              sqlite3ColumnExpr(pDest, pDestCol), -1)!=0 ){  in xferOptimization()
2941       Expr *pDestExpr = sqlite3ColumnExpr(pDest, pDestCol);  in xferOptimization()
2955   for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){  in xferOptimization()
2965     if( pSrcIdx->tnum==pDestIdx->tnum && pSrc->pSchema==pDest->pSchema  in xferOptimization()
2974   if( pDest->pCheck && sqlite3ExprListCompare(pSrc->pCheck,pDest->pCheck,-1) ){  in xferOptimization()
2986   assert( IsOrdinaryTable(pDest) );  in xferOptimization()
2987   if( (db->flags & SQLITE_ForeignKeys)!=0 && pDest->u.tab.pFKey!=0 ){  in xferOptimization()
3007   regAutoinc = autoIncBegin(pParse, iDbDest, pDest);  in xferOptimization()
3011   sqlite3OpenTable(pParse, iDest, iDbDest, pDest, OP_OpenWrite);  in xferOptimization()
3012   assert( HasRowid(pDest) || destHasUniqueIdx );  in xferOptimization()
3014       (pDest->iPKey<0 && pDest->pIndex!=0)          /* (1) */  in xferOptimization()
3043     if( pDest->iPKey>=0 ){  in xferOptimization()
3049         sqlite3RowidConstraint(pParse, onError, pDest);  in xferOptimization()
3053     }else if( pDest->pIndex==0 && !(db->mDbFlags & DBFLAG_VacuumInto) ){  in xferOptimization()
3057       assert( (pDest->tabFlags & TF_Autoincrement)==0 );  in xferOptimization()
3077       sqlite3VdbeChangeP4(v, -1, (char*)pDest, P4_TABLE);  in xferOptimization()
3085     sqlite3TableLock(pParse, iDbDest, pDest->tnum, 1, pDest->zName);  in xferOptimization()
3088   for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){  in xferOptimization()
3132        && !HasRowid(pDest)   in xferOptimization()
3135         codeWithoutRowidPreupdate(pParse, pDest, iDest, regData);  in xferOptimization()