Lines Matching refs:pDest
6814 sqlite3 *pDest, /* Destination database handle */
41108 ** that pDest points to.
41120 SQLITE_PRIVATE int sqlite3PagerReadFileheader(Pager *pPager, int N, unsigned char *pDest){
41122 memset(pDest, 0, N);
41133 rc = sqlite3OsRead(pPager->fd, pDest, N, 0);
56474 Btree *pDest; /* Destination b-tree file */
56476 int bDestLocked; /* True once a write-transaction is open on pDest */
56571 rc = sqlite3BtreeSetPageSize(p->pDest,sqlite3BtreeGetPageSize(p->pSrc),-1,0);
56622 p->pDest = findBtree(pDestDb, pDestDb, zDestDb);
56628 if( 0==p->pSrc || 0==p->pDest || setDestPgsz(p)==SQLITE_NOMEM ){
56662 Pager * const pDestPager = sqlite3BtreePager(p->pDest);
56664 int nDestPgsz = sqlite3BtreeGetPageSize(p->pDest);
56669 int nDestReserve = sqlite3BtreeGetReserve(p->pDest);
56714 if( iDest==PENDING_BYTE_PAGE(p->pDest->pBt) ) continue;
56786 Pager * const pDestPager = sqlite3BtreePager(p->pDest); /* Dest pager */
56802 && SQLITE_OK==(rc = sqlite3BtreeBeginTrans(p->pDest, 2))
56805 sqlite3BtreeGetMeta(p->pDest, BTREE_SCHEMA_VERSION, &p->iDestSchema);
56820 pgszDest = sqlite3BtreeGetPageSize(p->pDest);
56821 destMode = sqlite3PagerGetJournalMode(sqlite3BtreePager(p->pDest));
56859 rc = sqlite3BtreeUpdateMeta(p->pDest,1,p->iDestSchema+1);
56865 rc = sqlite3BtreeSetVersion(p->pDest, 2);
56883 assert( pgszDest==sqlite3BtreeGetPageSize(p->pDest) );
56887 if( nDestTruncate==(int)PENDING_BYTE_PAGE(p->pDest->pBt) ){
56912 nDestTruncate==(int)(PENDING_BYTE_PAGE(p->pDest->pBt)-1)
56954 && SQLITE_OK==(rc = sqlite3BtreeCommitPhaseTwo(p->pDest, 0))
57016 sqlite3BtreeRollback(p->pDest);
57129 b.pDest = pTo;
63759 Mem *pDest; /* Where to write the extracted value */
64065 Mem *pDest;
65669 Mem *pDest; /* Where to write the extracted value */
65688 u.am.pDest = &aMem[pOp->p3];
65689 memAboutToChange(p, u.am.pDest);
65749 MemSetTypeFlag(u.am.pDest, MEM_Null);
65904 MemReleaseExt(u.am.pDest);
65905 sqlite3VdbeSerialGet((u8 *)&u.am.zRec[u.am.aOffset[u.am.p2]], u.am.aType[u.am.p2], u.am.pDest);
65908 sqlite3VdbeMemMove(&u.am.sMem, u.am.pDest);
65914 sqlite3VdbeSerialGet((u8*)u.am.zData, u.am.aType[u.am.p2], u.am.pDest);
65916 u.am.pDest->enc = encoding;
65919 sqlite3VdbeMemShallowCopy(u.am.pDest, pOp->p4.pMem, MEM_Static);
65921 MemSetTypeFlag(u.am.pDest, MEM_Null);
65927 ** dynamically allocated space over to the u.am.pDest structure.
65932 assert( !(u.am.pDest->flags & MEM_Dyn) );
65933 assert( !(u.am.pDest->flags & (MEM_Blob|MEM_Str)) || u.am.pDest->z==u.am.sMem.z );
65934 u.am.pDest->flags &= ~(MEM_Ephem|MEM_Static);
65935 u.am.pDest->flags |= MEM_Term;
65936 u.am.pDest->z = u.am.sMem.z;
65937 u.am.pDest->zMalloc = u.am.sMem.zMalloc;
65940 rc = sqlite3VdbeMemMakeWriteable(u.am.pDest);
65943 UPDATE_MAX_BLOBSIZE(u.am.pDest);
65944 REGISTER_TRACE(pOp->p3, u.am.pDest);
69425 Mem *pDest;
69432 u.cm.pDest = &aMem[pOp->p3];
69433 memAboutToChange(p, u.cm.pDest);
69435 sqlite3VdbeMemSetNull(u.cm.pDest);
69448 sqlite3VdbeMemMove(&u.cm.sContext.s, u.cm.pDest);
69462 sqlite3VdbeMemMove(u.cm.pDest, &u.cm.sContext.s);
69463 REGISTER_TRACE(pOp->p3, u.cm.pDest);
69464 UPDATE_MAX_BLOBSIZE(u.cm.pDest);
69466 if( sqlite3VdbeMemTooBig(u.cm.pDest) ){
87205 Table *pDest, /* The table we are inserting into */
87208 int iDbDest /* The database of pDest */
88422 ** for index pDest in an insert transfer optimization. The rules
88430 static int xferCompatibleIndex(Index *pDest, Index *pSrc){
88432 assert( pDest && pSrc );
88433 assert( pDest->pTable!=pSrc->pTable );
88434 if( pDest->nColumn!=pSrc->nColumn ){
88437 if( pDest->onError!=pSrc->onError ){
88441 if( pSrc->aiColumn[i]!=pDest->aiColumn[i] ){
88444 if( pSrc->aSortOrder[i]!=pDest->aSortOrder[i] ){
88447 if( !xferCompatibleCollation(pSrc->azColl[i],pDest->azColl[i]) ){
88489 Table *pDest, /* The table we are inserting into */
88492 int iDbDest /* The database of pDest */
88502 int emptyDestTest; /* Address of test for empty pDest */
88507 int destHasUniqueIdx = 0; /* True if pDest has a UNIQUE index */
88513 if( sqlite3TriggerList(pParse, pDest) ){
88517 if( pDest->tabFlags & TF_Virtual ){
88574 if( pSrc==pDest ){
88585 if( pDest->nCol!=pSrc->nCol ){
88588 if( pDest->iPKey!=pSrc->iPKey ){
88591 for(i=0; i<pDest->nCol; i++){
88592 if( pDest->aCol[i].affinity!=pSrc->aCol[i].affinity ){
88595 if( !xferCompatibleCollation(pDest->aCol[i].zColl, pSrc->aCol[i].zColl) ){
88598 if( pDest->aCol[i].notNull && !pSrc->aCol[i].notNull ){
88602 for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){
88614 if( pDest->pCheck && sqlite3ExprCompare(pSrc->pCheck, pDest->pCheck) ){
88626 if( (pParse->db->flags & SQLITE_ForeignKeys)!=0 && pDest->pFKey!=0 ){
88647 regAutoinc = autoIncBegin(pParse, iDbDest, pDest);
88648 sqlite3OpenTable(pParse, iDest, iDbDest, pDest, OP_OpenWrite);
88649 if( (pDest->iPKey<0 && pDest->pIndex!=0) || destHasUniqueIdx ){
88670 if( pDest->iPKey>=0 ){
88677 }else if( pDest->pIndex==0 ){
88681 assert( (pDest->tabFlags & TF_Autoincrement)==0 );
88686 sqlite3VdbeChangeP4(v, -1, pDest->zName, 0);
88688 for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){
92384 SQLITE_PRIVATE void sqlite3SelectDestInit(SelectDest *pDest, int eDest, int iParm){
92385 pDest->eDest = (u8)eDest;
92386 pDest->iParm = iParm;
92387 pDest->affinity = 0;
92388 pDest->iMem = 0;
92389 pDest->nMem = 0;
92858 SelectDest *pDest, /* Destination of SELECT results */
92861 int eDest = pDest->eDest;
92889 SelectDest *pDest, /* How to dispose of the results */
92897 int eDest = pDest->eDest; /* How to dispose of results */
92898 int iParm = pDest->iParm; /* First argument to disposal method */
92916 if( pDest->iMem==0 ){
92917 pDest->iMem = pParse->nMem+1;
92918 pDest->nMem = nResultCol;
92921 assert( pDest->nMem==nResultCol );
92923 regResult = pDest->iMem;
93002 p->affinity = sqlite3CompareAffinity(pEList->a[0].pExpr, pDest->affinity);
93057 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iParm);
93227 SelectDest *pDest /* Write the sorted results here */
93236 int eDest = pDest->eDest;
93237 int iParm = pDest->iParm;
93296 assert( regRow!=pDest->iMem+i );
93297 sqlite3VdbeAddOp3(v, OP_Column, pseudoTab, i, pDest->iMem+i);
93303 sqlite3VdbeAddOp2(v, OP_ResultRow, pDest->iMem, nColumn);
93304 sqlite3ExprCacheAffinityChange(pParse, pDest->iMem, nColumn);
93306 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iParm);
93865 SelectDest *pDest /* What to do with query results */
93904 SelectDest *pDest /* What to do with query results */
93925 dest = *pDest;
93965 return multiSelectOrderBy(pParse, p, pDest);
94243 pDest->iMem = dest.iMem;
94244 pDest->nMem = dest.nMem;
94255 ** pIn->nMem columns to be output. pDest is where the output should
94274 SelectDest *pDest, /* Where to send the data */
94306 switch( pDest->eDest ){
94313 testcase( pDest->eDest==SRT_Table );
94314 testcase( pDest->eDest==SRT_EphemTab );
94316 sqlite3VdbeAddOp2(v, OP_NewRowid, pDest->iParm, r2);
94317 sqlite3VdbeAddOp3(v, OP_Insert, pDest->iParm, r1, r2);
94333 sqlite3CompareAffinity(p->pEList->a[0].pExpr, pDest->affinity);
94337 sqlite3VdbeAddOp2(v, OP_IdxInsert, pDest->iParm, r1);
94346 sqlite3VdbeAddOp2(v, OP_Integer, 1, pDest->iParm);
94358 sqlite3ExprCodeMove(pParse, pIn->iMem, pDest->iParm, 1);
94365 ** starting at pDest->iMem. Then the co-routine yields.
94368 if( pDest->iMem==0 ){
94369 pDest->iMem = sqlite3GetTempRange(pParse, pIn->nMem);
94370 pDest->nMem = pIn->nMem;
94372 sqlite3ExprCodeMove(pParse, pIn->iMem, pDest->iMem, pDest->nMem);
94373 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iParm);
94386 assert( pDest->eDest==SRT_Output );
94496 SelectDest *pDest /* What to do with query results */
94718 p, &destA, pDest, regOutA,
94727 p, &destB, pDest, regOutB,
94823 if( pDest->eDest==SRT_Output ){
96025 ** contents of the SelectDest structure pointed to by argument pDest
96028 ** pDest->eDest Result
96035 ** in register pDest->iParm then abandon the rest
96039 ** row of result as the key in table pDest->iParm.
96040 ** Apply the affinity pDest->affinity before storing
96043 ** SRT_Union Store results as a key in a temporary table pDest->iParm.
96045 ** SRT_Except Remove results from the temporary table pDest->iParm.
96047 ** SRT_Table Store results in temporary table pDest->iParm.
96051 ** SRT_EphemTab Create an temporary table pDest->iParm and store
96059 ** of the co-routine is stored in register pDest->iParm.
96061 ** SRT_Exists Store a 1 in memory cell pDest->iParm if the result
96078 SelectDest *pDest /* What to do with the query results */
96111 if( IgnorableOrderby(pDest) ){
96112 assert(pDest->eDest==SRT_Exists || pDest->eDest==SRT_Union ||
96113 pDest->eDest==SRT_Except || pDest->eDest==SRT_Discard);
96139 if( checkForMultiColumnSelectError(pParse, pDest, pEList->nExpr) ){
96212 if( !IgnorableOrderby(pDest) ){
96242 rc = multiSelect(pParse, p, pDest);
96305 if( pDest->eDest==SRT_EphemTab ){
96306 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pDest->iParm, pEList->nExpr);
96395 selectInnerLoop(pParse, p, pEList, 0, 0, pOrderBy, distinct, pDest,
96660 distinct, pDest,
96794 pDest, addrEnd, addrEnd);
96810 generateSortTail(pParse, p, v, pEList->nExpr, pDest);
96830 if( rc==SQLITE_OK && pDest->eDest==SRT_Output ){