Lines Matching refs:pDest
9643 sqlite3 *pDest, /* Destination database handle */
60981 SQLITE_PRIVATE int sqlite3PagerReadFileheader(Pager *pPager, int N, unsigned char *pDest){
60983 memset(pDest, 0, N);
60994 rc = sqlite3OsRead(pPager->fd, pDest, N, 0);
79694 u8 *pDest, /* Pointer to the place to start writing */
79703 for(i=0; i<iAmt && pDest[i]==0; i++){}
79707 memset(pDest + i, 0, iAmt - i);
79713 int rc = btreeOverwriteContent(pPage, pDest+nData, pX, iOffset+nData,
79718 if( memcmp(pDest, ((u8*)pX->pData) + iOffset, iAmt)!=0 ){
79725 memmove(pDest, ((u8*)pX->pData) + iOffset, iAmt);
80155 SQLITE_PRIVATE int sqlite3BtreeTransferRow(BtCursor *pDest, BtCursor *pSrc, i64 iKey){
80156 BtShared *pBt = pDest->pBt;
80168 if( pDest->pKeyInfo==0 ) aOut += putVarint(aOut, iKey);
80175 if( nIn==nRem && nIn<pDest->pPage->maxLocal ){
80188 nOut = btreePayloadToLocal(pDest->pPage, pSrc->info.nPayload);
82035 Btree *pDest; /* Destination b-tree file */
82126 rc = sqlite3BtreeSetPageSize(p->pDest,sqlite3BtreeGetPageSize(p->pSrc),0,0);
82197 p->pDest = findBtree(pDestDb, pDestDb, zDestDb);
82203 if( 0==p->pSrc || 0==p->pDest
82204 || checkReadTransaction(pDestDb, p->pDest)!=SQLITE_OK
82244 Pager * const pDestPager = sqlite3BtreePager(p->pDest);
82246 int nDestPgsz = sqlite3BtreeGetPageSize(p->pDest);
82266 if( iDest==PENDING_BYTE_PAGE(p->pDest->pBt) ) continue;
82344 Pager * const pDestPager = sqlite3BtreePager(p->pDest); /* Dest pager */
82379 && SQLITE_OK==(rc = sqlite3BtreeBeginTrans(p->pDest, 2,
82388 pgszDest = sqlite3BtreeGetPageSize(p->pDest);
82389 destMode = sqlite3PagerGetJournalMode(sqlite3BtreePager(p->pDest));
82431 rc = sqlite3BtreeNewDb(p->pDest);
82435 rc = sqlite3BtreeUpdateMeta(p->pDest,1,p->iDestSchema+1);
82442 rc = sqlite3BtreeSetVersion(p->pDest, 2);
82460 assert( pgszDest==sqlite3BtreeGetPageSize(p->pDest) );
82464 if( nDestTruncate==(int)PENDING_BYTE_PAGE(p->pDest->pBt) ){
82492 nDestTruncate==(int)(PENDING_BYTE_PAGE(p->pDest->pBt)-1)
82504 if( iPg!=PENDING_BYTE_PAGE(p->pDest->pBt) ){
82548 && SQLITE_OK==(rc = sqlite3BtreeCommitPhaseTwo(p->pDest, 0))
82612 sqlite3BtreeRollback(p->pDest, SQLITE_OK, 0);
82754 b.pDest = pTo;
82770 sqlite3PagerClearCache(sqlite3BtreePager(b.pDest));
93827 Mem *pDest /* Store the value into this register. */
93830 sqlite3 *db = pDest->db;
93831 int encoding = pDest->enc;
93878 rc = sqlite3VdbeMemSetStr(pDest, pBuf, len, encoding,
93880 pDest->flags |= MEM_Term;
93882 rc = sqlite3VdbeMemSetStr(pDest, pBuf, len, 0,
93886 rc = sqlite3VdbeMemFromBtree(pC->uc.pCursor, iOffset, len, pDest);
93888 sqlite3VdbeSerialGet((const u8*)pDest->z, t, pDest);
93890 pDest->z[len] = 0;
93891 pDest->flags |= MEM_Term;
93894 pDest->flags &= ~MEM_Ephem;
96029 Mem *pDest; /* Where to write the extracted value */
96064 pDest = &aMem[pOp->p3];
96065 memAboutToChange(p, pDest);
96066 sqlite3VdbeMemSetNull(pDest);
96213 pDest = &aMem[pOp->p3];
96214 memAboutToChange(p, pDest);
96216 sqlite3VdbeMemShallowCopy(pDest, pOp->p4.pMem, MEM_Static);
96218 sqlite3VdbeMemSetNull(pDest);
96232 pDest = &aMem[pOp->p3];
96233 memAboutToChange(p, pDest);
96234 assert( sqlite3VdbeCheckMemInvariants(pDest) );
96235 if( VdbeMemDynamic(pDest) ){
96236 sqlite3VdbeMemSetNull(pDest);
96244 sqlite3VdbeSerialGet(zData, t, pDest);
96251 pDest->n = len = (t-12)/2;
96252 pDest->enc = encoding;
96253 if( pDest->szMalloc < len+2 ){
96255 pDest->flags = MEM_Null;
96256 if( sqlite3VdbeMemGrow(pDest, len+2, 0) ) goto no_mem;
96258 pDest->z = pDest->zMalloc;
96260 memcpy(pDest->z, zData, len);
96261 pDest->z[len] = 0;
96262 pDest->z[len+1] = 0;
96263 pDest->flags = aFlag[t&1];
96267 pDest->enc = encoding;
96268 assert( pDest->db==db );
96290 sqlite3VdbeSerialGet((u8*)sqlite3CtypeMap, t, pDest);
96293 p->cacheCtr, colCacheCtr, pDest);
96303 UPDATE_MAX_BLOBSIZE(pDest);
96304 REGISTER_TRACE(pOp->p3, pDest);
98867 VdbeCursor *pDest; /* Cursor to write to */
98874 pDest = p->apCsr[pOp->p1];
98877 rc = sqlite3BtreeTransferRow(pDest->uc.pCursor, pSrc->uc.pCursor, iKey);
101470 Mem *pDest;
101477 pDest = &aMem[pOp->p3];
101478 memAboutToChange(p, pDest);
101480 sqlite3VdbeMemSetNull(pDest);
101488 sContext.pOut = pDest;
101495 sqlite3VdbeMemSetNull(pDest);
101496 pDest->flags = MEM_Null|MEM_Zero;
101497 pDest->u.nZero = 0;
101499 MemSetTypeFlag(pDest, MEM_Null);
101504 sqlite3VdbeError(p, "%s", sqlite3_value_text(pDest));
101507 sqlite3VdbeChangeEncoding(pDest, encoding);
101508 REGISTER_TRACE(pOp->p3, pDest);
101509 UPDATE_MAX_BLOBSIZE(pDest);
133667 Table *pDest, /* The table we are inserting into */
135824 static int xferCompatibleIndex(Index *pDest, Index *pSrc){
135826 assert( pDest && pSrc );
135827 assert( pDest->pTable!=pSrc->pTable );
135828 if( pDest->nKeyCol!=pSrc->nKeyCol || pDest->nColumn!=pSrc->nColumn ){
135831 if( pDest->onError!=pSrc->onError ){
135835 if( pSrc->aiColumn[i]!=pDest->aiColumn[i] ){
135839 assert( pSrc->aColExpr!=0 && pDest->aColExpr!=0 );
135841 pDest->aColExpr->a[i].pExpr, -1)!=0 ){
135845 if( pSrc->aSortOrder[i]!=pDest->aSortOrder[i] ){
135848 if( sqlite3_stricmp(pSrc->azColl[i],pDest->azColl[i])!=0 ){
135852 if( sqlite3ExprCompare(0, pSrc->pPartIdxWhere, pDest->pPartIdxWhere, -1) ){
135887 Table *pDest, /* The table we are inserting into */
135916 if( IsVirtual(pDest) ){
135921 if( pDest->iPKey>=0 ) onError = pDest->keyConf;
135970 if( pSrc->tnum==pDest->tnum && pSrc->pSchema==pDest->pSchema ){
135971 testcase( pSrc!=pDest ); /* Possible due to bad sqlite_schema.rootpage */
135974 if( HasRowid(pDest)!=HasRowid(pSrc) ){
135980 if( pDest->nCol!=pSrc->nCol ){
135983 if( pDest->iPKey!=pSrc->iPKey ){
135986 if( (pDest->tabFlags & TF_Strict)!=0 && (pSrc->tabFlags & TF_Strict)==0 ){
135989 for(i=0; i<pDest->nCol; i++){
135990 Column *pDestCol = &pDest->aCol[i];
136027 sqlite3ColumnExpr(pDest, pDestCol), -1)!=0 ){
136046 Expr *pDestExpr = sqlite3ColumnExpr(pDest, pDestCol);
136060 for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){
136070 if( pSrcIdx->tnum==pDestIdx->tnum && pSrc->pSchema==pDest->pSchema
136079 if( pDest->pCheck
136081 && sqlite3ExprListCompare(pSrc->pCheck,pDest->pCheck,-1)
136094 assert( IsOrdinaryTable(pDest) );
136095 if( (db->flags & SQLITE_ForeignKeys)!=0 && pDest->u.tab.pFKey!=0 ){
136115 regAutoinc = autoIncBegin(pParse, iDbDest, pDest);
136119 sqlite3OpenTable(pParse, iDest, iDbDest, pDest, OP_OpenWrite);
136120 assert( HasRowid(pDest) || destHasUniqueIdx );
136122 (pDest->iPKey<0 && pDest->pIndex!=0) /* (1) */
136151 if( pDest->iPKey>=0 ){
136157 sqlite3RowidConstraint(pParse, onError, pDest);
136161 }else if( pDest->pIndex==0 && !(db->mDbFlags & DBFLAG_VacuumInto) ){
136165 assert( (pDest->tabFlags & TF_Autoincrement)==0 );
136185 sqlite3VdbeChangeP4(v, -1, (char*)pDest, P4_TABLE);
136193 sqlite3TableLock(pParse, iDbDest, pDest->tnum, 1, pDest->zName);
136196 for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){
136240 && !HasRowid(pDest)
136243 codeWithoutRowidPreupdate(pParse, pDest, iDest, regData);
143003 SQLITE_PRIVATE void sqlite3SelectDestInit(SelectDest *pDest, int eDest, int iParm){
143004 pDest->eDest = (u8)eDest;
143005 pDest->iSDParm = iParm;
143006 pDest->iSDParm2 = 0;
143007 pDest->zAffSdst = 0;
143008 pDest->iSdst = 0;
143009 pDest->nSdst = 0;
144001 SelectDest *pDest, /* How to dispose of the results */
144008 int eDest = pDest->eDest; /* How to dispose of results */
144009 int iParm = pDest->iSDParm; /* First argument to disposal method */
144035 if( pDest->iSdst==0 ){
144041 pDest->iSdst = pParse->nMem+1;
144043 }else if( pDest->iSdst+nResultCol > pParse->nMem ){
144051 pDest->nSdst = nResultCol;
144052 regOrig = regResult = pDest->iSdst;
144202 if( eDest==SRT_Table && pDest->iSDParm2 ){
144239 int i2 = pDest->iSDParm2;
144273 assert( sqlite3Strlen30(pDest->zAffSdst)==nResultCol );
144275 r1, pDest->zAffSdst, nResultCol);
144297 assert( nResultCol<=pDest->nSdst );
144301 assert( nResultCol==pDest->nSdst );
144317 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iSDParm);
144337 pSO = pDest->pOrderBy;
144543 SelectDest *pDest /* Write the sorted results here */
144552 int eDest = pDest->eDest;
144553 int iParm = pDest->iSDParm;
144601 sqlite3VdbeAddOp2(v, OP_Null, 0, pDest->iSdst);
144604 regRow = pDest->iSdst;
144703 assert( nColumn==sqlite3Strlen30(pDest->zAffSdst) );
144705 pDest->zAffSdst, nColumn);
144715 int i2 = pDest->iSDParm2;
144730 sqlite3VdbeAddOp2(v, OP_ResultRow, pDest->iSdst, nColumn);
144732 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iSDParm);
145517 SelectDest *pDest /* What to do with query results */
145639 0, 0, pDest, addrCont, addrBreak);
145671 SelectDest *pDest /* What to do with query results */
145693 SelectDest *pDest /* What to do with query results */
145714 selectInnerLoop(pParse, p, -1, 0, 0, pDest, 1, 1);
145766 SelectDest *pDest /* What to do with query results */
145783 dest = *pDest;
145821 return multiSelectOrderBy(pParse, p, pDest);
146104 pDest->iSdst = dest.iSdst;
146105 pDest->nSdst = dest.nSdst;
146151 SelectDest *pDest, /* Where to send the data */
146182 assert( pDest->eDest!=SRT_Exists );
146183 assert( pDest->eDest!=SRT_Table );
146184 switch( pDest->eDest ){
146191 sqlite3VdbeAddOp2(v, OP_NewRowid, pDest->iSDParm, r2);
146192 sqlite3VdbeAddOp3(v, OP_Insert, pDest->iSDParm, r1, r2);
146207 r1, pDest->zAffSdst, pIn->nSdst);
146208 sqlite3VdbeAddOp4Int(v, OP_IdxInsert, pDest->iSDParm, r1,
146221 sqlite3ExprCodeMove(pParse, pIn->iSdst, pDest->iSDParm, pIn->nSdst);
146231 if( pDest->iSdst==0 ){
146232 pDest->iSdst = sqlite3GetTempRange(pParse, pIn->nSdst);
146233 pDest->nSdst = pIn->nSdst;
146235 sqlite3ExprCodeMove(pParse, pIn->iSdst, pDest->iSdst, pIn->nSdst);
146236 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iSDParm);
146249 assert( pDest->eDest==SRT_Output );
146358 SelectDest *pDest /* What to do with query results */
146564 p, &destA, pDest, regOutA,
146573 p, &destB, pDest, regOutB,
150193 SelectDest *pDest /* What to do with the query results */
150232 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistFifo );
150233 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Fifo );
150234 assert( p->pOrderBy==0 || pDest->eDest!=SRT_DistQueue );
150235 assert( p->pOrderBy==0 || pDest->eDest!=SRT_Queue );
150236 if( IgnorableDistinct(pDest) ){
150237 assert(pDest->eDest==SRT_Exists || pDest->eDest==SRT_Union ||
150238 pDest->eDest==SRT_Except || pDest->eDest==SRT_Discard ||
150239 pDest->eDest==SRT_DistQueue || pDest->eDest==SRT_DistFifo );
150295 if( pDest->eDest==SRT_Output ){
150480 if( !IgnorableOrderby(pDest) ){
150491 rc = multiSelect(pParse, p, pDest);
150786 if( pDest->eDest==SRT_EphemTab ){
150787 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pDest->iSDParm, pEList->nExpr);
150883 selectInnerLoop(pParse, p, -1, &sSort, &sDistinct, pDest, iCont, iBreak);
150892 selectInnerLoop(pParse, p, -1, &sSort, &sDistinct, pDest,
151287 &sDistinct, pDest,
151444 pDest, addrEnd, addrEnd);
151459 generateSortTail(pParse, p, &sSort, pEList->nExpr, pDest);
162308 static void whereOrMove(WhereOrSet *pDest, WhereOrSet *pSrc){
162309 pDest->n = pSrc->n;
162310 memcpy(pDest->a, pSrc->a, pDest->n*sizeof(pDest->a[0]));