Lines Matching defs:pDest
7052 sqlite3 *pDest, /* Destination database handle */
42018 ** that pDest points to.
42030 SQLITE_PRIVATE int sqlite3PagerReadFileheader(Pager *pPager, int N, unsigned char *pDest){
42032 memset(pDest, 0, N);
42043 rc = sqlite3OsRead(pPager->fd, pDest, N, 0);
57663 Btree *pDest; /* Destination b-tree file */
57665 int bDestLocked; /* True once a write-transaction is open on pDest */
57760 rc = sqlite3BtreeSetPageSize(p->pDest,sqlite3BtreeGetPageSize(p->pSrc),-1,0);
57811 p->pDest = findBtree(pDestDb, pDestDb, zDestDb);
57817 if( 0==p->pSrc || 0==p->pDest || setDestPgsz(p)==SQLITE_NOMEM ){
57851 Pager * const pDestPager = sqlite3BtreePager(p->pDest);
57853 int nDestPgsz = sqlite3BtreeGetPageSize(p->pDest);
57858 int nDestReserve = sqlite3BtreeGetReserve(p->pDest);
57903 if( iDest==PENDING_BYTE_PAGE(p->pDest->pBt) ) continue;
57975 Pager * const pDestPager = sqlite3BtreePager(p->pDest); /* Dest pager */
57991 && SQLITE_OK==(rc = sqlite3BtreeBeginTrans(p->pDest, 2))
57994 sqlite3BtreeGetMeta(p->pDest, BTREE_SCHEMA_VERSION, &p->iDestSchema);
58009 pgszDest = sqlite3BtreeGetPageSize(p->pDest);
58010 destMode = sqlite3PagerGetJournalMode(sqlite3BtreePager(p->pDest));
58048 rc = sqlite3BtreeUpdateMeta(p->pDest,1,p->iDestSchema+1);
58054 rc = sqlite3BtreeSetVersion(p->pDest, 2);
58072 assert( pgszDest==sqlite3BtreeGetPageSize(p->pDest) );
58076 if( nDestTruncate==(int)PENDING_BYTE_PAGE(p->pDest->pBt) ){
58101 nDestTruncate==(int)(PENDING_BYTE_PAGE(p->pDest->pBt)-1)
58143 && SQLITE_OK==(rc = sqlite3BtreeCommitPhaseTwo(p->pDest, 0))
58205 sqlite3BtreeRollback(p->pDest, SQLITE_OK);
58328 b.pDest = pTo;
58344 sqlite3PagerClearCache(sqlite3BtreePager(b.pDest));
65084 Mem *pDest; /* Where to write the extracted value */
65390 Mem *pDest;
67017 Mem *pDest; /* Where to write the extracted value */
67036 u.an.pDest = &aMem[pOp->p3];
67037 memAboutToChange(p, u.an.pDest);
67097 MemSetTypeFlag(u.an.pDest, MEM_Null);
67252 VdbeMemRelease(u.an.pDest);
67253 sqlite3VdbeSerialGet((u8 *)&u.an.zRec[u.an.aOffset[u.an.p2]], u.an.aType[u.an.p2], u.an.pDest);
67256 sqlite3VdbeMemMove(&u.an.sMem, u.an.pDest);
67262 sqlite3VdbeSerialGet((u8*)u.an.zData, u.an.aType[u.an.p2], u.an.pDest);
67264 u.an.pDest->enc = encoding;
67267 sqlite3VdbeMemShallowCopy(u.an.pDest, pOp->p4.pMem, MEM_Static);
67269 MemSetTypeFlag(u.an.pDest, MEM_Null);
67275 ** dynamically allocated space over to the u.an.pDest structure.
67280 assert( !(u.an.pDest->flags & MEM_Dyn) );
67281 assert( !(u.an.pDest->flags & (MEM_Blob|MEM_Str)) || u.an.pDest->z==u.an.sMem.z );
67282 u.an.pDest->flags &= ~(MEM_Ephem|MEM_Static);
67283 u.an.pDest->flags |= MEM_Term;
67284 u.an.pDest->z = u.an.sMem.z;
67285 u.an.pDest->zMalloc = u.an.sMem.zMalloc;
67288 rc = sqlite3VdbeMemMakeWriteable(u.an.pDest);
67291 UPDATE_MAX_BLOBSIZE(u.an.pDest);
67292 REGISTER_TRACE(pOp->p3, u.an.pDest);
70786 Mem *pDest;
70793 u.cn.pDest = &aMem[pOp->p3];
70794 memAboutToChange(p, u.cn.pDest);
70796 sqlite3VdbeMemSetNull(u.cn.pDest);
70809 sqlite3VdbeMemMove(&u.cn.sContext.s, u.cn.pDest);
70823 sqlite3VdbeMemMove(u.cn.pDest, &u.cn.sContext.s);
70824 REGISTER_TRACE(pOp->p3, u.cn.pDest);
70825 UPDATE_MAX_BLOBSIZE(u.cn.pDest);
70827 if( sqlite3VdbeMemTooBig(u.cn.pDest) ){
89288 Table *pDest, /* The table we are inserting into */
89291 int iDbDest /* The database of pDest */
90505 ** for index pDest in an insert transfer optimization. The rules
90513 static int xferCompatibleIndex(Index *pDest, Index *pSrc){
90515 assert( pDest && pSrc );
90516 assert( pDest->pTable!=pSrc->pTable );
90517 if( pDest->nColumn!=pSrc->nColumn ){
90520 if( pDest->onError!=pSrc->onError ){
90524 if( pSrc->aiColumn[i]!=pDest->aiColumn[i] ){
90527 if( pSrc->aSortOrder[i]!=pDest->aSortOrder[i] ){
90530 if( !xferCompatibleCollation(pSrc->azColl[i],pDest->azColl[i]) ){
90566 Table *pDest, /* The table we are inserting into */
90569 int iDbDest /* The database of pDest */
90579 int emptyDestTest; /* Address of test for empty pDest */
90584 int destHasUniqueIdx = 0; /* True if pDest has a UNIQUE index */
90590 if( sqlite3TriggerList(pParse, pDest) ){
90594 if( pDest->tabFlags & TF_Virtual ){
90599 if( pDest->iPKey>=0 ) onError = pDest->keyConf;
90649 if( pSrc==pDest ){
90660 if( pDest->nCol!=pSrc->nCol ){
90663 if( pDest->iPKey!=pSrc->iPKey ){
90666 for(i=0; i<pDest->nCol; i++){
90667 if( pDest->aCol[i].affinity!=pSrc->aCol[i].affinity ){
90670 if( !xferCompatibleCollation(pDest->aCol[i].zColl, pSrc->aCol[i].zColl) ){
90673 if( pDest->aCol[i].notNull && !pSrc->aCol[i].notNull ){
90677 for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){
90689 if( pDest->pCheck && sqlite3ExprCompare(pSrc->pCheck, pDest->pCheck) ){
90701 if( (pParse->db->flags & SQLITE_ForeignKeys)!=0 && pDest->pFKey!=0 ){
90721 regAutoinc = autoIncBegin(pParse, iDbDest, pDest);
90722 sqlite3OpenTable(pParse, iDest, iDbDest, pDest, OP_OpenWrite);
90723 if( (pDest->iPKey<0 && pDest->pIndex!=0) /* (1) */
90751 if( pDest->iPKey>=0 ){
90758 }else if( pDest->pIndex==0 ){
90762 assert( (pDest->tabFlags & TF_Autoincrement)==0 );
90767 sqlite3VdbeChangeP4(v, -1, pDest->zName, 0);
90769 for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){
94538 SQLITE_PRIVATE void sqlite3SelectDestInit(SelectDest *pDest, int eDest, int iParm){
94539 pDest->eDest = (u8)eDest;
94540 pDest->iParm = iParm;
94541 pDest->affinity = 0;
94542 pDest->iMem = 0;
94543 pDest->nMem = 0;
95015 SelectDest *pDest, /* Destination of SELECT results */
95018 int eDest = pDest->eDest;
95046 SelectDest *pDest, /* How to dispose of the results */
95054 int eDest = pDest->eDest; /* How to dispose of results */
95055 int iParm = pDest->iParm; /* First argument to disposal method */
95073 if( pDest->iMem==0 ){
95074 pDest->iMem = pParse->nMem+1;
95075 pDest->nMem = nResultCol;
95078 assert( pDest->nMem==nResultCol );
95080 regResult = pDest->iMem;
95159 p->affinity = sqlite3CompareAffinity(pEList->a[0].pExpr, pDest->affinity);
95214 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iParm);
95384 SelectDest *pDest /* Write the sorted results here */
95393 int eDest = pDest->eDest;
95394 int iParm = pDest->iParm;
95453 assert( regRow!=pDest->iMem+i );
95454 sqlite3VdbeAddOp3(v, OP_Column, pseudoTab, i, pDest->iMem+i);
95460 sqlite3VdbeAddOp2(v, OP_ResultRow, pDest->iMem, nColumn);
95461 sqlite3ExprCacheAffinityChange(pParse, pDest->iMem, nColumn);
95463 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iParm);
96025 SelectDest *pDest /* What to do with query results */
96064 SelectDest *pDest /* What to do with query results */
96085 dest = *pDest;
96129 return multiSelectOrderBy(pParse, p, pDest);
96407 pDest->iMem = dest.iMem;
96408 pDest->nMem = dest.nMem;
96419 ** pIn->nMem columns to be output. pDest is where the output should
96438 SelectDest *pDest, /* Where to send the data */
96470 switch( pDest->eDest ){
96477 testcase( pDest->eDest==SRT_Table );
96478 testcase( pDest->eDest==SRT_EphemTab );
96480 sqlite3VdbeAddOp2(v, OP_NewRowid, pDest->iParm, r2);
96481 sqlite3VdbeAddOp3(v, OP_Insert, pDest->iParm, r1, r2);
96497 sqlite3CompareAffinity(p->pEList->a[0].pExpr, pDest->affinity);
96501 sqlite3VdbeAddOp2(v, OP_IdxInsert, pDest->iParm, r1);
96510 sqlite3VdbeAddOp2(v, OP_Integer, 1, pDest->iParm);
96522 sqlite3ExprCodeMove(pParse, pIn->iMem, pDest->iParm, 1);
96529 ** starting at pDest->iMem. Then the co-routine yields.
96532 if( pDest->iMem==0 ){
96533 pDest->iMem = sqlite3GetTempRange(pParse, pIn->nMem);
96534 pDest->nMem = pIn->nMem;
96536 sqlite3ExprCodeMove(pParse, pIn->iMem, pDest->iMem, pDest->nMem);
96537 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iParm);
96550 assert( pDest->eDest==SRT_Output );
96660 SelectDest *pDest /* What to do with query results */
96882 p, &destA, pDest, regOutA,
96891 p, &destB, pDest, regOutB,
96987 if( pDest->eDest==SRT_Output ){
98205 ** contents of the SelectDest structure pointed to by argument pDest
98208 ** pDest->eDest Result
98215 ** in register pDest->iParm then abandon the rest
98219 ** row of result as the key in table pDest->iParm.
98220 ** Apply the affinity pDest->affinity before storing
98223 ** SRT_Union Store results as a key in a temporary table pDest->iParm.
98225 ** SRT_Except Remove results from the temporary table pDest->iParm.
98227 ** SRT_Table Store results in temporary table pDest->iParm.
98231 ** SRT_EphemTab Create an temporary table pDest->iParm and store
98239 ** of the co-routine is stored in register pDest->iParm.
98241 ** SRT_Exists Store a 1 in memory cell pDest->iParm if the result
98258 SelectDest *pDest /* What to do with the query results */
98291 if( IgnorableOrderby(pDest) ){
98292 assert(pDest->eDest==SRT_Exists || pDest->eDest==SRT_Union ||
98293 pDest->eDest==SRT_Except || pDest->eDest==SRT_Discard);
98319 if( checkForMultiColumnSelectError(pParse, pDest, pEList->nExpr) ){
98391 if( !IgnorableOrderby(pDest) ){
98421 rc = multiSelect(pParse, p, pDest);
98484 if( pDest->eDest==SRT_EphemTab ){
98485 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pDest->iParm, pEList->nExpr);
98574 selectInnerLoop(pParse, p, pEList, 0, 0, pOrderBy, distinct, pDest,
98840 distinct, pDest,
98974 pDest, addrEnd, addrEnd);
98990 generateSortTail(pParse, p, v, pEList->nExpr, pDest);
99010 if( rc==SQLITE_OK && pDest->eDest==SRT_Output ){
