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()
2729   for(i=0; i<pSrc->nKeyCol; i++){  in xferCompatibleIndex()
2730     if( pSrc->aiColumn[i]!=pDest->aiColumn[i] ){  in xferCompatibleIndex()
2733     if( pSrc->aiColumn[i]==XN_EXPR ){  in xferCompatibleIndex()
2734       assert( pSrc->aColExpr!=0 && pDest->aColExpr!=0 );  in xferCompatibleIndex()
2735       if( sqlite3ExprCompare(0, pSrc->aColExpr->a[i].pExpr,  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()
2789   Table *pSrc;                     /* The table in the FROM clause of SELECT */  in xferOptimization()  local
2819   assert(pSelect->pSrc);   /* allocated even if there is no FROM clause */  in xferOptimization()
2820   if( pSelect->pSrc->nSrc!=1 ){  in xferOptimization()
2823   if( pSelect->pSrc->a[0].pSelect ){  in xferOptimization()
2860   pItem = pSelect->pSrc->a;  in xferOptimization()
2861   pSrc = sqlite3LocateTableItem(pParse, 0, pItem);  in xferOptimization()
2862   if( pSrc==0 ){  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()
2872   if( !IsOrdinaryTable(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()
2886     Column *pSrcCol = &pSrc->aCol[i];  in xferOptimization()
2921              sqlite3ColumnExpr(pSrc, pSrcCol),  in xferOptimization()
2942       Expr *pSrcExpr = sqlite3ColumnExpr(pSrc, pSrcCol);  in xferOptimization()
2959     for(pSrcIdx=pSrc->pIndex; pSrcIdx; pSrcIdx=pSrcIdx->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()
3002   iDbSrc = sqlite3SchemaToIndex(db, pSrc->pSchema);  in xferOptimization()
3039   if( HasRowid(pSrc) ){  in xferOptimization()
3041     sqlite3OpenTable(pParse, iSrc, iDbSrc, pSrc, OP_OpenRead);  in xferOptimization()
3086     sqlite3TableLock(pParse, iDbSrc, pSrc->tnum, 0, pSrc->zName);  in xferOptimization()
3090     for(pSrcIdx=pSrc->pIndex; ALWAYS(pSrcIdx); pSrcIdx=pSrcIdx->pNext){  in xferOptimization()
3126     }else if( !HasRowid(pSrc) && pDestIdx->idxType==SQLITE_IDXTYPE_PRIMARYKEY ){  in xferOptimization()