Lines Matching defs:pDest
6613 sqlite3 *pDest, /* Destination database handle */
40025 ** that pDest points to.
40037 SQLITE_PRIVATE int sqlite3PagerReadFileheader(Pager *pPager, int N, unsigned char *pDest){
40039 memset(pDest, 0, N);
40050 rc = sqlite3OsRead(pPager->fd, pDest, N, 0);
55471 Btree *pDest; /* Destination b-tree file */
55473 int bDestLocked; /* True once a write-transaction is open on pDest */
55568 rc = sqlite3BtreeSetPageSize(p->pDest,sqlite3BtreeGetPageSize(p->pSrc),-1,0);
55619 p->pDest = findBtree(pDestDb, pDestDb, zDestDb);
55625 if( 0==p->pSrc || 0==p->pDest || setDestPgsz(p)==SQLITE_NOMEM ){
55659 Pager * const pDestPager = sqlite3BtreePager(p->pDest);
55661 int nDestPgsz = sqlite3BtreeGetPageSize(p->pDest);
55666 int nDestReserve = sqlite3BtreeGetReserve(p->pDest);
55711 if( iDest==PENDING_BYTE_PAGE(p->pDest->pBt) ) continue;
55783 Pager * const pDestPager = sqlite3BtreePager(p->pDest); /* Dest pager */
55799 && SQLITE_OK==(rc = sqlite3BtreeBeginTrans(p->pDest, 2))
55802 sqlite3BtreeGetMeta(p->pDest, BTREE_SCHEMA_VERSION, &p->iDestSchema);
55817 pgszDest = sqlite3BtreeGetPageSize(p->pDest);
55818 destMode = sqlite3PagerGetJournalMode(sqlite3BtreePager(p->pDest));
55856 && (rc = sqlite3BtreeUpdateMeta(p->pDest,1,p->iDestSchema+1))==SQLITE_OK
55877 assert( pgszDest==sqlite3BtreeGetPageSize(p->pDest) );
55881 if( nDestTruncate==(int)PENDING_BYTE_PAGE(p->pDest->pBt) ){
55906 nDestTruncate==(int)(PENDING_BYTE_PAGE(p->pDest->pBt)-1)
55948 && SQLITE_OK==(rc = sqlite3BtreeCommitPhaseTwo(p->pDest, 0))
56009 sqlite3BtreeRollback(p->pDest);
56122 b.pDest = pTo;
62740 Mem *pDest; /* Where to write the extracted value */
63035 Mem *pDest;
64611 Mem *pDest; /* Where to write the extracted value */
64629 u.am.pDest = &aMem[pOp->p3];
64630 memAboutToChange(p, u.am.pDest);
64631 MemSetTypeFlag(u.am.pDest, MEM_Null);
64690 assert( u.am.pDest->flags&MEM_Null );
64839 sqlite3VdbeMemReleaseExternal(u.am.pDest);
64840 sqlite3VdbeSerialGet((u8 *)&u.am.zRec[u.am.aOffset[u.am.p2]], u.am.aType[u.am.p2], u.am.pDest);
64843 sqlite3VdbeMemMove(&u.am.sMem, u.am.pDest);
64849 sqlite3VdbeSerialGet((u8*)u.am.zData, u.am.aType[u.am.p2], u.am.pDest);
64851 u.am.pDest->enc = encoding;
64854 sqlite3VdbeMemShallowCopy(u.am.pDest, pOp->p4.pMem, MEM_Static);
64856 assert( u.am.pDest->flags&MEM_Null );
64862 ** dynamically allocated space over to the u.am.pDest structure.
64867 assert( !(u.am.pDest->flags & MEM_Dyn) );
64868 assert( !(u.am.pDest->flags & (MEM_Blob|MEM_Str)) || u.am.pDest->z==u.am.sMem.z );
64869 u.am.pDest->flags &= ~(MEM_Ephem|MEM_Static);
64870 u.am.pDest->flags |= MEM_Term;
64871 u.am.pDest->z = u.am.sMem.z;
64872 u.am.pDest->zMalloc = u.am.sMem.zMalloc;
64875 rc = sqlite3VdbeMemMakeWriteable(u.am.pDest);
64878 UPDATE_MAX_BLOBSIZE(u.am.pDest);
64879 REGISTER_TRACE(pOp->p3, u.am.pDest);
68240 Mem *pDest;
68247 u.cj.pDest = &aMem[pOp->p3];
68248 memAboutToChange(p, u.cj.pDest);
68250 sqlite3VdbeMemSetNull(u.cj.pDest);
68263 sqlite3VdbeMemMove(&u.cj.sContext.s, u.cj.pDest);
68277 sqlite3VdbeMemMove(u.cj.pDest, &u.cj.sContext.s);
68278 REGISTER_TRACE(pOp->p3, u.cj.pDest);
68279 UPDATE_MAX_BLOBSIZE(u.cj.pDest);
68281 if( sqlite3VdbeMemTooBig(u.cj.pDest) ){
85015 Table *pDest, /* The table we are inserting into */
85018 int iDbDest /* The database of pDest */
86231 ** for index pDest in an insert transfer optimization. The rules
86239 static int xferCompatibleIndex(Index *pDest, Index *pSrc){
86241 assert( pDest && pSrc );
86242 assert( pDest->pTable!=pSrc->pTable );
86243 if( pDest->nColumn!=pSrc->nColumn ){
86246 if( pDest->onError!=pSrc->onError ){
86250 if( pSrc->aiColumn[i]!=pDest->aiColumn[i] ){
86253 if( pSrc->aSortOrder[i]!=pDest->aSortOrder[i] ){
86256 if( !xferCompatibleCollation(pSrc->azColl[i],pDest->azColl[i]) ){
86298 Table *pDest, /* The table we are inserting into */
86301 int iDbDest /* The database of pDest */
86311 int emptyDestTest; /* Address of test for empty pDest */
86316 int destHasUniqueIdx = 0; /* True if pDest has a UNIQUE index */
86322 if( sqlite3TriggerList(pParse, pDest) ){
86326 if( pDest->tabFlags & TF_Virtual ){
86383 if( pSrc==pDest ){
86394 if( pDest->nCol!=pSrc->nCol ){
86397 if( pDest->iPKey!=pSrc->iPKey ){
86400 for(i=0; i<pDest->nCol; i++){
86401 if( pDest->aCol[i].affinity!=pSrc->aCol[i].affinity ){
86404 if( !xferCompatibleCollation(pDest->aCol[i].zColl, pSrc->aCol[i].zColl) ){
86407 if( pDest->aCol[i].notNull && !pSrc->aCol[i].notNull ){
86411 for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){
86423 if( pDest->pCheck && sqlite3ExprCompare(pSrc->pCheck, pDest->pCheck) ){
86444 regAutoinc = autoIncBegin(pParse, iDbDest, pDest);
86445 sqlite3OpenTable(pParse, iDest, iDbDest, pDest, OP_OpenWrite);
86446 if( (pDest->iPKey<0 && pDest->pIndex!=0) || destHasUniqueIdx ){
86467 if( pDest->iPKey>=0 ){
86474 }else if( pDest->pIndex==0 ){
86478 assert( (pDest->tabFlags & TF_Autoincrement)==0 );
86483 sqlite3VdbeChangeP4(v, -1, pDest->zName, 0);
86485 for(pDestIdx=pDest->pIndex; pDestIdx; pDestIdx=pDestIdx->pNext){
90166 SQLITE_PRIVATE void sqlite3SelectDestInit(SelectDest *pDest, int eDest, int iParm){
90167 pDest->eDest = (u8)eDest;
90168 pDest->iParm = iParm;
90169 pDest->affinity = 0;
90170 pDest->iMem = 0;
90171 pDest->nMem = 0;
90632 SelectDest *pDest, /* Destination of SELECT results */
90635 int eDest = pDest->eDest;
90663 SelectDest *pDest, /* How to dispose of the results */
90671 int eDest = pDest->eDest; /* How to dispose of results */
90672 int iParm = pDest->iParm; /* First argument to disposal method */
90690 if( pDest->iMem==0 ){
90691 pDest->iMem = pParse->nMem+1;
90692 pDest->nMem = nResultCol;
90695 assert( pDest->nMem==nResultCol );
90697 regResult = pDest->iMem;
90776 p->affinity = sqlite3CompareAffinity(pEList->a[0].pExpr, pDest->affinity);
90831 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iParm);
91001 SelectDest *pDest /* Write the sorted results here */
91010 int eDest = pDest->eDest;
91011 int iParm = pDest->iParm;
91059 assert( regRow!=pDest->iMem+i );
91060 sqlite3VdbeAddOp3(v, OP_Column, pseudoTab, i, pDest->iMem+i);
91066 sqlite3VdbeAddOp2(v, OP_ResultRow, pDest->iMem, nColumn);
91067 sqlite3ExprCacheAffinityChange(pParse, pDest->iMem, nColumn);
91069 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iParm);
91624 SelectDest *pDest /* What to do with query results */
91663 SelectDest *pDest /* What to do with query results */
91684 dest = *pDest;
91724 return multiSelectOrderBy(pParse, p, pDest);
92002 pDest->iMem = dest.iMem;
92003 pDest->nMem = dest.nMem;
92014 ** pIn->nMem columns to be output. pDest is where the output should
92033 SelectDest *pDest, /* Where to send the data */
92065 switch( pDest->eDest ){
92072 testcase( pDest->eDest==SRT_Table );
92073 testcase( pDest->eDest==SRT_EphemTab );
92075 sqlite3VdbeAddOp2(v, OP_NewRowid, pDest->iParm, r2);
92076 sqlite3VdbeAddOp3(v, OP_Insert, pDest->iParm, r1, r2);
92092 sqlite3CompareAffinity(p->pEList->a[0].pExpr, pDest->affinity);
92096 sqlite3VdbeAddOp2(v, OP_IdxInsert, pDest->iParm, r1);
92105 sqlite3VdbeAddOp2(v, OP_Integer, 1, pDest->iParm);
92117 sqlite3ExprCodeMove(pParse, pIn->iMem, pDest->iParm, 1);
92124 ** starting at pDest->iMem. Then the co-routine yields.
92127 if( pDest->iMem==0 ){
92128 pDest->iMem = sqlite3GetTempRange(pParse, pIn->nMem);
92129 pDest->nMem = pIn->nMem;
92131 sqlite3ExprCodeMove(pParse, pIn->iMem, pDest->iMem, pDest->nMem);
92132 sqlite3VdbeAddOp1(v, OP_Yield, pDest->iParm);
92145 assert( pDest->eDest==SRT_Output );
92255 SelectDest *pDest /* What to do with query results */
92477 p, &destA, pDest, regOutA,
92486 p, &destB, pDest, regOutB,
92582 if( pDest->eDest==SRT_Output ){
93784 ** contents of the SelectDest structure pointed to by argument pDest
93787 ** pDest->eDest Result
93794 ** in register pDest->iParm then abandon the rest
93798 ** row of result as the key in table pDest->iParm.
93799 ** Apply the affinity pDest->affinity before storing
93802 ** SRT_Union Store results as a key in a temporary table pDest->iParm.
93804 ** SRT_Except Remove results from the temporary table pDest->iParm.
93806 ** SRT_Table Store results in temporary table pDest->iParm.
93810 ** SRT_EphemTab Create an temporary table pDest->iParm and store
93818 ** of the co-routine is stored in register pDest->iParm.
93820 ** SRT_Exists Store a 1 in memory cell pDest->iParm if the result
93837 SelectDest *pDest /* What to do with the query results */
93869 if( IgnorableOrderby(pDest) ){
93870 assert(pDest->eDest==SRT_Exists || pDest->eDest==SRT_Union ||
93871 pDest->eDest==SRT_Except || pDest->eDest==SRT_Discard);
93897 if( checkForMultiColumnSelectError(pParse, pDest, pEList->nExpr) ){
93943 if( !IgnorableOrderby(pDest) ){
93973 rc = multiSelect(pParse, p, pDest);
94022 if( pDest->eDest==SRT_EphemTab ){
94023 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pDest->iParm, pEList->nExpr);
94067 selectInnerLoop(pParse, p, pEList, 0, 0, pOrderBy, -1, pDest,
94323 distinct, pDest,
94455 pDest, addrEnd, addrEnd);
94471 generateSortTail(pParse, p, v, pEList->nExpr, pDest);
94491 if( rc==SQLITE_OK && pDest->eDest==SRT_Output ){